Convert BMO (Bank of Montreal) CSV to QBO / QFX / OFX
Drop your BMO (Bank of Montreal) CSV or Excel export below and get a BMO (Bank of Montreal) → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from BMO (Bank of Montreal)
Canadian parent bank - DISTINCT from the US 'BMO Harris'/'BMO U.S.' entry. No verified Canadian OFX/Web Connect identity: not in ofxtools fi.cfg, and the authoritative Intuit fidir.txt contains only US-side BMO rows (BMO U.S. 17614, etc.) - there is NO 'Bank of Montreal (Canada)' Web Connect/INTU.BID entry. So ORG='', FID='0', intuBid='', confidence=none. Do NOT borrow the US 17614 for Canadian accounts and do NOT fabricate. BMO Canada is moving to OAuth feeds and Intuit discontinued QuickBooks Desktop in Canada, so the realistic path is CSV -> QBO/QFX conversion - exactly our page's value. EXPORT (BMO Online Banking for Personal, Canada): Sign in > under 'My Accounts' select the account > 'Download Account Details' / 'Download Transactions' > choose a date range and a Download format. Format menu offers QuickBooks, Quicken, Simply Accounting, and Spreadsheet (CSV); CSV and OFX are the dependable outputs. VERIFIED CSV COLUMN LAYOUT (BMO Canada chequing/Mastercard): First Bank Card, Transaction Type, Date Posted, Transaction Amount, Description. KEY QUIRKS: (1) the card/account number ('First Bank Card') is the FIRST column; (2) amount is a single signed 'Transaction Amount' (debits negative); (3) the file frequently has NO header row; (4) Date Posted is typically MM/DD/YYYY or DD/MM/YYYY depending on profile - treat as DMY but allow ISO/MDY fallback. Map Description->payee/memo, Transaction Amount->signed OFX amount. INTU.BID blank; generate QFX/OFX only after a user supplies a working ORG/FID, or have them use a native .QBO.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for BMO (Bank of Montreal) files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “BMO (Bank of Montreal)” in the bank dropdown autofills it.
FAQ
How do I export a CSV from BMO (Bank of Montreal)?
Canadian parent bank - DISTINCT from the US 'BMO Harris'/'BMO U.S.' entry. No verified Canadian OFX/Web Connect identity: not in ofxtools fi.cfg, and the authoritative Intuit fidir.txt contains only US-side BMO rows (BMO U.S. 17614, etc.) - there is NO 'Bank of Montreal (Canada)' Web Connect/INTU.BID entry. So ORG='', FID='0', intuBid='', confidence=none. Do NOT borrow the US 17614 for Canadian accounts and do NOT fabricate. BMO Canada is moving to OAuth feeds and Intuit discontinued QuickBooks Desktop in Canada, so the realistic path is CSV -> QBO/QFX conversion - exactly our page's value. EXPORT (BMO Online Banking for Personal, Canada): Sign in > under 'My Accounts' select the account > 'Download Account Details' / 'Download Transactions' > choose a date range and a Download format. Format menu offers QuickBooks, Quicken, Simply Accounting, and Spreadsheet (CSV); CSV and OFX are the dependable outputs. VERIFIED CSV COLUMN LAYOUT (BMO Canada chequing/Mastercard): First Bank Card, Transaction Type, Date Posted, Transaction Amount, Description. KEY QUIRKS: (1) the card/account number ('First Bank Card') is the FIRST column; (2) amount is a single signed 'Transaction Amount' (debits negative); (3) the file frequently has NO header row; (4) Date Posted is typically MM/DD/YYYY or DD/MM/YYYY depending on profile - treat as DMY but allow ISO/MDY fallback. Map Description->payee/memo, Transaction Amount->signed OFX amount. INTU.BID blank; generate QFX/OFX only after a user supplies a working ORG/FID, or have them use a native .QBO.
Is my BMO (Bank of Montreal) data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.