What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Fix Reconciliation Discrepancies in QuickBooks
QuickBooks Online

How to Fix Reconciliation Discrepancies in QuickBooks Online by Finding What Changed

Last month closed at $0.00. This month QuickBooks says the account isn't ready to reconcile, or the difference won't move no matter what you tick. Either way, something that already matched the bank has changed, gone missing or arrived twice. The message on your screen tells you which kind of hunt it is.

Where the fix starts

Beginning balance off? Open Reconcile, pick the account, and select We can help you fix it in the alert. That opens the reconciliation discrepancy report.

All apps Accounting Reconcile

This month's difference not zero? The cause sits inside this statement period: a duplicate, a missing bank fee, or a bank line matched to the wrong record.

Never reconciled this account before? Look at the opening balance first, against the bank statement for the day before you started using QuickBooks.

Read the message, then pick the fix

What you see What it usually means Where to go next
"Your account isn't ready to reconcile yet" A transaction in a month you already reconciled was edited, deleted, voided or unreconciled. The discrepancy report, in the steps below.
Difference equals one transaction exactly That transaction is duplicated, or missing from QuickBooks. Search the register for that amount around the statement dates.
Difference is double one transaction It was entered the wrong way round, a deposit recorded as a payment or the reverse. Delete it and enter it again as the right type, with the same date.
Difference divides evenly by 9 Often two digits swapped, $54 typed as $45. Compare amounts with the statement digit by digit.
Off since the first reconciliation The opening balance entry doesn't match the bank. Correct it as in changing a beginning balance.

Working through the reconciliation discrepancy report

The report lists reconciled transactions that changed since your last reconciliation, one row each.

  1. 1

    Write down the total before touching anything

    The banner at the top shows the Total discrepancy difference. Note it. When you've finished, the fixes you made should add up to that figure.

  2. 2

    Read what happened on each row

    Each row shows who changed the transaction, what they changed and when, its register status (R, C or blank), and its amount at the last reconciliation beside today's amount.

  3. 3

    Use Review in tray to put back what was wrong

    For an edited transaction, QuickBooks pre-fills the original version: check it and save. A deleted expense can be restored from the tray, and a voided transaction can have the void reversed. View History, in the dropdown beside Review in tray, shows every change.

    Watch for: changes someone made on purpose. Intuit calls the report's fixes suggestions. Ask whoever made the change before you undo it, and check with your accountant if it touches a closed period.

  4. 4

    Rebuild what the report can't restore

    Settings ⚙ Audit log

    Some deleted transactions only offer Go to register. Re-enter those with their original date and amount, and mark them R. Filter the Audit log to this account and the dates since your last reconciliation to catch deletes and voids the report missed.

  5. 5

    Back to this month once it reads zero

    Once the total reads $0.00, carry on with this month's reconciliation.

Duplicates, gaps and bad matches inside this statement

Beginning balance fine, difference still not zero: the problem is in this period.

One deposit, recorded twice

How you'll know: Two identical amounts on the same date, one typed in by hand and one added from the bank feed.

Fix: Keep the copy matched to the bank line. If the extra one is a bank deposit holding customer payments, deleting it sends them back to Payments to deposit. Deleting a deposit covers that.

A bank charge nobody entered

How you'll know: A monthly fee, interest or a returned-item charge on the statement, with nothing in QuickBooks to tick.

Fix: Add it with the statement's date. Recording bank charges shows the quickest way.

The feed matched a line to the wrong record

How you'll know: The amounts look right on screen, but an older transaction now carries a different date or amount.

Fix: Open it and check its audit history. Undo the match in Banking, then match the bank line to the record it really belongs to.

A connected app rewrote an old entry

How you'll know: The person listed against the change is an app's connection, not anyone on your team.

Fix: Put the original back, then look at how that app handles edits to past orders or payments in its settings.

Questions people ask

How do I undo a reconciliation in QuickBooks Online if I need to start over?

Intuit's help says the primary admin or an accountant can undo a whole reconciliation from History by account. Anyone else can unreconcile transactions one at a time in the register. Find the cause first, though, or the same gap comes straight back. The full steps are in undoing a reconciliation.

What if the discrepancy is exactly the amount of one transaction?

Good news: that's the quickest kind to fix. One transaction is missing, duplicated or entered at the wrong amount. Search the register for that exact figure a few days either side of the statement dates.

Can a bank feed error really cause a reconciliation discrepancy?

Yes. A feed can match a downloaded line to the wrong existing record, or bring the same transaction in twice after a connection drops. Nobody typed anything wrong, so check the feed's recent matches before blaming data entry.

How do I print a reconciliation report to double-check my work?

Go to Settings ⚙, then Reconcile, then History by account. Pick the account and select View report on the reconciliation you want, then print or save it as a PDF. Reconciliation reports explains what each section shows.

Should I let QuickBooks post an adjustment to close a small gap?

Generally only as a last resort, and after talking to your accountant. The adjustment makes the screen balance but leaves the real error in the books, usually in an expense account nobody looks at.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.