TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.
ERROR · RECONCILIATIONQuickBooks help
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.
§ TL;DR
“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.
§ 01 · What breaks a reconciliation
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.
§ 02 · The self-fix
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.
- 1
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.
- 2
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.
- 3
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.
- 4
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.
- 5
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.
- 6
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.
§ 03 · When to call
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.§ 04 · Software, or the books?
When a reconciliation is no longer a software problem.
A single period that will not balance is often one edited transaction. When the difference runs across periods, or a period was forced to zero, it is the books that need work, not the reconcile screen.
- The beginning balance no longer matches last period’s ending balance.
- A reconciliation adjustment was posted to make the difference disappear.
- Several months in a row are unreconciled.
Start with the free QuickBooks file review — a limited review that identifies likely issues and the information needed for a written scope, with the findings in plain English. If the findings show that the books themselves need work, that is QuickBooks cleanup, quoted as a fixed fee against a written scope before any work starts.
Discrepancy spans months, or a prior period was force-balanced?A QuickBooks ProAdvisor reviews the file free, then traces the discrepancy and reverses any bogus adjustment until each month ties again — a focused diagnostic is a fixed-fee scope from $450; bookkeeping cleanup runs $1,200–$15,000+ if the books are behind.
Get the free file review
§ 05 · Who fixes it
A QuickBooks 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 QuickBooks ProAdvisor holding the Intuit QuickBooks Certification Level 2 does that against a written scope and re-runs reconciliation until each month ties to the statement again.
Freefile review first — we look before we scope
From $450fixed-fee diagnostic for a focused reconciliation fix
§ 08 · Questions
What people ask about a reconciliation that won’t balance.
Why won’t my QuickBooks reconciliation balance?
Most often a transaction you already reconciled was later edited, deleted, or voided. Other common causes: duplicate transactions from the bank feed; a wrong beginning or opening balance; transactions dated outside the statement period or posted to the wrong account; uncleared stragglers from a prior period; or a manual adjustment that once force-balanced the books and is now masking the real discrepancy.
How do I find what changed a reconciliation in QuickBooks?
Run the Reconciliation Discrepancy Report, which lists transactions that were changed after they were reconciled, and the Audit Log, which shows who edited, deleted, or voided what and when. Between them you can usually pinpoint the reconciled transaction that moved and restore or correct it so the period ties again.
My beginning balance is wrong — how do I fix it?
Compare the beginning balance QuickBooks shows for this reconciliation against the ending balance from the period before it. If they differ, the problem started earlier — often a mistyped opening balance at setup or a change to a prior period — and that earlier period has to be corrected before the current month can balance. A persistent mismatch across periods is a sign to have the file reviewed.
Should I just enter an adjustment to make it balance?
Almost never. Forcing the difference to zero with a manual reconciliation adjustment hides the real discrepancy instead of fixing it — and it resurfaces later, now buried under the adjustment. Trace the cause first with the discrepancy report and the audit log. If a prior period was already force-balanced this way, the adjustment needs to be found and reversed, which is ProAdvisor cleanup work.
Does this affect QuickBooks Online and QuickBooks Desktop?
Both. Reconciliation exists in QuickBooks Online and QuickBooks Desktop, and the same causes apply — an edited or deleted reconciled transaction, a wrong beginning balance, duplicates, or a wrong date range. The reports differ slightly (Desktop and Online surface the discrepancy and audit information in their own ways) but the logic and the order of likelihood are the same.
When should I stop self-fixing and call 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. We start with a free file review, then a focused diagnostic is a fixed-fee scope from $450, or a bookkeeping cleanup ($1,200–$15,000+) if the books are behind.
Can you fix my Intuit account or reset my login so I can reconcile?
No — that’s an Intuit account matter, and an independent firm can’t access it. For an Intuit login, password, subscription, or billing question, contact Intuit directly. We work inside your own QuickBooks file: tracing the discrepancy, correcting the changed transactions, reversing any bogus adjustment, and getting each period to reconcile to the statement.
TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.Call (877) 751-5575Book a discovery call
Discrepancy spans months, or a prior period was force-balanced?