Convert Citi card card statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel, Xero files from the PDF.
US Citi card statements download as open PDFs with no password. The card's activity page has a Download link with an "Activity Since Last Statement" drop-down, which lets you pick a closed statement period or set a custom date range.
Drop your Citi card card statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in USD.
Last updated
How to download a Citi card card statement as a PDF
- Sign on at citi.com and choose the card from the account tiles on the dashboard.
- Open the "Statements" tab on the card page; some layouts label it "Statements & Documents" in the account menu.
- Choose a statement date from the list; the most recent twelve months open straight away as PDFs.
- For anything older, use "Request previous statements", tick the months you need and wait for the email; the requested PDFs stay in the list for about seven days before they have to be requested again.
- Click the download icon and save the file, one billing cycle per PDF.
- In the Citi Mobile app: tap the card, scroll to "Statements", pick the cycle and use Share or Save. The same twelve-month window applies in the app and older cycles are requested there or on the website.
Then drop the file above; several months of Citi card statements at once come back as one workbook.
Is the Citi card PDF password-protected?
US Citi card statements download as open PDFs with no password. The locked PDFs some people meet come from Citi's consumer portals in other markets; if that is what you have, type the password when the upload box asks for it and the file is unlocked on your device.
What Citi card statements look like
Sale Date and Post Date on every row, with activity split into "Payments, Credits and Adjustments", "Standard Purchases", "Fees Charged" and "Interest Charged", and an Account Summary that walks previous balance through to new balance.
A Citi card statement is three to five pages on a roughly thirty-day cycle. The Account Summary on page one lists Previous balance, Payments, Credits, Purchases, Cash advances, Fees, Interest and New balance, alongside a box giving Total fees charged and Total interest charged for the calendar year to date. Every transaction row has a Sale Date and a Post Date, both MM/DD, then Description and Amount, and the rows are grouped under "Payments, Credits and Adjustments", "Standard Purchases", "Fees Charged" and "Interest Charged". Payments and refunds print with a leading minus; purchases have no sign. Accounts with authorized users repeat the section headings under each cardholder's name, which is where the CSV's Member Name column comes from. Co-branded cards add a page: the Costco Anywhere Visa shows Costco Cash Rewards by category, AAdvantage cards show miles earned, and neither panel contains an amount that moves the balance. Custom Cash statements add a note showing which category earned the higher rate that cycle. Twelve months of statements are available immediately online and older ones back to seven years arrive within a few days of being requested.
Why not use Citi card's own export?
The card's activity page has a Download link with an "Activity Since Last Statement" drop-down, which lets you pick a closed statement period or set a custom date range. CSV is always offered; Quicken (QFX) and QuickBooks (QBO) have appeared and disappeared for card accounts over the years and are not reliably there, so treat them as varying by card. The card CSV has Status, Date, Description, Debit, Credit and Member Name columns, which makes it handy for splitting spend by authorized user. Against that, it has a single date rather than sale and post dates, it includes pending rows with a Status of Pending, and it carries no Previous Balance or New Balance, so you cannot prove a period from it. Statements themselves reach back seven years on request, far beyond what the activity download covers, and the PDF is what you convert when the numbers have to agree with what Citi printed.
Where Citi card statements trip up converters
- Two dates per row and the totals are built on the post date; a row booked on its sale date near a cycle boundary will not tie to the New Balance, which is where the check flags it.
- Payments and refunds carry a leading minus while purchases are unsigned, so a converter that treats every figure as a charge overstates the balance and fails the tie-out.
- Co-branded cards (Costco, AAdvantage) add a rewards panel that looks like a table; it carries no amounts that move the balance and does not become rows.
Which software Citi card customers import into
Citi card customers most often import into QuickBooks Online, Excel, Xero.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Citi card questions
The Citi statement I need is eighteen months old and not in the list. Do I have to phone?
No. The list shows the last twelve months; anything older is fetched with "Request previous statements" on the same page, which covers up to seven years. Citi emails when the PDFs are ready, usually within a few days, and they then sit in the statements list for about a week before dropping off. Request everything you need in one go, download the lot while the window is open, and convert them as a batch.
Which date does the Citi Account Summary work from, Sale Date or Post Date?
Post Date. The Purchases figure in the summary is the sum of everything that posted inside the cycle, regardless of when the sale happened, so a purchase with a Sale Date of the 29th and a Post Date of the 1st belongs to the next statement. stmtai uses the Post Date for the row and keeps the Sale Date in the description. If you rebuild the sheet on Sale Date the New Balance will not tie, and the check will point at the row that crossed the boundary.
My Costco Anywhere Visa statement has a rewards table with dollar figures. Will those be counted as transactions?
They should not be, and if a converter did count them the previous-to-new balance check would fail by exactly that amount. The Costco Cash Rewards panel is a summary of what you have earned this cycle and year to date; no money has moved on the card. The annual reward certificate is issued separately in February and is not a credit on the statement either. Only the rows under the four activity headings are transactions.
How do I convert a Citi card card statement PDF to Excel?
Download it from Citi card using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many Citi card statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.