Convert Citizens Bank Statements to CSV, Excel & QBO

Citizens Online Banking shows 18 months of transactions and, by its own FAQ, 18 months of statements. The Export button covers what is online. Drop a statement below and get every transaction as CSV, Excel, or QBO.

Click to upload or drag & drop

your bank statement PDF

Select PDF file

PDF only · up to 6 pages · 10 MB max

No signup requiredBank-grade encryption6 free pages every day

Checking, savings & Citizens AccessCredit card & business statementsExports to CSV, Excel & QBO

Need more than the demo? Start free with 10 pages

CapyParse is an independent tool and is not affiliated with, endorsed by, or sponsored by Citizens Financial Group, Inc..

What Citizens exports natively, and where it stops

Citizens is clear about its history window and vague about its file formats. Here is what its own pages say:

Format	Where	History	The catch
Export (personal)	Account page, Export button	Up to 18 months of transactions	You choose the download criteria and a format. Citizens does not list the personal formats, and Quicken downloads are not available in the mobile app.
Web Connect (business)	Export icon, or Download Account Data on account history	Same 18-month history	Choose Quicken, Quicken for Mac, or QuickBooks. Citizens follows Intuit’s product sunset policy for older versions.
Credit cards	Card account, or CentreSuite for business cards	12 months of statement activity on personal cards	Business cards download a QBO file from CentreSuite. Citizens’ terms say card statements may not be available in online banking.
PDF eStatements	Document Center tab	18 months, per the FAQ	The online terms allow up to 7 years for eligible accounts. Older statements are ordered through Contact Us, so save each PDF as it posts.

Citizens export behavior as of October 2026.

Eighteen months covers this year’s books and not much else. A tax review, a loan file, or a catch-up project reaches further back than that, into statements you saved. CapyParse converts them to CSV, Excel, or QBO with one row per transaction.

From Citizens PDF to spreadsheet in two short steps

Get your statement PDFs from Citizens Online Banking

1Sign in to Citizens Online Banking and open the Document Center tab.
2Use the filter to pick the account and the time frame, then save each statement PDF.
3Upload them here in one batch. For Citizens Access, sign in on the Citizens Access site and download the PDFs there.

Convert with CapyParse

1Upload the PDFs, digital or scanned, one statement or a whole year in a batch.
2Review every extracted transaction next to the original page, with anything unusual flagged for a quick check.
3Export CSV, Excel, or QBO. Multi-account statements come out as one clean file per account.

Built for the way Citizens prints statements

Citizens checking, savings, credit card, and business statements each print differently. CapyParse reads each one as printed:

Combined statements, split per account

Citizens combines checking, savings, money market, and CD statements only on paper, while Citizens Access sends one combined statement every month. Either way, each account becomes its own table with its own balance.

Checks keep their numbers

Where a checking statement lists checks paid, the check number stays with the row, so you can match each one against your register.

Deposits and withdrawals stay signed

Whether a statement groups additions and subtractions in separate sections or prints them in one list, each row comes out with the right sign and the running balance where one is printed.

Charges stay charges

Card statements separate payments, purchases, fees, and interest. Each row keeps its type and direction, so a refund never imports into your books as a purchase.

Eighteen months, or seven years?

Citizens gives two answers to how long statements stay online. Its Online Banking FAQ says up to 18 months of statements are available in the Document Center, and older ones are ordered through Contact Us. Its online banking terms say you may view up to 7 years of eligible account statements, with credit card, mortgage, business loan, and combined statements possibly excluded.

Plan on the shorter figure. Transaction history is 18 months either way, and the safe habit is to save each statement PDF as it posts. If you came to Citizens through the 2022 HSBC branch purchase or the Investors Bank acquisition, your statements from that year are well past 18 months, so the copies you saved are the ones that count.

Citizens Access is a separate case. It has its own site and login, and its terms give up to 7 years of transactions and statements. Its PDFs convert the same way as branch account statements.

Three formats out, ready for your tools

CSV

Opens directly in Excel and Google Sheets with dates, descriptions, and amounts in separate columns. The universal import format for every accounting tool.

Excel (XLSX)

Native spreadsheet formatting, one sheet per account on combined statements, ready for pivot tables and formulas.

QBO for QuickBooks

A Web Connect file with the financial institution details QuickBooks verifies, so imports work on the first try instead of failing with a bank error.

Review everything before you export

Every extracted transaction appears next to the original statement page, with anything unusual flagged for a second look. Nothing leaves for your books until you have seen it.

50,000+

Pages converted

1,000+

Banks & credit unions

Export formats

Uploads are encrypted in transit, only you can access your documents, and you can delete them from your dashboard at any time.

Citizens conversion questions

How do I export transactions from Citizens Online Banking?

Click the account, then use the Export button and choose your download criteria and format. Business accounts can also use Download Account Data on the account history page and pick Quicken, Quicken for Mac, or QuickBooks. Exports reach as far as online history, which is up to 18 months. For older periods, convert your statement PDFs with CapyParse.

How far back can I get Citizens Bank statements?

Citizens’ FAQ says up to 18 months of statements are available online under the Document Center tab, and older ones can be ordered through Contact Us. Its online banking terms allow up to 7 years for eligible accounts. Transaction history covers up to 18 months, or 12 months of statement activity on personal credit cards.

Can I get Citizens transactions into QuickBooks?

Yes. Business Online Banking exports to QuickBooks through Web Connect, and business credit cards download a QBO file from CentreSuite. Personal accounts use the Export button, though Citizens does not list its formats. For periods past the 18-month window, convert the PDF statements with CapyParse, export QBO, and upload the file in QuickBooks under Banking, then Upload transactions.

Does this work with Citizens Access statements?

Yes. Citizens Access savings and CD statements convert the same way as branch account statements. Citizens Access has its own site and login, and its terms give up to 7 years of statements online.

Does this work with former HSBC and Investors Bank statements?

Yes. Citizens took over 80 HSBC East Coast branches and acquired Investors Bank in 2022. If you saved statements from before the conversion, upload them alongside your Citizens statements. The exports share one column layout, so the history lines up as one table.

Is it safe to upload my Citizens Bank statement?

All uploads are encrypted in transit via HTTPS. When you sign up, your documents are stored securely in your account, only you can access them, and you can delete any document from your dashboard at any time.

Convert your Citizens statements now

Try it free right on this page, no signup. Create an account for 10 more pages, Excel and QBO export, and batch uploads.

Start free