Convert Citibank statements to Excel
Citi lets you export card activity in several formats, from CSV to a QuickBooks file, but the search only reaches back two years. Banking statements are their own case, since Citi may group several accounts onto one statement. Whether you're holding a checking statement or a card statement full of foreign purchases, here is what to expect when you convert Citibank PDFs.
Private workspace. HTTPS upload. No credit card needed.
$9 for 25 pages, one-off, no subscription. See pricing
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Citibank statement into Excel
-
Download the PDF statement from Citibank online banking
- Sign on to Citi Online.
- Open the account and select 'View Statements'.
- Open the statement for the period you need.
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your Citibank statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about Citibank statements
Several accounts, one statement
Citi may combine your accounts on a common statement, which it calls Customer Statement Grouping, and in some cases you can ask for accounts to be split out. A grouped statement means one PDF holds activity for more than one account, so post each account's rows to the matching account in your books.
28 to 31 days, not calendar months
Citi defines a statement period as any span of 28 to 31 days, so month-end close doesn't always line up with it. With dates converted to YYYY-MM-DD you can filter to the calendar month you need, and consecutive statements are checked for gaps or overlaps.
Foreign purchases take extra lines
A purchase in another currency shows the original amount and the US dollar conversion on additional lines. Those lines describe the purchase; the dollar amount is what hits the account. When you review the output, that's the figure to expect in the amount column, and the one the balance check adds up.
Beyond the two-year search
Card activity search stops at two years. For earlier periods, request the older statements for download, then convert them here. They come out in the same date, description and amount columns as your recent exports, so the years line up in one workbook.
Output and review
From Citibank PDF to your books
Accounting tip
Citi's card export includes a QuickBooks (QBO) file for recent activity. For older statements, the QuickBooks-ready CSV uploads into QuickBooks Online with column mapping, and the Xero-ready CSV does the same through Xero's bank statement import.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
Citibank statement questions
Should I use Citi's export or convert the PDF?
Will a printed Citibank statement convert if I scan it?
Can I import converted Citibank rows into QuickBooks or Xero?
Convert your Citibank statement to Excel
Private workspace. HTTPS upload. No credit card needed.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Citibank.