QuickBooks reconciliation won’t balance: causes & fixes.
“Reconciliation won’t balance” covers a cluster of symptoms — the difference at the end of reconciling won’t go to zero, the beginning balance doesn’t match last month, or a period you already reconciled no longer ties. Most cases trace to a handful of causes, and the self-fix steps below work in order of likelihood. Below that: when a discrepancy spanning multiple periods means it’s a ProAdvisor call. Independent firm, not affiliated with Intuit Inc.
“QuickBooks reconciliation won’t balance” means the difference at the end of reconciling isn’t zero — the cleared balance in QuickBooks doesn’t match the bank statement’s ending balance — or a period you previously reconciled no longer ties because something inside it was changed after the fact. The most common single cause is a reconciled transaction that was later edited, deleted, or voided, which is exactly what the Reconciliation Discrepancy Report and the Audit Log are built to surface. Reconciliation exists in both QuickBooks Online and QuickBooks Desktop; the reports differ slightly but the logic is the same.
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 won’t balance, in five questions.
What does “QuickBooks reconciliation won’t balance” mean?
The difference at the end of reconciling isn’t zero — the cleared balance in QuickBooks doesn’t match the bank statement’s ending balance — or a period you already reconciled no longer ties because something inside it was changed after the fact. It happens in both QuickBooks Online and QuickBooks Desktop.
Why won’t my QuickBooks reconciliation balance?
Most often a transaction you already reconciled was later edited, deleted, or voided, which throws the period out of balance. Other common causes: duplicate transactions from the bank feed; a wrong beginning / opening balance; transactions dated outside the statement period or posted to the wrong account; uncleared stragglers left from a prior period; or a manual adjustment that once force-balanced the books and is now masking the real discrepancy.
How do I fix a reconciliation that won’t balance myself?
In order of likelihood: run the Reconciliation Discrepancy Report (and the Audit Log) to find changed, deleted, or voided reconciled transactions; check the beginning balance against last period’s ending balance; find and remove duplicate downloaded transactions; confirm the statement date range and that transactions sit in the right account; clear or correct any stragglers; and if a prior period was force-balanced with a bogus adjustment, identify and reverse it. The discrepancy report surfaces a large share of cases.
When does a reconciliation problem need a ProAdvisor?
When several months are unreconciled; when the discrepancy spans multiple periods; when a prior reconciliation was force-balanced with a made-up adjustment; or when the account never reconciled at all. That’s a cleanup, not a single fix — it’s a file review and a focused diagnostic or a full cleanup.
Why did a reconciliation I already finished suddenly change?
A previously-reconciled period “un-ties” when a transaction inside it is edited, deleted, or voided after the fact — the most common single cause. The Audit Log shows who changed what and when, and the Reconciliation Discrepancy Report flags the reconciled transactions that moved. Restoring or correcting them brings the period back in line.
“Reconciliation won’t balance,” plainly.
Reconciling is the monthly check that confirms your QuickBooks records match what the bank actually did: you mark each transaction that cleared, and at the end the difference between your cleared balance and the statement’s ending balance should be zero. When people say reconciliation “won’t balance,” they usually mean one of a few things: the difference at the end won’t go to zero no matter what they check; the beginning balance QuickBooks shows doesn’t match last period’s ending balance; or a period they already reconciled has changed — an old reconciliation that used to tie suddenly doesn’t.
The good news is that most of these trace to a short list of causes, and the self-fix steps below address them in order of likelihood — running the Reconciliation Discrepancy Report and the Audit Log surfaces a large share of cases, because the usual culprit is a reconciled transaction someone edited, deleted, or voided after the fact. What the steps can’t fix is a discrepancy that has compounded across many months, or a prior period that was “balanced” with a bogus adjustment to make the number go to zero. That part is a ProAdvisor job, not a single correction. And if the underlying issue is your Intuit account or login, that’s Intuit’s to resolve — not something we can reach.
Common causes, in order of likelihood.
The self-fix steps address these in the same order — so working through them in sequence resolves most broken reconciliations efficiently.
Cause 01 · A reconciled transaction was edited, deleted, or voided
The single most common cause. Once a transaction has been reconciled, changing its amount, date, or account — or deleting or voiding it — throws the period out of balance, so a reconciliation that used to tie no longer does. The Reconciliation Discrepancy Report and the Audit Log are built to surface exactly this.
Cause 02 · Duplicate transactions from the bank feed
Transactions that were both downloaded and manually entered, or imported twice after a reconnect, inflate the cleared balance and stop the difference from reaching zero. The data is there twice — the fix is finding and removing the genuine duplicates without deleting the real transaction.
Cause 03 · The beginning / opening balance is wrong
If the beginning balance QuickBooks shows doesn’t match the prior period’s ending balance — often from a mistyped opening balance when the account was set up, or a change to an earlier period — every reconciliation after it starts off-balance no matter how carefully you clear the current month.
Cause 04 · Transactions outside the statement period or in the wrong account
Transactions dated outside the statement’s date range, or posted to the wrong bank or credit-card account, pull the cleared balance away from the statement total. They look like they belong, but they don’t fall in this reconciliation — or this account.
Cause 05 · Uncleared stragglers left from a prior period
Transactions that never cleared the bank — an old uncashed check, a payment that bounced, an entry that was never matched — can linger uncleared and quietly shift the running difference. Clearing or correcting these brings the period back toward zero.
Less common · Less common: a manual adjustment masking an earlier discrepancy
When a prior period was force-balanced with a manual reconciliation adjustment to make the difference go to zero, the real discrepancy was never fixed — just hidden. It resurfaces later, and the adjustment itself now has to be found and reversed. This is where surface steps stop working and a file review is warranted.
How to fix a reconciliation that won’t balance.
Six steps, in order. Most discrepancies surface in the first two or three — if all six don’t resolve it, or the difference spans multiple periods, stop and get the file reviewed.
Run the Reconciliation Discrepancy Report and the Audit Log
Start here. The Reconciliation Discrepancy Report lists transactions that were changed after they were reconciled, and the Audit Log shows who edited, deleted, or voided what and when. Together they point straight at the most common cause — restore or correct the affected transactions and re-check the difference.
Check the beginning balance against last period’s ending balance
Confirm the beginning balance QuickBooks shows for this reconciliation equals the ending balance from the period before it. If it doesn’t, the problem started earlier — a mistyped opening balance or a change to a prior period — and has to be corrected before the current month can tie.
Find and remove duplicate downloaded transactions
Review the register and the For Review tab for transactions that appear twice — usually a downloaded entry plus a manually entered one, or a re-import after a reconnect. Remove the genuine duplicates carefully, so you don’t delete the real transaction the duplicate was copied from.
Confirm the statement date range and the right account
Make sure the statement date and ending balance you entered match the actual bank statement, and that every transaction you’re clearing falls inside that date range and belongs to this account — not a different bank or credit-card register. A wrong date range or misposted entry alone can stop the difference from closing.
Clear or correct any stragglers
Work through transactions that never cleared the bank — old uncashed checks, bounced payments, entries that were never matched. Decide whether each should clear, be corrected, or be voided with the right date, so the cleared set reflects what actually happened at the bank.
If a prior period was force-balanced, find and reverse the bogus adjustment
As a last self-fix step, look for a manual reconciliation adjustment that was made to force an earlier period to zero. If one exists, the real discrepancy is still there underneath it — the adjustment has to be identified and reversed. If the difference still won’t close, or it spans multiple periods, stop and get the file reviewed before it compounds.
Discrepancy spans months, or a prior period was force-balanced?
A Certified ProAdvisor reviews the file free, then traces the discrepancy and reverses any bogus adjustment until each month ties again — 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.
Three signals it’s a ProAdvisor call.
The discrepancy spans multiple periods
The difference doesn’t live in one month — it traces back through several, each one off by an amount that compounds. Chasing a multi-period discrepancy by hand is exactly the work a ProAdvisor does with the discrepancy report and the audit trail, and it rarely resolves with a single correction.
Months are unreconciled, or it never reconciled at all
The account hasn’t been reconciled in months — or was never reconciled since setup — so there’s no clean prior period to anchor to. That’s a cleanup: rebuilding the reconciliation from a known-good point forward, not fixing one month’s difference.
A prior period was force-balanced with a bogus adjustment
Someone made the difference go to zero with a made-up reconciliation adjustment instead of finding the cause. The real discrepancy is still in the file, now buried under the adjustment — the moment to have it traced and reversed before it distorts the financials further.
A Certified ProAdvisor traces the discrepancy and makes the books tie.
Forcing a reconciliation to zero is the easy — and wrong — way out. The work that actually restores trust in the numbers is tracing where the discrepancy came from: pulling the Reconciliation Discrepancy Report and Audit Log to find the reconciled transaction that was edited, deleted, or voided; confirming each beginning balance against the prior period’s ending balance; removing duplicate downloads without deleting real transactions; and, where a previous period was force-balanced with a bogus adjustment, identifying and reversing it so the period ties on its own. A Certified QuickBooks ProAdvisor with active Online and Desktop certifications does that against a written scope and re-runs reconciliation until each month ties to the statement again. 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 reconciliation fix
Independent
Certified ProAdvisor firm — not Intuit, not Intuit’s software support
What people ask about a reconciliation that won’t balance.
Is this Intuit’s official QuickBooks support?
Why won’t my QuickBooks reconciliation balance?
How do I find what changed a reconciliation in QuickBooks?
My beginning balance is wrong — how do I fix it?
Should I just enter an adjustment to make it balance?
Does this affect QuickBooks Online and QuickBooks Desktop?
When should I stop self-fixing and call a ProAdvisor?
Can you fix my Intuit account or reset my login so I can reconcile?
Discrepancy spans months, or a prior period was force-balanced?
Self-fix didn’t hold? Get the file reviewed.
If the difference won’t close, the discrepancy spans multiple periods, or a prior reconciliation was force-balanced with a bogus adjustment, the problem is in the books — not a single number. 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+ depending on how far behind. Independent ProAdvisor firm, written scope before any work begins.