A QuickBooks balance mismatch after reconciliation can make your financial reports, bank balance, and reconciliation records appear inconsistent. You may notice that the QuickBooks balance does not match your bank statement, the beginning balance is different from the previous reconciliation, or the account's ending balance changes after reconciliation.
Reconciliation is designed to help verify that transactions recorded in QuickBooks agree with your bank or credit-card statement. When balances do not match, the cause is often a changed, deleted, duplicated, or incorrectly entered transaction.
This guide explains why a QuickBooks balance mismatch after reconciliation can occur and how to investigate it without accidentally creating additional accounting problems.
Why Does QuickBooks Balance Mismatch After Reconciliation?
Several issues can cause a discrepancy.
1. Reconciled Transactions Were Changed
Changing the date, amount, account, or reconciliation status of a previously reconciled transaction can affect the account balance.
Even a small change can cause the next reconciliation to show an unexpected difference.
2. A Reconciled Transaction Was Deleted
If a transaction that was included in a previous reconciliation is deleted, the reconciled balance may no longer agree with the historical bank statement.
3. Duplicate Transactions
Duplicate deposits, checks, expenses, or downloaded bank transactions can change the QuickBooks balance.
This is particularly common when transactions are imported or downloaded from a bank and then entered manually.
4. Incorrect Opening Balance
An incorrect opening balance can cause reconciliation differences even when the current transactions appear correct.
The opening balance should generally agree with the ending balance from the previous reconciliation.
5. Bank Statement and QuickBooks Dates Differ
A transaction can appear on a different statement period because of differences in transaction dates, posting dates, or bank processing times.
6. Missing Transactions
A transaction that appears on the bank statement but is missing from QuickBooks will affect the reconciliation.
Review deposits, withdrawals, fees, interest, transfers, and other activity for the statement period.
How to Fix QuickBooks Balance Mismatch After Reconciliation
Step 1: Compare the Previous Reconciliation
Start with the last successfully reconciled period.
Record the previous statement's ending balance and compare it with the beginning balance shown for the current reconciliation.
If these numbers do not agree, investigate the previous reconciliation before continuing.
Step 2: Review the Reconciliation Report
Run the appropriate reconciliation report for the affected account.
Look for transactions that were previously marked as reconciled but have since been modified, deleted, or added.
The report can help identify where the historical balance changed.
Step 3: Check for Changed Transactions
Review transactions included in previous reconciliations.
Pay particular attention to:

• Transaction amounts
• Dates
• Account assignments
• Deposits
• Checks
• Expenses
• Transfers
• Journal entries

If a reconciled transaction was changed after reconciliation, determine whether the change was intentional.
Step 4: Look for Deleted Transactions
Review the account's audit or transaction history to determine whether a previously reconciled transaction was deleted.
A deleted reconciled transaction can create a difference between the historical QuickBooks balance and the bank statement.
If the transaction was deleted accidentally, determine whether it should be restored or re-entered based on the accounting records.
Step 5: Search for Duplicate Transactions
Compare QuickBooks transactions with the bank statement.
Look for transactions that appear twice, especially when bank feeds are being used.
Do not delete a transaction merely because it appears similar to another transaction. Confirm the date, amount, payee, and account before making changes.
Step 6: Check the Beginning Balance
When starting a new reconciliation, compare the QuickBooks beginning balance with the previous statement's ending balance.
If the beginning balance is different, do not simply enter an adjustment to force the numbers to match.
First identify what changed.
Step 7: Review the Bank Statement
Compare every transaction on the bank statement with the corresponding QuickBooks entry.
Check:

• Deposits
• Checks
• Electronic payments
• Bank fees
• Interest
• Transfers
• Credit-card payments
• Returned transactions
• Adjustments

A missing or incorrectly entered transaction can cause the reconciliation difference.
Step 8: Check for an Incorrect Reconciliation
If a previous reconciliation was completed incorrectly, correcting the underlying transactions may not be enough.
You may need to undo or correct the affected reconciliation depending on your QuickBooks version and accounting workflow.
Before undoing a completed reconciliation, consider the effect on subsequent reconciliations and financial reports.
QuickBooks Beginning Balance Doesn't Match
A QuickBooks beginning balance that doesn't match the previous statement's ending balance often indicates that something changed after the previous reconciliation.
Possible causes include:

• Deleted reconciled transactions
• Edited transactions
• Changed transaction dates
• Incorrect opening balances
• Reconciliation adjustments
• Duplicate entries

Investigate the historical transactions before making a new adjustment.
QuickBooks Reconciliation Difference Is Not Zero
If the reconciliation difference is not zero, compare the difference amount with individual transactions.
For example, if the difference equals a specific transaction amount, that transaction may be missing, duplicated, or entered incorrectly.
If the difference is unusual or does not correspond to a transaction, review the opening balance and previously reconciled activity.
Do not add an unexplained adjustment simply to make the reconciliation reach zero.
QuickBooks Balance Changed After Reconciliation
If your balance changed after completing a reconciliation, review the account's transaction history and audit information.
Determine whether a reconciled transaction was edited, deleted, or added after the reconciliation.
Changes to reconciled transactions can affect future reconciliation results.
How to Prevent Reconciliation Differences
To reduce future balance mismatches:

• Reconcile accounts regularly.
• Compare QuickBooks transactions with bank statements.
• Avoid unnecessary edits to reconciled transactions.
• Review downloaded bank transactions before adding them.
• Watch for duplicate transactions.
• Maintain reliable company-file backups.
• Keep reconciliation reports for your accounting records.
• Investigate discrepancies before creating adjustments.

Frequently Asked Questions
Why does my QuickBooks balance not match after reconciliation?
The difference may be caused by edited or deleted reconciled transactions, duplicate entries, missing transactions, incorrect opening balances, or reconciliation adjustments.
Why did my QuickBooks beginning balance change?
A beginning balance can change when transactions from a previous reconciliation are edited, deleted, added, or otherwise changed.
Should I make an adjustment to fix a reconciliation difference?
Not automatically. First identify the cause of the difference. An unexplained adjustment can hide the underlying accounting problem and affect future reconciliations.
Can deleting a reconciled transaction cause a balance mismatch?
Yes. Deleting a transaction that was included in a previous reconciliation can change the historical balance and cause the next reconciliation to differ.
How do I find what changed after reconciliation?
Review reconciliation reports, transaction history, and audit information. Compare previously reconciled transactions with the original bank statements.
Conclusion
A QuickBooks balance mismatch after reconciliation usually means that something affecting the account changed between reconciliation periods. Common causes include edited or deleted reconciled transactions, duplicate entries, missing transactions, incorrect opening balances, and reconciliation adjustments.
Start by comparing the current beginning balance with the previous statement's ending balance. Then review reconciliation reports, transaction history, and bank statements to identify changes.
Avoid creating an unexplained adjustment simply to make the reconciliation difference disappear. Finding and correcting the underlying transaction is generally a more reliable approach to maintaining accurate accounting records.
Regular reconciliation, careful review of downloaded bank transactions, and reliable backups can help prevent future QuickBooks balance discrepancies.