How to Convert BMO Bank Statements to CSV or Excel

Why Convert BMO Statements?

BMO (Bank of Montreal) is Canada's oldest bank, founded in 1817, and one of the Big Five. BMO serves millions of personal and commercial banking customers across Canada and the US. Their PDF statements contain detailed transaction records, but the compact table formatting makes manual extraction a chore — especially for busy months with dozens of transactions per page. BankRead reads BMO's statement layout automatically, extracting dates, descriptions, debits, credits, and balances into a structured format ready for export to CSV or Excel.

Understanding the BMO Statement Format

BMO chequing and savings statements use a portrait PDF layout. The transaction table includes columns for Date, Description, Debits, Credits, and Balance. Transactions are listed in chronological order. The header section shows the account number, branch transit, statement period, and account summary (opening balance, total debits, total credits, closing balance). BMO Mastercard statements use a separate layout with Date, Transaction Description, and Amount columns, plus a statement summary section at the top showing previous balance, payments, purchases, and new balance.

How to Convert with BankRead

Follow these steps to convert your BMO PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your BMO online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your BMO Statement PDF

1. Log in to BMO Online Banking at bmo.com with your card number and password.
2. Click on the account name from the accounts dashboard.
3. Select 'Statements' from the account options or navigation menu.
4. Choose the month you need from the list — BMO keeps eStatements for up to 7 years.
5. Click the PDF download link and save the file to your computer.

What Data Gets Extracted

BankRead extracts the following fields from your BMO statement:

• Transaction date
• Description (e.g., 'INTERAC DIRECT PAYMENT — CANADIAN TIRE #327')
• Debit amount (withdrawals, payments, fees)
• Credit amount (deposits, refunds)
• Running balance
• AI-assigned category (e.g., Auto & Gas, Shopping, Utilities)

Export Options

Once your BMO statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for BMO Statements

• BMO statements use a clean, column-aligned table that's well-suited to automated extraction — expect high accuracy.
• BMO Mastercard statements are also supported. Upload credit card statements the same way as chequing statements.
• Multi-page statements (common for business accounts with high transaction volume) are processed in a single upload.
• BMO occasionally includes promotional banners or notices in the PDF — BankRead's parser ignores these and extracts only the transaction table.
• BMO US personal banking (formerly BMO Harris) statements have a slightly different layout — both Canadian and US BMO formats are supported.

Common Issues and Solutions

• BMO statements sometimes include an 'Interest Summary' or 'Fee Summary' section at the end. These are extracted as individual line items, not duplicated.
• Older BMO statements (pre-2013) may use a scanned image format. BankRead automatically detects scanned PDFs and processes them with AI vision. You can also upload photos of paper BMO statements.
• BMO's combined statements (multiple accounts in one PDF) are supported — all accounts' transactions are extracted together.

Frequently Asked Questions