4 Methods Compared · Updated 2026

How to Convert a Citibank Statement to CSV

Q: Is Adobe Acrobat Pro good for converting Citibank statements?

Adobe Acrobat Pro can export PDFs to Excel via All Tools then Export a PDF. Results on bank statements are inconsistent. Adobe often creates extra columns from layout artifacts, requires manual cleanup, and lacks balance reconciliation or account splitting for Citi combined statements. It is acceptable for occasional one-off conversions if you already pay for Adobe.

Q: What is the easiest way to convert multiple Citibank statements at once?

Dedicated bank statement converters (SendItSheets, DocuClipper, CapyParse, Bankstatemently, LedgerBox, and others) handle batch uploads natively. Power Query and Adobe Acrobat are designed for single-file processing, so converting 12 monthly statements with them means running the workflow 12 times.

Q: Can I import Citibank statements directly into QuickBooks?

Yes, via two paths. For recent activity you can connect Citi as a bank feed in QuickBooks Online or upload a downloaded transaction file. For older PDF statements, convert first. Most dedicated converters output QBO directly, or you can use CSV upload in QuickBooks Online with manual column mapping.

Q: Are scanned Citibank statements supported?

Native Citi PDFs downloaded from citi.com are digital and text-based, so they work with most methods. Scanned or photographed paper statements require OCR before conversion. Power Query and basic Adobe export typically struggle with scanned files, while dedicated converters with OCR built in handle them better.

Citibank delivers statements as PDFs. There is a native transaction download for recent activity on both Citi deposit accounts and Citi credit cards, but it is date-range limited, and older monthly statements are PDF only. To get your full history into a spreadsheet you have four practical options. This guide walks through each, with step-by-step instructions and an honest look at where each method falls short.

Quick Answer

The four methods to convert a Citibank statement to CSV are: (1) Citi's native transaction download (free, recent activity only, date-range limited), (2) Excel Power Query Get Data from PDF (free, Windows only, struggles with multi-page and combined statements), (3) Adobe Acrobat Pro export (paid, manual cleanup required), and (4) dedicated bank statement converters (free tier available, handles Citi quirks automatically). Dedicated converters are the most accurate for older PDFs, credit card statements, and Citi combined relationship statements with more than one account.

Jump to methods Which method should I use?

Why converting Citibank statements is harder than it should be

Citibank delivers most of its statements as PDFs, which look fine on screen but were never designed for data extraction. Three Citi quirks make conversion harder than for a typical PDF table:

Two different statement layouts. Citi deposit statements (checking and savings, such as Citi Priority or the Citibank Account) and Citi credit card statements use different formats. Deposit statements list debits and credits with a running balance. Credit card statements add sections for payments, purchases, fees, and interest charged. A tool has to handle both, and generic converters often mis-read the credit card interest and fee blocks as transactions.

Combined relationship statements. Citi bundles the accounts in a banking relationship, such as a Citi checking and a Citi savings, into a single PDF statement, each with its own header, transaction table, and balance summary. Tools that are not account-aware merge everything into one block or capture only the first account.

Co-brand credit cards use the Citi format. The Costco Anywhere Visa and Citi / AAdvantage cards are issued by Citi, so their statements follow the standard Citi credit card layout, interest and fee sections included. If you are converting a Costco card statement, you are really converting a Citi statement.

The rest of this guide walks through the four practical methods to handle these challenges, with step-by-step instructions for each.

Citi's native transaction download

Free Easiest Recent activity only

Citi online banking and the Citi Mobile app include a transaction download for recent activity on both deposit accounts and credit cards. This is the fastest method when the data you need is still inside the available date-range window.

You'll need:

Citi online banking or Citi Mobile login
Transactions within the available download window (varies by account)

Log into citi.com on a desktop browser (or open the Citi Mobile app).
Select the account you want to export (a Citi checking, savings, or a Citi credit card such as the Costco Anywhere Visa).
Open the account's Account Activity or Transactions view.
Find the Download option (usually near the transaction list or under a menu above the activity table).
Choose a date range for the transactions you want to export.
Select the file type: CSV or Excel for spreadsheet use, or QFX/QIF for Quicken and similar software.
Click Download. The file saves to your computer.
Open the file in Excel, Google Sheets, or your accounting software.

What works well

Free and fast, no third-party tools
Data comes from Citi directly, so it is authoritative
Multiple format options (CSV, Excel, QFX, QIF)

Limitations

Only covers recent activity within the available download window (varies by account)
Cannot reach older monthly statements, which are available only as PDFs
Live transaction feed, not the official monthly statement; formatting and categorization may differ
One account at a time; does not handle combined relationship statements in a single pass
Bookkeepers receiving PDF statements from clients cannot use this method

Use this method when your transactions are still in the download window and you want the fastest path. Skip ahead to methods 2-4 for older statements or PDF-only data.

Excel Power Query (Get Data from PDF)

Free with Excel Moderate Windows only

Microsoft Excel includes a PDF data import feature called Power Query (also called "Get Data from PDF"). This method works on Windows versions of Microsoft 365 and Excel 2019+. It is free if you already have Excel.

You'll need:

Excel 2019 or later, or Microsoft 365, on Windows
The Citi statement saved as a PDF on your computer
A digital (text-based) PDF, not a scanned image

Open a blank Excel workbook.
Go to the Data tab in the ribbon.
Click Get Data > From File > From PDF.
Browse to your Citi PDF and click Import.
The Navigator window opens, showing tables Power Query detected. Citi statements typically appear as separate tables per page. Click each one to preview.
Select the transaction table you want (or multiple, via Ctrl-click).
Click Transform Data to open the Power Query Editor for cleanup.
In the editor: rename column headers, remove header/footer rows, filter out balance summary and (on credit cards) interest and fee rows, and adjust column data types (Date, Currency, Text).
Click Close & Load to push the cleaned data into a new Excel sheet.
Save the file as .csv via File > Save As if you need CSV format.

What works well

Free if you already have Excel
Refreshable: load a new statement to the same folder and Power Query applies the same cleanup steps
Full control over data transformations

Citi issues

Often picks up only the first page of multi-page statements (a documented Power Query behavior)
Combined relationship statements merge into one mess or only the first account appears
Credit card interest and fee sections get pulled in alongside transactions and need manual removal
No balance reconciliation, so errors pass through silently
Not available on Mac (Power Query for PDF is Windows-only)
Each new statement requires going through the cleanup steps unless you build a reusable query

Best for: technically comfortable users on Windows with a single-account, single-month Citi checking statement. Skip if you have credit card PDFs, combined relationship statements, or batch processing needs.

Adobe Acrobat Pro export to Excel

Paid (Adobe subscription) Easy Cleanup required

Adobe Acrobat Pro (part of the Adobe Acrobat subscription) includes PDF-to-Excel export. This is convenient if you already pay for Adobe, but the output usually requires manual cleanup before it is usable.

You'll need:

Adobe Acrobat Pro subscription (currently around $23/month standalone, included in Creative Cloud)
The Citi statement PDF
Excel or Google Sheets to open and clean the output

Open the Citi PDF in Adobe Acrobat Pro.
Click All Tools in the left sidebar.
Select Export a PDF.
Choose Microsoft Excel as the export format.
From the dropdown, select Excel Workbook (.xlsx).
Click Convert to XLSX.
Choose a save location and click Save.
Open the resulting Excel file. Expect to clean up extra columns, merged cells, and misaligned rows, especially on credit card statements.
If you need CSV, save the cleaned Excel file as CSV via File > Save As.

What works well

Works on both Mac and Windows
Handles scanned PDFs via OCR (using Enhance Scans > Recognize Text first)
Familiar workflow if you already use Adobe

Citi issues

Often produces many extra columns from layout artifacts (widely reported in Adobe's user forums)
Does not understand bank statement structure; treats it as generic PDF data
No balance reconciliation or duplicate detection
Combined relationship statements merge together; account boundaries are lost
Credit card interest and fee sections come through as if they were transactions
Manual cleanup time often equals or exceeds the conversion time itself
Requires a paid Adobe subscription

Best for: occasional one-off conversions when you already pay for Adobe and have time for cleanup. Avoid for recurring bookkeeping work or batch processing.

Dedicated bank statement converters

Free tier + paid plans Easy Built for the job

Several tools are purpose-built for bank statement extraction. They understand the structure of statements (transactions vs. summaries, account boundaries, balance reconciliation) and handle Citi's specific quirks automatically. The category includes SendItSheets, DocuClipper, CapyParse, Bankstatemently, LedgerBox, and others. Most offer free tiers for trial.

You'll need:

Your Citi PDF statement (or several, for batch processing)
A free account on whichever converter you choose

Choose a converter. Most offer free tiers (typically 5-10 pages per month) so you can test before committing.
Sign up for a free account. No credit card is usually required for the free tier. Try SendItSheets here if you want to start with a Citi PDF now.
Upload your Citi PDF via drag-and-drop or file picker.
Wait for processing (typically 6-30 seconds per statement depending on length).
Review the extracted data on screen. Most tools show a side-by-side comparison with the original PDF.
If the tool offers it, check the balance validation: beginning balance + transactions = ending balance.
Export to your preferred format: CSV, Excel (XLSX), or QBO for QuickBooks.
Import into Excel, Google Sheets, QuickBooks, Xero, or your accounting software.

What works well

Designed specifically for bank statements: understands transactions vs summaries
Splits Citi combined relationship statements into separate accounts
Separates credit card transactions from interest and fee sections (including Costco Anywhere Visa and AAdvantage cards)
Balance reconciliation built in: catches errors before export
Batch upload for multiple statements
Works on Mac and Windows (browser-based)
Handles scanned PDFs via OCR

Tradeoffs

Requires creating an account (most are free for low volume)
Higher volume usually requires a paid plan
Cloud-based, so uploads leave your computer (most use encryption in transit)
Different tools handle Citi quirks with varying accuracy. Test on the free tier first

Best for: bookkeepers handling multiple client statements, anyone reconciling year-end records from older PDFs, users with combined relationship statements, and credit card PDF conversions (including Costco and AAdvantage cards). SendItSheets falls in this category and is designed for bulk bookkeeper workflows. See the comparison below for when it is the right fit.

Which method should I use?

The right method depends on your situation. Use this table to match your use case to the best method.

If you...	Use this method	Why
Need recent transactions (within the download window) for a single account	Method 1: Citi download	Fastest path. Data comes from Citi directly, no third-party tool needed.
Have a single-month, single-account Citi checking statement PDF and use Windows Excel	Method 2: Power Query	Free, works well on simple cases. Skip for credit cards or combined statements.
Convert one or two statements occasionally and already pay for Adobe	Method 3: Adobe Acrobat	Convenient if Adobe is already in your stack. Expect cleanup time.
Need to convert older PDF statements (beyond the download window)	Method 4: Dedicated converter	Only method that works for older PDFs that are no longer in the transaction download.
Have Citi credit card statements with interest and fee sections	Method 4: Dedicated converter	Separates real transactions from interest and fee blocks. Generic methods mix them together.
Have a Costco Anywhere Visa or Citi / AAdvantage card statement	Method 4: Dedicated converter	These are Citi-issued cards on the Citi credit card format; a dedicated converter parses them cleanly.
Have Citi combined relationship statements with more than one account	Method 4: Dedicated converter	Account-aware extraction splits accounts automatically. Generic methods merge or drop accounts.
Are a bookkeeper processing many client statements monthly	Method 4: Dedicated converter	Batch uploads and validation save hours per client. SendItSheets, DocuClipper, and similar tools are built for this workflow.
Doing year-end catch-up across 12+ monthly statements	Method 4: Dedicated converter	Batch processing handles the volume. Manual methods do not scale to 12+ statements.
Need to import directly into QuickBooks	Method 1 (recent) or Method 4 (older)	Both can produce a QuickBooks-ready file. The download is direct from Citi; converters work on PDFs.

Citibank quirks every method has to handle

Regardless of which method you choose, three Citi issues will affect your output. Knowing about them upfront lets you verify the conversion handled them correctly.

Combined relationship statements

Citi can place a checking and a savings account from the same relationship in one PDF, each with its own header and balance summary. Check that your output preserves account boundaries. If all transactions appear in one mass, the account information is lost.

Credit card interest and fees

Citi credit card statements, including the Costco Anywhere Visa and AAdvantage cards, add sections for payments, interest charge calculations, and fees below the transaction table. Generic tools often pull these lines in as if they were purchases. After conversion, confirm that only real transactions made it into your CSV.

Balance reconciliation

Citi deposit statements include a beginning balance, transactions, and an ending balance. After conversion, verify: beginning + transactions = ending. If not, your conversion missed something (a fee, an interest charge, or a transaction split across pages). Methods with built-in balance validation catch this automatically.

Need this for banks beyond Citibank?

The methods above work for any US bank's PDF statements with bank-specific quirks. For Chase, Bank of America, Wells Fargo, Capital One, U.S. Bank, and other major banks, see our bank statement to Excel guide with supported institutions, security details, and bulk processing workflows.

Frequently asked questions

Does Citibank offer a direct CSV download for statements?

Partially. Citi online banking and the Citi Mobile app let you download recent account activity as CSV or Excel (and QFX/QIF) for a chosen date range from the account activity view (Method 1 above). This is a live transaction export, not the formal monthly statement, and older activity beyond the available window is available only as a PDF statement, so conversion is required for full history.

How many years of Citibank statements are available online?

Citi typically keeps several years of PDF statements available in online banking, often up to seven years for many deposit and card accounts. To find them, log into citi.com, open the account, and look for Statements or Documents. The structured transaction download window is shorter than the PDF statement archive, so older months are usually available only as PDFs that need conversion.

Why do Citibank statements come in two different layouts?

Citi deposit statements (checking and savings, such as Citi Priority or the Citibank Account) and Citi credit card statements use different layouts. Deposit statements list debits and credits with a running balance, while credit card statements add sections for payments, purchases, fees, and interest charged. A converter has to handle both formats, and generic tools often mis-parse the credit card interest and fee sections as transactions.

Why does my Citibank statement include more than one account?

Citi bundles linked accounts in a banking relationship, such as a Citi checking and a Citi savings account, into a single monthly PDF statement with a separate section for each account. Each section has its own header, transaction table, and balance summary. Tools that are not account-aware either merge the accounts into one block or capture only the first account. Account-aware extraction (found in dedicated converters, Method 4) keeps them separate. See our multi-account bank statement extraction guide for more.

Are Costco and American Airlines (AAdvantage) cards on Citibank statements?

Yes. The Costco Anywhere Visa and Citi / AAdvantage cards are issued by Citi, so their statements use the standard Citi credit card statement format. You convert them exactly like any other Citi credit card statement: the same four methods apply, and the same interest and fee sections need to be separated from real transactions. A dedicated converter (Method 4) handles this automatically.

Will Power Query work on Citibank statement PDFs?

Power Query works for simple single-account Citi deposit statements on Windows. It typically struggles with multi-page statements (a documented issue where it picks up only the first page), combined relationship statements with more than one account, and credit card statements where interest and fee sections sit alongside the transaction table. Power Query is not available on Mac. Method 2 above walks through the steps if your statement is straightforward.

Is Adobe Acrobat Pro good for converting Citibank statements?

Adobe Acrobat Pro can export PDFs to Excel via All Tools > Export a PDF. Results on bank statements are inconsistent. Adobe often creates extra columns from layout artifacts, requires manual cleanup, and lacks bank-specific features like balance reconciliation or account splitting for combined statements. It is acceptable for occasional one-off conversions if you already pay for Adobe, but not ideal for recurring bookkeeping work.

What is the easiest way to convert multiple Citibank statements at once?

Dedicated bank statement converters handle batch uploads natively. SendItSheets, DocuClipper, CapyParse, Bankstatemently, and LedgerBox all accept multiple PDFs in a single upload. Power Query and Adobe Acrobat are designed for single-file processing, so converting 12 monthly statements with them means running the workflow 12 times. For bookkeepers processing multiple clients monthly, batch processing typically saves several hours per month.

Can I import Citibank statements directly into QuickBooks?

Yes, via two paths. (1) For recent activity, you can connect Citi as a bank feed in QuickBooks Online, or download transactions and upload them under Banking. (2) For older PDF statements, convert first using Method 4; most dedicated converters output QBO directly, or you can use CSV upload in QuickBooks Online and map columns manually. Our PDF bank statement to QuickBooks guide covers the details.

Are scanned Citibank statements supported?

Native Citi PDFs downloaded from citi.com are digital (text-based) and work with all methods above. Scanned or photographed paper statements require OCR before conversion. Power Query and basic Adobe export struggle with scanned files; dedicated converters with OCR built in (Method 4) handle them better. Adobe Acrobat Pro can OCR a scanned PDF first via Enhance Scans > Recognize Text, then export. See our scanned bank statement extraction guide.

Need a dedicated converter? Try SendItSheets free

If Method 4 fits your situation, SendItSheets is built for bookkeepers, Citi combined relationship statements, credit card PDFs (including Costco and AAdvantage cards), year-end catch-ups, and bulk processing. Free 14-day trial, 30 pages, no credit card required.

Try SendItSheets Free