QuickBooks reconciliation discrepancies: find & fix.
Your reconciliation won’t balance, or the beginning balance no longer matches what it was last month. A reconciliation discrepancy almost always means a transaction that was already reconciled got changed after the fact — edited, deleted, voided, or re-dated. This is the methodical hunt: read the difference for clues, use the Reconciliation Discrepancy report and the audit log to find exactly what changed, and fix the root cause rather than forcing an adjustment that hides it. Independent firm, not affiliated with Intuit Inc.
A QuickBooks reconciliation discrepancy is a difference between your books and the bank statement that stops a reconciliation from balancing — or a beginning (opening) balance that is suddenly wrong when it tied in a prior period. The most common single cause is a previously-reconciled transaction that was later edited, deleted, voided, or moved to a different date. Two tools find it: the Reconciliation Discrepancy report, which lists transactions changed since they were reconciled, and the audit log (QuickBooks Desktop) or audit history (QuickBooks Online), which shows who changed what and when. The right fix is to correct the root-cause transaction — not to force an adjustment that papers over it.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, and not Intuit’s official software support. Not affiliated with Intuit Inc.
Reconciliation discrepancies, in five questions.
What is a QuickBooks reconciliation discrepancy?
A difference between your books and the bank statement that stops a reconciliation from balancing — or a beginning (opening) balance that is suddenly wrong when it tied last period. It almost always means a transaction that was already reconciled has since been edited, deleted, voided, or re-dated, so the reconciled history no longer ties to the bank.
Why won’t my QuickBooks reconciliation balance?
Most often a previously-reconciled transaction was changed after the fact, or someone manually edited the opening / beginning balance. Other causes: transactions entered in the wrong period, duplicate or missing transactions, and a bank-feed match applied to the wrong transaction. The fix is to find the exact change — not to force an adjustment that hides it.
How do I find a reconciliation discrepancy in QuickBooks?
Start with the difference amount for clues — a single round number often points to one changed transaction, while many small ones suggest several. Then run the Reconciliation Discrepancy report to list transactions changed since they were reconciled, and use the audit log (Desktop) or audit history (QuickBooks Online) to see who changed what and when.
How do I fix a reconciliation discrepancy?
Correct the root-cause transaction: restore something that was deleted or voided, re-date a transaction posted to the wrong period, remove a true duplicate carefully, re-match a bank-feed entry to the right transaction, or reset a manually-edited beginning balance to what it should be. Then re-run the affected reconciliation so each month ties again.
Should I just force an adjustment to make it balance?
No — a forced reconciliation adjustment papers over the real change, distorts your financials, and pushes the error into the next month. It’s a last resort that an accountant should sign off on, never a first move. Forcing it once tends to compound into a multi-month problem that costs more to unwind than the original discrepancy.
Why a reconciliation won’t balance, plainly.
A reconciliation discrepancy is a gap between what QuickBooks shows and what the bank statement shows that keeps a reconciliation from coming to zero. It surfaces two ways. Either the difference at the end of a reconciliation won’t clear no matter what you select, or the beginning balance QuickBooks proposes for a new reconciliation doesn’t match the ending balance you reconciled to last time. Both point to the same underlying event: something that was already reconciled has been changed since.
When a transaction that you previously cleared is later edited, deleted, voided, or re-dated, QuickBooks recalculates — and the reconciled history no longer ties. The fix is not to invent an adjustment that forces the numbers to agree; that only hides the change and corrupts the next month too. The fix is to find the exact transaction that moved, understand why, and correct it at the source. QuickBooks gives you two tools for that hunt — the Reconciliation Discrepancy report and the audit trail — and the difference amount itself is the first clue. If the change turns out to be an Intuit account or data-sync issue rather than something inside your books, that part stays with Intuit.
What causes a reconciliation discrepancy.
Ranked by how often they’re the culprit — the find-and-fix steps below trace these in the same order, so working down the list resolves most discrepancies efficiently.
Cause 01 · A reconciled transaction was edited, deleted, or voided
By far the most common cause. A transaction you had already cleared in a prior reconciliation gets changed afterward — its amount edited, or the transaction deleted or voided entirely. QuickBooks recalculates, the reconciled total no longer matches the bank, and the difference appears in the next reconciliation even though that month looked fine before.
Cause 02 · The opening or beginning balance was manually changed
The beginning balance for a new reconciliation is meant to carry forward from last month’s ending balance. If someone manually edited the opening-balance equity entry or the first reconciled transaction, the proposed beginning balance no longer matches what you actually reconciled to — so the new reconciliation starts off wrong before you clear a single line.
Cause 03 · Transactions entered in the wrong period
A transaction dated into the wrong month — or re-dated after it was reconciled — lands in a statement period it doesn’t belong to. The month it left and the month it joined both stop tying, and the difference can look larger than the single transaction because two periods are affected at once.
Cause 04 · Duplicate or missing transactions
A transaction recorded twice (often manually entered and then imported) or one that’s missing entirely throws the difference off by exactly that amount. Duplicates inflate one side of the reconciliation; a missing transaction leaves a real bank line with nothing to clear against.
Cause 05 · A bank-feed match to the wrong transaction
When a downloaded bank-feed item is matched to the wrong existing transaction — or added as new when a match already existed — the register and the statement drift apart. The amounts can look close enough to slip through, then surface later as a discrepancy that doesn’t obviously tie to one entry.
Less common · Less common: data damage or a sync issue
Occasionally the difference traces not to a human edit but to file data damage, or to bad data arriving from a bank-feed or sync issue. These are where the surface steps stop explaining the difference and a file review — or, if it’s an Intuit-side sync matter, Intuit — is warranted.
How to find and fix discrepancies.
Six steps, in order. Read the difference for clues first, then let the Reconciliation Discrepancy report and the audit trail name the transaction — and fix the root cause, not the symptom.
Read the difference amount for clues
Before opening any report, look at the difference itself. A single round figure often means one changed or missing transaction of that amount — search the register for it directly. A difference that’s the sum of several smaller numbers points to multiple changes. Twice a familiar amount usually means a duplicate. The number is your first and fastest lead.
Confirm the beginning balance
Open a new reconciliation and check the proposed beginning balance against last month’s reconciled ending balance. If it doesn’t match, the problem is upstream — a prior reconciled transaction or the opening-balance entry was changed — and you’ll trace that period rather than the current one.
Run the Reconciliation Discrepancy report
QuickBooks keeps a Reconciliation Discrepancy report that lists transactions changed after they were reconciled, with the date of the change. This is the most direct tool for the hunt: it points straight at the edited, deleted, or voided entries that knocked the reconciliation out of balance.
Trace it in the audit log or audit history
Use the audit log in QuickBooks Desktop, or the audit history in QuickBooks Online, to see exactly who changed a transaction, what it was before, and when. This confirms what the discrepancy report flagged and tells you whether to restore the original, re-date it, or remove a duplicate — and it preserves accountability.
Fix the root cause, not the symptom
Correct the transaction at its source: restore something deleted or voided, re-date an entry posted to the wrong period, carefully remove a genuine duplicate, re-match a bank-feed item to the right transaction, or reset a manually-changed beginning balance. Address the actual change — resist the urge to invent an offsetting entry.
Re-run the reconciliation and verify each month ties
After the root-cause fix, re-run the affected reconciliation — and any later month the change touched — so each period ties to its statement again. If the difference still won’t clear, or it spans several months, stop before forcing anything and get the file reviewed; a forced adjustment only deepens the problem.
Discrepancy you can’t trace, or months out of balance?
A Certified ProAdvisor reviews the file free, then finds what changed and corrects the reconciliation at the root — a focused diagnostic is typically a $1,200–$3,000 fixed-fee scope; cleanup runs $1,500–$15,000+ if the books are behind. Independent firm.
When to bring in a ProAdvisor.
You can’t trace what changed
The reconciliation won’t balance, but the discrepancy report and audit trail don’t lead you to a clear cause — or there are too many changes to untangle by hand. That’s the point to have a ProAdvisor read the file, because guessing from here usually adds more entries to clean up later.
Several months are out of balance
The beginning balance has drifted across multiple periods, or a prior forced adjustment already buried the original change. Once a discrepancy compounds month over month, untangling it is cleanup work — a methodical re-tie of each affected period, not a single fix.
An adjustment was already forced
Someone made the reconciliation balance with a forced adjustment, and now the financials look off or the next month won’t reconcile either. Reversing a forced entry and finding the real root cause is precise work an accountant should do before it distorts the books further.
A Certified ProAdvisor finds what changed and corrects it at the root.
Forcing an adjustment to make a reconciliation balance is the fast wrong answer — it buries the real change and pushes the error into next month. The work that actually restores trust in the numbers is the trace: reading the difference for its signature, running the Reconciliation Discrepancy report, walking the audit log or audit history to see exactly which reconciled transaction was edited, deleted, voided, or re-dated, and correcting that transaction so the reconciled history ties again. A Certified QuickBooks ProAdvisor with active Online and Desktop certifications does that against a written scope and verifies each affected month re-ties before closing. Independent firm — not Intuit, and not Intuit’s software support; an Intuit account, login, or billing matter stays with Intuit.
Free
file review first — we look before we scope
$1,200–$3,000
typical fixed-fee diagnostic for a focused discrepancy + reconciliation fix
Independent
Certified ProAdvisor firm — not Intuit, not Intuit’s software support
What people ask about reconciliation discrepancies.
Is this Intuit’s official QuickBooks support?
Why won’t my QuickBooks reconciliation balance?
Why is my beginning (opening) balance wrong?
What is the Reconciliation Discrepancy report?
How do I see who changed a transaction?
Should I force an adjustment to make it balance?
Does this apply to QuickBooks Online and QuickBooks Desktop?
When should I stop and call a ProAdvisor?
Discrepancy you can’t trace, or several months out of balance?
Can’t find it? Get the file reviewed.
If the difference won’t resolve, the beginning balance has drifted across several months, or a prior adjustment already buried the problem, the books need hands-on diagnosis — not another forced entry. Start with a free file review; from there a focused diagnostic is typically a $1,200–$3,000 fixed-fee scope, and a full cleanup runs $1,500–$15,000+ when the books are behind. Independent ProAdvisor firm, written scope before any work begins.