Convert Citizens Bank Statement to CSV - Free Tool (2026)

Citizens Financial Group is the 11th largest bank in the United States, headquartered in Providence, Rhode Island. With roughly 1,100 branches spread across 14 states in the Northeast and Mid-Atlantic, Citizens serves millions of personal and business customers. The bank expanded significantly in 2022 when it acquired 80 former HSBC branches in the New York metro area, bringing a wave of customers whose older HSBC-era statements follow a different PDF layout. Citizens also operates Citizens Access, an online-only division offering high-yield savings and CDs with its own distinct statement format. Whether you hold a One Deposit Checking account, a Citizens Access High-Yield Savings account, or a Citizens Bank credit card, this guide walks you through every method for converting your statement PDFs into CSV, Excel, or QBO files.

Can You Download CSV Directly from Citizens?

Yes, partially. If you log into Citizens Online Banking and navigate to your account activity, you can download recent transactions as a CSV or OFX file.

However, the built-in export has several limitations you should know about:

• ~90-day cap: The transaction export only covers approximately the last 90 days of activity. Anything older is only available as a PDF statement through the Statements section.
• Missing detail: The CSV download pulls from your transaction feed, not your official statement. Running balances, check numbers, and statement summary sections are not included.
• Citizens Access not included: If you have a Citizens Access High-Yield Savings or CD account, the main Citizens Online Banking portal does not list those accounts. Citizens Access has its own separate login at citizensaccess.com, and it does not offer CSV export at all.
• No scanned-statement support: If you have paper statements that you've scanned, the online banking download feature can't help.

For anything beyond the last 90 days, Citizens Access accounts, or former HSBC-era statements, you'll need to convert the PDF itself. For a broader look at downloading statements from any bank, see our guide to downloading bank statements as CSV.

Citizens Bank Statement Formats and Quirks

Before you convert, it helps to understand how Citizens structures its statements. Not all Citizens PDFs are the same, and the HSBC acquisition introduced additional format variation.

Key things to know: Citizens Bank provides up to 7 years of downloadable PDF statements through online banking. Citizens Access statements use a distinct, minimalist layout compared to traditional branch account PDFs. Customers who migrated from HSBC in 2022 may have older statements with HSBC branding and a different column structure. Credit card statements drop the year from transaction dates since each covers a single billing cycle.

Convert a Citizens Bank Statement to CSV with CapyParse (Step-by-Step)

Here's how to convert any Citizens PDF statement into a clean CSV, Excel, or QBO file using CapyParse:

Account Type Details

CapyParse handles more than just Citizens checking accounts. Here's what to expect with different Citizens products:

One Deposit Checking

One Deposit Checking is the most popular Citizens personal checking product. Statements list deposits, withdrawals, debit card purchases, and fees in separate sections with a running daily balance. CapyParse reads each section, assigns the correct transaction type, and outputs a single unified table. If your One Deposit Checking statement includes linked savings or money market accounts, CapyParse detects those sub-sections and produces separate output files.

Citizens Access High-Yield Savings

Citizens Access is the bank's online-only platform offering high-yield savings accounts and CDs. Because Citizens Access operates on a separate system, its PDF statements look different from traditional Citizens branch statements. The layout is more compact, with fewer headers and a simpler transaction table. CapyParse recognizes the Citizens Access format automatically and extracts interest credits, transfers, and balance data without any manual adjustment. Keep in mind that Citizens Access does not provide its own CSV download, so PDF conversion is the only automated option.

Citizens Bank Credit Cards

Citizens Bank credit card statements, including the Citizens Bank Cash Back Plus and Citizens Bank Clear Value cards, group transactions into sections: Purchases, Payments, Credits, Fees, and Interest Charges. Credit card PDFs drop the year from transaction dates since each statement covers a single billing cycle. CapyParse infers the correct year from the statement period and correctly classifies each transaction type in your export.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Citizens statement as a QBO file from CapyParse and import it directly into QuickBooks via Banking > Upload transactions. Or use the CSV export and map the columns manually. For a detailed walkthrough, see our guide on importing bank statements into QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. All transaction fields (date, description, amount, balance) appear in separate columns, ready for sorting, filtering, pivot tables, or custom formulas. The Excel (.xlsx) export is also available if you prefer native spreadsheet formatting.

Need to convert OFX files instead? Citizens offers OFX downloads for recent activity. Check out our QBO/OFX to CSV conversion guide to convert those files.

Tips for Citizens Bank Conversions

Frequently Asked Questions

Related Articles