LIMITED TIME

Get 15% off — Use code at checkout

C

Convert Citizens Bank Statement to Excel, CSV & QuickBooks

Upload a Citizens checking, savings, credit card or business statement PDF and get every transaction as a spreadsheet row.

Encrypted in transit
Results in seconds
Text and scanned PDFs

About Citizens Bank

Citizens Bank is headquartered in Providence, Rhode Island, and is the retail bank of Citizens Financial Group. It operates across New England, the Mid-Atlantic and the Midwest, where its Ohio and Michigan branches came from Charter One. In 2022 Citizens bought Investors Bank in New Jersey and New York and took over 80 HSBC branches on the East Coast, so many customers in those states hold accounts that started at another bank.

Consumer accounts include One Deposit Checking, Citizens Quest Checking, One Deposit Savings and the Citizens Private Client tier, plus the Cash Back Plus World Mastercard. Business accounts are sold as Clearly Better Business Checking. Routing numbers depend on the state: 011500120 in Rhode Island (and for wires), 241070417 in Ohio and Michigan.

Citizens Bank, N.A.

Headquarters

Providence, RI

Routing numbers
011500120241070417

011500120 is the Rhode Island (and wire) routing number; 241070417 is used in Ohio and Michigan on accounts from the former Charter One. Other states have their own numbers.

Accounts we see most
One Deposit CheckingCitizens Quest CheckingOne Deposit SavingsCitizens Private ClientCash Back Plus World MastercardClearly Better Business Checking
Also known as

Citizens, Citizens Financial Group, Charter One, Investors Bank

How to download your Citizens Bank statement as a PDF

The converter needs the PDF statement Citizens Bank produces, not a screenshot or a transaction export.

Online banking

  1. 1

    Log in at citizensbank.com and select the account.

  2. 2

    Open "Statements" and choose the statement month.

  3. 3

    Download the PDF.

  4. 4

    Upload the PDF to ProcessBankStatement and download it as CSV, Excel, QuickBooks or OFX.

Mobile app

  1. 1

    Open the Citizens app and tap the account.

  2. 2

    Tap "Statements", choose the month and download the PDF.

  3. 3

    Upload the PDF here.

What you get back

Every transaction on the statement, one row each, with the date, description, amount and running balance.

Most popular

CSV

Opens in Excel, Google Sheets, and imports into most accounting software.

Excel (.xlsx)

Date, Description, Amount and Balance columns with amounts stored as numbers.

QuickBooks (.qbo)

Import straight into QuickBooks Desktop or Online as bank transactions.

OFX

For Quicken, Xero, and other tools that accept OFX bank feeds.

Citizens Bank statement conversion: questions we get asked

Why does my Citizens statement show routing number 241070417 instead of 011500120?

241070417 is the number Citizens uses in Ohio and Michigan on accounts inherited from Charter One; 011500120 is the Rhode Island number and the one used for wires. The converter ignores the routing number and reads the transaction rows only.

Ready to convert your Citizens Bank statement?

Upload the PDF at the top of this page, or create a free account for daily free pages.

Last updated: October 20, 2026