Does it work for Citigold consolidated statements?

Yes. Citigold PDFs that combine checking + savings + money-market on one file are split into three independently reconciled streams; the XLSX export keeps them as separate sheets so you don't have to demultiplex manually.

Will Costco Anywhere Visa statements import into QuickBooks?

Yes. The QBO exporter tags each row CREDIT or DEBIT based on sign and uses the cycle-close date as the batch date — QuickBooks imports them as a credit-card account with the Costco merchant names preserved.

How does the cycle-close date differ from the calendar month?

Citi credit-card statements close on a fixed cycle date (e.g. the 15th), not month-end. The export's Statement Period field reflects the actual cycle (Mar 15 - Apr 14, say) so bookkeeping entries line up with how Citi actually bills you.

What about Citi Double Cash PDFs across multiple cycles?

Batch up to 10 cycle PDFs in one upload — each runs through the LLM path independently with its own Verified badge, then downloads as a single ZIP of XLSX/CSV/QBO files, one per cycle.

Convert your Citi statement to Excel

Priority Checking, Savings+, Costco Anywhere, and Double Cash. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

BankPDFtoXLS is an independent service. We are not affiliated with, endorsed by, or sponsored by Citibank. The name "Citibank" is used only to describe compatibility with statements you have legally obtained from your own account. See our trademarks policy.

Drag bank statement PDFs here

or click to browse · PDF · up to 50 MB each · max 25 per batch

From Citi PDF to verified spreadsheet

1. Drop your Citibank PDF — digital or scanned, monthly statement or a combined multi-month export, up to 50 MB (or batch up to 25 files). Password-protected PDFs and image-only scans both work: scans go through vision OCR automatically.
2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

What a Citi statement PDF looks like

Sections in the PDF

Account Summary · Debits / Withdrawals · Credits / Deposits · Fees

Transaction date format

MM/DD/YY

Products we've parsed

Citigold Private Client, Citi Priority Checking, Regular Checking / Access Account, Citi Savings+ / Citi Accelerate Savings, Costco Anywhere Visa, Citi Double Cash / Custom Cash / Premier / Strata

Citibank checking statements group transactions into Debits and Credits blocks with a consolidated Account Summary on page one showing beginning balance, total debits, total credits, and ending balance. The parser reads both blocks, merges by posting date, and validates that credits minus debits equals ending minus beginning to the cent.

Citi credit-card statements (Double Cash, Custom Cash, Costco Anywhere, Premier, Strata Premier) close on a cycle date that shifts a few days each month. The exported period reflects the cycle window printed on the statement header, not the calendar month — useful when reconciling against a rolling credit-card budget.

Citigold and Citi Priority customers often receive consolidated statements with checking, savings, and money-market sections on the same PDF. Each section is treated as its own running-balance stream, and the XLSX export keeps them on separate sheets so category coding stays clean.

Which Citi statements work

We handle checking, savings, and credit-card PDFs from Citibank.

checking
savings
credit-card

Citi statement gotchas to watch for

Format-specific quirks that break naive PDF parsers — and how the reconciliation pipeline handles each one.

Cycle-close date drifts across calendar months

Citi credit-card statements close on a cycle date that shifts a few days each month — your March statement might run Feb 14 to Mar 13, the April one Mar 14 to Apr 12. Tax-prep workflows that assume calendar-month boundaries end up either missing or double-counting transactions at the seams. The export period reflects the printed cycle window, not the calendar month, and the QBO batch date uses the cycle close so QuickBooks imports without duplicate-detection conflicts.

Costco Anywhere foreign-transaction rows are stacked

Costco Anywhere Visa transactions in foreign currency print as three stacked rows — original currency amount, exchange rate, and converted USD amount — but only the converted USD line affects the running balance. Sum all three naively and the math fails by twice the foreign amount. The parser detects the FX-row triple and keeps only the USD line in the running-balance reconciliation, but preserves the original currency and exchange rate in metadata columns so the export remains audit-complete.

Citigold consolidated statements show parallel running balances

Citigold Private Client and Citi Priority customers receive consolidated PDFs with checking, savings, and money-market sections — each maintaining its own beginning/ending balance. Manual reconciliation that sums all rows into one column produces a meaningless aggregate. The parser treats each section as an independent running-balance stream, validates each separately against its printed beginning/ending pair, and the XLSX export keeps them on labelled sheets so per-account category coding stays clean.

Frequently asked questions

Does it work for Citigold consolidated statements?: Yes. Citigold PDFs that combine checking + savings + money-market on one file are split into three independently reconciled streams; the XLSX export keeps them as separate sheets so you don't have to demultiplex manually.
Will Costco Anywhere Visa statements import into QuickBooks?: Yes. The QBO exporter tags each row CREDIT or DEBIT based on sign and uses the cycle-close date as the batch date — QuickBooks imports them as a credit-card account with the Costco merchant names preserved.
How does the cycle-close date differ from the calendar month?: Citi credit-card statements close on a fixed cycle date (e.g. the 15th), not month-end. The export's Statement Period field reflects the actual cycle (Mar 15 - Apr 14, say) so bookkeeping entries line up with how Citi actually bills you.
What about Citi Double Cash PDFs across multiple cycles?: Batch up to 10 cycle PDFs in one upload — each runs through the LLM path independently with its own Verified badge, then downloads as a single ZIP of XLSX/CSV/QBO files, one per cycle.

Where Citi conversions get used

Most Citi statements that come through us are part of one of these workflows. Each link below explains how the reconciliation guarantee maps to that practice.

Forensic accountants

Discovery packets, multi-year tracing

Divorce attorneys

Opposing-counsel financial disclosure

Bookkeepers

Catch-up & bank-feed gaps

Scanned PDFs

Vision OCR + reconciliation

PDF to QBO

QuickBooks-ready OFX export

For QuickBooks workflows

Verified imports, no duplicates