TL;DR - Quick Summary
- Who it is for: Canadians with statements from RBC, TD, Scotiabank, BMO, CIBC, National Bank, Desjardins, or a credit union.
- Key fact: French headers such as Montant and Date de transaction are detected and output as standard English CSV columns.
- Use the eStatement: A custom date-range history export often leaves out the opening and closing balances you need to reconcile, so convert the monthly eStatement PDF.
- Watch out for: Bank lines show totals with GST/HST included, so you still need supplier receipts to claim input tax credits.
- Start: Convert at /pdf-to-csv, then import into Xero, Wave, QuickBooks Canada, or Sage 50 CA, and keep records for 6 years for the CRA.
🇨🇦 Canadian Bank Statement Conversion
Convert statements from all major Canadian banks to CSV or Excel format. Supports CAD currency, English/French bilingual statements, and CRA tax documentation requirements.
All Canadian Banks
RBC, TD, Scotiabank, BMO, CIBC, National Bank, Desjardins
English/French
Bilingual statement support, especially Quebec banks
CAD Currency
Canadian dollar formatting maintained
Major Canadian Bank Support
| Bank | Account Types | Market Position | Notes |
|---|---|---|---|
| RBC (Royal Bank) | Day to Day, VIP, Business | #1 in Canada | Excellent CSV compatibility |
| TD Canada Trust | Everyday, Select, Business | #2 in Canada | US parent, Canadian operations |
| Scotiabank | Basic, Preferred, Business | Big Five member | International presence |
| BMO (Bank of Montreal) | Practical, Premium, Business | Oldest Canadian bank | Strong business banking |
| CIBC | Smart, Imperial, Business | Big Five member | Merged with Imperial |
| National Bank | Everyday, Premier, Business | Quebec-based | Bilingual focus |
| Desjardins | Rebate, Signature, Business | Credit union | Quebec cooperative |
Big Five Banks: RBC, TD, Scotiabank, BMO, and CIBC control ~90% of Canadian banking. All have excellent CSV conversion compatibility.
English/French Bilingual Support
Canadian Bilingual Banking
Canada is officially bilingual. Banks in Quebec (Desjardins, National Bank) often provide French statements. Our converter handles both English and French column headers automatically.
English Headers
Date, Description, Amount
Transaction Date, Payee, Balance
Posted Date, Merchant, Debit/Credit
French Headers
Date, Description, Montant
Date de transaction, Bénéficiaire
Date d'affichage, Commerçant
✓ Automatic Detection
Our converter automatically detects French column headers and converts them to standard English CSV format for universal accounting software compatibility.
CAD Currency Formatting
Canadian dollar (CAD) formatting maintained with proper decimal places and thousands separators for Canadian accounting software.
Format
$1,234.56
Dollar sign, comma separator
Decimals
.00
Two decimal places (cents)
Currency Code
CAD
ISO 4217 standard
CRA Tax Compliance
Canada Revenue Agency (CRA) Requirements
CRA requires Canadian taxpayers to maintain supporting documents for 6 years. Bank statements in CSV/Excel format qualify as acceptable records for tax audits.
Personal Income Tax
CSV statements document income deposits, eligible deductions, RRSP contributions for T1 returns.
Business GST/HST
Import to QuickBooks Canada or Sage 50 CA for GST/HST tracking and filing.
Record Retention
Keep CSV files for 6 years from end of tax year. CRA accepts digital records.
Should I download the monthly eStatement or a transaction history export?
Use the monthly eStatement PDF when you need a reconciled record. RBC, TD, BMO, Scotiabank, and CIBC all offer eStatements in online banking, usually under the account's statements or documents section. A custom date-range history export often omits the opening and closing balances, which are the numbers you need to confirm that a converted file is complete.
How do I bring a converted Canadian statement into Xero or Wave?
Both accept a CSV with a date, a description, and a single signed amount column. In Xero, open the bank account and choose the option to import a statement, then map the columns on the preview screen. Wave, which was built in Toronto, accepts bank statement uploads from its Transactions page. In either one, set the date format to match the file before you confirm, since a DD/MM and MM/DD mix-up is the usual cause of transactions landing in the wrong month.
Does the bank statement show the GST/HST I paid?
No. A bank line shows the total amount paid, with sales tax included and not broken out. To claim input tax credits you still need the supplier's receipt or invoice showing their GST/HST registration number. Import the bank data to get the transactions into your books, then split the tax portion on each expense using the receipt.
Frequently Asked Questions
🇨🇦 Convert Canadian Bank Statements
All Canadian banks supported. CAD currency. English/French bilingual. CRA compliant. Works with QuickBooks CA, Sage 50 CA.
Start Free ConversionRBC • TD • Scotiabank • BMO • CIBC • All Canadian banks