How to Convert Canadian Bank Statements to CSV and Excel (2026 Guide)

Why Convert Canadian Bank Statements to CSV?

Canada's Big Five banks — RBC, TD, Scotiabank, BMO, and CIBC — along with dozens of smaller banks and credit unions, provide statements as PDF files. Converting to CSV unlocks your data for:

• Import into QuickBooks, Sage, or Xero for bank reconciliation
• GST/HST tracking for CRA quarterly remittances
• T2 corporate tax returns and T1 personal tax filing
• Expense analysis in Excel or Google Sheets
• Replacing failed bank feeds when direct connections to accounting software break

Understanding Canadian Bank Statement Formats

Date Formats

Canadian banks use various date formats — some use MM/DD/YYYY (following US convention), others use DD/MM/YYYY or MMM DD, YYYY. French-language statements from Quebec banks may use entirely different formatting. StatementKit correctly identifies and standardises all Canadian date formats.

Bilingual Statements

Canada is officially bilingual, and many banks — especially Desjardins, National Bank, and Laurentian Bank — issue statements in French or bilingual English/French format. StatementKit's AI handles both languages, correctly parsing transaction descriptions, dates, and banking terminology in either language.

Transaction Types

Canadian bank statements include several country-specific transaction types:

• Interac e-Transfer — Canada's dominant person-to-person payment system
• Pre-Authorized Debit (PAD) — Recurring bill payments
• Interac Direct Payment — Debit card purchases at point-of-sale
• Cheque clearances — With cheque numbers for reconciliation
• EFT (Electronic Funds Transfer) — Payroll deposits, government payments (CRA refunds, EI, CPP)

Bank-by-Bank Format Guide

RBC Royal Bank

Canada's largest bank provides statements with Date, Description, Withdrawals, Deposits, and Balance columns. RBC Online Banking allows PDF downloads from the Statements section. See our RBC conversion guide for specific details.

TD Canada Trust

TD statements include Date, Transaction Details, Debit, Credit, and Balance. TD EasyWeb provides PDF statement downloads. TD uses abbreviated dates and includes transit/account numbers on each page.

Scotiabank

Scotiabank statements show Date, Description, Withdrawals, Deposits, and Balance. Scotia OnLine provides statement downloads. Scotiabank includes a summary section with total debits and credits.

BMO (Bank of Montreal)

BMO statements use Date, Transaction Description, Debit, Credit, and Balance columns. BMO Online Banking provides PDF downloads. BMO's format is clean and tabular, working well with conversion tools.

CIBC

CIBC statements include Date, Description, Debit, Credit, and Balance. CIBC Online Banking provides statement downloads from the Accounts section. CIBC includes an activity summary at the top of each statement.

Step-by-Step: Convert Any Canadian Bank Statement

1. Download your PDF statement from your bank's online banking portal.
2. Upload to StatementKit — sign up for free and upload the PDF file.
3. Review the extracted transactions — verify dates, amounts, and descriptions are correct.
4. Download as CSV or Excel — choose the format that suits your needs.
5. Import into your accounting software — upload the CSV to QuickBooks, Sage, Xero, or Wave.

Importing Into Canadian Accounting Software

Importing into QuickBooks Online

QuickBooks is the most popular small business accounting software in Canada:

1. Go to Banking > Banking
2. Select your bank account and click Link account > Upload from file
3. Upload the CSV and map the Date, Description, and Amount columns
4. Review and accept the imported transactions

Importing into Sage 50

Sage 50 (formerly Simply Accounting) is widely used by Canadian accountants:

1. Go to Banking > Import Bank Statement
2. Select the CSV file from StatementKit
3. Map the columns to Sage's expected format
4. Import and begin categorizing transactions

Importing into Wave

Wave is a Canadian-made free accounting software popular with freelancers:

1. Go to Banking > Connected Accounts
2. Select your account and click Upload a statement
3. Upload the CSV file
4. Wave auto-categorizes many common transactions

CRA Tax Reporting and GST/HST

GST/HST Tracking

Canadian businesses registered for GST/HST need to track the tax paid on purchases (Input Tax Credits) and collected on sales. Having bank transactions in CSV format makes it easy to:

• Identify GST/HST-eligible expenses by category
• Calculate Input Tax Credits for your GST/HST return
• Prepare quarterly or annual GST/HST filings

T2 Corporate Returns

For incorporated businesses, year-end bank statement data helps reconcile revenue and expenses for T2 corporate tax returns. CSV format allows easy sorting and summarization of business transactions.

T1 Self-Employment Income

Sole proprietors report business income on T2125 (Statement of Business or Professional Activities). Structured bank data makes it straightforward to separate business from personal transactions and calculate net business income.

Tips for Canadian Users

• Watch for provincial differences — Quebec businesses may have QST in addition to GST. Alberta has no provincial sales tax.
• Handle French statements — if your bank issues statements in French, StatementKit handles the translation of transaction types automatically.
• Credit union statements work too — Vancity, Coast Capital, Meridian, Servus, and all other Canadian credit unions are supported.
• Download the full tax year (January to December for personal, or your fiscal year for corporate) to have all data in one place.

Related Resources

• Canadian Bank Statement Converter — our dedicated tool page for Canadian banks
• RBC Royal Bank Statement Converter — specific guide for RBC
• How to Import Bank Statements into QuickBooks
• Bank Statement to CSV — general conversion guide