Convert Citizens Bank statements to Excel and CSV
To convert a Citizens statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export every transaction with date, description, amount and running balance. Batched deposits from payment processors come out as single dated rows you can match to your sales records.
Not affiliated with Citizens. statement.work is an independent tool. Citizens is a trademark of its owner and is named here only to describe the statements this page is about.
About Citizens statements
Citizens Bank is the banking business of Citizens Financial Group, headquartered in Providence, Rhode Island, serving consumers and businesses in New England, the Mid-Atlantic and the Midwest. Its business customers include many small retailers and service firms, whose statements are full of processor deposits and card-related fees.
What the statements typically contain
- Account details and statement period.
- A balance summary for the period.
- Transactions with dates, descriptions, amounts and balances, often grouped by type.
- Fees, interest and service charges.
Exact layouts vary by account and over time.
Common conversion problems
- Batched deposits. A deposit like “card processor settlement” stands for many sales, usually net of processing fees. Reconciling it means matching to the processor’s payout report, not to individual invoices.
- Similar-looking deposits. Daily settlements of similar amounts look like duplicates at a glance. Check the dates and references before treating any as an error. statement.work flags likely duplicates for review rather than removing anything.
- Grouped sections. Deposits and withdrawals listed separately need merging into date order to follow the running balance.
- Service charges. Business account fees can be summarized apart from the main transactions.
How to convert it
- Download the statement PDF from online banking, or use a scan or photo.
- Upload it to statement.work.
- Review the single, date-ordered list of transactions.
- Export to Excel or CSV.
- Confirm the ending balance matches the statement.
Matching deposits to sales
For small businesses taking card payments, the key reconciliation step is deposits against processor payouts. The reconciliation guide explains a quick way to do it. Statements from TD Bank or U.S. Bank convert to the same columns if a business uses more than one bank.
Questions
Why don't my card sales appear individually on my statement?
Card and online payment processors usually deposit sales in batches, net of their fees, so the bank statement shows one deposit for many sales. Match each deposit to the processor's payout report.
Can statement.work split a batched deposit into individual sales?
No. A bank statement only contains the deposit itself. statement.work extracts it accurately; the breakdown comes from your payment processor's records.
Is statement.work affiliated with Citizens?
No. statement.work is independent and is not affiliated with or endorsed by Citizens Financial Group.