Convert RBC bank statements to Excel or CSV
Upload the PDF exactly as it comes from RBC Online Banking. Get back a spreadsheet with one row per transaction — date, description, debit, credit, running balance. No retyping, no cleanup.
What comes back
RBC prints a running balance every few lines, not every line, and splits contactless-purchase descriptions across two rows. ApexParser reconciles both — it doesn't just copy text top to bottom.
| Date | Description | Out | In | Balance |
|---|---|---|---|---|
| 2025-03-14 | Canadian Tire | 84.12 | ||
| 2025-03-14 | Starbucks #114 | 6.75 | ||
| 2025-03-14 | e-Transfer, Rivera Contracting | 1,250.00 | 22,104.38 |
How it works
Three steps. No manual cleanup after.
Upload your RBC statement PDF
Business or personal account, single or multi-page. No pre-processing needed.
We parse and reconcile
Every debit and credit is checked against RBC's printed running balance, not guessed from the words in the description.
Download Excel or CSV
Five columns, ready to import into QuickBooks Online, Xero, or your working papers.
Built for RBC's actual layout
Sparse balance handling
RBC doesn't print a balance on every line. ApexParser tracks the running balance across the gaps and checks it against the statement's declared totals, not just the visible checkpoints.
Multi-line descriptions merged
Contactless Interac purchases split across two lines in the PDF — reference number on one line, merchant on the next — come back as one clean row.
Debits and credits signed correctly
Column position decides the sign, not keyword-matching on the description, so ambiguous entries still land in the right column.
Business and personal formats
RBC Digital Choice Business, personal chequing, and multi-page statements all use the layout ApexParser already knows.
Common questions
Does this work with RBC business account statements?
Yes. RBC Digital Choice Business statements use the same five-column layout as personal accounts, and ApexParser handles both.
RBC only shows the balance every few transactions — how do you know which are debits and which are credits?
Every transaction is checked against the nearest printed balance using the statement's own numbers. If a line can't be confirmed against a balance, it's flagged instead of guessed.
My statement has cheque images mixed in with the printed activity — will those get counted as extra transactions?
No. Scanned cheque images are recognized and excluded so you don't get duplicate rows for the same cheque.
What file do I get back?
An Excel file (.xlsx) with Date, Description, Debit, Credit and Balance columns, one row per transaction.