QuickBooks Reconciliation Discrepancy? Find the Difference (2026)

If you're in the middle of reconciliation and the numbers don't match, you're dealing with a discrepancy.

Your ending balance is off. You've checked transactions. Something still doesn't add up.

This is different from a starting balance issue. If reconciliation can't even start, see if reconciliation can't even start because beginning balance is wrong.

Here, the problem is inside the period you're reconciling — and the goal is to find the exact difference and fix it without guessing.

First — Run the Reconciliation Discrepancy Report

Before changing anything, run the discrepancy report.

QuickBooks Online:

Banking → Reconcile → History → View Discrepancy Report

QuickBooks Desktop:

Reports → Banking → Reconciliation Discrepancy

This report shows transactions that were changed after reconciliation.

Look for:

• Deleted transactions
• Modified amounts
• Changed dates
• Edited reconciliation status

Each of these will create a difference between your QuickBooks balance and your bank balance.

The report gives you a direct starting point — instead of manually scanning hundreds of transactions.

5 Common Causes of Reconciliation Discrepancy

1. Deleted reconciled transactions

This is the most common cause.

If a previously reconciled transaction is deleted, QuickBooks removes it from the balance — but your bank still includes it.

Result: your reconciliation difference equals the deleted amount.

Fix: recreate the transaction or restore it from history, then re-reconcile the period.

2. Modified amounts on reconciled transactions

If someone edits the amount of a reconciled transaction, the difference carries forward.

Even small changes create discrepancies.

Fix: compare the edited transaction to your bank record and revert it to the original value.

3. Date changes on reconciled transactions

Changing the date moves a transaction into a different reconciliation period.

That breaks the original reconciliation and creates a mismatch.

Fix: restore the correct transaction date so it falls back into the original reconciliation window.

4. Missing transactions never imported

If your bank has transactions that QuickBooks doesn't, your ending balance won't match.

This often happens when imports are incomplete or certain periods were skipped.

Fix: identify the missing period and restore the data. If you're missing larger gaps, see historical data gaps causing discrepancy.

5. Manual adjustments or journal entries

Reconciliation adjustments or manual entries can create rolling discrepancies.

They may have been used to “force balance” in a previous period.

Fix: review past adjustments. If they don't match actual bank activity, they should be corrected or reversed.

How to Fix Reconciliation Discrepancies (Per Scenario)

Start with the discrepancy report and fix issues one by one.

• Deleted transactions: recreate them using original bank data, then re-reconcile.
• Modified amounts: restore the correct values based on your bank statement.
• Date changes: move transactions back into the correct period.
• Missing transactions: import the missing entries so balances align.
• Manual adjustments: remove unnecessary adjustments and reconcile properly.

QuickBooks includes a Reconciliation Adjustment feature. This should only be used as a last resort.

It forces the numbers to match but doesn't fix the underlying issue. Over time, this leads to compounding discrepancies across periods.

The correct approach is always to restore accurate transaction data.

When the Fix Requires Importing Missing Data

If the discrepancy comes from missing transactions, manual fixes won't work.

You need to restore the missing data.

Step 1: Identify the discrepancy window

Find the date range where balances start to diverge.

Step 2: Download bank statements

Pull PDFs covering that period from your bank.

Step 3: Convert PDF to QBO

Run the statements through a structured Excel converter with IRS categories to get QuickBooks-compatible output.

Step 4: Import into QuickBooks

Upload using Web Connect import.

Step 5: Reconcile again

With complete data, the discrepancy should resolve.

This is the fastest way to fix discrepancies caused by incomplete transaction history.

If you need a direct workflow, see how to recover missing transactions to fix discrepancy or import bank statements into QuickBooks for a clean reimport.

FAQ