How to Export Bank Transactions from Every Major Canadian Bank (CSV & XLSX)

Exporting your bank transactions is the first step to organized expense tracking. Every major Canadian bank lets you download your transaction history - but the process varies by institution. This guide gives you exact steps for each bank, plus tips on getting the cleanest file for upload into ExpenseFlow.

Why Export Your Transactions?

Manually entering every purchase into a spreadsheet is slow, error-prone, and easy to fall behind on. Exporting your bank statement as a file lets you import months of transactions in seconds, catch deductible expenses you might have forgotten, maintain consistent records for CRA audit purposes, and reconcile your books against what actually cleared your account.

Most banks support CSV (comma-separated values) format, and some also offer XLSX (Excel). ExpenseFlow accepts both.

RBC Royal Bank

RBC Online Banking lets you export up to 6 months of transactions at a time.

Steps (Online Banking)

Steps (RBC Mobile App)

The RBC app does not currently support transaction export. Use the desktop site instead.

Note: RBC's CSV includes columns: *Date, Description 1, Description 2, CAD$, USD$*. ExpenseFlow auto-detects this format.

Source: RBC Help Centre - "Downloading Transactions"

TD Canada Trust

TD's EasyWeb portal supports CSV and Microsoft Money (OFX) formats.

Steps (EasyWeb)

Note: TD exports include *Date, Description, Debit, Credit, Balance* columns. If you see separate Debit and Credit columns, ExpenseFlow handles both.

Source: TD Help - "How do I download my account transactions?"

Scotiabank

Scotiabank's Scotia OnLine portal supports CSV and several other formats.

Steps (Scotia OnLine)

Note: Scotiabank CSVs include *Date, Description, Withdrawals, Deposits, Balance* columns. Withdrawals (expenses) are positive numbers - ExpenseFlow handles the sign convention automatically.

Source: Scotiabank Help Centre - "Downloading or exporting account statements"

BMO Bank of Montreal

BMO's online banking supports CSV export from both the desktop site and app.

Steps (BMO Online Banking)

Steps (BMO Mobile App)

Note: BMO's CSV includes *Date, Description, Amount* with negative amounts for withdrawals.

Source: BMO Help & Support - "How do I download my account transactions?"

CIBC

CIBC Online Banking supports CSV export with flexible date ranges.

Steps (CIBC Online Banking)

Note: CIBC exports include *Date, Description, Debit, Credit* columns. Expenses appear in the Debit column; credits (deposits) appear in the Credit column.

Source: CIBC Help Centre - "Downloading account activity"

Wealthsimple

Wealthsimple's Cash account (chequing) supports CSV export through the web app.

Steps (Wealthsimple Web)

Note: Wealthsimple's CSV uses unique column names (*transaction_date, activity_sub_type, net_cash_amount*). ExpenseFlow has native support for the Wealthsimple format - select "Wealthsimple" in the bank selector when uploading for best results.

Source: Wealthsimple Help - "Downloading your transaction history"

Tips for the Cleanest Export

Supported Formats Summary

ExpenseFlow also accepts XLSX files exported from any Canadian bank or financial institution that supports Excel format export.