Convert BMO Harris Bank CSV to QBO / QFX / OFX
Drop your BMO Harris Bank CSV or Excel export below and get a BMO Harris Bank → 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 Harris Bank
US bank, the successor to Harris Bank / BMO Harris (the US retail brand was renamed from 'BMO Harris' to plain 'BMO' in 2023; this is DISTINCT from BMO Canada). INTU.BID/FID is VERIFIED from the authoritative Intuit fidir.txt (qb2900): the primary entry is 'BMO U.S.' with Intuit BID = FID = 17614 (status ACTIVE, BANKING&DIRECT). Related fidir rows for the same US franchise: 09931 'BMO U.S. - Retail, SB', 53742 'BMO U.S. - OLBB' (business online banking), 54093 'BMO U.S. - Credit Cards', 17392 'BMO Financial Group' (spend dynamics/commercial cards). For a generic QFX/QBO use ORG=BMO U.S., FID=17614, INTU.BID=17614 (in fidir the BID and FID columns are identical here). Caveat: US-system migrations (Harris -> BMO, and Bank of the West -> BMO) repeatedly broke Direct/Web Connect, so if a feed fails users may need the 'Retail, SB' (09931) or 'OLBB' (53742) variant instead. EXPORT (BMO US online banking): Log in > select account > transaction history/Activity > Download/Export > pick date range + format. Formats include CSV/Spreadsheet, Quicken (.QFX), QuickBooks (.QBO/Web Connect), and OFX; BMO publishes 'connecting to QuickBooks' PDFs so the native .QBO is the most reliable QuickBooks path. CSV layout: header row, then Date, Description, Amount (single signed column; debits negative) plus Balance; some exports split into separate Debit/Credit columns - support both. US date format MDY (MM/DD/YYYY).
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 Harris Bank files
- Choose MM/DD/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 Harris Bank” in the bank dropdown autofills it.
FAQ
How do I export a CSV from BMO Harris Bank?
US bank, the successor to Harris Bank / BMO Harris (the US retail brand was renamed from 'BMO Harris' to plain 'BMO' in 2023; this is DISTINCT from BMO Canada). INTU.BID/FID is VERIFIED from the authoritative Intuit fidir.txt (qb2900): the primary entry is 'BMO U.S.' with Intuit BID = FID = 17614 (status ACTIVE, BANKING&DIRECT). Related fidir rows for the same US franchise: 09931 'BMO U.S. - Retail, SB', 53742 'BMO U.S. - OLBB' (business online banking), 54093 'BMO U.S. - Credit Cards', 17392 'BMO Financial Group' (spend dynamics/commercial cards). For a generic QFX/QBO use ORG=BMO U.S., FID=17614, INTU.BID=17614 (in fidir the BID and FID columns are identical here). Caveat: US-system migrations (Harris -> BMO, and Bank of the West -> BMO) repeatedly broke Direct/Web Connect, so if a feed fails users may need the 'Retail, SB' (09931) or 'OLBB' (53742) variant instead. EXPORT (BMO US online banking): Log in > select account > transaction history/Activity > Download/Export > pick date range + format. Formats include CSV/Spreadsheet, Quicken (.QFX), QuickBooks (.QBO/Web Connect), and OFX; BMO publishes 'connecting to QuickBooks' PDFs so the native .QBO is the most reliable QuickBooks path. CSV layout: header row, then Date, Description, Amount (single signed column; debits negative) plus Balance; some exports split into separate Debit/Credit columns - support both. US date format MDY (MM/DD/YYYY).
Is my BMO Harris Bank 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.