How to Fix QuickBooks After Switching Banks

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

Short answer

When you switch banks or your bank changes systems, the QuickBooks bank feed usually breaks because the account connection and account numbers change. Reconnect the new account as a fresh feed for going-forward activity, then fill the gap by downloading the PDF statements from the old and new banks, converting each to a QBO file, and importing them under Bank transactions. That keeps a clean, continuous history without the duplicates a broken feed leaves behind.

Switching banks is one of the surest ways to break your bookkeeping for a month or two. A merger like Bank of the West moving to BMO, a business deciding to leave a big bank for a credit union, or even a routine routing-number change can all knock the QuickBooks bank feed offline. The feed disconnects, transactions stop importing, and when you try to fix it you sometimes end up with the same charges twice. A switch is one of the most common reasons for missing transactions in a QuickBooks bank feed, because the connection drops right around the changeover. This guide walks through how to move your books to a new bank cleanly, fill the transition gap, and avoid the duplicate mess that usually follows.

Why switching banks breaks the QuickBooks bank feed

The bank feed in QuickBooks Online ties to a specific account at a specific institution through a stored connection. When the bank changes, that connection no longer matches. A merger reissues account numbers and moves them onto a new core system, a new bank is a different institution entirely, and even a branch or product change can reset the login the feed depends on. QuickBooks cannot follow those changes automatically, so the feed either stops pulling new transactions or starts pulling them under a connection that no longer reconciles. The result is a stretch of missing activity right around the switch, which is exactly the period you most need to get right.

Step one: stop the old feed cleanly before you disconnect

Before you touch the new bank, close out the old one in QuickBooks. Let the old feed finish importing everything it can, categorize and reconcile through the last full statement, then disconnect the old account from Bank transactions so it stops trying to sync a closed account. Disconnecting does not delete any transactions already in QuickBooks; it only stops the feed. Reconciling first matters because once you disconnect, you lose the easy match between the feed and the register, and a half-reconciled old account is the most common source of a wrong balance later.

Step two: connect the new bank as a fresh feed

Add the new bank as a new account in QuickBooks rather than trying to repoint the old one. In Bank transactions, choose to connect an account, search for the new institution, and link it to a new or existing account in your chart of accounts. The fresh feed will backfill roughly the last 90 days and then keep syncing going forward. Connecting it as a clean account avoids the tangle of an old connection that no longer matches the bank, and it gives you a clear line between old-bank history and new-bank activity.

Step three: fill the gap from the PDF statements

The fresh feed only reaches back about 90 days, so anything older than that, plus any days the switch skipped, has to come from the statements. Download the PDF statements covering the gap from both the old and new bank's online banking, then convert each one to a QBO file and import it under Bank transactions. The converter reads every line, you review it, and QuickBooks dates each transaction correctly so the gap closes and your history stays continuous. If you have not done it before, here is how to import the QBO file into QuickBooks step by step. If your new bank is one of the larger US institutions, the per-bank guides walk through exactly where to find the statements, including BMO statement to QuickBooks for accounts that moved over from Bank of the West, Comerica statement to QuickBooks, and M&T Bank statement to QuickBooks. For the full process on any bank, start with the PDF bank statement to QuickBooks converter.

How to avoid duplicate transactions during the switch

Duplicates happen when the same transaction comes in twice: once from a feed and once from an imported statement, or from two overlapping statement imports. The fix is to map out the dates before you import anything. Note the exact date the new feed's backfill starts, then only import statement data for the period before that date. Where the feed and a statement overlap, pick one source for those days, not both. If duplicates still slip in, you can exclude them from the For Review tab before you add them, which is far easier than deleting posted transactions later. Importing oldest to newest also makes it obvious if a day is covered twice.

Reconcile each month against the statement, not the feed

Once the gap is filled and the new feed is running, reconcile every month against its PDF statement ending balance, working from the oldest open month forward. Reconciling to the statement rather than the feed is what catches a missing day, a duplicated charge, or a transaction that posted to the wrong account during the switch. When each month ties out to the bank's own ending balance, you know the transition is clean and the new bank's books are trustworthy from day one.

Frequently asked questions

How do I change banks in QuickBooks Online without losing history?

Connect the new bank as a new account and leave the old account in place rather than deleting it. The old transactions stay in QuickBooks under the old account, the new feed handles going-forward activity, and you fill any gap by converting the PDF statements to QBO files and importing them. Nothing is lost because you are adding the new source alongside the old history, not replacing it.

Why did my bank feed disconnect after a bank merger?

A merger moves your account onto the acquiring bank's systems and usually reissues the account number and login, so the stored feed connection no longer matches. QuickBooks cannot follow that change on its own, so the feed errors out or stops pulling transactions. Reconnect the account under the new bank's name and convert the PDF statements for the transition period to close the gap.

Should I delete the old bank account in QuickBooks after switching?

No. Disconnect the old feed so it stops syncing, but keep the account itself so its reconciled history and reports stay intact. Deleting or merging accounts during a switch is a common cause of broken balances and missing audit trails. Make the old account inactive only after everything is reconciled and you are sure you will not need to post to it again.

How do I bring in transactions from the period the feed skipped?

Download the PDF statements that cover the skipped dates from your old and new bank's online banking, convert each statement to a QBO file, and import it under Bank transactions. QuickBooks dates every line from the statement, so the skipped period fills in correctly and reconciles to the statement total. Use the converter at the top of this page to turn each statement into an importable QBO file.

How long does the new bank feed take to start working?

A new feed usually connects within a few minutes and backfills roughly the last 90 days, though some banks take a day or two to finish the first sync. Do not wait on it to close your books. Convert the PDF statements for the gap right away, reconcile, and let the feed catch up to the present in the background.

When you need a different output than QBO

A bank switch is not always a QuickBooks-only cleanup. If you want the transactions in a spreadsheet first to compare the old and new bank side by side, a bank statement to Excel converter turns the same PDFs into a worksheet you can sort and review. If your bookkeeper handed you the gap data as a spreadsheet, a CSV to QBO converter turns that file into the QBO format QuickBooks imports. And when the statements come in formats other than PDF, a general bank statement to QuickBooks converter covers the rest.

A clean handoff to the new bank

Switching banks does not have to leave a hole in your books. Reconcile and disconnect the old feed, connect the new one fresh, fill the gap from the PDF statements, and reconcile month by month against the statement totals. Done in that order, the transition is just a few extra imports instead of a tangle of duplicates and missing months. When you are ready, upload your first transition statement to the converter at the top of this page and close the gap.

Z tej samej rodziny narzędzi