How to Download and Convert Citibank Statements to CSV

Citi's online banking portal covers a wide range of account types: Citi checking and savings accounts through Citibank, and credit cards including the Double Cash, Custom Cash, Premier, and Prestige lines. The statement download experience is consistent across most of these, though there are some differences between deposit accounts and credit cards.

Like Bank of America and Chase, Citi offers both PDF statements and a direct data download from transaction history. The direct download is the faster option for recent data; the PDF is better for official records and older statement periods.

Option 1: Direct CSV or Excel download (fastest for recent data)

1. Log in at online.citi.com and select the account.
2. On the account activity page, look for the Download button near the top of the transaction list.
3. Select your date range and file format:
   • Microsoft Excel (.csv) for spreadsheets
   • Quicken (.qfx) for Quicken
   • QuickBooks (.qbo) for QuickBooks
   • Microsoft Money (.ofx) for Xero
4. Click Download.

Citi's CSV download typically includes Date, Description, Debit, and Credit columns (separate debit and credit rather than a single signed amount). When you import this into Excel or Sheets, you may need to combine these into a single Amount column depending on what your accounting tool expects.

Option 2: PDF statement download (for monthly records and older data)

Citi provides PDF statements going back up to 7 years for most accounts.

1. Log in to online.citi.com and select the account.
2. Click Statements and Documents (accessible from the account menu or the Accounts overview page).
3. Select the statement period and click Download PDF.

Converting Citi PDFs to CSV

Citi statement PDFs have a clean, consistent tabular layout. A dedicated parser converts them accurately. Upload your PDF to Statement Pro's Citi converter and download a clean CSV with Date, Description, and Amount columns.

Citi credit card statements and Citi checking statements use different column layouts. Credit card statements organize transactions by posting date and include a Reference Number column. Checking statements include a running balance column. A parser handles these differences automatically; a generic PDF tool may not.

Combining Citi's debit and credit columns

Citi checking accounts use separate Debit and Credit columns rather than a single signed Amount column. When merging these for import, the convention is: credits (deposits, incoming transfers) become positive amounts, and debits (payments, withdrawals) become negative amounts.

If you are doing this in Excel, use a formula like:

=IF(D2<>"",D2*-1,E2)

Where column D is Debit and column E is Credit. This produces a negative amount for debits and a positive amount for credits.

Importing into QuickBooks Online

For the cleanest import, use the QBO format from Citi's native download rather than CSV. Go to Transactions > Bank Transactions > File Upload and upload the QBO file directly. If you are using CSV, QuickBooks will ask you to map columns during the upload. If your CSV has separate Debit and Credit columns, QuickBooks will let you map both during the column mapping step.

Importing into Xero

Use the OFX download from Citi's native export for the easiest Xero import. In Xero, go to Accounting > Bank Accounts, select your Citi account, and click Import a Statement. If you are using CSV, Xero expects Date, Payee, Description, and Amount columns in a single signed format.

Citi credit card accounts vs. checking accounts

Citi credit cards and Citi bank accounts are on separate platforms within Citi's portal. If you access citibank.com and log in to your checking account, you may not see your credit card statements in the same view. If you cannot find a credit card statement in the main portal, try navigating to the credit card section directly.

For general guidance on PDF-to-CSV conversion, see How to Convert PDF to CSV. For other major bank guides, see the pages for Chase, Bank of America, and Capital One.