How to Import BMO Transactions into QuickBooks (After the Digital Banking Migration)

Short answer: BMO connects to QuickBooks Online through an OAuth login and to QuickBooks Desktop through Web Connect (.QBO) files. If your feed stopped after BMO moved to Digital Banking, delete the old connection and reauthorize a new one. The catch is that a reauthorized feed starts fresh and does not backfill the transactions from before the migration. For those months, and for QuickBooks Desktop, convert the BMO statement PDF to a QBO file and import it under Transactions, Bank transactions, Upload from file in QuickBooks Online, or File, Utilities, Import, Web Connect Files in Desktop.

A lot of BMO customers hit the same wall in the last two years. The bank retired the old BMO Harris online systems, moved everyone onto BMO Digital Banking, and the QuickBooks connection that had been quietly working for years stopped bringing anything in. Reconnecting fixed the current month. It did not bring back the history, and for the businesses in the middle of a close, that was the part that mattered.

Why the BMO feed stopped after the migration

The connection between a bank and QuickBooks is not permanent. It is an authorized link, and when BMO changed the platform underneath it, the authorization no longer pointed at anything. BMO now uses OAuth for QuickBooks Online, which is the modern, more secure method: you log in at BMO and grant access without handing your banking password to Intuit. It is cleaner when it holds. But moving to it meant every existing connection had to be torn down and rebuilt, and a rebuilt connection behaves like a brand-new one.

That is the piece worth understanding before you spend an afternoon on it. The feed was not broken in a way that reconnecting repairs and restores. It was replaced, and a replacement starts from the day you authorize it.

Reconnecting BMO in QuickBooks Online

In QuickBooks Online, open Transactions, then Bank transactions, find the BMO account, and disconnect it if it is showing an error. Then add it back: search for BMO, pick the current listing rather than a legacy BMO Harris entry, and complete the OAuth login at BMO's site. When it lands back in QuickBooks, it will pull recent activity forward and nothing older.

Before you accept that first batch, check it against a statement. Reconnecting is the classic moment for a register to pick up doubled or missing transactions, because the old connection may have brought in a few days the new one repeats. Match the first synced week to the statement line by line, then let QuickBooks carry on.

Importing BMO transactions into QuickBooks Desktop

QuickBooks Desktop does not use the OAuth feed. Its path is Web Connect: download a .QBO file from BMO Digital Banking and import it under File, Utilities, Import, Web Connect Files on older versions, or File, Import, From Web Connect on newer ones. Point it at the file, map it to the right account, and review before you accept.

When BMO Digital Banking does not offer a .QBO download for the account or the period, which is common once you go back past the recent window or the account has been closed, the statement PDF is the source that always exists. Upload it to the BMO statement to QBO converter, choose QBO as the output, and import that file exactly the way you would import one from the bank. QuickBooks cannot tell the difference, because the format is identical: an OFX document carrying dates, descriptions, and signed amounts. What QuickBooks cannot read is the PDF itself, which is why renaming a statement to .qbo, an idea that resurfaces in forums every year, has never worked.

Recovering the pre-migration history

This is the job the reconnect does not do, and it is a conversion job, not a connection one. Pull the BMO statement PDFs for the months the new feed skipped, convert each one to a QBO file, and import them oldest first, reconciling as you go so the ending balance ties to each statement. Legacy Bank of the West statements, which moved into BMO after the 2023 acquisition, convert the same way. Once the older periods are in and reconciled, the current OAuth feed carries the rest forward. If you are rebuilding several months at once, the sequencing in our guide to catch-up bookkeeping in QuickBooks keeps it orderly.

Keeping duplicates out of the register

Duplicates get more likely during a migration, because people reconnect a feed and also import files to fill the gap, and the two overlap. Three habits prevent almost all of it. Deactivate any live BMO feed on an account before you import a file to it manually, so a half-live connection and a file do not post the same activity twice. Note the newest transaction that came in cleanly and start the next file the day after it, since overlapping date ranges are the number one cause of doubled activity. And reconcile the month you switched, not the following one, so a clean ending balance confirms the transition before you move on. If duplicates do land, exclude them from the For review tab rather than deleting entries that have already been reconciled.

Categorizing what lands in QuickBooks

Once the transactions are in, the review work is the same whether they came from a feed or a converted file: confirm the payee, set the category, and split anything mixed. If your business runs a lot of card and reimbursement activity, pushing that categorization onto software that reads receipts and sorts spending automatically keeps the BMO review queue from becoming the monthly bottleneck. The bank data tells you money moved; the receipt tells you what it bought.

Should you switch to QuickBooks Online because of this?

Only if you wanted to anyway. The OAuth feed is the method BMO intends to keep supporting, so QuickBooks Online is the smoother long-term fit. But QuickBooks Desktop still works, the Web Connect import still works, and a monthly file upload is not a migration. If your practice runs on Desktop, plan for a short import each month rather than a platform move you did not budget for. The comparison in QuickBooks Online vs Desktop bank statement import lays out what each version accepts.

Last updated July 2026. Bank connection methods and platform details change; confirm current details with BMO.