How to convert a Citi statement PDF to Excel or CSV

If you have a Citi account and need your transactions in a spreadsheet, you can convert the statement PDF on your own computer with StatementLocal. The file is read inside your browser and is never uploaded.

Step 1: download the statement PDF

  1. Sign in to Citi's website on a computer. Banking apps often show a statement without an easy way to save the PDF.
  2. Open the statements or documents section for the account. Banks usually call it something like Statements, or Statements and documents. Menus change, so Citi's own help pages are the final word on where it is.
  3. Choose the statement period and download the PDF. Save it where you can find it.
  4. Use the PDF exactly as downloaded. A statement that was printed and scanned back in has no text layer, and this version of StatementLocal cannot read scans.

Step 2: convert it

  1. Open the StatementLocal converter.
  2. Drop the PDF on the page, or choose it.
  3. Read the verdict at the top of the result:
    • Reconciled: the rows add up from the printed opening balance to the printed closing balance.
    • Off by $X, check rows N to M: something does not add up. The likely rows are highlighted.
    • Cannot check: the statement prints no balances to check against.
  4. If a row is wrong, fix it in the grid. The verdict updates when you leave the cell.
  5. Download CSV, Excel (.xlsx) or QuickBooks CSV. You can download 3 statements a day free.

Credit card statements: dates without a year, and signs

Card statements work differently from checking statements in two ways that trip up most converters.

Dates with no year. Card statements usually print transaction dates as MM/DD. StatementLocal takes the year from the statement period. A statement that runs from December 18 to January 17 puts the December rows in the earlier year and the January rows in the later one.

Signs. On a card statement, a purchase increases what you owe and a payment reduces it. StatementLocal checks a card statement the card way: previous balance, plus purchases and fees, minus payments and credits, should equal the new balance. If that adds up, you see Reconciled.

Before you import a card statement into accounting software, check which sign it expects. Most tools want purchases on a card account as money spent. If yours wants the opposite, flip the sign of the Amount column in Excel: put -1 in a spare cell, copy it, select the amounts and use Paste Special, Multiply.

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on real Citi statements, and we do not claim it reads every one. That is why every conversion is checked against the statement's own printed balances: if an amount is missed or misread, the totals stop adding up and you see Off by instead of Reconciled.

More answers are in the FAQ, and the privacy page lists exactly what the page sends (nothing, unless you use Pro).

StatementLocal is not affiliated with, endorsed by or sponsored by Citi or its parent company. The name is used only to say whose statements this guide is about.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.