Citibank statement to Excel
Citi statements print an account summary box above the ledger and set merchant names in capitals, truncated at the column edge. The summary stays out of the export, the truncated tails are rejoined, and the descriptions are kept exactly as printed so they still match your receipts.
Column layout
Retail banking statements print four columns; Citi credit cards drop the balance column entirely.
| Account type | Date column | Description column | Amount column | Balance column |
|---|---|---|---|---|
| Citi checking / savings | Date | Description | Amount | Balance |
| Citi credit cards | Date | Description | Amount | — |
Lines that look like transactions but are not
These sit in the same column band as the ledger and are excluded from the export:
- Beginning balance and ending balance captions.
- The account summary box on page one — interest earned, fees, APY.
- The repeated page header carrying the account number.
Why the descriptions look cut off
Citi truncates long merchant names at the column edge instead of shrinking the font, so the tail prints on the following line. Those tails are folded back into the row above rather than becoming rows with no date and no amount.
Questions
Does it work with Citi credit card statements that have no balance column?
Yes. The balance column comes out empty rather than guessed, and purchases are negative while payments and credits are positive.
Are the all-caps descriptions a problem?
No. They are kept verbatim — Excel and Google Sheets both search case-insensitively, so a capitalised merchant name still matches your own notes.
Can I convert several Citi accounts at once?
One file at a time, up to 30 pages. A monthly statement runs 3 to 6 pages, so several months fit in one conversion.
Other banks
Try it on your own statement
No account, no card, no email. Convert one file and check the rows against the original.
Open the converter