How Canadian banks give you your statements
Every major Canadian bank keeps PDF statements online for around seven years. Their transaction downloads are another story: short date ranges, or formats for one piece of software.
| Bank | PDF statements online | Built-in download |
|---|---|---|
| RBC | Up to 7 years, while the account is open | Not documented for personal accounts |
| TD | Up to 7 years from when you switched online | CSV or QuickBooks/Quicken, last 45 days max |
| Scotiabank | Up to 7 years | QuickBooks (QBO) or Quicken (QFX) |
| BMO | Up to 7 years | QuickBooks Online connection for business |
| CIBC | Up to 7 years | CSV or QuickBooks/Quicken, last 13 months |
| Desjardins | 7 years from when you registered | CSV; business CSV, TXT and OFX |
Copies of old statements from the bank typically cost $5 to $15 each, so the PDFs you can already download are the practical source for anything the download can't reach.
What the CRA expects you to keep
- Six years. You generally must keep required records and supporting documents for six years from the end of the last tax year they relate to (the fiscal period for corporations, the calendar year for individuals). File late, and it's six years from when you file.
- Bank statements count. The CRA tells sole proprietors and partnerships to keep deposit slips, bank statements and cancelled cheques.
- GST/HST and Québec. GST/HST records follow a similar six-year rule, and Revenu Québec also generally requires six years.
- Electronic records are fine. Records that start out electronic, like eStatements, must be kept in an electronic, readable format even if you also print them. Scanned paper only replaces the original if it was imaged to the CAN/CGSB 72.34 standard.
- Keep them in Canada. Records must be kept at your place of business or residence in Canada unless the CRA gives written permission otherwise.
The Canadian date-format trap
Canadian bank data doesn't agree on one date order:
- The Government of Canada's data standard writes all-numeric dates as YYYY-MM-DD.
- QuickBooks Online Canada recommends dd/mm/yyyy.
- Wave requires YYYY-MM-DD or YYYY/MM/DD.
- Desjardins' business CSV uses YYYY/MM/DD.
A date like 03/04 can mean 3 April or 4 March. When you import, make sure the file's date order matches what your software expects, and spot-check a few transactions after the import.
Importing into Canadian accounting software
- Accepts a 3-column (date, description, amount) or 4-column (date, description, credit, debit) CSV.
- Recommends dd/mm/yyyy dates and asks you to leave zero values blank.
- Files must be in English, 350 KB or less, and up to 1,000 lines per upload.
- Requires the transaction date and amount, with income and expenses in one amount column.
- Accepts DD/MM/YYYY, MM/DD/YYYY or YYYY/MM/DD.
Wave
- Accepts OFX, QBO, QFX, ASO and CSV, but not PDF.
- A CSV needs a date, an amount (one column, or separate deposit and withdrawal columns) and a description.
- Dates must be YYYY-MM-DD or YYYY/MM/DD, and you should remove any balance-total rows.
Converting a Canadian bank statement
- Upload your PDF statements. Batch upload handles a year of monthly statements at once.
- Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
- Download one transaction per row, ready to review, reconcile or import, and check the date order matches your software.
Credit card statements from Canadian issuers convert the same way with the credit card statement converter.