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.
Upload Bank Statement
Drop your file here or click to browse
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.
Providence, RI
011500120241070417011500120 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.
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
Log in at citizensbank.com and select the account.
- 2
Open "Statements" and choose the statement month.
- 3
Download the PDF.
- 4
Upload the PDF to ProcessBankStatement and download it as CSV, Excel, QuickBooks or OFX.
Mobile app
- 1
Open the Citizens app and tap the account.
- 2
Tap "Statements", choose the month and download the PDF.
- 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.
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.