Convert BMO Bank Statement to Excel, CSV & QuickBooks
Upload a BMO checking, savings, credit card or business statement PDF, or an older BMO Harris or Bank of the West statement, and get every transaction as a spreadsheet row.
Upload Bank Statement
Drop your file here or click to browse
About BMO
BMO Bank N.A. is the US subsidiary of Bank of Montreal, headquartered in Chicago. It was called BMO Harris Bank until 2023, when it took the BMO name after buying Bank of the West and converting those West Coast accounts to BMO systems in September 2023. Statements from before those dates carry BMO Harris or Bank of the West branding.
Consumer accounts include BMO Smart Advantage Checking, BMO Smart Money (a checkless account), BMO Relationship Checking and BMO Savings Builder, plus the BMO Cash Back and BMO Premium Rewards Mastercards. BMO Bank's routing number is 071025661; 071000288 is the older Harris Bank number. These are separate from BMO's Canadian transit numbers.
BMO Bank N.A.
Chicago, IL
071025661071000288071025661 is BMO Bank's main routing number (formerly BMO Harris); 071000288 is the legacy Harris Bank number still printed on some older Illinois accounts.
BMO Harris, BMO Harris Bank, Bank of Montreal (US), Bank of the West
How to download your BMO statement as a PDF
The converter needs the PDF statement BMO produces, not a screenshot or a transaction export.
Online banking
- 1
Sign in to BMO Digital Banking (bmo.com, US) and select the account.
- 2
Open "Statements" and choose the statement month.
- 3
Download the PDF.
- 4
Upload the PDF to ProcessBankStatement and download it as CSV, Excel, QuickBooks or OFX.
Mobile app
- 1
Open the BMO Digital Banking app and tap the account.
- 2
Tap "Statements", choose the month and download the PDF.
- 3
Upload the PDF here.
What you get back
Every transaction on the statement, one row each, with the date, description, amount and running balance.
CSV
Opens in Excel, Google Sheets, and imports into most accounting software.
Excel (.xlsx)
Date, Description, Amount and Balance columns with amounts stored as numbers.
QuickBooks (.qbo)
Import straight into QuickBooks Desktop or Online as bank transactions.
OFX
For Quicken, Xero, and other tools that accept OFX bank feeds.