QBSpecialist

QuickBooks not reconciling

QuickBooks not reconciling

Won't finish at zero? Here's the fix.

QuickBooks not reconciling means the reconciliation won't finish at a difference of zero — a beginning balance that no longer matches, a cleared transaction that was changed or deleted, or a missing statement month. One recent period is usually a do-it-yourself fix; months of compounding drift need a cleanup so your cash ties back to the bank.

Last reviewed October 2026 by a Certified QuickBooks ProAdvisor

What this page is based on: Intuit’s help on fixing a beginning balance without undoing a reconciliation (checked October 2026) and our reconciliation-first methodology

The do-it-yourself fix, step by step
  • Free, view-only review first
  • Every month re-reconciled
  • One specialist — never a rotating pool

First, what not to do. Do not force a reconciliation by entering an adjustment simply to make the difference zero. First compare the beginning balance, statement period and cleared transactions. Investigate changes to previously reconciled transactions before deciding whether a correction is needed.

What “QuickBooks not reconciling” actually means

QuickBooks not reconciling means the reconcile window won't close at a difference of zero: the transactions you've marked cleared don't add up to the statement's ending balance, and QuickBooks won't let you finish while that gap exists. The gap is the whole problem.

That is different from a bank feed that stopped importing or a report that looks wrong. Reconciliation is the deliberate month-end check that your recorded cash matches the bank line for line. When it won't complete, it's telling you that the recorded history and the statement have quietly diverged — and it's refusing to certify a month it can't prove. Left alone, that gap only compounds — what happens if you don't reconcile QuickBooks is the slow-motion version of the same story.

What causes a reconciliation discrepancy

Reconciliation discrepancy

How a changed cleared item breaks the beginning balance $12,480.00 Expected beginning LESS $350.00 Deleted cleared deposit = $12,130.00 Actual beginning CHANGED AFTER RECONCILING OUT BY $350.00 NOT RECONCILED
Read this as text

This month's expected beginning balance of $12,480.00, less a $350.00 cleared deposit deleted after last month was reconciled, leaves an actual beginning balance of $12,130.00 — so the account starts out by $350.00 and will not reconcile. A worked, illustrative example.

A changed or deleted cleared item silently moves the beginning balance, so the next month starts out of balance by that exact amount — here $350.00 — and will not reconcile until the item is restored. Figures are illustrative.

A reconciliation discrepancy is almost always one of a short list: a beginning balance that no longer matches last period's reconciled ending; a previously cleared transaction that was later edited, voided or deleted; a wrong opening balance entered when the account was first set up; transactions missing, doubled or mis-keyed; a statement ending balance or statement date typed wrong; items ticked as cleared that are not on the statement; or a statement month that was skipped entirely.

The beginning balance is the quiet one. QuickBooks calculates it from every transaction you've ever cleared, so editing, voiding, or deleting a transaction inside a month you already closed silently shifts it — and the next reconciliation starts out of balance by exactly that amount. Skipped months compound the same way: reconcile January and March but not February, and March inherits February's unresolved difference. Missing or misread statement figures do the rest. If you want to re-run a month in the right order yourself, our step-by-step bank reconciliation checklist walks the phases from gathering statements to resolving the difference to zero.

The evidence sequence: what to check, in order

Every discrepancy is found the same way, cheapest check first, and nothing is changed until the evidence says what to change:

  1. The statement as keyed. Compare the ending balance and the statement date entered in QuickBooks with the statement itself — a swapped digit or the wrong month is the cheapest fix there is. A difference divisible by 9 ($297 = 9 × 33) points to swapped digits.
  2. The beginning balance. Compare it with the previous period's reconciled ending balance. If the two differ, check for an incorrect opening balance, edited or deleted reconciled transactions, manual changes to reconciliation status, and other transactions affecting earlier periods. Use the discrepancy report and audit history to identify the cause before changing an entry.
  3. What changed since the last reconciliation. In Desktop, the Reconciliation Discrepancy report lists edits, deletions and voids to cleared transactions. In QuickBooks Online, open Reconcile for the account and select 'We can help you fix it' in the beginning-balance alert: the Reconcile Discrepancy report lists each change, and the audit log shows deleted or voided transactions (Intuit, updated 9/1/2026). Viewing and editing reconciliations needs admin access.
  4. Cleared versus the statement. Untick anything marked cleared that is not on this statement, and find every statement line that is not in the books.
  5. Duplicates and gaps. Look for pairs the bank feed added twice and for days the feed skipped, against the statement line by line.
  6. Only then, a correction. Restore the changed transaction, enter the missing one, or remove the duplicate — each with its evidence. An adjustment is the last resort, with its reason written down, never a plug to reach zero.

Reconciliation exception log — sample

SPECIMEN· Sample Company LLC · operating checking · statement ending 03/31/2026

Sample exception log: each finding in the order checked, its effect on the difference, and the difference left (difference = statement ending balance minus cleared balance)
Step and findingEffectDifference left
Difference when the reconciliation was opened−$1,154.17
1 · Ending balance keyed with two digits swapped ($297 = 9 × 33)+$297.00−$857.17
2 · Beginning balance off: a February deposit edited up by $612 after it was reconciled+$612.00−$245.17
3 · A customer payment marked cleared but not on this statement+$118.40−$126.77
4 · A bank fee on the statement, missing from the books+$126.77$0.00
  1. E1Evidence: the bank statement's ending balance against the figure keyed in QuickBooks. The keyed figure was corrected.
  2. E2Evidence: the Reconcile Discrepancy report and the audit log. The edited February deposit was restored to its reconciled amount; no adjustment was entered.
  3. E3Evidence: the statement's deposit lines. The payment was unticked; it clears on the April statement.
  4. E4Evidence: the fee line on the statement. The fee was entered from the statement, dated the day the bank charged it.
Illustrative example — not a client file. Every figure is a specimen value. Difference = statement ending balance minus cleared balance, in the order the QuickBooks reconcile screen shows them; each correction moves it toward zero, and it reaches zero by arithmetic, not by an adjustment.

The workpaper behind a log like this is on our reconciliation workpaper template page, and as a spreadsheet you can download (CSV) with the exception log underneath.

When it's actually a bookkeeping problem we fix

A reconciliation discrepancy becomes our kind of problem when it has compounded across months — beginning balances drifting period after period, cleared transactions edited inside closed months — so no single re-entry can pull it straight. At that point it's a reconciliation cleanup, not a quick correction.

The tell is direction. A single outstanding check that hasn't cleared yet is a timing difference, and it resolves itself next month; you don't touch it. A cleared transaction that was changed after the fact is a discrepancy, and it will sit there until someone finds and fixes it. When months of those pile up, the right move is a structured cleanup that re-ties each period to its statement — the same work behind our bank reconciliation service.

Timing difference vs. discrepancy

Timing difference versus a true discrepancy TIMING DIFFERENCE · NORMAL −$420.00 Outstanding check RESOLVES TO 0.00 Wait for it to clear DISCREPANCY · BROKEN OUT $350.00 Cleared item changed WON'T CLEAR ON ITS OWN Trace it and correct it
Read this as text

On the left, an outstanding check of $420.00 is a normal timing difference that resolves to $0.00 when it clears. On the right, a cleared deposit changed after reconciling leaves the account out by $350.00 and will not clear on its own. A comparison of the two, illustrative.

A timing difference resolves itself when the item clears; a discrepancy is a changed record that will sit unresolved until it's traced and corrected. Telling them apart is the first move. Figures are illustrative.

How we fix a file that won't reconcile

We work backward from the last period that reconciled cleanly. Using the Reconciliation Discrepancy report, we find every cleared transaction changed or deleted since then, restore the correct beginning balance, and re-tie each month to its statement until the difference is zero again.

The free review runs on view-only access; if you hire us, the work uses QuickBooks' accountant access to make and log every correction — never your bank logins — and every change is visible to you in the audit log. We don't reach for the “enter an adjustment” button, because that plug just relabels the problem as an opening-balance discrepancy. Each corrected month is re-reconciled and handed back with a written summary you could give a tax preparer without a caveat.

What reconciliation cleanup costs

Reconciliation cleanup is quoted as a fixed scope after a free, view-only review — never by the hour, and never before we've actually seen the file. What drives the number is how many periods have drifted and how many accounts are involved, not the calendar.

A single account off by one recent month is small. Several accounts drifting across a year, with cleared transactions edited along the way, is a larger scope — and we tell you which one you're looking at, in writing, before any work starts. No number is invented before the review, because the file decides it.

How we're different

One specialist does your reconciliation from start to finish — never a rotating pool passing your file around — and every corrected month is re-reconciled to the statement, then handed back with a written month-by-month summary.

We also draw the line honestly. If your problem is one recent period you could fix in an afternoon, we'll tell you that and point you at the steps rather than quote you a cleanup. The work we take on is the work that genuinely needs a specialist: compounded drift, changed cleared history, and reconciliations that have to be rebuilt without throwing away the months that are already right.

Which do you need?

Do it yourself, or bring in a specialist?

One recent period that won't reconcile is usually a do-it-yourself fix. Months of compounding drift — or cleared transactions changed in closed periods — is where a specialist keeps you from making it worse.

When a reconciliation problem is a do-it-yourself fix vs. a specialist cleanup
Do it yourselfSpecialist cleanup
Best whenOne recent period is offMonths of drift compounding
Re-check the keyed ending balance and date
Re-enter the correct beginning balance
Trace changed or deleted cleared itemsIt depends
Bisect with the Discrepancy reportIt depends
Re-tie every prior period to its statement
Planned effortAn afternoonDays, fixed scope
VerdictRecent and isolatedCompounded and tangled

Honest answer

Who this affects

Not every reconciliation that won't zero out needs a specialist. If your books reconciled cleanly through last month and a single account is off this month by an amount you can point to, you can very likely fix it yourself — and you should.

The businesses that do need help are the ones where the drift has been running quietly for a while: several accounts, several months, and a beginning balance nobody trusts anymore because transactions were edited in periods that were supposedly closed. If you open the reconcile window and can't say when it last balanced, that's the signal you're past a quick fix — the history has to be reconstructed in order, not patched at the end.

Do-it-yourself

The do-it-yourself fix, step by step

For a single recent period, work through these in order — most people can do it in an afternoon, and the first three steps solve more cases than everything after them.

  1. Check what you typed. On the reconcile screen, open Edit info and compare the statement ending date and ending balance with the statement itself, digit by digit. A transposed number or the wrong month is the most common cause there is.
  2. Untick what isn't on the statement. Every item marked cleared must appear on this statement. Untick anything that doesn't, and add anything the statement shows that QuickBooks is missing — a bank fee, an interest credit, a transfer.
  3. Compare the beginning balance with last statement's ending balance. If they differ, the current month is not the problem: something reconciled earlier has changed, and the gap equals that change.
  4. Find what changed. In QuickBooks Desktop, run Reports → Banking → Reconciliation Discrepancy for the account: it lists every cleared transaction changed or deleted since the last reconcile, with the date. In QuickBooks Online, open Reconcile for the account and select ‘We can help you fix it’ in the beginning-balance alert: the Reconcile Discrepancy report lists each change, and Reconcile → History by account holds the report for each past period to compare against. Restore or re-enter each changed item exactly as it originally cleared.
  5. Only then consider undoing. Intuit's own help says an incorrect beginning balance can be fixed without deleting the reconciliation (Intuit: avoid undoing a reconciliation, checked October 2026). In Desktop, Banking → Reconcile → Undo Last Reconciliation reverses one period at a time. In Online, Close without saving (under the Save for later drop-down) discards a session started against the wrong statement; a completed reconciliation can be undone from History by account by the primary admin or an accountant user (per Intuit), which removes all the completed work for that period; otherwise you unreconcile transactions one by one in the register, earliest month first.
  6. If the QuickBooks Online reconcile screen won't open, it is usually the browser, not the books: try a private window, clear the cache or use another browser, and sign out and back in before assuming the file is damaged.

Finally, re-run the affected month against its statement and confirm the difference lands at zero without an adjustment. If it won't — or the changes stretch back across several months — stop before you start deleting things, because unwinding reconciled history by hand is exactly what a cleanup is for, and where the reconciliation reference shows the method in full.

Straight talk

When not to hire us

Don't hire us if last month reconciled and you simply haven't done this month yet — that's your normal month-end, not a cleanup. Don't hire us if your bank feed just stopped importing; that's a reconnection, and it doesn't stop you reconciling from the statement.

And don't hire us to reconcile a single, obvious, recent difference you can already see — a missed deposit, one duplicated payment, a fat-fingered ending balance. Those are minutes of your own time. We're worth it when the difference has a history: many months, many accounts, or a beginning balance that's been drifting since a period you thought was closed. If you're not sure which you've got, the free review tells you — and if it's the small kind, we'll say so.

How each corrected month is documented

  • Who’s responsible for your file

    A Certified QuickBooks ProAdvisor handles your file from the review through the corrections to the hand-back — the same person throughout, never a rotating pool.

    About QBSpecialist
  • Sample reconciliation summary — an illustrative month-by-month summary for Sample Company LLC showing three accounts reconciled for each month once the discrepancies are cleared. Marked SPECIMEN, not a real client document. Business checking, Business savings, Credit card: each ticked for all 12 months. Result: Discrepancies cleared, out by 0.00.Illustrative example — not a client file.

    Sample reconciliation summary

    The corrected register and month-by-month reconciliation report you receive once the discrepancies are cleared.

  • How we work

    Every corrected month re-tied to the statement, difference back to zero. Read the method.

    Read the reconciliation reference
  • Response commitment

    A written reply within one business day.

Remote-first, nationwide

Mon–Sat · 8am–6pm CT

We work entirely remote — view-only access for the free review, QuickBooks' accountant access for the reconciliation work itself, every change visible to you in the audit log, and every corrected month documented in writing.

Questions about reconciliation problems

Why won't QuickBooks let me finish reconciling?

Because the difference at the bottom of the reconcile window isn't zero. QuickBooks won't close a reconciliation while the cleared balance and the statement ending balance disagree, so somewhere there's a transaction that's missing, doubled, or changed since you last reconciled.

What is a reconciliation discrepancy?

It's the gap between what your books say cleared and what the statement says cleared. Unlike a timing difference — a check that simply hasn't cleared yet — a discrepancy won't resolve on its own, because a previously reconciled transaction was edited, deleted, or voided.

My beginning balance is wrong — how did that happen?

The beginning balance is calculated from every transaction you've ever cleared. When someone edits, deletes, or voids a transaction from a month you already reconciled, that calculation shifts, and the next reconciliation starts already out of balance by the amount of the change.

Can I just force it to reconcile with an adjustment?

You can, and QuickBooks offers to post one — but it only hides the problem. The adjustment lands in an opening-balance or reconciliation-discrepancy account and quietly misstates your books. We'd rather find the real cause, which is usually faster than living with the plug.

What is the Reconciliation Discrepancy report?

It's a built-in report that lists every transaction changed or deleted since an account was reconciled, with the date it was altered. It's the first place we look, because it points straight at what broke the beginning balance instead of making you hunt for it.

Is this the same as my bank feed not working?

No. A bank feed imports transactions; reconciliation proves your books match the statement line by line. A feed can import perfectly and still leave you unreconciled, and a broken feed doesn't stop you reconciling from the statement itself. They're separate problems with separate fixes.

How far back do you have to go?

Only as far as the last month that reconciled cleanly. We find that point first, then work forward. If it reconciled through March and drifted after, we start at April — we don't redo work that's already right, and we tell you the starting point after a free review.

Will fixing this change my tax numbers?

It can, and that's the point — a file that won't reconcile is a file whose income and expenses aren't trustworthy yet. Correcting the discrepancies ties your cash back to the bank, so the numbers you hand a preparer are ones the statement actually supports.

The cleared balance matches my statement, but QuickBooks still shows a difference. Why?

Because the beginning balance moved. The difference QuickBooks shows is measured from the beginning balance, which is built from everything you cleared before. If a transaction in an earlier reconciled month was edited, deleted or voided, the beginning balance shifts by that amount and this month cannot reach zero, however carefully you tick it. Find the changed transaction first; the current month is usually fine.

How do I undo a reconciliation in QuickBooks Online?

Usually you don't need to. Intuit's own help says a beginning balance that doesn't match the statement can be fixed without deleting the reconciliation. If you reconciled the current session against the wrong statement, choose Close without saving from the Save for later drop-down. Per Intuit, the primary admin or an accountant user can undo a completed reconciliation from History by account, which removes all the completed work for that period; otherwise you unreconcile transactions one at a time in the register, working from the earliest month forward.

Do you undo my previous reconciliations?

Almost never. Un-reconciling is a last resort because it throws away good work. We correct the specific transactions that broke, restore the right beginning balance, and re-verify — leaving every already-clean period untouched wherever we possibly can.

Not sure how bad it is?

Talk to a QuickBooks specialist.

Describe the file and a specialist will tell you which of these you are dealing with — including when the answer is that you don't need us.

Or start with a free, view-only review