Citizens personal, Private Client and business checking
Convert a Citizens Bank statement to Excel, CSV or QuickBooks
Citizens exports 18 months of transactions and keeps up to seven years of statements. Convert the statement PDFs to get any of those years into Excel, CSV or QuickBooks, checked against the balances Citizens prints.
- Up to seven years of Document Center statements
- Each month checked from previous to current balance
- Checks kept with their numbers
- Excel, CSV, QBO and QFX output
7 years
of statements and check images online
In the Document Center, per Citizens’ checking disclosures
18 months
of transaction history
Deposit accounts, via the Export button
Web Connect
for Quicken and QuickBooks
Export or Download Account Data
$3
paper statement fee on many accounts
No fee for paperless eStatements
The short answer
Can you export a Citizens Bank statement to Excel?
You can export recent Citizens activity yourself: in online banking, open the account and use the Export button, then pick the download criteria and format. Business customers can also use Download Account Data on the account history page. Citizens shows up to 18 months of transaction history for deposit accounts, so anything older, and anything that has to match a statement, comes from the PDF statement, and converting it gives you the same Excel, CSV or QuickBooks file.
Citizens’ checking disclosures say you can access up to seven years of account statements and check images in the Document Center of Online Banking or the Citizens Mobile App. The Document Center also holds eNotices and 1099-INT and other tax forms.
A converted Citizens statement is checked from end to end: the previous balance, less checks and withdrawals, plus deposits and credits, must equal the current balance, and the converted rows must match every total the statement prints.
Citizens’ own pages give two different answers to “how far back”
Sample statement
What a Citizens statement looks like
Hover or tap a number to see what each part means for a conversion.
Citizens
One Deposit Checking · Account ending 5527
Statement period 09/09/2026 to 10/08/2026
Transaction details for checking account ending 5527
Balance Calculation
- Previous Balance
- 3,120.50
- Checks
- - 485.00
- Withdrawals & Debits
- - 1,936.04
- Deposits & Credits
- + 4,960.00
- Current Balance
- = 5,659.46
Checks
| Check # | Date | Amount |
|---|---|---|
| 318 | 09/14 | 425.00 |
| 319 | 09/29 | 60.00 |
Total Checks485.00
Other Withdrawals & Debits
| Date | Amount | Description |
|---|---|---|
| 09/10 | 148.62 | EVERSOURCE ENERGY BILL PAY |
| 09/16 | 97.43 | DBT PURCHASE STOP & SHOP 0412 QUINCY MA |
| 09/22 | 89.99 | VERIZON WIRELESS PAYMENTS |
| 10/01 | 1,600.00 | ZELLE PAYMENT TO SAM RIVERA |
Total Other Withdrawals & Debits1,936.04
Deposits & Credits
| Date | Amount | Description |
|---|---|---|
| 09/12 | 2,480.00 | HARBORVIEW MEDICAL PAYROLL DIR DEP |
| 09/26 | 2,480.00 | HARBORVIEW MEDICAL PAYROLL DIR DEP |
Total Deposits & Credits4,960.00
Native export
What Citizens lets you export
Each route covers a different stretch of time. Converting the statement is for everything the Export button does not reach.
Export and Download Account Data in Online Banking
Up to 18 months
Web Connect files for Quicken, Quicken for Mac or QuickBooks, for the download criteria you choose, from the account summary or the account history page.
Where it stops: Nothing older than the 18-month transaction history, and Citizens does not list CSV or Excel among the export choices.
Document Center
Up to 7 years
Statements, check images, eNotices and tax forms. Citizens says the eStatement carries the same information as the paper statement, front and back.
Where it stops: A PDF only, and combined statements are not offered as Paperless eStatements.
Converting the statement with VouchRow
Any statement you have
The PDF becomes rows in the format your software takes, checked from previous balance to current balance, with every row linked to its line.
Where it stops: Needs the statement PDF or a scan. A month you never saved has to come from Citizens first.
How far back
How far back each Citizens option reaches
Citizens keeps statements for years longer than it keeps transaction history, and personal credit cards are shorter again.
Transaction history and Export (deposit accounts)
Up to 18 months
Citizens says up to 18 months of transaction history can be viewed. It does not state a separate limit for the export itself.
Statement activity, personal credit cards
12 months
Citizens’ online banking FAQ gives 12 months of statement activity for personal credit cards.
Statements and check images (Document Center)
Up to 7 years
Per Citizens’ checking disclosures and digital terms. Some older FAQ pages still say 18 months; the Document Center shows what your account has.
A dashed bar means the bank does not publish a figure; check your own online banking.
Step by step
How to convert a Citizens Bank statement
- 1Save the statements from the Document CenterSign in to Citizens Online Banking, open the Document Center and save each statement you need as a PDF. Citizens says up to seven years of statements and check images are there, including in the Citizens Mobile App.
- 2One account per batchKeep each checking, savings or business account’s statements together, so each converted set lands in the right account in your software.
- 3Upload and convertSign in to VouchRow and add the PDFs. Digital statements convert in batches. A scanned paper statement is read with OCR, one at a time. A password-protected PDF is unlocked in your browser; the password is never sent.
- 4Check each monthThe rows must take the previous balance to the current balance, and each group must match its total. If not, VouchRow shows the difference, and clicking any row shows its line on the PDF.
- 5ExportExcel or CSV to review, QBO for QuickBooks, QFX or QIF for Quicken, or the Xero CSV preset.
Formats
Where is your Citizens data going?
Pick the destination. The advice changes with it.
Citizens Bank statement to Excel
An .xlsx with one row per check, withdrawal and deposit: date, description, check number where there is one, and a signed amount. The amounts sum to the difference between the previous and current balance.
For several years from the Document Center, convert them in one batch and sort by date; each month starts where the last one ended, which is easy to show a lender or an accountant.
PDF to ExcelCitizens Bank statement to CSV
CSV is for another tool to read: a budgeting app, a script or an import screen. Choose the date format the importer expects before exporting; MM/DD/YYYY suits most US software.
Citizens does not list CSV among its Export choices, and its history stops at 18 months. A converted CSV covers whichever statements you upload, with the same columns every month.
PDF to CSVCitizens Bank statement to QuickBooks
Export QBO and import it into the bank account in QuickBooks (in QuickBooks Online, upload from file under bank transactions; in Desktop, as a Web Connect file). It is the same kind of file Citizens’ own Web Connect export produces, so older months land in the same account.
Each row carries a transaction ID and the bank ID can be set, so where a converted month overlaps a downloaded one, QuickBooks recognises the repeats.
PDF to QBOCitizens Bank statement to Quicken
QFX is Quicken’s Web Connect format, the same route Citizens uses for its own Quicken downloads. Import it into the existing Citizens account so the older history joins it.
QIF also works, but it has no transaction IDs, so a month imported twice will duplicate. Prefer QFX when the account already holds downloaded months.
PDF to QFXCitizens Bank statement to Xero
Use the Xero CSV preset: one signed amount column and the date format Xero expects. Import it into the matching bank account in Xero, then reconcile as usual.
Check numbers go into the reference, so paid checks can be matched to the bills they settled.
Statements into XeroStatement layout
How a Citizens statement is laid out
The facts to check against the statement in front of you. Accounts covered: One Deposit Checking, EverValue Checking and Quest Checking, Citizens Private Client checking, Citizens savings and money market accounts, Clearly Better Business Checking and other business checking.
| Sample statement | Citizens does not publish one or a guide to reading its statement; compare the notes below with yours |
|---|---|
| Balance proof | A balance calculation: Previous Balance, less Checks and Withdrawals & Debits, plus Deposits & Credits, equals Current Balance |
| Activity groups | Checks, Other Withdrawals & Debits and Deposits & Credits, listed separately under the account’s transaction details |
| Amounts | Unsigned; the group the row sits in decides whether it is money in or out |
| Online copy | Citizens says an eStatement carries the same information as the front and back of the paper statement |
Why it works
What converting Citizens statements handles
Seven years, not 18 months
The Export button stops at the 18-month transaction history. Document Center statements go back up to seven years and convert the same way.
Signed by group
Checks and withdrawals come out negative and deposits and credits positive, whatever sign the PDF does or does not print.
Balanced end to end
Each month is proved from the previous balance to the current balance, with the printed totals checked as well.
Checks matched by number
Paid checks keep their check numbers, so they line up with the check images in the Document Center and with your register.
Every row traced to its line
Click a row and the PDF opens at the line it came from. A reviewer can check any figure without leafing through pages.
Scanned copies too
Statements Citizens mails or you request from before the online archive are read with OCR, one at a time.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
Archive
How far back Citizens Bank statements go
Citizens’ checking disclosures say up to seven years of account statements and check images are in the Document Center of Online Banking or the Citizens Mobile App, and its digital banking terms say the same for eligible account statements. Some FAQ pages on citizensbank.com still give the older figure of 18 months, with Contact Us for anything older. The Document Center itself is the final word: open it and see how far your list goes before ordering copies.
Not everything is there. Citizens’ terms say credit card, mortgage, business loan, combined and relationship statements may not be available on the digital service, and its fee guide says combined statements are not available as Paperless eStatements. If you receive one combined paper statement for several accounts, keep the paper or scan it.
Paper costs extra on many accounts. Citizens’ personal fee guide lists a $3 monthly paper statement fee for One Deposit Checking, with Paperless eStatements at no charge, and the business guide lists $3 per statement period for paper on Clearly Better Business Checking.
| What | Online |
|---|---|
| Statements and check images (Document Center) | Up to 7 years |
| Transaction history, deposit accounts | Up to 18 months |
| Statement activity, personal credit cards | 12 months |
Layout
What a Citizens Bank statement looks like
Citizens does not publish a sample statement or a guide to reading one, so treat this as a description to compare with your own. Citizens checking statements open with the account and statement period and a balance calculation: Previous Balance, Checks, Withdrawals & Debits, Deposits & Credits and Current Balance. The activity follows under the transaction details for the account, in separate groups for checks, other withdrawals and debits, and deposits and credits, each row with a date, an amount and a description.
Amounts are listed without a sign; the group tells you which way the money moved. That is the main thing a conversion has to get right on a Citizens statement, and the balance calculation is what proves it: if any group is read with the wrong sign, the month will not close at the current balance.
Citizens says the eStatement in the Document Center includes identical information to the front and back of the paper statement, so the online PDF and a scanned paper copy of the same month should convert to the same rows.
QuickBooks and Quicken
Citizens Bank with QuickBooks and Quicken
Citizens’ business banking page tells customers to use Web Connect for Quicken or QuickBooks: click Export on the account summary page, or Download Account Data on the account history page, and choose Quicken, Quicken for Mac or QuickBooks. Citizens also says it follows the product sunsetting policy of Quicken and QuickBooks by Intuit, so an old desktop version can stop working with its downloads.
After Citizens moved to a new online platform in 2023, QuickBooks users reported in Intuit’s community that Citizens QBO files would not import, and Intuit tracked it as an open issue at the time. If a downloaded QBO fails, a QBO converted from the statement is an alternative for the same months. Each converted row carries a transaction ID, so where a converted month overlaps a downloaded one, the repeats are recognised.
Business
Citizens business checking statements
Business checking statements carry the same kind of balance calculation and grouped activity. Busy business accounts are where the 18-month transaction history runs out fastest, and where an accountant most often needs a prior year in QuickBooks, so convert the Document Center statements to QBO and import them into the same account.
Citizens does not publish separate statement or download limits for its commercial platforms, so check with your treasury contact if your business banks there rather than in Business Online Banking.
Troubleshooting
Common Citizens conversion problems
Most Citizens problems come from the archive and the unsigned amounts.
- Export stops 18 months back: that is Citizens’ transaction history limit. Older months are in the Document Center statements.
- You were told statements stop at 18 months: older FAQ pages say so. The checking disclosures say up to seven years. Check the Document Center.
- Every withdrawal shows as money in: amounts are unsigned, and the group heading was not carried onto the rows.
- Balance calculation lines appear as transactions: Previous Balance, Checks, Withdrawals & Debits, Deposits & Credits and Current Balance are totals, not rows.
- A combined statement is missing online: Citizens does not offer combined statements as Paperless eStatements. Use the paper copy.
- QuickBooks will not accept a downloaded Citizens QBO: users reported this after the 2023 platform change. A QBO converted from the statement is an alternative.
Side by side
Citizens’ Export button vs converting the statement
| Citizens Export / Download Account Data | Converting the PDF statement | |
|---|---|---|
| How far back | Up to 18 months of transaction history | Up to 7 years in the Document Center, plus any you saved |
| Formats | Web Connect files for Quicken, Quicken for Mac and QuickBooks | Excel, CSV, QBO, QFX, OFX, QIF, IIF, Tally XML |
| Matches the statement month | Only if you pick the exact dates | Always: one statement, one cycle |
| Checked against the statement | No | From previous balance to current balance, with every printed total |
| Combined paper statements | Not applicable | Scan the paper copy and convert it with OCR |
| Proof for a reviewer | A list of rows | Every row linked to its line on the PDF |
Before you import
After converting a Citizens statement, check these
- The month balancesPrevious Balance less checks and withdrawals plus deposits equals the Current Balance. If not, the difference is shown.
- Withdrawals are negativeChecks and withdrawals are money out, deposits and credits money in, even though the statement prints no signs.
- No balance calculation rowsPrevious Balance, the group totals and Current Balance do not appear among the transactions.
- Check numbers presentEvery paid check has its number, ready to match against the check images in the Document Center.
- Dates in the right yearOn a period that crosses December into January, the December rows are in the old year.
- Every account accounted forIf you hold several Citizens accounts, each has its own statements and its own converted file.
Downloaded activity and statements are not the same thing
Excel for Citizens
Who uses it
Who converts Citizens Bank statements
Prior-year QuickBooks clean-up
Businesses and their bookkeepers bringing years beyond the 18-month history into QuickBooks from Document Center statements.
Mortgage and loan files
Several months of Citizens statements for a lender, each row traceable to the statement Citizens issued.
Taxes and amended returns
A full year of statements converted in one batch, with checks listed by number for matching to receipts.
Divorce, estates and forensic work
Up to seven years of statements turned into one ledger per account, for counsel, an executor or an examiner.
FAQ
Citizens statements: questions
How do I export a Citizens Bank statement to Excel?
For the last 18 months, open the account in Citizens Online Banking and use the Export button. For a full statement, or anything older, save the statement PDF from the Document Center and convert it here to Excel or CSV, checked from the previous to the current balance.
How do I download a Citizens Bank statement?
Sign in to Citizens Online Banking and open the Document Center, which holds statements, check images, eNotices and tax forms. Choose the account and the statement, and save it as a PDF. Citizens says statements are in the Citizens Mobile App too.
How far back can I get Citizens Bank statements online?
Citizens’ checking disclosures say up to seven years of statements and check images. Some older FAQ pages still say 18 months, so check the Document Center itself. Transaction history online is up to 18 months.
How do I download transactions from Citizens Bank?
Click the account, then the Export button, and choose your download criteria and format. Business customers can also use Download Account Data on the account history page. History goes back up to 18 months.
Does Citizens Bank work with QuickBooks?
Citizens tells business customers to use Web Connect for QuickBooks: export from online banking and import the file. For months older than 18 months, convert the statement PDF to QBO and import it into the same account.
Does Citizens Bank work with Quicken?
Yes, through Web Connect downloads for Quicken and Quicken for Mac from the Export button. For older months, convert the statement PDF to QFX and import it into the same account.
Is there a fee for Citizens Bank paper statements?
On many accounts, yes. Citizens’ fee guides list $3 a month for paper statements on One Deposit Checking and $3 per statement period on Clearly Better Business Checking. Paperless eStatements carry no fee.
My Citizens statement PDF has a password. Can I still convert it?
Yes. Enter the password when you upload. The PDF is unlocked in your browser and the password is never sent to us.
Keep going
Related guides and converters
Formats for Citizens statements
Other bank pages
Other banks
Sources
The facts about Citizens Bank on this page come from these pages, checked in October 2026. Banks change their online banking; if something here no longer matches, the bank’s own help page wins. Tell us and we will update it.
- Citizens: checking disclosures, up to 7 years of statements and check images (citizensbank.com)
- Citizens: online banking terms and conditions, eStatements and digital service (citizensbank.com)
- Citizens: mobile and online banking FAQs, Document Center, Export and 18 months of history (citizensbank.com)
- Citizens: accounting software compatibility, Web Connect for Quicken and QuickBooks (citizensbank.com)
- Citizens: personal fees and features guide, paper statement fee (citizensbank.com)
- Citizens: business deposit account fees and features guide (citizensbank.com)
- Intuit QuickBooks Community: Citizens Bank QBO import issue after the 2023 platform change
Convert your Citizens Bank statements
Upload the PDFs from the Document Center, check every month from previous to current balance, and export Excel, CSV, QBO or QFX.