US
Upload a Citibank statement PDF and every transaction comes back as clean rows — date, description, amount and balance — pulled out of Citi's grouped layout and checked so the totals reconcile. Export to Excel, CSV, or a QBO/OFX file for QuickBooks.
Citibank checking statements don't run as one continuous list. Citi sorts the month into buckets by transaction type, which is easy enough to read on paper but scrambles the moment it lands in a spreadsheet.
How a Citibank statement is organized
A Citi checking statement is broken into labeled groups:
Section | What's in it |
|---|---|
Deposits, credits & interest | Money in — payroll, transfers, interest |
Debits | Card payments, ACH, transfers out |
Checks | Checks that cleared, by number |
Electronic & ATM | Online payments and ATM activity |
Every group has its own Date / Description / Amount columns, and there's no single balance beside each line. A tool that just reads down the page loses which bucket a line came from, so a debit can be counted as income. The converter tracks the group each transaction belongs to, sets the direction from that, and rebuilds one statement in date order.
Interest and linked accounts
Citi checking often earns interest, and it lands in the credits group as its own line rather than folded into your deposits — worth keeping separate when you're working out real income for the month. Citi customers also tend to link checking and savings, and a single statement can cover both. Each account keeps its own opening and closing balance, so the two never blur into one running total. The structure is the same from basic checking up to Citigold, so whichever tier you hold, the conversion behaves the same way.
Where to download your Citibank statement
- Online: sign in at citi.com, open the account, and go to Statements. Choose a period and download the PDF.
- App: tap the account, open Statements & Documents, pick the month and save the PDF.
Downloaded this way it's a digital PDF with selectable text, so the conversion is exact. A scanned or photographed statement works through OCR — it just takes a little longer.
Getting it into a spreadsheet or QuickBooks
- Excel or Google Sheets — one clean row per transaction, real numbers ready to total and filter.
- QuickBooks — a QBO or OFX file that imports as bank-feed transactions to categorize.
- Xero, Zoho and others — the same data in each one's format.
Before download, the figures reconcile: the section totals have to agree with the beginning and ending balance. On a grouped statement, that check is what stops a debit being counted as income.
Common snags with Citibank statements
- Groups flattened into one list. The converter keeps credits, debits and checks apart so directions stay correct.
- Checks in their own block. Each check number stays tied to its amount.
- Account tiers. Basic checking and Citigold statements share the same structure, so the same conversion works.
Frequently asked questions
Can I convert a Citibank statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the section totals checked so nothing is misclassified.
Why do my Citibank transactions come out mixed up in other tools?keyboard_arrow_down
Because Citi groups the month into credits, debits, checks and electronic transfers instead of one list. Tools that read top to bottom lose the labels. This one tags each group as money in or out.
Can I import a Citibank statement into QuickBooks?keyboard_arrow_down
Yes. Export to QBO or OFX and import it as a bank feed. If QuickBooks rejects a QBO file, OFX is the reliable fallback from the same converter.
Does it handle a statement that covers linked Citi accounts?keyboard_arrow_down
Yes. If your Citibank statement includes linked checking and savings, each account keeps its own opening and closing balance so the two aren't merged into a single total.
Does it read scanned Citibank statements?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from citi.com will convert faster and cleaner than a scan.
