Bank of Montreal ยท Canada

BMO Statement to Excel, CSV & QuickBooks | AI Bank Statement

BMO stores eStatements for seven years as PDFs, one per account, while paper statements now cost $2.75 each. Here's how to get BMO statements, what business customers can sync to QuickBooks, and how to turn BMO PDFs into Excel, CSV, QuickBooks or Xero data.

Last reviewed 14 October 2026

At a glance

Official statement format
PDF eStatements in BMO Online Banking and the mobile app
Statements online
Up to seven years after they're posted
Paper and copies
Paper statement $2.75 each; copy of a statement $5.00
Business sync
Direct connection to QuickBooks Online, up to two years of deposit transactions
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

How to get a BMO eStatement

In BMO Online Banking (personal)

  1. Sign in to Online Banking.
  2. Select View eStatements from the left navigation menu.
  3. Choose the statement and save or print the PDF.

In the BMO mobile app

  1. Sign in and select the account.
  2. Open the Account details tab and select Statements.

In Online Banking for Business

  1. Under the Account Information tab, open the eStatements menu and select Account Statements.
  2. Choose the From and To dates and the accounts, then select Search.
  3. On the Statement Download screen, click the link in the Statement Date column to open the PDF.

Things to know about BMO statements

  • Seven years online. eStatements are stored for seven years after they're posted; save or print anything you need to keep longer.
  • One statement per account. BMO issues a separate statement for each account you hold.
  • Paper costs more than it used to. A paper statement is $2.75 each, a statement copy $5.00, and eStatements are free.
  • Cheque images aren't in eStatements. You can see the last three months of cheque images in Online Banking; older ones are a per-item request.
  • Report errors quickly. BMO's agreement asks you to report problems within 30 days of the statement date for monthly statements, another reason to get statements into a spreadsheet you can check.

Business: BMO and QuickBooks Online

BMO business accounts connect directly to QuickBooks Online: select Connect Account in QuickBooks, choose Bank of Montreal Canada โ€“ Business, sign in with your BMO Online Banking credentials and pick the accounts. You can view up to two years of transaction details for chequing and savings accounts, and up to three months plus the current month for business credit cards.

For anything outside that window, a different accounting app, or a client who sent PDFs, convert the statements instead.

Converting a BMO PDF statement

  1. Upload one or more BMO eStatements. 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, with date, description, withdrawals, deposits and balance in separate columns.

Amounts stay in dollars, and dates are written out consistently, so check that your accounting software's import date setting matches.

Getting BMO data into QuickBooks or Xero

  • QuickBooks: choose the 3- or 4-column CSV and upload it from file. QuickBooks Online Canada takes up to 1,000 lines per upload.
  • Xero: choose Xero CSV and import it as a bank statement for the matching account.

BMO credit card eStatements convert with the credit card statement converter.

Choose your output format

Frequently asked questions

How far back can I get BMO eStatements?

BMO says eStatements are stored for seven years, and you can access account statements for up to seven years after they're posted in Online Banking. Save or print copies you want to keep longer.

How do I find my eStatements in the BMO app?

Select the account, then Statements in the Account details tab. That's also where you can register for eStatements if you haven't already.

What does BMO charge for statements?

eStatements are free. BMO lists $2.75 per paper statement, $5.00 for an interim statement, and $5.00 for a search or copy of a personal account item such as a statement.

Does BMO connect to QuickBooks or Xero?

BMO business accounts can connect directly to QuickBooks Online, which pulls in transactions automatically and lets you view up to two years of deposit account transactions. BMO doesn't name Xero; for Xero, or for periods outside the connection, convert the statements and import them.

Can I import a converted BMO statement into QuickBooks or Xero?

Yes. Choose QuickBooks 3- or 4-column CSV or Xero CSV as the output, then import it into your accounting software.

Is it safe to upload a BMO statement?

Statements show your account number and transaction history. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Stop retyping statements by hand

Upload a PDF and download clean Excel, CSV, Xero or QuickBooks data in about 30 seconds.