QuickBooks Bank Reconciliation Discrepancy: Find and Fix It
No account needed for your first 3 conversions. We never store your bank login.
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. Getting the dates and signs right on that gap file matters more than the speed of the conversion, and our comparison of the best CSV to QBO converters weighs the tools on exactly that. 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.
What does the difference amount tell you?
The number itself narrows the search faster than scrolling the register does. Before you open a single transaction, run the difference through the patterns below. Four of them identify the cause outright, and the other two cut the list of suspects to a handful of rows.
| What the difference looks like | Most likely cause | Where to look first |
|---|---|---|
| Evenly divisible by 9 | Transposed digits, for example 54.00 keyed as 45.00 | Amounts whose digits are a rearrangement of each other |
| Exactly twice a transaction on the statement | A sign that went in backwards: a payment entered as a deposit | That one transaction, not the whole register |
| Exactly equal to one statement line | A single missing or duplicated transaction | Search the register for that amount |
| A round figure ending in .00 | A manual journal entry or a forced adjustment from a prior month | Journal entries dated in the period |
| A few odd cents | A bank fee or interest posted separately, or a rounding difference | The statement's fee and interest lines |
| Matches the change in your beginning balance | A previously reconciled transaction was edited, deleted or unreconciled | The prior period, not this one |
The last row is the one people waste the most time on, because the problem is not in the month they are staring at. If the beginning balance moved, stop reconciling the current period and go back.
What is the Reconciliation Discrepancies account in QuickBooks?
It is the expense account QuickBooks Desktop posts a forced reconciliation adjustment to. This surprises people who expect the adjustment to land in Opening Balance Equity: it does not. Anything sitting in Reconciliation Discrepancies is a difference somebody chose to write off rather than explain, so a growing balance there is a warning sign.
Review it at least annually. Each entry represents a month where the books stopped matching the bank and the cause was never found, and the underlying error is usually still in the file. If the account carries anything more than trivial pennies, the honest move is to reverse the adjustments and reconcile properly rather than let the write-offs accumulate.
Why is my QuickBooks balance different from the bank balance?
Because the two are measuring different things at different moments. The bank shows what has cleared and, in the case of available balance, what it is holding. QuickBooks shows everything you have entered, including checks written but not yet cashed and deposits recorded but not yet settled. A gap between them is normal; a gap that will not reconcile at the statement date is not.
Compare like with like before assuming an error. Reconcile against the statement ending balance on the statement ending date, never against today's online balance, and check whether you are looking at the bank's current balance or its available balance. Pending card authorizations that have not posted are the single most common false alarm.
How do I reconcile a credit card account in QuickBooks?
The same way as a bank account, with the signs reversed. On a card, a purchase increases what you owe and a payment reduces it, so the ending balance you enter is the amount owed on the statement, not a positive cash figure. Reconcile the card before you reconcile the checking account that pays it, so the payment is matched on both sides.
The classic card discrepancy is a payment recorded twice: once as a transfer out of checking and again as a payment on the card. Both accounts look plausible in isolation and the pair only shows up when you reconcile them in sequence.
Can I reconcile in QuickBooks Online without a bank feed?
Yes. The reconciliation screen works from whatever is in the register, regardless of how it got there. If a bank has dropped its feed or you have chosen not to pay for one, download the statement activity, convert it to a .qbo file and import it, then reconcile normally. The result is identical to a feed, on your schedule rather than the bank's.
This has become a practical question rather than a theoretical one, because banks keep retiring the paid connections. If yours has, the Direct Connect alternative covers the switch, and CSV to QuickBooks Online covers the import itself.
What if a whole month was reconciled against the wrong statement?
Undo that reconciliation and redo it rather than adjusting forward. Every month after it inherits the wrong beginning balance, so patching the current period only moves the error along. In QuickBooks Online an accountant user can undo a reconciliation from the reconciliation history; in Desktop, open the reconcile window and choose Undo Last Reconciliation.
Work forward from the earliest affected month, one at a time, checking the beginning balance at the start of each. It is slower than a single adjusting entry, and it is the only version that leaves the file defensible if anyone audits it later.
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.