Ressler Bookkeeping
← All articles 7 Steps to Fix QuickBooks Bank Reconciliation Errors how-to

7 Steps to Fix QuickBooks Bank Reconciliation Errors

NR Nancy Ressler Bookkeeper 11 min read

Last Updated: November 10, 2026

Quick Summary

Most QuickBooks bank reconciliation errors come from duplicate entries, voided checks, missing transactions, wrong dates, or unreconciled prior periods. Fix them by checking the beginning balance, running the discrepancy report, and correcting source transactions rather than deleting entries or forcing a match.

  • Back up the QuickBooks file before making any changes.
  • Confirm each month's beginning balance equals the prior month's ending balance.
  • Run the Reconciliation Discrepancy report before editing anything, and save a PDF copy.
  • Fix errors in the original transaction, not inside the reconciliation window.
  • Avoid plug entries; they hide the error and it returns in the next period.
Is your QuickBooks reconciliation stuck?Ressler Bookkeeping cleans up QuickBooks files and catch-up records for small businesses.
Request a Cleanup Review

Table of Contents

Why QuickBooks Reconciliation Errors Happen

Bank reconciliation errors in QuickBooks usually come from a small set of causes, and These are among the most common causes seen in QuickBooks cleanup work. A transaction gets entered twice, a check gets voided after it was matched, or a bank feed pulls in an item that was already entered by hand. Each one throws the cleared balance off by a little, and the error grows over months.

Most business owners don't notice until the numbers stop matching the bank statement. By then, several months of reconciliations may be built on a bad starting point.

Here are the errors that show up most often:

  • Duplicate entries from a bank feed plus a manual entry
  • Voided or deleted checks that were already marked as cleared
  • Missing transactions that never reached the register
  • Wrong dates that push an item into the wrong statement period
  • Unreconciled prior periods that carry errors forward

Watch out: Don't delete transactions to make a reconciliation balance. The difference will reappear, and you lose the audit trail you need at tax time.

What You Need Before You Start Fixing Errors

Gather everything before you open the reconciliation window, since a missing document is a common reason a fix takes longer than it should.

You will need:

  1. Bank statements for every month you're working on, in PDF form
  2. Access to the bank's online portal, so you can compare against live data
  3. The QuickBooks file, backed up before any changes
  4. The list of transactions you already know are wrong, if one exists
  5. The name of the person who made prior reconciliations, if someone else did them

Work from a backup copy. Many errors can be undone with a single step, but a copy protects you if a change goes further than you intended.

How to Fix the Beginning Balance in QuickBooks Reconciliation

The beginning balance is the most common source of a stubborn discrepancy. If the opening balance in QuickBooks doesn't match the prior statement's ending balance, every later month will fail to reconcile, no matter how carefully you work.

Start by comparing the beginning balance in QuickBooks against the ending balance on the previous bank statement. If they differ, the problem is in an earlier period.

Then follow these steps:

  1. Open the prior month's reconciliation report and check its ending balance.
  2. Confirm it matches the bank statement for that month.
  3. If it doesn't, reopen that month and find the transaction causing the gap.
  4. Correct the prior period before you return to the current one.

Expected result: Each month's beginning balance equals the previous month's ending balance, with no gap between them.

Using the QuickBooks Reconciliation Discrepancy Report

The discrepancy report shows which transactions changed in a way that breaks the match with the bank statement. Run it before you start editing, because guessing at causes wastes time and often creates new errors.

Small business owner checking bank statements while performing bank reconciliation on a laptop in a home office.
Small business owner checking bank statements while performing bank reconciliation on a laptop in a home office.

To open it in QuickBooks Desktop, go to Reports, then Accountant & Taxes, then Reconciliation Discrepancy, and select the account and period. In QuickBooks Online, the equivalent is found under Reports by searching for "reconciliation" and choosing the discrepancy or reconciliation report for that account.

Read the report in three passes:

  1. Check the date column first. Any cleared transaction dated after the statement's closing date is a candidate for a wrong-period error. Compare it with the bank line it was supposed to match.
  2. Check for paired amounts. Two entries with the same amount, same payee, and dates a few days apart are usually a duplicate, often from a bank feed plus a manual entry. Note both IDs.
  3. Check for cleared items with no bank match. These are the transactions most likely to have been voided, deleted, or edited after clearing. Open each one and confirm it still exists and still carries the amount you expect.

When you trace a flagged item, open the original transaction, not a copy from the reconciliation window. Edit the source record, then reconcile again. This keeps the cleared status consistent with the register.

Use this rule to decide the next step:

  • If the flagged item is a single clear error, such as a wrong date or a duplicate, correct the original record.
  • If the difference traces back to a prior period that was already closed, undo that reconciliation and redo it, rather than adjusting around it.
  • If the difference is small and you cannot find its cause after a full pass, record a single adjusting entry to a clearly named account and document why. Do not bury it in a general expense line.

Keep a short log of each change: the transaction, what was wrong, what you changed, and the date. If an accountant or auditor asks why the books moved, that log answers the question without reconstructing the work.

Watch out: Running the discrepancy report after you have already made several edits can hide the original cause, because the report reflects the current state of the file. Run it first and save a PDF copy before changing anything.

The discrepancy report points to the most common causes of a mismatch, so you can check each one before editing anything.

Check What to look for Action
Date column Cleared transaction dated after the statement's closing date Compare with the bank line and correct the date
Paired amounts Same amount and payee, dates a few days apart Likely duplicate; note both IDs and remove one
Cleared items with no bank match Transaction voided, deleted or edited after clearing Open it and confirm it still exists with the expected amount
Single clear error One wrong date or duplicate Correct the original record
Closed prior period Difference traces to an already reconciled period Undo the reconciliation and redo it
Small unexplained difference No cause found after a full pass Record one documented adjusting entry, never a plug

How to Fix Reconciliation Discrepancies in QuickBooks Online

QuickBooks Online handles reconciliation differently from the desktop product, so the steps differ slightly.

To fix a discrepancy in QuickBooks Online:

  1. Go to Accounting, then Reconcile, and select the account.
  2. Enter the statement date and ending balance exactly as the bank shows them.
  3. Match each bank line to a QuickBooks transaction. Mark only what you can verify.
  4. Look at the difference at the bottom. If it isn't zero, check for duplicates and wrong dates first.
  5. Fix the error in the original transaction, not in the reconciliation window.
  6. Finish the reconciliation only when the difference reads zero.

Editing a transaction inside the reconciliation window can leave the cleared status out of sync. Always fix the source record.

How to Fix Issues When Reconciling in QuickBooks Desktop

QuickBooks Desktop gives you direct control over reconciliation, which is useful and risky in equal measure. Most users hesitate at the same point: whether to undo a prior reconciliation or to correct the problem in the current period. The answer depends on where the error sits, so use the framework below instead of guessing.

Start in the Reconcile window. Mark items as cleared against the bank statement. If the difference does not reach zero, open Locate Discrepancies to see transactions that changed since the last reconciliation.

Then choose one of three paths.

Path 1: Fix in the current period. Use this when the error is in the transactions you are reconciling now, such as a missing entry, a duplicate in the current statement, or a wrong date that still falls inside the period. Edit or void the source transaction, then re-mark the items and check the difference again. No undo is needed.

Path 2: Undo the last reconciliation. Use this when a prior period was reconciled incorrectly and the error is now carried forward into the current period. Go to File, then Utilities, then Undo Last Reconciliation. This reopens the most recent reconciled period. Correct the error there, then reconcile that period again from the start. Undo only the most recent one. Undoing several periods at once makes the file harder to rebuild and widens the damage if something goes wrong.

Path 3: Record an adjusting entry. Use this only when the difference is small, you have confirmed no transaction is wrong, and you cannot find a cause after checking the discrepancy report. Post the adjustment to a clearly labeled account, and note the reason in the memo field. This is a last resort, because it leaves an unexplained balance in the books rather than fixing the source.

The mistake that causes the most trouble is using a plug entry to force a match. A plug makes the reconciliation show zero while the underlying error remains, and the difference returns in the next period, now harder to trace. If you feel the urge to plug, stop and go back to the discrepancy report.

Before undoing anything, back up the company file. Undo is reversible in the sense that you can reconcile again, but a backup gives you a clean point to return to if the rework goes wrong.

Watch out: Undoing a reconciliation clears the cleared status on every transaction in that period. Re-reconcile the full period against the bank statement, not just the item you changed, or the new difference will be harder to find.

Booking a Cleanup Review With Ressler Bookkeeping

If your reconciliations keep failing, the cause may go back several years. Ressler Bookkeeping has been in business since 2010 and specializes in QuickBooks cleanup and catch-up bookkeeping for small businesses in Prescott and Northern Arizona, with virtual options available for clients elsewhere. Review the full scope of bookkeeping services offered, including account reconciliation, before you book.

Get in contact to request more information about QuickBooks cleanup services.

Frequently Asked Questions

How do I fix a reconciliation error in QuickBooks?

Start by confirming the statement ending balance and date match your bank statement exactly. Next, compare cleared transactions against the statement line by line, looking for missing, duplicate or mis-dated entries. Once you find the difference, correct the transaction itself rather than forcing the reconciliation to balance. If the error sits in a prior period, the reconciliation discrepancy report will show where the gap began. Reopen that reconciliation only when the fix requires changing cleared items, and then re-reconcile from the affected statement forward.

Can I go back and fix a reconciliation in QuickBooks Online?

Yes. In QuickBooks Online you can open the account register, review previously reconciled transactions and edit or delete them, but edited cleared items will change the account's balance and may require you to reconcile the period again. Use the reconciliation report to identify the affected transactions before making changes. Keep a note of what you changed so the audit trail stays clear for you and your accountant.

What causes a beginning balance error in QuickBooks reconciliation?

Beginning balance errors usually come from a previous statement that was reconciled with a wrong ending balance, a transaction that was later deleted or moved to a different date, or an opening balance entered incorrectly when the account was set up. Compare the beginning balance QuickBooks shows with the prior statement's ending balance. If they differ, find the earliest reconciliation that does not match and correct the transactions in that period first.

Why won't my QuickBooks Desktop reconciliation balance?

Common causes include duplicate bank feed entries, checks or deposits recorded on the wrong date, voided checks still marked as cleared, and fees or interest that were never entered. Work through the statement in order, match each cleared item, and add any missing bank charges as journal entries. Once the difference equals zero, finish the reconciliation and save a copy of the report for your records.

GoogleAdd resslerbookkeeping.com as a preferred source on Google →