How to Convert a Citizens Bank PDF Statement to CSV or Excel
Citizens gives you a Document Center and two different answers on how far back it goes. Plan for the shorter one.
Eighteen months or seven years, and the Document Center
Citizens' online banking FAQ gives one number:
"Up to 18 months of your statements are available online and can be retrieved immediately in Online Banking under the DOCUMENT CENTER tab… If you wish to order a statement older than 18 months, simply click on the Contact Us link."
Citizens adds a line that is effectively an instruction: statements "can be saved or downloaded any time for longer storage needs". The bank is telling you its window is not an archive.
Its newer documents give a different number. Citizens' checking account disclosures and its Digital Terms and Conditions both describe up to seven years of eligible account statements available digitally in the Document Center. The FAQ appears to be the older page, so seven years may well be the current window, but Citizens has not reconciled the two and we are not going to pretend it has. Check what your own Document Center lists, and save everything you can see.
| What | How long |
|---|---|
| Statements online | 18 months (online banking FAQ) or up to 7 years (checking disclosures and digital terms) |
| Transaction history | 18 months (12 months statement activity for personal cards) |
| Tax forms | 7 years from year of origination |
Quick answer: download every statement your Document Center lists and convert them. Plan on the FAQ's 18 months; if your account shows up to seven years, as Citizens' newer terms describe, take those too.
Two things that produce wrong answers about Citizens
The name. Several unrelated US banks trade as Citizens, Citizens Bank and Trust among them, so check that the page you are reading is on citizensbank.com, from the Rhode Island-headquartered Citizens Financial Group, which is the one most people mean. Its own pages give both the 18-month and the seven-year statement figure, as above, plus seven years for tax forms.
The export. Citizens documents an Export icon on the account summary page and a Download Account Data button on the account history page, then offers three destinations: Quicken, Quicken for Mac and QuickBooks. No CSV, Excel, OFX or QIF appears in any Citizens documentation. That is verified absence of documentation rather than proof the option is missing, and no published export date range exists either — so do not assume the 18-month statement figure caps the export.
One more, for anyone with legacy HSBC accounts: Citizens states that HSBC transaction history and account statements will not be available in Citizens Online Banking following the 2022 east-coast branch conversion. If you are chasing pre-conversion HSBC history through Citizens, it is not there.
Converting the statements (4 steps)
- Open the Document Center
In Online Banking, use the DOCUMENT CENTER tab and filter by account and timeframe. - Download everything the Document Center lists
Citizens' online banking FAQ says statements older than 18 months must be ordered via Contact Us, while its newer terms describe up to seven years online. Save whatever your account shows. - Save them for longer storage
Citizens itself notes statements can be saved or downloaded any time for longer storage needs. - Convert them
Create a free account at reconcileiq.com/bank-statement-converter, open MatchIQ, then open the PDF converter. Upload the statements and download clean CSV.
What comes out
Citizens publishes no statement-reading guide and no annotated sample for deposit accounts, so this page does not describe its column structure. Be wary of the "Citizens Bank statement sample" results that dominate image search: they are template-mill uploads, not bank documents, and building a parsing expectation on them is worse than having none.
The converter returns a consistent shape regardless: one normalised sortable date column, descriptions rejoined, one correctly signed amount column, and the running balance kept separate.
If the next job is coding those rows in QuickBooks or Xero, CodeIQ reads the same statements and codes each line against your own chart of accounts and history, then posts the approved result back.
Convert Your Citizens Statement
Upload the PDF, check it against the statement's own opening and closing balance, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
It depends which Citizens page you read. Its online banking FAQ says up to 18 months of statements are available online and can be retrieved immediately in Online Banking under the Document Center tab, and that to order a statement older than 18 months you click Contact Us, covering most deposit, line of credit and loan accounts. Its checking disclosures and digital terms describe up to seven years of eligible statements in the Document Center. Download whatever your account shows.
Possibly. Citizens' checking disclosures and digital terms describe up to seven years of eligible account statements available digitally, while its older online banking FAQ says 18 months. Tax forms are accessible for seven years from their year of origination. Several unrelated banks also share the Citizens name, so check that you are reading citizensbank.com.
Citizens documents an Export button and a Download Account Data button, and names three destinations: Quicken, Quicken for Mac and QuickBooks. No CSV, Excel, OFX or QIF appears anywhere in its documentation. The personal FAQ confirms an export exists and lets you select a format, without saying which formats.
Citizens states you can view up to 18 months of transaction history, with a parenthetical of 12 months of statement activity for personal credit cards. That parenthetical is genuinely ambiguous in Citizens' own wording, since it sits under a transaction-history heading but refers to statement activity, so we are not going to make it cleaner than they do.
Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what allows scanned and photographed statements to work as well as native PDFs.