Convert BMO statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel files from the PDF.
BMO eStatements are plain PDFs with no password. On an account page, Download Account Details lets you choose Quicken, QuickBooks, Simply Accounting or Spreadsheet (CSV), and you can set a date range, but in practice it only reaches back a few months.
Drop your BMO statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in CAD.
Last updated
How to download a BMO statement as a PDF
- Sign in to BMO Online Banking and select the account from My Accounts.
- Open the account menu and choose Statements (labelled eStatements on some screens).
- Pick the statement date from the list. The PDF opens or downloads depending on your browser.
- Save it. Statements are archived for seven years from the time you enrolled in eStatements.
- In the BMO app: tap the account, then Statements & Documents, then the period, and use the save option.
Then drop the file above; several months of BMO statements at once come back as one workbook.
Is the BMO PDF password-protected?
BMO eStatements are plain PDFs with no password. Some older combined business statements are image-based scans rather than text, but they are still not locked.
What BMO statements look like
Date, Description, Amounts deducted from your account, Amounts added to your account, Balance.
BMO puts an Opening balance line at the top of the table as if it were a transaction, with the figure in the Balance column and nothing in the amount columns; it is treated as the opening figure, not a row. The headings are Date, Description, Amounts deducted from your account, Amounts added to your account, Balance. Cheques show as "Cheque, No. 0123", Interac transfers as INTERAC e-Transfer Sent or Received, and the plan fee as a Plan Fee line. Dates are shown as short month and day, year from the header. Business clients sometimes receive a combined statement with several accounts in one PDF, each with its own opening and closing balance, and BMO occasionally drops a promotional notice between the summary and the table.
Why not use BMO's own export?
On an account page, Download Account Details lets you choose Quicken, QuickBooks, Simply Accounting or Spreadsheet (CSV), and you can set a date range, but in practice it only reaches back a few months. Two things to know about the CSV: dates come out as a bare number like 20250522 rather than a date, and there is no balance column, so nothing to reconcile against. For the current quarter it is fine. For a prior year, or when the running balance is the point, the eStatement PDFs are the record that exists.
Where BMO statements trip up converters
- Statement may start with "Opening balance" as a row; it is used as the opening figure, not a transaction.
Which software BMO customers import into
BMO customers most often import into QuickBooks Online, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
BMO questions
My BMO business statement covers three accounts in one PDF. Do I get three sheets?
Yes, one per account, without splitting. Each section starts with its own Opening balance line and ends with its own closing balance, so the converter reads the PDF as three accounts and the workbook gets a sheet per account, each tied out against its own closing balance. If a section were ever missed, printing each account's pages to a separate PDF and uploading them together gives the same result.
Why is there an Opening balance row in the statement but not in my converted rows?
Because it is not a transaction. It is read as the opening figure and used to check that the first real row moves the balance correctly, then the closing balance is checked at the end. If you need it in the spreadsheet for your own workings, add it as a first line; the value is in the summary at the top of the statement.
Will the dates from a BMO CSV export, like 20250522, be fixed if I upload that instead?
Upload the PDF rather than the CSV. The statement carries proper dates and a balance column, and the conversion outputs real date cells. The CSV export is meant for accounting software imports and is the wrong starting point for a spreadsheet.
How do I convert a BMO statement PDF to Excel?
Download it from BMO using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many BMO statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.