Convert Citi statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel files from the PDF.
Citi statement PDFs are not password-protected in the US. For deposit accounts Citi lets you download activity as a spreadsheet (CSV) for up to 180 days from the account activity page; the download opens in a pop-up, so if nothing happens it is your pop-up blocker.
Drop your Citi statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in USD.
Last updated
How to download a Citi statement as a PDF
- Sign on at citi.com and open the account.
- Click "Statements" (for cards it is under the account menu; for banking it is in the left navigation).
- Choose the statement period from the drop-down list.
- Click "Download" and save the PDF. Only one statement downloads at a time.
- In the Citi Mobile app, tap the account, then "Statements", then the period; the PDF opens and can be saved from the share sheet.
Then drop the file above; several months of Citi statements at once come back as one workbook.
Is the Citi PDF password-protected?
Citi statement PDFs are not password-protected in the US. Some Citi affiliates abroad do protect theirs, but that is a different portal.
What Citi statements look like
Checking and savings on one PDF, each with its own transaction list and balance summary.
Citi likes to put several accounts on one PDF: a Citigold or Citi Priority statement has a "Relationship Summary" on page one and then a "Checking Activity" and "Savings Activity" section for each account, each with Date, Description, Amount Subtracted, Amount Added and Balance columns. Because every account has its own opening and closing balance, the balance check runs per section. Dates are MM/DD and the year is on the statement period line. Card statements are laid out as "Payments, Credits and Adjustments", "Purchases", "Fees" and "Interest Charged" with a "Sale Date" and "Post Date" per row; we use the post date so the period totals agree. Page counts are modest, usually four to eight for banking and three to five for a card.
Why not use Citi's own export?
For deposit accounts Citi lets you download activity as a spreadsheet (CSV) for up to 180 days from the account activity page; the download opens in a pop-up, so if nothing happens it is your pop-up blocker. Credit card activity can be exported as CSV but not as QBO or QFX, which is a nuisance if QuickBooks Desktop is the destination. Either way, 180 days is half a tax year, and the export has no opening or closing balance. Statements are available online for 24 months on banking accounts and up to 7 years on cards, so once you need more than six months the PDF is what you have.
Where Citi statements trip up converters
- Checking and savings on one PDF: the balance check is per account, so if you need both, save each account section as its own PDF (Print → pages) for a clean tie-out.
- Citi card statements (see the credit card note below) use the sign convention where payments reduce the balance.
Which software Citi customers import into
Citi customers most often import into QuickBooks Online, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Citi questions
My Citi PDF has checking and savings in one file. Will the balances tie out?
Yes. The Checking Activity and Savings Activity sections are read as two accounts, each with its own opening and closing balance, so each ties out on its own and the result shows them side by side with a sheet per account in the workbook. The Relationship Summary page is not treated as an account. If a section were ever merged into another, printing each page range to its own PDF and uploading both gives the same result.
Citi will not give me a QBO file for my credit card. Is the PDF route any better?
It is the practical route. Convert the card statement and you get a spreadsheet with charges as debits and payments as credits, dated by posting date, which imports into QuickBooks Online through the CSV upload. The statement also carries the previous and new balance so you can confirm nothing was dropped, which the CSV export does not.
How do I convert a Citi statement PDF to Excel?
Download it from Citi using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many Citi statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.