How to Convert Citibank Statements to CSV or Excel

Why Convert Citibank Statements?

Citibank is a global banking leader and the fourth-largest bank in the US by assets, serving millions of customers with checking, savings, and credit card products including the popular Citi Double Cash and Custom Cash cards. Citi's PDF statements can be dense — credit card statements in particular may span many pages with foreign transaction fees, reward summaries, and promotional APR details mixed in with the actual transactions. For accountants, freelancers, and business owners, extracting just the transaction data from Citibank PDFs into a usable spreadsheet format is a recurring headache. BankRead's AI parser understands Citibank's statement layouts and pulls out clean, categorized transaction data automatically.

Understanding the Citibank Statement Format

Citibank checking account statements use a portrait PDF layout listing transactions chronologically with columns for Date, Description, Amount (debits and credits), and Balance. Citi credit card statements are more complex: they begin with an account summary (previous balance, payments, new charges, fees, interest), followed by a detailed transaction section with Transaction Date, Post Date, Description, and Amount. Foreign transactions include the original currency and conversion rate. The statement header shows the account number (last 4 digits), statement closing date, and payment due date.

How to Convert with BankRead

Follow these steps to convert your Citibank PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Citibank online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your Citibank Statement PDF

1. Sign in to Citi Online at online.citi.com with your user ID and password.
2. Navigate to the account you want (checking, savings, or credit card).
3. Click 'Statements' in the account menu or under 'Services.'
4. Select the statement period from the dropdown — Citi retains statements for up to 7 years.
5. Click 'View Statement' then use the download or print-to-PDF option to save the file.

What Data Gets Extracted

BankRead extracts the following fields from your Citibank statement:

• Transaction date (the date the transaction occurred)
• Post date (for credit card statements, the date it posted to the account)
• Description / merchant (e.g., 'UBER *TRIP HELP.UBER.COM CA')
• Debit amount (charges, purchases, fees)
• Credit amount (payments, returns, credits)
• AI-assigned category (e.g., Transportation, Food & Drink, Travel, Utilities)

Export Options

Once your Citibank statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for Citibank Statements

• Citibank credit card statements may include foreign currency transactions with original amounts — BankRead extracts the USD-converted amount used for billing.
• Long statements from high-spend months can reach 8–10 pages. All pages are processed in a single upload.
• Citi's promotional APR and rewards summary sections are skipped — only actual transactions are extracted.
• Citibank Costco Visa statements follow the same format as other Citi credit cards and are fully supported.
• Some Citi statements include a year-end summary PDF — this aggregate report is separate from monthly statements.

Common Issues and Solutions

• Citibank credit card statements list both Transaction Date and Post Date. BankRead uses the Transaction Date as the primary date, with Post Date available if your statement includes it.
• Citi checking statements sometimes include a 'Check Detail' section with scanned check images. BankRead extracts only the transaction rows, not check images.
• Very old Citibank statements (pre-2012) may be scanned image PDFs rather than text-based. BankRead handles these with AI vision extraction.

Frequently Asked Questions