Citibank is one of the most widely used banks for both personal and business banking, with over 200 million customer accounts worldwide. Converting Citi statement PDFs to Excel or CSV is a common task for bookkeepers, accountants, and business owners — but Citi's PDFs have several distinctive quirks that make the process more challenging than other banks.
The two biggest issues: (1) Citi frequently combines multiple accounts in one PDF, and (2) many Citi statements are password-protected. This guide covers both problems and walks you through every method for getting clean transaction data.
Citibank PDF Quirks You Need to Know
Before you try any conversion method, it helps to understand why Citi statements behave differently from other banks.
Combined Accounts in a Single PDF
If you have a Citibank checking account linked to a Citi Savings account (common with Citi's relationship banking packages), Citi typically issues one combined PDF statement that covers both accounts. The PDF will have a section for your checking account with its own header, balance, and transaction list, followed by a separate section for savings — all in the same file. Credit card accounts are always on separate PDFs.
This matters for conversion: a generic PDF tool will often merge both account sections into one undifferentiated transaction list, losing track of which transaction belongs to which account. A dedicated converter recognizes the account section headers and keeps them separate.
Password-Protected PDFs
Citibank applies password protection to PDF statements as a security feature. This is more consistent than at other banks — nearly all Citi statement PDFs downloaded from the portal are password-protected. The default password format is the last 4 digits of your Social Security Number. Some Citi accounts use a different format; check your statement welcome letter or Citi's help pages if the SSN-based password doesn't work.
Running Balance per Transaction
Unlike some banks that only show period-end balances, Citi includes a running balance column for each transaction in both checking/savings and credit card statements. This is excellent for verification — you can compare the balance after each transaction to spot conversion errors.
Separate Fee and Interest Sections (Credit Cards)
Citi credit card statements have distinct sub-sections at the bottom of the transaction list for "Fees Charged" and "Interest Charged." These entries have the same column structure as regular transactions but appear under labeled section headers. They need to be captured as transactions and categorized correctly, not excluded or treated as headers.
Unlocking Citi's Password-Protected PDFs
Before you can convert a password-protected Citi statement, you need to create an unlocked version. The easiest method uses Chrome's built-in PDF viewer — no additional software needed.
- Open the PDF in Google Chrome. Right-click the PDF file and choose "Open with > Google Chrome." Or drag and drop it into a Chrome window.
- Enter the password when prompted. Chrome will show a password entry dialog. Type the last 4 digits of your SSN and press Enter. The statement will open and display all pages.
- Print to PDF. Press Ctrl+P (Cmd+P on Mac) to open the Print dialog. In the "Destination" dropdown, select "Save as PDF." Make sure all pages are selected.
- Save the new file. Click Save and give the file a new name (e.g., "citi-june-unlocked.pdf"). This new PDF contains all the same transaction data but with the password restriction removed.
- Use the unlocked PDF for conversion. Upload this new file to BankStatementToCSVFile.com or any other converter.
How to Download Your Citibank Statement PDF
- Log in to citibank.com. Use your User ID and password. Complete two-factor authentication if prompted.
- Navigate to your account. From the dashboard, click on the checking, savings, or credit card account whose statement you need.
- Go to Account Details > Statements. Look for the "Statements" link in the account navigation menu. This shows a list of available statements by month.
- Select the statement month. Click the month you want. Citi will open it in your browser or prompt a download.
- Save the PDF. If it opens in your browser, press Ctrl+S to save. If it downloads automatically, find it in your Downloads folder.
Method 1: Free Online Converter (Recommended)
This is the recommended approach for all Citi statement types — checking, savings, and credit cards. It handles Citi's combined-account PDFs, correctly identifies account section breaks, and captures fee/interest sub-sections from credit card statements.
- Unlock the PDF first if it's password-protected (see the Chrome method above). The converter cannot process locked PDFs.
- Go to bankstatementtocsvfile.com. No account required for the free tier.
- Upload your Citi PDF. Drag and drop or click to browse. Files are transmitted over HTTPS and deleted after conversion.
- Wait 15–40 seconds. For combined-account PDFs, the converter identifies account sections. Output columns: Date, Description, Debit, Credit, Balance.
- Download CSV or Excel. Open the file and verify: correct transaction count, amounts match, dates are in chronological order, fee/interest rows are included.
Method 2: Citi Direct CSV Download
Citi's online banking portal allows direct download of recent transactions for checking and savings accounts. This covers the current statement period plus approximately 2 prior months. The downloaded file is already in CSV format — no PDF conversion needed.
- Log in and open your account at citibank.com.
- Go to Account Details > Download. The Download link is typically in the account activity view, near the transaction list filter options.
- Choose the date range. Select from available options (current statement, last 30 days, custom range up to ~90 days).
- Select format: CSV. Citi may also offer OFX/QFX format, which QuickBooks and Quicken can import directly.
- Download and open. The file contains Date, Description, Debit, Credit columns ready for import.
Method 3: Excel PDF Import
Excel's built-in PDF importer (Data → Get Data → From File → From PDF) works reasonably well for simple single-column transaction lists but fails consistently with Citi's format for two reasons:
- Multi-account PDFs: Excel treats each account section as a separate table and imports them independently. You have to manually merge and label them.
- Split sections (Deposits/Withdrawals): Citi checking statements separate transactions by type. Excel produces two or more unmerged tables that need to be combined and chronologically sorted by hand.
For a single-page, single-account Citi savings statement with fewer than 20 transactions, this method might be workable. For anything more complex, use Method 1 — it will save you 20–40 minutes of manual cleanup.
Citibank Account Types: Format Differences
| Account Type | PDF Format | Password Protected | Combined in One PDF | Direct CSV Available |
|---|---|---|---|---|
| Citibank Checking (Access, Regular, Interest) | Deposits / Withdrawals sections | Yes | May include savings | Recent only (2–3 months) |
| Citi Savings | Deposits / Withdrawals sections | Yes | May be combined with checking | Recent only |
| Citi Double Cash / Custom Cash / Citi Simplicity | Chronological by post date + sub-sections | Yes | No (separate PDF) | Recent only |
| Citi Premier / Citi Prestige | Chronological by post date + sub-sections | Yes | No (separate PDF) | Recent only |
| AAdvantage MileUp / Citi Diamond Preferred | Chronological by post date + sub-sections | Yes | No (separate PDF) | Recent only |
How Citi Credit Card PDFs Are Structured
Understanding the structure helps you verify your converted output is complete and correct.
Payment and Credits Section (Top)
The first section lists all payments you made to the account and any credits (refunds, promotional credits, dispute resolutions). These appear with the original transaction date and post date. Payments are typically identified with "THANK YOU FOR YOUR PAYMENT" in the description.
Purchases Section
The main body of the statement. Transactions are listed in chronological order by post date (the date the transaction cleared, which may be 1–3 days after the actual transaction date). Each row shows: Transaction Date, Post Date, Description, and Amount. A running balance appears after each transaction — this is the cumulative amount you owe, increasing with each purchase and decreasing with payments.
Fees Charged Section
Annual fees, late fees, balance transfer fees, and foreign transaction fees appear in a separate "Fees Charged" section below the purchases list. These have the same column structure as purchases and should be treated as regular debit transactions in your bookkeeping.
Interest Charged Section
Monthly interest charges (if you carry a balance) appear in a separate "Interest Charged" section. Citi itemizes interest by purchase type: Purchase APR, Cash Advance APR, Balance Transfer APR. Each appears as a separate line item.
How Citi Checking PDFs Are Structured
Deposits and Credits Section
Lists all money coming into the account: direct deposits, ACH credits, wire transfers, check deposits, and interest earned. Each entry shows the date, a description (often abbreviated bank code), and the amount. No debit column is shown in this section — only credits.
Withdrawals and Debit Transactions Section
Lists all outflows: ATM withdrawals, debit card purchases (listed by merchant), ACH debits, wire transfers, and checks. On multi-page statements, this section continues across pages. If a month has 60+ debit transactions, this section may span 2–3 pages, with the section header repeating on each new page (important for converters to handle correctly).
Check Images Section
If your account includes check image service, Citi includes miniature images of cleared checks at the end of the statement. These are purely visual and contain no additional transaction data not already listed in the withdrawals section.
Citi Business Banking
Citi business accounts are managed through a separate portal at online.citibank.com. Business account statements have a noticeably different header format — they include the business name, EIN (last few digits), and sometimes multiple account signatories.
Key differences from personal statements:
- Business statements may include multiple sub-accounts (e.g., operating + payroll) in one PDF — even more complex than the personal combined-account scenario.
- Business credit cards (CitiBusiness card, CitiBusiness AAdvantage) are on separate statements, same structure as personal credit cards.
- Password format: Business statements may use a different password — often the last 4 digits of the EIN rather than SSN. Check the PDF cover letter for instructions.
- Citi Treasury Management clients have access to more sophisticated export options through the CitiDirect BE portal.
Importing Your Citi CSV into QuickBooks
After converting your Citibank statement to CSV, import it into QuickBooks Online in a few minutes:
- In QuickBooks Online, go to Banking (Transactions) → Upload from file.
- Select your Citi CSV and the corresponding QuickBooks account. For credit card statements, make sure the account type is "Credit Card" in QuickBooks, not "Bank." This affects how debits and credits are interpreted.
- Map the columns. Date → Date, Description → Description, Debit → Amount (negative) or Debit, Credit → Amount (positive) or Credit. Click Next.
- Review the imported transactions. QuickBooks will show a preview — verify dates and amounts look correct before finalizing.
- Set up Bank Rules for recurring Citi items. Common rules: "CITIBANK INTEREST CHARGE" → categorize as Bank Charges/Interest Expense; "AUTOPAY PAYMENT THANK YOU" → categorize as Credit Card Payment; "LATE FEE" → categorize as Bank Fees.
Convert Your Citibank Statement Now
Free · Handles password-unlocked PDFs · Multi-account statements · All Citi credit cards · No signup required
Convert Citibank Statement Free →Frequently Asked Questions
Why is my Citibank PDF password-protected and what is the password?
Citi password-protects statements as a security measure. The default password is the last 4 digits of your Social Security Number. If that doesn't work, try your full date of birth (MMDDYYYY format) or check the PDF's accompanying email or cover page for alternative password instructions. To remove the password permanently, open the PDF in Chrome, enter the password, print to PDF via Ctrl+P → Save as PDF — this creates an unlocked copy you can convert freely.
My Citi PDF has both checking and savings — how do I split them?
Citibank frequently combines linked checking and savings accounts in one PDF, with each account in its own labeled section. When you upload a combined PDF to BankStatementToCSVFile.com, the converter detects the account section headers and can output them as separate files or clearly label each row with the account it belongs to. Verify the output by comparing the transaction count and closing balance for each account against the statement's summary page.
What's different between a Citi credit card statement and checking statement format?
Citi checking/savings statements group transactions into Deposits and Withdrawals sections (transactions in each section ordered by date, but the two sections are separate). Citi credit card statements list all transactions chronologically by post date in a single list, with additional sub-sections at the bottom for Fees Charged and Interest Charged. Both types show a running balance per transaction. The converter handles both layouts automatically and filters out non-transaction rows (summary data, minimum payment notices, reward points summaries).
How far back can I get Citibank statements online?
Citibank makes 7 years of statements available in the online portal under Statements & Documents. For statements older than 7 years, call Citi customer service at 1-800-374-9700 or visit a branch. Archived statements older than 7 years may incur a fee (typically $5–$10 per statement) and may take 7–10 business days to produce. Once received by mail, scan them and convert using the OCR-capable converter.
Can I import a converted Citi statement into QuickBooks for reconciliation?
Yes. After converting your Citi statement to CSV, go to QuickBooks Online → Banking → Upload from file. Select the CSV, match it to the correct account (Bank type for checking/savings, Credit Card type for Citi credit cards), map Date/Description/Debit/Credit columns, and import. For best results, set up Bank Rules for recurring Citi items like interest charges, annual fees, and autopay entries so they categorize automatically on future imports. Then use the standard Accounting → Reconcile flow to match your imported transactions against the statement.
Does the converter work for Citi business account statements?
Yes, BankStatementToCSVFile.com handles Citi business banking statements. Business PDFs have a different header layout (business name, EIN fragments) but the transaction table structure is similar to personal accounts. The password for business statements may be the last 4 digits of the EIN rather than SSN — check the statement cover page. For Citi Treasury Management accounts (accessed via CitiDirect BE), those have dedicated export functionality within the treasury platform that bypasses the need for PDF conversion entirely.