Citi statement to Excel, checked to the cent.
Drop a Citi checking or savings statement. You get a spreadsheet with a Proof tab that adds every transaction to the opening balance and compares it with the closing balance on your statement. Read in your browser, never uploaded.
Layout not confirmed. We found no sample statement published by Citi, so it is read by the generic reader and we cannot promise it works on yours. The Proof tab tells you whether it did.
Drop your Citi statement PDF
Checking or savings statement, downloaded from online banking
Several months? Select them together: you also get a month-to-month check.
OFX, the QuickBooks CSV and the Xero CSV are for accounting software that imports bank files, and are offered only when the statement balances to the cent. We test-imported the OFX and the QuickBooks CSV into GnuCash (free accounting software): every row, date, sign and the closing balance came out as on the statement. The QuickBooks CSV follows Intuit's published three-column layout (Date, Description, Amount); the Xero CSV has the columns Xero's help page describes (Date, Amount, Description, Cheque number; money out negative; no balances). GnuCash is not QuickBooks or Xero, we have not tried those two, and the Xero CSV has not been imported into Xero by us.
Tested in Microsoft Excel for Windows and Google Sheets (Excel for the web: not tested yet).
One workbook: a Chain proof sheet (live formulas: each month balances, and closing = next opening) and every transaction in one table.
Chase, Bank of America, Wells Fargo and TD Bank: tested on synthetic statements in their layouts and on the sample statements Wells Fargo and TD Bank publish, not yet on customer statements. U.S. Bank and Citi: no official sample exists that we could find, so they use the generic reader. Every file shows whether it balanced. How we test

Download your Citi statement as a PDF
Sign in at citi.com or in the Citi Mobile app.
Open the account and go to Statements.
Choose the month and download the statement as a PDF.
Menu names change from time to time. Look for "Statements". Use the monthly PDF statement: it includes the opening and closing balances the proof needs.
What SheetProof reads on a Citi statement
- Tables with separate money-out and money-in columns (for example Amount Subtracted and Amount Added, the headings described in a user-uploaded Citibank sample; Citi does not publish an official sample that we could find), so every amount gets the right sign when your file uses them.
- The balance printed at the end of a day (not on every row) is checked against the rows above it.
- The Beginning Balance and Ending Balance from the checking summary.
Status: layout not confirmed. We could not find a sample statement published by Citi, so we have never read its real layout; the test file we use is our own, modelled on descriptions, and proves nothing about yours. Treat Citi like any other bank on the generic reader: if your file does not balance, the tool tells you and marks the row, so you never get a silently wrong spreadsheet. If you try it, tell us how it went from the contact page (the bank and the result, never the file).
Citi statement to CSV
Want a CSV for a budgeting app or a spreadsheet? After the conversion, click Download CSV. Columns: Date (YYYY-MM-DD), Description, Amount (negative for money out), Running balance and Balance on statement. Map Date, Description and Amount when you import. For QuickBooks Online use CSV for QuickBooks instead.
The Proof tab only exists in the Excel file: CSV has no tabs. Check the verdict on this page before you import.
If it doesn't balance
You'll see the amount it's off by and the first row where the running balance stops matching the balance Citi printed. That usually means a line was missed or misread. The Excel file marks the row CHECK so you can compare it with the PDF in seconds.
Citi statement questions
How do I download my Citi statement as a PDF?
1. Sign in at citi.com or in the Citi Mobile app. 2. Open the account and go to Statements. 3. Choose the month and download the statement as a PDF. Menu names change from time to time: look for "Statements". Use the monthly PDF statement, not a screenshot or a print of the transaction list.
How do I convert a Citi statement to Excel?
Download the statement as a PDF from Citi online banking, drop it on this page and click "Download Excel (.xlsx)". The file has a Transactions tab and a Proof tab that checks the balance.
Can I convert a Citi statement to CSV?
Yes. After the conversion click "Download CSV". It has Date, Description, Amount, Running balance and Balance on statement columns.
Does it work with Citi credit card statements?
Not yet. SheetProof Convert reads checking and savings statements for now. If you drop a credit card statement, the tool tells you.
Is my Citi statement uploaded?
No. It is read by your browser on your device. Only anonymous events such as "a conversion happened" are counted, never the file or its numbers.
Can I convert several months?
Yes. Select the PDFs together (up to 12): you get one workbook with a Chain proof sheet that checks every month on its own and checks that each month opens where the last one closed, so a month missing in between shows. Or convert them one at a time: each file gets its own Proof tab.
Is SheetProof affiliated with Citi?
No. Citi is a trademark of Citibank, N.A.. SheetProof is an independent tool.
Other banks
Synthetic layout testedBank of AmericaBank of America statement to Excel & CSV
Synthetic layout testedWells FargoWells Fargo statement to Excel & CSV
Synthetic layout testedU.S. BankU.S. Bank statement to Excel & CSV
Layout not confirmed · proof still appliesTD BankTD Bank statement to Excel & CSV
Tested on a published samplePNCPNC statement to Excel & CSV
Generic reader · betaNavy FederalNavy Federal statement to Excel & CSV
Generic reader · betaCapital OneCapital One statement to Excel & CSV
Generic reader · betaHSBCHSBC statement to Excel & CSV
Generic reader · beta
Compare SheetProof Convert with DocuClipper and Bank Statement Converter