QuickBooks Bank Reconciliation Discrepancy: Find and Fix It

Short answer: A QuickBooks bank reconciliation discrepancy means the difference between your bank statement and QuickBooks is not zero, and it almost always traces to one of five causes: a wrong beginning balance, a duplicate transaction, a deleted or edited previously-reconciled item, a transaction entered with the wrong amount or date, or transactions that were never imported. Work them in that order and the difference resolves. Run the Reconciliation Discrepancy report first, because it lists exactly which reconciled transactions were changed after the fact.

Reconciliation is the monthly check that your books match reality. When the difference will not clear to zero, the instinct is to force it with an adjustment, but a forced adjustment hides the real error and it compounds. The faster path is to find the specific transaction causing the gap. Here is the order that finds it quickest.

What causes a reconciliation discrepancy in QuickBooks?

Five causes account for nearly every discrepancy. A changed beginning balance means a previously-reconciled transaction was edited, deleted, or voided. A duplicate means the same transaction was imported twice, often from overlapping bank feed and file imports. A wrong amount or date throws the total or pushes an item into the wrong statement period. Missing transactions were never brought into QuickBooks. And a manual reconciliation adjustment from a prior month can carry forward. Identify which one you have before touching anything.

Why is my beginning balance wrong this month?

Your beginning balance is wrong because a transaction you already reconciled was later edited, deleted, or unreconciled. QuickBooks locks a reconciled balance, so when the opening figure no longer matches last month's ending figure, something in a closed period moved. Run the Reconciliation Discrepancy report, which lists every reconciled transaction that was changed and the date it changed, then reopen those items and restore them to how they cleared. Fixing the beginning balance first is essential, because you cannot reconcile the current month on top of a broken starting point.

How do I find the exact transaction causing the difference?

Start with the difference amount itself, because the number is a clue. If the discrepancy is evenly divisible by nine, you likely have two digits transposed, such as 54 entered as 45. If it equals a single transaction on your statement, that item is probably missing or duplicated. If it is exactly double a transaction, you have a duplicate. Sort the register by amount to spot repeats, then by date to catch items posted to the wrong period. This narrows most discrepancies to one or two candidates in minutes.

How do I find and remove duplicate transactions?

Sort the account register by amount so identical figures sit next to each other, and look for the same date, payee, and amount appearing twice. Duplicates usually come from importing a file that overlaps the bank feed, or from importing the same statement twice. Delete the copy that is not matched to anything, keep the reconciled one, and reconcile again. To avoid re-creating the duplicate, only import the date range you have not already brought in.

What if transactions are missing from QuickBooks?

If your statement shows transactions QuickBooks never received, import the gap. Download the missing period from your bank as a CSV, convert it to a .qbo file, and import that so the transactions post with the correct dates and amounts. This is common when a bank feed reaches back only 90 days or when a feed silently stopped updating for a stretch. Our CSV to QuickBooks Desktop guide covers the import path for the desktop app, and the CSV to QBO converter builds the file.

Should I use a reconciliation adjustment to force it to zero?

Only as a last resort, and only for a tiny, well-understood difference such as a rounding penny. A reconciliation adjustment posts a plug entry to an expense account and clears the screen, but it does not fix the underlying error, so the same gap tends to reappear and the plug entries pile up. If you cannot find the cause, it is better to leave the month open and keep hunting than to bury a real error under an adjustment you will have to unwind later.

How do I prevent discrepancies next month?

Three habits prevent most of them. Never edit or delete a transaction after it is reconciled; if it is wrong, correct it with a clearly dated entry instead. Import each period once, matched cleanly to the bank feed so nothing doubles. And reconcile every account every month while the details are fresh, rather than letting several months stack up. When you do need to backfill older activity, pulling it from the bank as a file and converting it keeps the amounts and dates exact. When you are digging figures out of a scanned or paper statement, get them into clean rows first so the import matches to the penny.

Where is the Reconciliation Discrepancy report in QuickBooks?

In QuickBooks Online, open Reports and search for Reconciliation Discrepancy, then pick the account. In QuickBooks Desktop, go to Reports, then Banking, then Reconciliation Discrepancy. The report lists every previously-reconciled transaction that was later edited, deleted, or voided, along with the date of the change and who made it. It is the single fastest tool for a wrong beginning balance, because it points you straight at the transactions that moved instead of making you scan the whole register.

How do I undo a reconciliation and start over?

In QuickBooks Online, an accountant user can undo a reconciliation from the reconciliation history, which unclears the transactions for that period so you can redo it cleanly. In QuickBooks Desktop, you undo a reconciliation from the Reconcile window under the Locate Discrepancies or Undo Last Reconciliation option. Undo only the periods you need, work forward from the earliest broken month, and reconcile each one against its statement so the beginning balances chain correctly again.

Related reading: if the opening figure is the problem, see why your opening balance is wrong after import, clear doubled entries with duplicate transactions in QuickBooks Online, and to catch up a full backlog use reconcile a year of QuickBooks in one sitting.