Convert Canadian bank statements to Excel
Canadian banks keep about seven years of statements online, but their downloads stop much sooner: 45 days for TD's accounting software export, 13 months at CIBC. Older months, and anything that has to match what the bank issued, start from the PDF. French statements from Desjardins and National Bank come through with their numbers fixed. Pick your bank, or upload a statement.
- Currency
- Canadian dollars (CAD), some USD accounts
- Dates
- Month and day; year from the period
- Money columns
- Withdrawals, deposits, balance
- Common imports
- QuickBooks Online, Xero, Sage
Private workspace. HTTPS upload. No credit card needed.
Banks
Canadian banks and what their statements do
Big banks 6
-
RBC Royal Bank
Withdrawals and Deposits columns, with a balance printed only on each day's last line.
-
TD Canada Trust
EasyWeb's software download covers 45 days and account history 18 months; statements go back seven years.
-
Scotiabank
Interac e-Transfer recipients often sit on the line below the amount.
-
BMO
A separate statement for every account each month, with seven years of eStatements online.
-
CIBC
Download Transactions reaches back 13 months; statements cover seven years for accounts and cards.
-
National Bank of Canada
French statements write 2 345,22, which comes out as 2345.22; descriptions stay in French.
Co-operative and provincial 2
-
Desjardins
Often in French, with a folio number and a three-letter transaction code on every line.
-
ATB Financial
Dates print as MM/DD without the year, and consolidated statements group several accounts.
Online banks and apps 4
-
EQ Bank
Monthly, online-only statements kept seven years; the US Dollar Account stays in USD.
-
Tangerine
Electronic statements are monthly and paper ones quarterly; chequing is paperless only.
-
Simplii Financial
eStatements are kept seven years and skipped in months with no balance and no activity.
-
Wealthsimple
Chequing statements start in September 2023, each with a CSV button beside the PDF.
Statement layout
What Canadian statements look like
Two money columns and no year
RBC and CIBC put withdrawals and deposits in separate columns beside the balance, and RBC, TD and ATB print only the month and day, leaving the year to the statement period. The two columns become one signed amount, and the year is filled in, even on statements that cross New Year.
French statements
Desjardins and National Bank statements may be in French, written 2 345,22 with a comma for the decimal and a space for thousands. Those become ordinary numbers like 2345.22. Descriptions stay as printed; nothing is translated.
Details on a second line
Card purchases often put the city and province under the merchant, and Interac e-Transfers put the recipient there. Those lines are joined to the transaction above, so one purchase stays one row.
Output and review
Rows, checks and exports
Each statement becomes rows of date, description, signed amount and balance in Excel, CSV or JSON, or in CSV layouts for QuickBooks and Xero. The rows are tested against the opening and closing balances before you export. Convert a year for one account while signed in and any missing month, overlap or repeated statement is flagged. USD accounts stay in US dollars.
QuickBooks, Xero and Sage
-
QuickBooks Online
Upload the QuickBooks CSV to the matching bank account and confirm the columns. Give each USD account its own bank account.
-
Xero
Use the Xero CSV with the bank statement import. You map the columns on the first file, and later files follow it.
-
Sage Accounting
Import the plain CSV as bank transactions. TD's and CIBC's own Simply Accounting downloads stop at 45 days and 13 months, so older periods come from statements.
FAQ