Canada bank statements

Canadian Bank Statements to Excel & CSV | AI Bank Statement

Canadian banks give you PDF statements for up to seven years, but their downloads are short-range or tied to specific software. This guide covers what the CRA expects you to keep, the date-format trap in Canadian data, and the import rules for QuickBooks, Xero and Wave, with a guide for each major bank.

Last updated 14 October 2026

At a glance

Currency
Canadian dollar (CAD, $)
Keep records (CRA)
Generally six years from the end of the last tax year they relate to
Government date standard
YYYY-MM-DD for all-numeric dates
Common accounting software
QuickBooks Online, Xero, Wave, Sage

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.

BankPDF statements onlineBuilt-in download
RBCUp to 7 years, while the account is openNot documented for personal accounts
TDUp to 7 years from when you switched onlineCSV or QuickBooks/Quicken, last 45 days max
ScotiabankUp to 7 yearsQuickBooks (QBO) or Quicken (QFX)
BMOUp to 7 yearsQuickBooks Online connection for business
CIBCUp to 7 yearsCSV or QuickBooks/Quicken, last 13 months
Desjardins7 years from when you registeredCSV; 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

QuickBooks Online

  • 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.

Xero

  • 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

  1. Upload your PDF statements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. 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.

Canada bank guides

Choose your output format

Frequently asked questions

How long do I need to keep bank statements in Canada?

The CRA says you generally must keep records and supporting documents for six years from the end of the last tax year they relate to, and tells sole proprietors and partnerships to keep their bank statements. GST/HST records follow a similar six-year rule, and Revenu Québec also uses six years.

Can I keep bank statements electronically for the CRA?

Yes. The CRA accepts records in an accessible and readable electronic format, and records that start out electronic, like eStatements, must be kept in electronic form even if you print them. Paper you scan can only be destroyed if it was imaged to the CGSB standard.

Why do dates go wrong when I import Canadian bank data?

Canadian data uses more than one date order. The federal standard for all-numeric dates is YYYY-MM-DD, QuickBooks Online Canada recommends dd/mm/yyyy, and Wave requires YYYY-MM-DD or YYYY/MM/DD. A file in the wrong order can swap day and month or be rejected, so match the date format to the software you're importing into.

Can Wave import a PDF bank statement?

No. Wave says it doesn't support PDF files for transaction uploads; it accepts OFX, QBO, QFX, ASO and CSV. Convert the PDF statement to CSV first, then upload it.

Which Canadian banks can I convert statements from?

Any Canadian bank or credit union that gives you a PDF statement. The guides below cover RBC, TD, Scotiabank, BMO, CIBC and Desjardins.

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing