How to Convert Citi Bank Statement to Excel

Citibank and Citi credit cards provide statements in PDF format. Here's exactly how to convert them to Excel for analysis and reconciliation.

Quick Convert: Skip the manual steps and convert your Citi statement instantly with Data River →

---

Downloading Your Citi Statement

Step 1: Log into Citi Online

1. Go to citibank.com (for banking) or citi.com/credit-cards (for credit cards)
2. Sign in with your User ID and password
3. Complete any 2-factor authentication

Step 2: Navigate to Statements

For Bank Accounts:

1. Select your checking, savings, or money market account
2. Click "Statements & Documents" or "eDocuments"
3. Choose the statement period you need

For Credit Cards:

1. Select your credit card account
2. Click "Statements" in the menu
3. Choose the billing statement

Step 3: Download PDF

1. Click "Download" or the PDF icon next to the statement
2. Save to your computer
3. Note: Citi statements are digital PDFs (not scanned)

---

Understanding Citi Statement Format

Bank Account Statements

Citi bank statements typically include:

Header Information:

• Account number (last 4 digits shown)
• Statement period
• Account summary with balances

Transaction Table:

• Date - Transaction date
• Check Number - If applicable
• Description - Payee/merchant name
• Withdrawals - Debits (money out)
• Deposits - Credits (money in)
• Balance - Running balance

Summary Section:

• Beginning balance
• Deposits and other credits
• Checks and other withdrawals
• Service charges and fees
• Ending balance

Credit Card Statements

Citi credit card statements include:

Account Summary:

• Previous balance
• Payments and credits
• Purchases and balance transfers
• Cash advances and fees
• Interest charged
• New balance
• Minimum payment and due date

Transactions:

• Date - Transaction or posting date
• Description - Merchant name and location
• Reference Number - Transaction ID
• Amount - Purchase amount

---

Method 1: Bank Statement Converter (Recommended)

Steps

1. Go to Data River or similar converter
2. Upload your Citi PDF
3. Wait for processing (usually under 30 seconds)
4. Download Excel/CSV

Output Format

For Bank Accounts:

For Credit Cards:

Advantages

• Accurate extraction of complex Citi layouts
• Preserves check numbers for reconciliation
• Handles both bank and credit card formats
• Works with all Citi account types

---

Method 2: Citi Transaction Download

Citi offers direct transaction downloads with some limitations.

For Bank Accounts

1. Log into Citi online banking
2. Go to your account
3. Click "Download to Spreadsheet" or "Download Transactions"
4. Select date range (typically up to 18 months)
5. Choose format: Microsoft Excel, Quicken, QuickBooks, or CSV
6. Click "Download"

For Credit Cards

1. Log into Citi credit card account
2. Click "Download" in the account activity section
3. Select date range
4. Choose CSV, QFX (Quicken), or QBO (QuickBooks)
5. Download file

Limitations

• Only activity, not full statement (missing fees breakdown, interest calculations)
• May not match statement period exactly
• Different column structure than PDF statement
• Historical limit (typically 12-18 months)

---

Method 3: Copy-Paste (Manual)

Works for quick exports but requires cleanup.

Steps

1. Open Citi PDF in a viewer
2. Select the transaction table
3. Copy (Ctrl+C / Cmd+C)
4. Paste into Excel
5. Use "Text to Columns" to separate columns
6. Clean up formatting

Challenges with Citi Statements

• Two-column transaction layout can misalign
• Check numbers may not paste in correct column
• Long merchant descriptions wrap to multiple lines
• Requires manual reformatting

---

Citi Account Type Specifics

Citibank Checking (CitiBank, Citigold)

• Check number tracking - Important for reconciliation
• Electronic transactions clearly labeled
• Multiple page formats for high-volume accounts
• Citigold accounts may include investment summaries

Citibank Savings and Money Market

• Interest calculation details shown
• Tiered interest rates for higher balances
• Fewer transactions - simpler to convert
• Monthly service fee clearly itemized

Citi Credit Cards

Citi offers many card types with varying statement formats:

Popular Citi Cards:

• Citi Double Cash - 2% cash back
• Citi Custom Cash - 5% on top category
• Citi Premier - Travel rewards
• Citi Diamond Preferred - Balance transfer
• Costco Anywhere Visa (by Citi) - Costco rewards

Credit Card Statement Features:

• Rewards summary (points, cash back, miles)
• Foreign transaction details if applicable
• Interest charge calculation - APR and daily rate shown
• Payment allocation - How payments are applied

---

Handling Citi Business Accounts

Citi business banking statements include:

• Business name and DBA
• EIN or tax ID reference
• Merchant services fees (if applicable)
• Wire transfer details
• Higher transaction volumes

Recommendation: Use a converter for business statements due to complexity and volume.

---

Common Citi Conversion Issues

Issue: Check Numbers Missing or Wrong Column

Citi statements show check numbers in a separate column, but generic converters may miss this.

Solution: Use a converter that handles Citi's check column format, or manually verify check numbers after conversion.

Issue: Foreign Transaction Currency Confusion

Citi credit card statements show both foreign currency amount and USD conversion.

Solution: Ensure your converter captures the USD amount (what you actually paid), not the foreign currency amount.

Issue: Pending Transactions

PDF statements don't include pending transactions.

Solution: Use Citi's online transaction download for most recent activity.

Issue: Multiple Accounts on One Statement

Citigold and business customers may receive combined statements.

Solution: Process each account section separately if your converter struggles with multi-account layouts.

---

Verifying Your Conversion

After converting, verify accuracy:

1. Transaction Count

Count rows in Excel. Should match number of transactions on statement.

2. Total Withdrawals

=SUM(D:D)

Should match "Checks and Other Withdrawals" total on statement.

3. Total Deposits

=SUM(E:E)

Should match "Deposits and Other Credits" total on statement.

4. Balance Reconciliation

Beginning Balance + Total Deposits - Total Withdrawals - Fees = Ending Balance

Ending balance in Excel should match statement.

---

What to Do With Converted Data

Expense Tracking

1. Add category column
2. Categorize each transaction (rent, groceries, utilities, etc.)
3. Create pivot table to summarize by category
4. Analyze spending patterns monthly

Accounting Integration

1. Import to QuickBooks - see how to import bank statements into QuickBooks
2. Import to Xero - see how to import bank statements into Xero
3. Match transactions to invoices and bills
4. Reconcile account monthly

Tax Preparation

1. Filter business expenses (if mixed personal/business account)
2. Identify deductible items
3. Create summary report by tax category
4. Export for accountant

Check Reconciliation

1. Sort by check number
2. Identify outstanding checks (issued but not cleared)
3. Match to check register
4. Flag discrepancies

---

Batch Converting Multiple Citi Statements

For annual record-keeping or tax preparation:

Process

1. Download all monthly statements for the year
2. Name consistently: Citi_Checking_2026-01.pdf, Citi_Checking_2026-02.pdf
3. Upload all to converter (if batch processing supported)
4. Combine into master Excel file
5. Add "Month" or "Quarter" column for analysis

Combined Analysis Format

Month,Date,Description,Withdrawals,Deposits,Balance
2026-01,01/15/26,PAYROLL,,2500.00,5500.00
2026-02,02/15/26,PAYROLL,,2500.00,8000.00

Enables year-over-year comparisons and tax reporting.

---

Citi Credit Card Rewards Tracking

Many Citi cards show points or cash back earned per statement period.

Extracting Rewards Information

1. Check statement summary page for rewards earned
2. Note reward rate (1%, 2%, 5% depending on category)
3. Calculate lifetime rewards by tracking across statements
4. Track redemptions separately

Popular Citi Rewards Programs

• ThankYou Points (Citi Premier, Prestige) - Transfer to airlines or redeem for travel
• Cash Back (Double Cash, Custom Cash) - Statement credit or direct deposit
• Costco Cash Back - Annual reward certificate

---

Summary

Converting Citibank statements to Excel is essential for detailed financial analysis and accounting workflows. Download your PDF from citi.com, use a converter to extract transactions accurately, and verify totals against your statement. Citi's structured format converts reliably for both bank accounts and credit cards. The resulting spreadsheet enables budgeting, reconciliation, and integration with accounting software.

Ready to convert your Citi statement? Try the Citi Statement Converter →