Convert BMO bank statements to Excel
BMO keeps seven years of eStatements in online banking, which covers most tax reviews, loan files and catch-up bookkeeping. The catch is that they're PDFs, and pasting one into Excel gives you broken rows and amounts that won't add. If you need those months as a spreadsheet or an import file, here is what to expect.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your BMO statement into Excel
-
Download the PDF statement from BMO online banking
- Sign in to BMO online banking or the BMO app.
- Open the account and go to its statements.
- Choose the statement period and download the statement as a PDF.
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your BMO statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about BMO statements
Descriptions that run onto extra lines
A long description often continues onto a second or third line, with the merchant on one and the location underneath. Copy-paste turns those into rows with no amount. Here the continuation lines are joined to the transaction they belong to, so one purchase stays one row.
Dollar signs in the amount columns
An amount printed as $1,250.00 is text to Excel, so it won't sum or sort properly. The output drops the symbol and the thousands comma and stores each amount as a plain number, negative for money out. Totals and pivot tables work without any cleanup.
One statement per account, every month
BMO issues a separate statement for each account you hold, monthly, and the paper and eStatement versions carry the same information. A year for two accounts is 24 files. Upload each account's statements as their own batch; a skipped month or a duplicate download gets flagged.
Output and review
From BMO PDF to your books
Accounting tip
In QuickBooks Online, add the QuickBooks-ready CSV through the bank account's upload option and confirm which column is which; Xero's statement import works the same way with the Xero-ready file. Sage Accounting also accepts a CSV of bank transactions.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
BMO statement questions
Do BMO credit card statements convert the same way?
What if I need a statement older than seven years?
Can I convert a business account statement?
Can I import converted BMO rows into QuickBooks or Xero?
Convert your BMO statement to Excel
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by BMO.