Undo A Bank Reconciliation In QuickBooks: Complete Guide to Correcting Reconciled Transactions
Bank reconciliation is an important part of maintaining accurate accounting records in QuickBooks. It allows businesses to compare transactions recorded in their QuickBooks account with activity shown on a bank or credit card statement. When the reconciliation is completed correctly, the account should agree with the financial institution’s statement.
However, mistakes can happen. You may reconcile the wrong account, enter an incorrect statement date, clear the wrong transactions, or discover that a transaction from a previous reconciliation was recorded incorrectly. In these situations, you may need to undo a bank reconciliation in QuickBooks.
Undoing a reconciliation should be approached carefully because reconciliation status is part of your accounting history. Removing or changing reconciled transactions without understanding the consequences can affect subsequent reconciliations and potentially create differences in account balances.
This guide explains how to undo a bank reconciliation in QuickBooks, when you may need to do it, what happens afterward, and how to troubleshoot common reconciliation problems.
What Does It Mean to Undo a Bank Reconciliation?
When a transaction is reconciled, QuickBooks records that it was compared with the corresponding bank or credit card statement.
Undoing a reconciliation removes that reconciliation status from the affected transactions.
This does not necessarily mean that the underlying transactions are deleted. Instead, the reconciliation information is changed so that the transactions can be reviewed and reconciled again.
The exact process can vary depending on whether you are using QuickBooks Online or QuickBooks Desktop.
QuickBooks Online and QuickBooks Desktop have different reconciliation tools and workflows, so it is important to identify the version you are using before making changes.
Why Would You Need to Undo a Reconciliation?
There are several legitimate reasons to undo a bank reconciliation.
You Reconciled the Wrong Account
If you accidentally selected the wrong bank account, the reconciliation may need to be corrected.
For example, a business may have separate operating and payroll accounts. Selecting the wrong account can result in transactions being marked as reconciled incorrectly.
The Statement Ending Date Was Incorrect
The statement date is an important part of the reconciliation.
If you entered the wrong date, QuickBooks may have included transactions that belong to another statement period.
Correcting the reconciliation can help restore the proper accounting timeline.
The Ending Balance Was Entered Incorrectly
Entering an incorrect bank statement ending balance can cause the reconciliation to be completed using inaccurate information.
The reconciliation may appear complete, but the underlying comparison is incorrect.
Incorrect Transactions Were Cleared
You may have accidentally marked transactions as cleared even though they were not present on the bank statement.
This can happen when several transactions have similar dates or amounts.
A Previously Reconciled Transaction Was Changed
A transaction from an earlier reconciliation may have been modified.
Changes to the amount, date, account, or transaction status can affect later reconciliation periods.
A Reconciliation Was Completed Prematurely
Sometimes a reconciliation is completed before all transactions have been properly reviewed.
If the reconciliation was based on incomplete information, undoing it may be the cleanest way to review the period again.
QuickBooks Online vs QuickBooks Desktop Reconciliation
Before undoing a reconciliation, determine whether you are using QuickBooks Online or QuickBooks Desktop.
The process is different.
QuickBooks Online
QuickBooks Online generally allows users with the appropriate permissions to undo reconciliations through the reconciliation history.
Depending on the account and user access, the process may involve reviewing the reconciliation history and undoing the appropriate reconciliation.
QuickBooks Desktop
QuickBooks Desktop provides reconciliation features within the Banking or Accountant-related workflows, depending on the product version.
In some versions, an accountant user can undo an entire reconciliation or work with individual transaction reconciliation statuses.
Because QuickBooks Desktop versions can differ, the exact options may depend on the edition and version being used.
How to Undo a Bank Reconciliation in QuickBooks Online
If you are using QuickBooks Online, begin by reviewing the reconciliation history for the account.
Step 1: Identify the Account
Determine which bank or credit card account contains the reconciliation you want to reverse.
If your company has several accounts, verify the account name carefully.
Step 2: Open the Reconciliation History
Go to the accounting section and locate the reconciliation history or reconciliation reports.
Review the list of completed reconciliations.
You should see information such as:
- Account
- Statement date
- Beginning balance
- Ending balance
- Reconciliation status
- Reconciliation report
Step 3: Locate the Incorrect Reconciliation
Find the reconciliation that contains the problem.
Do not immediately undo the most recent reconciliation simply because it is the easiest one to identify.
Determine exactly which reconciliation contains the error.
Step 4: Review the Reconciliation
Before undoing it, review the reconciliation report.
Look for:
- Incorrect cleared transactions
- Incorrect ending balance
- Incorrect statement date
- Missing transactions
- Duplicate transactions
- Unexpected adjustments
This review can help determine whether undoing the entire reconciliation is actually necessary.
Step 5: Undo the Reconciliation
If the reconciliation needs to be reversed, use the available undo option in the reconciliation history.
Depending on your QuickBooks Online version and permissions, the exact label or location may vary.
After undoing the reconciliation, review the account again.
Step 6: Reconcile the Account Again
Once the incorrect reconciliation has been undone, compare the QuickBooks transactions against the correct bank statement.
Enter the correct:
- Beginning balance
- Ending balance
- Statement date
Then carefully clear the appropriate transactions.
The goal is to reach a difference of zero using accurate statement information.
Can You Undo Only One Transaction From a Reconciliation?
This depends on the QuickBooks product and the type of correction you need.
In some situations, you may not need to undo the entire reconciliation. If one transaction has an incorrect reconciliation status, correcting that transaction may be sufficient.
However, changing an individual reconciled transaction can affect the reconciliation history.
Before making changes, determine whether the transaction is actually responsible for the discrepancy.
Avoid undoing or deleting multiple transactions simply to make the account balance appear correct.
What Happens After You Undo a Reconciliation?
Undoing a reconciliation can affect the reconciliation status of transactions.
Transactions that were previously reconciled may become unreconciled or require review again.
This can affect:
- Current reconciliation
- Future reconciliation
- Reconciliation reports
- Account balances
- Historical bookkeeping records
If you have already completed several reconciliations after the one you want to undo, additional work may be required.
For this reason, it is important to understand the sequence of reconciliations before making changes.
Should You Undo the Most Recent Reconciliation?
Not necessarily.
If you discover an error in an older reconciliation, undoing only the latest reconciliation may not solve the underlying problem.
Suppose you reconciled January, February, March, and April.
In May, you discover that a January transaction was entered incorrectly.
Changing January may affect February, March, April, and May.
You should therefore understand the impact on later periods before making changes.
How to Find Which Reconciliation Is Wrong
Start with the last reconciliation that you know was correct.
Then work forward.
Review each reconciliation period and compare:
- Beginning balance
- Ending balance
- Cleared transactions
- Unreconciled transactions
- Adjustments
- Transaction changes
This approach can help identify where the discrepancy first appeared.
Common Reasons a Reconciliation Becomes Incorrect
Deleted Reconciled Transaction
A transaction that was included in a previous reconciliation may have been deleted.
This can cause the beginning balance of a later reconciliation to change.
Changed Transaction Amount
If a reconciled transaction originally had an amount of $1,000 and was later changed to $900, the reconciliation may no longer agree with the original bank statement.
Changed Transaction Date
Moving a transaction from one statement period to another can affect which reconciliation should contain it.
Duplicate Transaction
Two transactions may represent the same bank activity.
One may have been reconciled while the other remains unreconciled.
Missing Transaction
The bank statement may contain a transaction that was never recorded in QuickBooks.
Incorrect Opening Balance
The beginning balance may have been changed or affected by historical activity.
Incorrect Reconciliation Adjustment
An adjustment may have been entered to force a reconciliation to zero without identifying the original problem.
How to Correct a Reconciliation Difference
After undoing a reconciliation, avoid immediately making an adjustment.
Instead, compare the records carefully.
Review the Bank Statement
Use the actual bank statement for the period.
Compare every relevant transaction.
Check the Transaction Amounts
Look for differences between the bank statement and QuickBooks.
Even a small difference can prevent reconciliation.
Search for Duplicates
Compare transaction dates, amounts, descriptions, and payees.
Review Transfers
Transfers between accounts can create confusion because the same movement of money appears in multiple accounts.
Check Bank Fees
Bank charges may not have been entered into QuickBooks.
Review Interest
Interest income can also cause a small difference if it has not been recorded.
Why You Should Not Force the Difference to Zero
A reconciliation difference of zero is important, but reaching zero by creating an unexplained adjustment does not necessarily mean the books are correct.
For example, suppose the actual discrepancy is caused by a missing $500 transaction.
Creating a $500 adjustment makes the reconciliation appear complete, but the underlying records remain incorrect.
The better approach is to find the source of the difference.
How Undoing Reconciliation Can Affect Financial Reports
Reconciliation primarily concerns whether transactions have been matched with bank activity, but changes to transactions can affect financial reports.
For example, changing a transaction’s date or account can affect:
- Profit and loss reports
- Balance sheet
- Cash balances
- Expense totals
- Income totals
- Accounts payable
- Accounts receivable
Therefore, reconciliation corrections should be made carefully, especially when dealing with prior accounting periods.
What If You Cannot Undo the Reconciliation?
If the undo option is unavailable, check your QuickBooks user permissions.
Some accounting functions require specific access.
You may also be working with a QuickBooks version or account configuration where the available reconciliation controls differ.
Before changing transactions manually, determine why the option is unavailable.
If you cannot identify the problem, consider consulting an accounting professional rather than making multiple historical changes.
Undoing a Reconciliation After Several Months
This is one of the situations that requires the most caution.
Imagine that a business reconciled:
- January
- February
- March
- April
- May
Then it discovers a January error in June.
Undoing January can potentially affect subsequent reconciliations.
You should review the reconciliation history from January forward and determine how later periods depend on the earlier balances.
In complicated cases, it may be more efficient to work with a qualified accounting professional who can review the historical reconciliation sequence.
If you need help reviewing a reconciliation that has already affected several accounting periods, 866-798-4134 can be used to request professional assistance.
How to Prevent Future Reconciliation Errors
Once your account is corrected, establish a consistent reconciliation routine.
Use the Correct Bank Statement
Always reconcile against the official statement for the correct period.
Verify the Account
Double-check the account before starting.
Review Before Completing
Do not rush through the transaction-clearing process.
Avoid Unnecessary Historical Changes
Once a period has been reconciled, avoid changing old transactions unless there is a legitimate reason.
Keep Reconciliation Reports
Retain reconciliation records according to your company’s accounting procedures.
Review Bank Feeds
Bank-feed transactions should be reviewed for duplicates and incorrect categorization.
Reconcile Regularly
Monthly reconciliation makes it easier to identify discrepancies while the transactions are still easy to trace.
QuickBooks Reconciliation Best Practices
A reliable reconciliation workflow can help reduce errors.
Use this approach:
- Obtain the bank statement.
- Confirm the correct QuickBooks account.
- Verify the statement period.
- Enter the correct ending balance.
- Compare transactions.
- Mark only transactions appearing on the statement.
- Investigate differences.
- Avoid unexplained adjustments.
- Complete the reconciliation only when the records agree.
- Save or retain the reconciliation report.
When Should You Ask for Professional Help?
Professional help can be useful when the reconciliation issue involves historical transactions or several accounting periods.
Consider getting assistance if:
- The beginning balance is incorrect
- Multiple reconciliations are affected
- Reconciled transactions were deleted
- Reconciled transactions were changed
- The account has a large unexplained difference
- An adjustment was previously entered
- You cannot determine which reconciliation is incorrect
- The books contain several duplicate transactions
- Financial reports changed after reconciliation corrections
Historical bookkeeping errors can become more complicated when corrections are made without understanding their impact.
QuickBooks Bank Reconciliation Troubleshooting Checklist
Before undoing a reconciliation, review the following:
Account Information
- Is this the correct bank account?
- Is this the correct credit card account?
- Is the statement period correct?
Statement Information
- Is the beginning balance correct?
- Is the ending balance correct?
- Is the statement date correct?
Transactions
- Are any transactions missing?
- Are there duplicates?
- Are transaction amounts accurate?
- Are transaction dates correct?
- Are transfers recorded properly?
- Are bank fees included?
- Is interest recorded?
Historical Activity
- Was a reconciled transaction deleted?
- Was a reconciled transaction changed?
- Was a previous reconciliation adjusted?
- Did a later reconciliation depend on the incorrect one?
Before Reconciliation Is Redone
- Review the reconciliation history
- Identify the exact source of the error
- Avoid unnecessary transaction deletion
- Avoid unexplained adjustments
- Confirm the correct statement
- Reconcile again carefully
Frequently Asked Questions
Can I undo a bank reconciliation in QuickBooks?
Yes, depending on the QuickBooks product and your user permissions, a bank reconciliation can generally be reversed or corrected. The exact process differs between QuickBooks Online and QuickBooks Desktop.
Does undoing a reconciliation delete transactions?
Undoing a reconciliation does not necessarily delete the underlying transactions. It primarily changes their reconciliation status so the account can be reviewed and reconciled again.
Can I undo just one reconciliation?
The available options depend on your QuickBooks version and the nature of the issue. In some cases, an individual transaction may be corrected without undoing an entire reconciliation.
What happens if I undo the wrong reconciliation?
Undoing the wrong reconciliation can create additional work because later reconciliations may depend on the earlier balance. Review the reconciliation history carefully before making changes.
Why did my beginning balance change after undoing a reconciliation?
The beginning balance can change when historical reconciled transactions are modified, deleted, or their reconciliation status is altered. Review previous reconciliation activity to identify the cause.
Should I delete a reconciled transaction?
Generally, you should not delete a reconciled transaction simply because it is causing a reconciliation problem. First determine why it is incorrect and what effect deleting it will have on later periods.
Can I reconcile the account again after undoing a reconciliation?
Yes. After correcting the underlying issue, you can reconcile the account again using the correct bank statement information.
Why is my QuickBooks reconciliation still off after undoing it?
Undoing a reconciliation does not automatically fix missing transactions, duplicate entries, incorrect amounts, or other bookkeeping errors. You still need to identify and correct the underlying discrepancy.
Can changing a reconciled transaction affect future reconciliations?
Yes. A change to a previously reconciled transaction can affect subsequent reconciliation balances and may require additional review.
What if several months of reconciliations are affected?
Start with the earliest incorrect reconciliation and work forward. Avoid making random changes to later periods because they can make the accounting history more difficult to reconstruct.
Is it safe to use an adjustment to fix a reconciliation?
An adjustment should not be used simply to hide an unexplained difference. First investigate missing transactions, duplicates, incorrect amounts, deleted transactions, and other potential causes.
How often should I reconcile my QuickBooks account?
Monthly reconciliation is a common approach for many businesses. Businesses with frequent transactions may choose to reconcile more often.
Can reconciliation errors affect financial statements?
They can, particularly when correcting the underlying transactions changes dates, amounts, accounts, income, expenses, or balances.
What should I do if I cannot find the cause of a reconciliation difference?
Review the reconciliation history, compare the bank statement with QuickBooks transaction by transaction, and work backward from the last known correct reconciliation. For complicated historical discrepancies, professional accounting assistance may be appropriate.
Final Thoughts
Knowing how to undo a bank reconciliation in QuickBooks can be useful when an account has been reconciled incorrectly or a historical transaction has been changed. However, undoing a reconciliation should not be treated as a simple way to make an account balance appear correct.
The best approach is to identify the exact source of the problem, review the reconciliation history, determine whether later periods are affected, and then make the smallest appropriate correction.
After the correction, reconcile the account again using the correct bank statement, statement date, ending balance, and cleared transactions.
Regular reconciliation, careful transaction review, accurate bank-feed management, and proper handling of historical records can help prevent many reconciliation problems in the future. If you need additional help correcting a complicated QuickBooks reconciliation issue, 866-798-4134 is available for professional assistance.
