Convert a Citi statement to Excel, CSV or QuickBooks
Citi’s card statements are organised around who spent the money, not around when it was spent. On an account with more than one card, that changes what a conversion has to do.
Covers Citi Checking, Double Cash, Custom Cash and Costco cards.
Drop a PDF bank statement here
Only pages with transactions count against this.
Review
Example statementHabib Bank Limited · 0441-79002251-03 · 2026-04-01 to 2026-04-30
- Row-by-row running balance
- Page subtotals
- Opening + movement = closing
- Printed credit / debit totals
- Printed credit / debit totals
- Transaction count
Arithmetic only. Verifies that amounts, balances and totals agree. Does not verify descriptions or dates, and cannot detect two errors that cancel out.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Apr 02, 2026 | IBFT TRANSFER FROM ZAINAB TRADERS / INV-4471 | PKR 185,000.00 | PKR 1,247,350.00 | |
| Apr 03, 2026 | POS PURCHASE 4157 IMTIAZ SUPER MARKET KARACHI | PKR 12,480.00 | PKR 1,234,870.00 | |
| Apr 05, 2026 | UTILITY PAYMENT K-ELECTRIC ACCOUNT 04412297 | PKR 38,640.00 | PKR 1,196,230.00 | |
| Apr 08, 2026 | CHEQUE 000241 CLEARED — AL-NOOR PACKAGING | PKR 220,000.00 | PKR 976,230.00 | |
| Apr 11, 2026 | IBFT TRANSFER FROM MEHRAN ENTERPRISES / PO-8890 | PKR 342,500.00 | PKR 1,318,730.00 | |
| Apr 14, 2026 | SALARY DISBURSEMENT APRIL 2026 — 11 EMPLOYEES | PKR 685,000.00 | PKR 633,730.00 | |
| Apr 17, 2026 | BANK CHARGES — ONLINE TRANSFER FEE | PKR 1,150.00 | PKR 632,580.00 | |
| Apr 21, 2026 | IBFT TRANSFER FROM SIDDIQUI BROTHERS / INV-4488 | PKR 128,750.00 | PKR 761,330.00 | |
| Apr 24, 2026 | POS PURCHASE 9921 TOTAL PARCO FUEL STATION | PKR 18,900.00 | PKR 742,430.00 | |
| Apr 28, 2026 | PROFIT CREDITED — SAVINGS ACCOUNT | PKR 4,318.00 | PKR 746,748.00 | |
| Closing balance10 transactions | PKR 746,748.00 | |||
Export
Preview is free. Create a free account to download.
Guest plan · preview only, no downloads
Multi-card statements restart the dates for each cardholder
On a Citi account with supplementary cards, the statement lists each cardholder’s transactions under their own heading, and the dates start again at the top of each block. Extracted in page order the result interleaves nothing correctly: the rows are chronological within a person and jump backwards between people. Any date-ordered check fails, and a spreadsheet sorted by date silently mixes two people’s spending together with no column saying whose it was. The cardholder heading has to be read as a heading and, ideally, carried onto the rows beneath it — otherwise the information is simply lost in the conversion.
How a Citi statement is laid out
Worth checking against the statement in front of you — Citi issues more than one layout, and which you have changes what to look for after converting.
| Date format | MM/DD, with the year from the statement period |
|---|---|
| Running balance | Absent on card statements |
| Amount columns | One amount column; credits and payments carry a minus or are marked |
| Ordering | Grouped by cardholder on multi-card accounts, then by date within each |
| Sections | Payments and credits are listed separately from purchases |
Downloaded activity and statements are not the same thing
Every large US bank offers two different exports, and people reach for the wrong one constantly. Downloadable account activity — CSV, and often QFX or OFX — covers a recent window, typically a few months, and stops. Statements are PDFs, are issued per period, and go back years. If you need last March, the activity export will not have it and the statement will; converting the PDF is how that gap is closed.
Excel for Citi
On a multi-card account, review in a spreadsheet first — the rows need sorting and, often, splitting by cardholder before they are worth importing anywhere.
Convert to ExcelQuestions
- The dates in my Citi conversion go backwards. Is it broken?
- Probably not. If the account has more than one card, the statement itself restarts the dates for each cardholder. Sorting by date puts them in order; deciding whether you want them mixed together is the real question.
- Can I keep which card each transaction came from?
- Only if the conversion reads the cardholder headings rather than skipping them as decoration. It is worth checking on the first statement you convert, because losing it is silent.
- Does a Citi card statement have a running balance?
- No. Reconciliation uses the previous balance, the printed purchase and payment totals, and the new balance instead.