Citi credit card statement to Excel
Drop a Citi card statement and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your Citi statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat a Citi statement looks like
| Columns | Sale Date · Post Date · Description · Amount |
|---|---|
| Dates | Two: transaction date and posting date |
| Sections | Payments, Credits and Adjustments · Standard Purchases |
Citi card descriptions are long, the full merchant name plus city and state, and routinely wrap onto a second line. The wrapped part carries no date and no amount, which is exactly the shape that turns into a phantom transaction.
How Citi writes its transaction lines
Citi card descriptions carry the full merchant name plus city and state, which is long enough to wrap onto a second line on most rows. The wrapped part has no date and no amount, and that is precisely the shape a converter mistakes for a new transaction.
What to check afterwards
Count your rows against the statement's own transaction count. More rows than transactions means wrapped descriptions were split; fewer means a page break swallowed something.
Where to download your Citi statement PDF
Account Details, then Statements, inside the card account at citi.com. Citi separates card and deposit statements even under one login.
Several cycles to combine? Merge the converted files, then check for duplicates where they overlap. Moving the result into accounting software: the QuickBooks route.
Citi statement questions
My converted file has more rows than the statement has transactions.
Wrapped descriptions were split. Citi's summary prints the transaction count; use it as your check every time. Fewer rows than that count means the opposite problem, usually a page break.
Do foreign transactions convert differently?
The amount converts the same, but Citi prints the original currency amount and the exchange detail on extra lines beneath the transaction. Those lines carry no date, so they behave like wrapped descriptions and belong to the row above.
Card statements carry no running balance, so the arithmetic check that verifies a bank statement cannot run here. Why that matters. On scans and how nothing is uploaded: read the details.