Download your RBC Royal Bank statement PDF and convert every transaction to a clean Excel or CSV file — CRA tax filing, QuickBooks Canada, and mortgage submissions all covered.
Go to rbcroyalbank.com and sign into Online Banking
Click your chequing, savings, or credit card account
Click "View e-Statements" from the account menu
Select the month and download — no password needed
RBC Royal Bank is Canada's largest bank by market capitalization. Its statement format is consistent across chequing, savings, and small business accounts.
| Section | What It Contains |
|---|---|
| Account Summary | Account holder name, transit/account number (masked), statement period |
| Transaction Table | Date | Description | Withdrawals | Deposits | Balance |
| e-Transfer | Sender/recipient name and Interac e-Transfer reference |
| Pre-authorized Debits | Company name and recurring payment reference |
Here is a real example of how raw PDF bank statement text is transformed into a clean Excel file:
| Raw PDF → Clean Excel | |
|---|---|
| Raw PDF text (messy) | Clean Excel output |
| 06/15/2026 DIRECT DEP PAYROLL ACME CORP 2,450.00 8,912.40 | Date: 2026-06-15 Description: Direct Deposit — Payroll, Acme Corp Credit: 2450.00 Balance: 8912.40 |
| 06/18/2026 DEBIT CARD PURCHASE AMAZON.COM 54.99 8,857.41 | Date: 2026-06-18 Description: Debit Card Purchase — Amazon.com Debit: 54.99 Balance: 8857.41 |
Dates standardised to YYYY-MM-DD. Currency symbols removed. Debit and Credit in separate columns. Ready for Excel, QuickBooks, Xero, or accountant review.
RBC, TD, Scotiabank, BMO, and CIBC statement PDFs are all auto-detected. DD/MM/YYYY or MM/DD/YYYY dates standardised, $ CAD amounts as plain numbers — ready for QuickBooks Canada, Wave, or CRA filing.
All Big Five bank PDF formats supported, including e-transfer and bill-pay narrations preserved exactly as printed.
Online-only and regional Canadian bank statements convert the same way — no manual reformatting needed.
🇨🇦 Use cases: CRA tax filing & T1 self-employment income • QuickBooks Canada / Wave import • Mortgage broker cash-flow review • Express Entry / PR proof of funds
All major US bank statement PDFs auto-detected. MM/DD/YYYY dates standardised, $ USD amounts as plain numbers, single signed-amount columns split into Debit/Credit automatically.
All major US bank formats including 2024–2025 redesigned layouts.
US neobank PDF and statement exports both handled.
🇺🇸 Use cases: QuickBooks Online import • Schedule C expense categorisation • Mortgage underwriting • SBA loan cash flow
Every major UK bank statement format is auto-detected. DD/MM/YYYY dates converted, sort codes preserved in narrations, £ GBP amounts as plain numbers — ready for Xero, Sage, or HMRC submission.
All major high-street bank PDFs supported. Faster Payments and BACS references preserved.
Digital bank and building society formats both covered.
🇬🇧 Use cases: HMRC Self-Assessment • Xero & FreeAgent import • Mortgage broker submission • UKVI visa evidence
→ Dedicated UK Bank Statement Converter