Convert Citi credit card statement to Excel
To convert your Citi credit card statement to Excel, drop the PDF below. LedgerClip rebuilds the transaction table on your device and gives you an Excel workbook that gives you numeric amounts you can total and filter straight away. Nothing is uploaded.
Drop your Citi credit card statement here
or choose a file — PDF, scan, or photo
Statements are read here in your browser. Nothing is sent to a server.
0bytes uploaded
Statement format
Citi statements download as text PDFs that parse directly; a scan or photo works too via on-device OCR.
Good to know
Citi offers the current and past 12 months as PDF, Quicken, and Microsoft Money downloads, and its statements break out an Account Activity Summary, Transactions, Interest & Fees, and a Rewards Summary.
Also exports
Getting your Citi credit card statement
Log in to Citi Online, open the card, click the Statements (PDF) link, choose the statement date, and download; statements older than 12 months may need to be requested. It downloads as a text PDF that LedgerClip reads directly, and a scan or photo works too. See Citi's official statement help.
What you get
Each transaction becomes one row with the posting date, the description exactly as Citi printed it, the amount with the right sign, and the running balance. The opening and closing balances are checked against the total so an incomplete extraction is caught before import. On a credit card, purchases come out as negative amounts (money spent) and payments or credits as positive, and the QBO export is written as a credit-card account so QuickBooks files it correctly.
Other formats
Also available for Citi: CSV, QuickBooks (QBO).
Questions
- Does the Citi statement have to be a downloaded PDF, or can I use a scan or photo?
- Both work. A statement downloaded from Citi is read from its text and is the most reliable. A scan or a phone photo is read on your device with OCR and checked so the totals reconcile.
- Is my Citi statement uploaded anywhere?
- No. The file is opened by code running in your browser and never transmitted. The byte counter on the page shows zero throughout.
- What does the Excel file contain?
- Date, description, and the signed amount — purchases as negative, payments and credits as positive — plus the running balance when the statement prints one.
- How many statements are free?
- Three a month, with every export format. Pro removes the limit.
Convert another card
LedgerClip reads credit-card statements from every major issuer — also convert Bank of America, American Express, Discover to Excel, or see every supported bank and card. Need the Citi bank statement instead? Convert the Citi bank statement.
If your Citi statement does not parse, report it and the layout is added within days. Updated .