BalanceProof

Convert Citibank bank statements to CSV, QBO CSV, or Xero

The first thing to know about Citibank statements is what Citi does not give you: there is no CSV or Excel download in Citi online banking. Statements come as PDF, full stop, which is why bookkeepers end up either retyping figures or reaching for a converter. The second thing is that Citi's two statement types behave differently. Checking and savings statements list transactions by date with Debit, Credit, and Balance columns, so they carry a running balance you can verify against. Credit-card statements instead split purchases, payments, and credits into separate sections with their own subtotals, sometimes across several pages. A converter has to treat those two shapes differently, folding the debit and credit columns into one signed amount for checking, and merging the sections into one time-ordered list for cards without dragging in the subtotals. This tool does both and then runs the reconciliation gate. Drop your Citi PDF on this page and the gate reports which rows tie out before you export.

Convert a statement now

Drop a PDF statement below. It is parsed in this browser tab: the file is not uploaded, and you can watch the Network tab while it runs. You get an editable preview, a reconciliation stamp, and CSV downloads for QuickBooks Online, Xero, or anything that reads plain CSV. No signup and no card for the first 20 pages each month.

Drop bank statement PDFs here

or

No signup. No upload - statements are parsed in this browser tab.

  • Balances are checked before anything is exported.
  • Rows that do not tie out are flagged, never dropped.
  • Close the tab and nothing is left behind.

How a Citibank statement is laid out

A Citi checking or savings statement presents activity in a dated table with Debit, Credit, and Balance columns. Keeping debits and credits in separate columns means the sign of each figure comes from the column it sits in rather than from a plus or minus, so a converter must fold the two into a single signed amount carefully. The Balance column is the useful part: it carries a running balance down the page, giving a value to check each row against. Citi credit-card statements are a different animal. Purchases, payments, and credits are grouped into their own sections, interest and fees get their own line items, and the statement can span multiple pages with subtotals, so the natural reading order is by section rather than by date. That structure is where careless parsers add a subtotal in as though it were a transaction. One layout detail is not independently sourced here: the exact date format Citi prints. Rather than assume MM/DD/YY or MM/DD/YYYY, this tool detects the format from your file and normalizes it for export, and the gate does not depend on the date format to check the balance chain.

  • Running balance: true.
  • Dates: generic.
  • Negative amounts: On checking and savings statements, debits and credits sit in their own columns (Debit, Credit, Balance) rather than one signed amount. On credit-card statements, purchases read as money out and payments and credits as money in..
  • Citi online banking does not offer a CSV or Excel download for statement data. Statements come as PDF, so a converter is the practical way to get structured rows.
  • Citi checking and savings statements list transactions by date with a running balance, using Debit, Credit, and Balance columns.
  • Citi credit-card statements group purchases, payments, and credits into separate sections with their own subtotals and can span several pages.
  • Most accounts keep statements online for 7 or more years, and consumer accounts show the most recent 12 to 24 months immediately.
  • The date format printed on the statement is not independently sourced here, so this tool detects it from your file rather than assuming.

How to download statements from Citibank

  1. Sign on at citibank.com on a desktop browser.
  2. Select the account you want a statement for.
  3. Click Statements and Documents in the account menu.
  4. Pick the statement period and click Download PDF.
  5. On the Citi Mobile app, sign in, tap the account, tap Statements, pick a month, then tap the download icon to save or share the PDF.

Citibank conversion pitfalls

Citi gives you a PDF, not a CSV
Citibank's online banking does not provide a CSV or Excel download for statement data, so without a converter the only path is retyping numbers from the PDF. Drop the PDF here and you get the structured rows Citi never exports, already checked by the gate.
Credit-card statements are split into sections
On a Citi card statement, purchases, payments, and credits live in separate sections with their own subtotals, and the statement can run several pages. A converter has to merge those sections into one time-ordered list without pulling in the subtotals. This tool consolidates them and the gate flags any subtotal that slips through.
Separate debit and credit columns must keep their sign
Citi checking statements use one column for debits and another for credits. Folding them into a single signed amount is where sign errors creep in. Because Citi checking statements also print a running balance, the gate rebuilds the balance from your amounts and checks it against Citi's column, catching a flipped sign.

Importing the CSV into QuickBooks Online

In QuickBooks Online go to Transactions, then Bank transactions, choose the account, and pick Upload from file. The converter's default export is the 3-column format QuickBooks expects: Date, Description, Amount, with one signed amount per row. A 4-column Date, Description, Credit, Debit file is available too, but QuickBooks parses the 3-column shape more reliably.

Three constraints matter. Dates must be MM/DD/YYYY for US companies, and one unreadable date fails the whole import. Files over 350 KB, roughly 1,000 rows, are rejected, so this converter splits large exports into date-ranged files automatically. And QuickBooks ignores any category column in a CSV: every imported transaction lands in For Review for you to categorize with bank rules.

  • Map Citi rows to the 3-column QuickBooks Online layout: Date, Description, Amount, with money out as a negative amount.
  • For checking statements, fold the separate Debit and Credit columns into one signed amount: credits positive, debits negative.
  • For card statements, set purchases negative and payments and credits positive so the single amount column reads correctly.
  • Format all dates as MM/DD/YYYY for QuickBooks Online US and keep one consistent format across the file, since mixed formats fail the import.
  • Files over about 350KB or 1,000 rows split automatically so each piece imports cleanly.

Importing into Xero

For Xero, the export uses Date and a single signed Amount, income positive, plus Payee, Description, and Reference columns. Import it under the bank account's Import a Statement option. Xero reads dates by your organisation's region setting, so check the day and month order match before you post.

How the reconciliation gate works

Most converters hand you a spreadsheet and leave the checking to you. This one does the arithmetic first. A bank statement carries its own proof: balances. If the rows are right, they add up to the printed balances; if a digit was misread or a row was dropped, they do not.

Every export gets one of five stamps. Verified row-by-row means each transaction was checked against a printed running balance. Verified at statement level means the opening balance plus all transactions equals the closing balance. Partially verified means daily balance figures anchored some of the rows. Unverifiable means the statement printed no balances to check against, so honesty is the stamp. Reconciliation failed means the math did not hold, and the exact failing rows are marked in the grid so you can fix or confirm them before export.

The stamp is a verification aid, not a guarantee. It shows you which rows the statement's own math confirms, so you verify three rows instead of three hundred.

Statements never leave this browser. There is no upload to vet, no processor to add to your WISP paperwork, and nothing stored when the tab closes. Open the Network tab during a conversion and watch: the page explains exactly what it sends and when, and none of it is your document.

Frequently asked questions

Can I download my Citibank statement as a CSV or Excel file?
No. Citi online banking offers statements as PDF only, with no native CSV or Excel export. Convert the PDF here to get a CSV, QuickBooks Online CSV, or Xero file, each carrying a reconciliation stamp.
Does a Citibank statement show a running balance?
Citi checking and savings statements list transactions by date with a Balance column, so there is a running balance to verify against. Card statements are section-based instead. Drop your PDF and the gate tells you what it verified.
How do I download a Citibank statement PDF?
Sign on at citibank.com, select the account, click Statements and Documents, pick the period, and click Download PDF. On the Citi Mobile app, tap the account, tap Statements, pick a month, and tap the download icon.
How far back can I get Citibank statements?
Most accounts keep statements online for 7 or more years, with the most recent 12 to 24 months available immediately for consumer accounts. Older ones can be requested to bring back online.
Why is my Citi credit-card statement hard to convert?
Card statements split purchases, payments, and credits into separate sections with subtotals across several pages. This tool merges them into one time-ordered list and drops the subtotals, and the gate flags any that slip through.
Which reconciliation state should I expect from a Citi checking statement?
Because Citi checking statements print a Balance column, the gate can usually check each row against it, so a clean statement can reach row-verified. Card statements without a per-row balance land at statement-verified against the totals.

Convert a Citibank statement free right now: 20 pages a month, full quality, reconciliation stamp included. Unlimited pages are $19 a month or $149 a year through BalanceProof, cancel in one click, no card needed to try.