Convert a Citibank statement PDF to Excel

How to convert a Citibank statement PDF to Excel

1. Download the PDF: sign on to Citi Online (or the Citi Mobile app), open the checking account, go to Statements and choose the month. Use the downloaded PDF, not a scan of a paper statement: scans don't work yet.
2. Upload it above. Utilly reads the activity table on every page and checks Opening Balance + transactions = Closing Balance. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
3. Download the CSV and open it in Excel. Dates and amounts come in as real dates and numbers, in the statement's order.
4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a Citibank statement

A Citibank checking statement opens with a summary of every account on it (Value of Accounts, or a Relationship Summary on older statements) and the fees for your account package. Then each account gets its own Checking Activity table: Date, Description, Amount Subtracted, Amount Added and Balance. Citi often puts checking and savings on the same statement, one table after the other.

What this is based on: test statements built in Citibank's current and older checking layouts above, with made-up names and transactions, plus a 2024 Citigold checking statement that was filed publicly as a court exhibit: its first account read 2 of 2 rows and balanced, and the second account on it read all 31 rows to that account's closing balance. We don't link to it because it contains a person's details. We haven't run every Citibank statement style through it: CitiBusiness checking, Citi Private Bank and statements in other currencies haven't been tested, and a statement scanned or rotated before it was saved won't read. That's why the balance check runs on every file: if yours doesn't balance, you see the difference before paying.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-01,ACH Electronic Credit SAMPLE CO PAYROLL PPD ID: 1234567890,2150.00,6360.55
2026-09-02,Debit Card Purchase 08/30 11:42a #4417 DEMO GROCERY #112 BROOKLYN NY 26243 Supermarkets,-84.12,6276.43
2026-09-04,Zelle Debit PAY ID:CTIab12cd ORG ID:CTI NAME:ALEX RIVERA,-600.00,5660.44
2026-09-08,Check # 1052,-1250.00,4410.44
2026-09-11,Other Debit,-125.00,4085.44

Want money in and money out in two columns again? Use =MAX(C2,0) and =MAX(-C2,0). Want to group spending? The category Citi prints under card purchases is at the end of the description, so a filter on "Restaurant" or "Supermarkets" finds them.

How far back Citibank statements go

Sources: Citibank: Online Bank Statements (24 months online, PDF, archived statements in 24-48 hours, no paperless for business accounts in Citi Online), Citibank: Consumer Deposit Account Agreement, effective Nov 20, 2025 (section 4, Account Statements: combined statements, separate statements on request, 28-to-31 day periods, 18 months of check images). Checked Oct 25, 2026.

QuickBooks and Quicken files for Citibank

If Citi Online lets you download the activity you need for the right dates, use that. For older months, or when all you have is the statements a client sent you, start from the statement PDF. The same Utilly conversion that gives you Excel also includes:

One credit covers every format of that statement. If a bank feed or an earlier download already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, Capital One statement to Excel, or U.S. Bank statement to Excel.