The risks of forcing a reconciliation.
When a reconciliation won’t balance, QuickBooks offers a tempting shortcut: enter a “reconciliation discrepancy” adjustment that pushes the difference to zero so you can finish. That’s “forcing” the reconciliation — and it doesn’t fix anything. It masks the real problem, dumps the difference into an account nobody reviews, and lets the error compound month after month. Below: exactly what a forced reconciliation hides, and how to fix it the right way.
What you can check before you sign
- Fixed fee, written first
- Your own QuickBooks file
- No hourly billing
If your file needs our paid diagnostic first, its fee is credited in full against the cleanup. Either way, you get a fixed fee in writing before any work starts.
Forcing a reconciliation means accepting QuickBooks’ offer to enter an adjusting entry — a “reconciliation discrepancy” — that pushes a stubborn difference to zero instead of finding the transaction that’s actually wrong. It looks like the reconciliation is done, but the difference doesn’t disappear: it lands in an opaque account, usually Reconciliation Discrepancies or Opening Balance Equity, where nobody looks.
The real error — a missing or duplicate transaction, an edited reconciled entry, a wrong opening balance, bank-feed duplicates, or a wrong amount — stays in the file, and every later reconciliation builds on top of it. The right fix is to find and correct the actual transaction so the books tie on their own, with no plug.
They took something that felt overwhelming to me as a first-year business owner and made it simple.
What stood out the most was TechBrot Inc’s attention to detail.
What forcing a reconciliation hides.
A reconciliation that won’t balance is pointing at one concrete problem. The forced adjustment buries it — here’s what can be underneath, in the order to check it.
Hidden cause 01 · A missing or duplicate transaction
The most common thing a forced adjustment buries. A transaction that never made it into QuickBooks — or one that was entered twice — throws the cleared balance off by exactly that amount. Forcing the reconciliation makes the screen balance while the underlying register is still wrong, so every report that pulls from it is wrong too.
Hidden cause 02 · An edited or deleted previously-reconciled transaction
A transaction that was already reconciled in a prior month later gets edited, voided, or deleted — which silently un-balances that closed period. The next reconciliation won’t tie, and forcing it papers over a change that the Audit Log can pinpoint to the exact entry, date, and user.
Hidden cause 03 · A wrong opening balance
If the account’s opening balance was entered incorrectly when the account was first set up — or got distorted by an Opening Balance Equity entry — the reconciliation can never tie on its own. Forcing it each month stacks adjustment on adjustment instead of correcting the starting figure once.
Hidden cause 04 · Bank-feed duplicates
Transactions that were both downloaded from the bank feed and manually entered — or downloaded twice after a reconnect — inflate the cleared balance. The reconciliation won’t balance because the file shows more activity than the statement. A forced adjustment hides the duplication rather than removing the extra copies.
Hidden cause 05 · A transaction at the wrong amount
A single transaction keyed at the wrong figure — a transposed number, a fee left off, a payment recorded gross instead of net — leaves the reconciliation short or over by the difference. Forcing it accepts the wrong amount permanently instead of correcting the one entry.
Where it lands · Where the forced difference goes — and why it compounds
When you accept the adjustment, QuickBooks dumps the difference into an opaque account — usually Reconciliation Discrepancies or Opening Balance Equity — where nobody reviews it. The original error stays in the file, the next reconciliation inherits it, and the adjustments accumulate. Over months, the balance sheet drifts from reality and no single report tells you why.
How to fix it the right way.
Six steps, in order. The goal is a reconciliation that ties to the bank statement on its own — with no adjusting entry to force it.
- 1
Run the Reconciliation Discrepancy Report and the Audit Log
Start with the Reconciliation Discrepancy Report — it lists transactions that were changed after a reconciliation — and the Audit Log, which shows exactly what was edited, voided, or deleted, when, and by whom. Together they turn a vague “it won’t balance” into a specific list of suspect transactions.
- 2
Find the actual changed or missing transaction
Compare the cleared balance to the bank statement and use the difference as a clue — the adjustment amount is almost always the size of the real error. Track down the one transaction that’s missing, duplicated, edited, deleted, or entered at the wrong amount. Identifying the specific entry is the whole job; the correction is the easy part.
- 3
Correct that transaction at the source
Fix the real entry rather than the symptom: add the missing transaction, remove the duplicate, restore or re-enter the changed one, or correct the wrong amount. If an opening balance is the culprit, fix the starting figure rather than adjusting every month. Correct the cause and the reconciliation tends to fall back into line.
- 4
Reverse any prior forced adjustments
Before re-reconciling, find and reverse the forced reconciliation-discrepancy entries from earlier periods — otherwise the difference gets counted twice once you correct the real transaction. This is also where balances stuck in Reconciliation Discrepancies or Opening Balance Equity get cleared back out to where they belong.
- 5
Re-reconcile cleanly
With the real error fixed and the old plugs reversed, re-run the reconciliation so the cleared balance ties to the bank statement on its own — with no adjusting entry needed. A reconciliation that balances without a plug is the only one you can actually trust.
- 6
Verify the books tie — and confirm any prior-period impact
Check that the register, the reconciliation, and the financial reports all agree, and that no mystery balance is left behind. Where a correction touches a closed or filed period, a CPA confirms the prior-period impact before anything is finalized — we don’t file taxes, and we don’t change a closed period without that sign-off.
Three signs prior reconciliations were forced.
Mystery balances in Reconciliation Discrepancies or OBE
There’s a balance sitting in Reconciliation Discrepancies or Opening Balance Equity that nobody can explain. Those accounts are where forced adjustments land — a lingering balance there is a strong sign prior reconciliations were pushed to zero instead of being corrected.
Reconciliations that “balance” but the reports are wrong
Every month shows as reconciled, yet the balance sheet or the bank balance is off by an amount no one can account for. When the reconciliation status is clean but the reports don’t match reality, the difference was almost certainly forced rather than found.
An adjustment entry on past reconciliations
The reconciliation history shows discrepancy or adjustment entries on prior months — the literal footprint of a forced reconciliation. Each one represents a real error that was buried instead of fixed, and they compound until the file is reconciled properly.
A QuickBooks ProAdvisor finds the real error instead of forcing it.
Forcing a reconciliation is the easy way out; finding the truth is the work. A QuickBooks ProAdvisor reads the Reconciliation Discrepancy Report and the Audit Log to trace the exact transaction that’s missing, duplicated, edited, deleted, or wrong — then corrects that entry, reverses the forced adjustments stacked up in prior periods, and re-reconciles until each month ties to the bank statement with no plug. Where a correction touches a closed or filed period, a CPA confirms the prior-period impact before anything is finalized — we don’t file taxes. Independent firm, working against a written scope; an Intuit account, login, or billing matter stays with Intuit.
What people ask about forced reconciliations.
What happens if I let QuickBooks force the reconciliation?
QuickBooks enters a reconciliation-discrepancy adjustment for the difference and marks the period reconciled. The screen balances, but the real error — a missing or duplicate transaction, an edited reconciled entry, a wrong opening balance, bank-feed duplicates, or a wrong amount — is still in the file, and the difference is now sitting in an opaque account. Every later reconciliation builds on that, so the books drift further from reality over time.
Where does the forced adjustment actually go?
Into an opaque account — most often Reconciliation Discrepancies or Opening Balance Equity — that almost no one reviews. That’s what makes it dangerous: the difference isn’t gone, it’s hidden, and the original error stays in the register feeding wrong numbers into your reports.
How do I find what’s really causing the discrepancy?
Run the Reconciliation Discrepancy Report and the Audit Log. The discrepancy report flags transactions changed after a reconciliation; the Audit Log shows exactly what was edited, voided, or deleted, when, and by whom. The difference amount is usually the size of the real error, which makes it a clue to the specific transaction — missing, duplicated, edited, deleted, or entered at the wrong amount.
Can a forced reconciliation be undone?
Yes. The right approach is to find and correct the real transaction, reverse the prior forced adjustment so the difference isn’t double-counted, then re-reconcile so the cleared balance ties to the statement on its own — with no plug. Balances stuck in Reconciliation Discrepancies or Opening Balance Equity get cleared back out as part of that work.
Will fixing this change a tax return I already filed?
It can, if a correction touches a period that was already closed or filed — which is why we have a CPA confirm any prior-period impact before anything in a closed period is finalized. We don’t file taxes; we fix the books and flag what your CPA needs to review so the correction is handled cleanly on both sides.
How much does it cost to fix forced reconciliations?
We start with a free file review to see how deep it goes. A focused reconciliation repair — finding the real errors, reversing the forced plugs, and re-reconciling — is a focused cleanup, a $1,200 to under $3,000 fixed fee. If forced adjustments have compounded across many months and the books are broadly behind, a full cleanup runs $1,200–$15,000+. You get a written scope before any work begins. To talk through your reconciliations, speak with an advisor at (877) 751-5575.
Can you just enter the adjustment for me to make it balance?
No — that’s the thing this page is warning against. Entering an adjustment to force a balance hides the real problem and corrupts the books over time. We find the actual error and correct it so the reconciliation ties on its own. A reconciliation that only balances because of a plug isn’t reconciled; it’s deferred.
Find the real error — get the file reviewed.
Tell us what’s wrong with the books. We’ll tell you whether cleanup, catch-up or monthly bookkeeping fits.
Or send the details instead