Bank Balance Doesn't Match QuickBooks: How to Fix It

Your bank balance does not match your QuickBooks balance for one of a few reasons: transactions that have not cleared the bank yet, transactions on the statement that are missing from QuickBooks, duplicate entries, an item recorded with the wrong amount or date, or a beginning balance thrown off by a reconciled transaction that was later edited. The difference is real and traceable, and reconciling the account against the statement is how you find the exact transactions behind it.

Most of these are quick fixes once you know which one you are dealing with. The trickiest is missing transactions, because the live bank feed only reaches back about 90 days and quietly drops connections, so a whole period can be absent from QuickBooks without any warning. When that is the cause, the fastest fix is to convert the statement PDF to a .qbo file with the tool above and import the missing transactions, so QuickBooks holds every line the bank does. Here is how to work through each cause.

Why doesn't my bank balance match my QuickBooks balance?

The two balances differ because they count different transactions. Your bank balance includes only what has cleared the bank, while your QuickBooks balance includes everything you have recorded, cleared or not. Add outstanding checks, deposits in transit, missing transactions, duplicates, and edited entries, and the gap appears. Reconciling against the statement isolates the exact transactions responsible.

What is the difference between bank balance and in QuickBooks balance?

On the QuickBooks Online banking screen, the Bank balance is the figure pulled straight from your bank, and the In QuickBooks balance is the total of transactions you have added to the register. They differ when transactions are still sitting in the For Review tab, or when you have recorded items the bank has not cleared yet. Adding and matching transactions brings them together.

Why is my QuickBooks balance higher than my bank balance?

QuickBooks reads higher than the bank when you have recorded money that has not actually left or arrived. Outstanding checks you wrote but the recipient has not cashed, deposits you entered but the bank has not posted, or duplicate income entries all inflate the QuickBooks figure. Confirm each uncleared item is legitimate, and remove any duplicate deposits.

Why is my QuickBooks balance lower than my bank balance?

QuickBooks reads lower than the bank when transactions the bank already processed are missing from your books. Deposits or transfers you never recorded, fees and charges the bank applied, or a month the feed never imported all leave QuickBooks short. Find the missing transactions on the statement and add or import them so the books catch up to the bank.

How do I fix my bank balance in QuickBooks?

Work in order. First, account for outstanding checks and deposits that simply have not cleared, since those are normal timing gaps. Next, find and delete duplicate transactions. Then import or enter any transactions on the statement that are missing from QuickBooks. Finally, reconcile the account against the statement so the difference settles at $0.00.

What are outstanding transactions in QuickBooks?

Outstanding transactions are entries you have recorded in QuickBooks that have not yet cleared the bank. The most common are checks written but not cashed and deposits made but not yet posted. They are not errors, just timing, and they explain a normal gap between your QuickBooks balance and the bank balance until the bank processes them.

Why are transactions missing from QuickBooks?

Transactions go missing when the bank feed does not capture them. The feed only pulls about the last 90 days, so older activity never imports, and a feed that disconnects for a stretch leaves a hole when it reconnects. Manual entries that were skipped also leave gaps. The cure is to import the missing period from the statement itself.

How do I find the difference between QuickBooks and my bank?

Run a reconciliation. Enter the statement's ending balance and date, then check off each QuickBooks transaction that appears on the statement. Whatever is left unmatched, on either side, is the source of your difference. The reconciliation discrepancy report also lists any reconciled transaction that was changed after the fact, which throws off the beginning balance.

Does reconciling fix a balance that doesn't match?

Reconciling does not fix the balance by itself, but it shows you exactly what to fix. Matching every QuickBooks transaction to the statement reveals what is missing, duplicated, or wrong. You then add, delete, or correct those items, and the balances agree. Reconcile every account monthly and the two balances rarely drift far apart.

Why doesn't my beginning balance match in QuickBooks?

A beginning balance stops matching when a transaction reconciled in a prior period was later edited, deleted, or unreconciled. QuickBooks built the opening figure from those cleared items, so changing one breaks it. Use the reconciliation discrepancy report to find the altered transaction and restore it, and the beginning balance lines up again.

How do I import missing transactions to fix the balance?

Download the statement for the missing period, convert the PDF to a .qbo file with the converter at the top of this page, then in QuickBooks Online go to Transactions, Bank transactions, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. The transactions post with their real dates so the balance corrects and the period can reconcile.

How do I stop my bank and QuickBooks balance from drifting apart?

Reconcile every account once a month, the moment each statement closes. Monthly reconciliation catches missing and duplicate transactions while they are easy to trace, before they pile up. Keep the feed healthy, import any month it skips, and avoid editing transactions that are already reconciled. Small, regular checks keep the two balances in step.

For the full workflow, see how to reconcile bank statements in QuickBooks, learn how far back QuickBooks can import bank transactions, and follow the steps to import old bank statements into QuickBooks when a month is missing. If a file gets rejected, read why QuickBooks won't import your .qbo file. If the register has dropped below zero, start with the causes of a negative bank balance in QuickBooks. To compare the bank against your register, a bank statement to Excel converter puts every line in a spreadsheet, a CSV to QBO converter covers accounts that only export CSV, and uncashed bills behind a high QuickBooks balance are easier to track with accounts payable automation.