How To Undo a Reconciliation In QuickBooks

Reconciling your QuickBooks account helps you compare recorded transactions with your bank statement and confirm that your financial records are accurate. Errors such as incorrect transaction amounts, dates, missing entries, duplicate transactions, or changes to previously reconciled transactions can create discrepancies. When these issues affect a completed reconciliation, you may need to undo the reconciliation or correct specific transactions. This guide explains how to undo a reconciliation and resolve common reconciliation issues in QuickBooks Online and QuickBooks Desktop.

What is Reconciliation in QuickBooks

Undo a Reconciliation in QuickBooks reverses the reconciled status of transactions to correct errors. Users can unreconcile individual transactions by changing the “R” status to blank. 

However, only QuickBooks Online Accountant users can undo an entire month’s reconciliation in a single batch. This process changes the transactions back to an “uncleared” state and lets you match them with the correct bank statement during reconciliation.

Reconciliation mistakes can affect your financial records, and undoing a bank reconciliation helps you correct them. You may need to undo a reconciliation in the following situations:

• Incorrect statement date or ending balance
• Report or Balance Sheet discrepancies
• Duplicate or incorrect transactions
• Transactions posted to the wrong accounts
• Suspicious transactions
• Forced or prematurely closed reconciliation
• Errors in cleared checks, deposits, or transfers
• Missing bank fees, interest, or transactions
• Previous reconciliation errors affecting current books

How to Undo Reconciliation in QuickBooks Online?

The process to undo bank reconciliation in QuickBooks Online depends on the status of the reconciliation and the changes you need to make. You can close an unfinished reconciliation without saving, undo an entire completed reconciliation, or unreconcile specific transactions.

Method 1: Unreconcile Individual Transactions in QuickBooks Online

Use this method to remove specific transactions from a reconciliation without undoing the entire reconciliation.

• Go to All apps, select Accounting, and then choose Chart of accounts.
• Find the account that contains the transaction and select View register.
• Locate the transaction you want to unreconcile. Reconciled transactions display an R in the checkmark column.
• Now, you can select the transaction to expand its details.
• Select the R in the checkmark column repeatedly until the field becomes blank.
• QuickBooks cycles through the following statuses:
  • R: Reconciled
  • C: Cleared
  • Blank: Uncleared
•  Select Save.

After you remove the transaction from the reconciliation, reconcile the account again using the correct transaction details.

Method 2: Undo an Entire Reconciliation

QuickBooks Online Accountant lets you undo an entire client reconciliation instead of unreconciling transactions one at a time. This option helps you restart the reconciliation process and correct errors. However, it does not reverse transactions that you reconciled manually.

Complete the following before undoing a reconciliation:

• Ensure you have Accountant access to the client’s QuickBooks Online company.
• Download any reconciliation reports or attachments you want to keep, as QuickBooks permanently deletes them after you undo the reconciliation.

Steps to Undo an Entire Reconciliation

Follow these steps to undo a client’s reconciliation:

• Open the client’s QuickBooks Online company.
• Go to All apps, select Accounting, and then choose Reconcile.
• Select History by account.
• Choose the account and select the appropriate date range.
• Locate the reconciliation you want to reverse a Reconciliation in QuickBooks.
• Under the Action column, select the dropdown arrow and choose Undo.

Note: Open the client’s company through QuickBooks Online Accountant when the Undo option does not appear.

• Select Yes to confirm.
• Select Undo again to complete the process.

QuickBooks reverses the selected reconciliation and all later reconciliations. Review the account register and audit history for changes, correct any errors, and reconcile the account again.

Method 3: Close an Unfinished Reconciliation Without Saving

You do not need to undo a reconciliation that is still in progress. Close the reconciliation without saving to discard the current session.

• Go to All apps, select Accounting, and then choose Reconcile.
• Select the account and choose Resume reconciling.
• Open the Save for later drop-down and select Close without saving.
• Confirm your choice.
• QuickBooks closes the reconciliation session without saving the changes.

Method 4: Undo an Entire Completed Reconciliation

You can undo an entire reconciliation when you have the required access. This option is available to the Primary Admin, In-house Accountant, or an accountant with access to the client’s company through QuickBooks Online Accountant.

Before you continue, download and save any reconciliation reports or attachments you want to keep. QuickBooks permanently deletes the related reports and attachments during the undo process.

• Go to All apps, select Accounting, and then choose Reconcile.
• Select History by account.
• Choose the account and select the appropriate date range.
• Locate the reconciliation you want to undo.
• Under the Action column, select the dropdown and choose Undo.
• Review the information in the confirmation window and select the checkbox to acknowledge the changes.
• Select Undo reconciliation to complete the process.

Method 5: Undo an Entire Period in QuickBooks Online Accountant

QuickBooks Online Accountant allows accountants to undo a client’s entire reconciliation instead of changing transactions individually.

• Open the client’s company file from your Accountant dashboard.
• Go to All apps, select Accounting, and then choose Reconcile.
• Select History by account.
• Choose the account and date range to find the reconciliation period.
• Under the Action column, select the dropdown and choose Undo.
• Select Yes to confirm, and then select Undo to complete the process.

Note: Open the client’s company through QuickBooks Online Accountant when the Undo option does not appear.

The selected reconciliation and any reconciliations completed after it are undone. Review the account register and audit history before reconciling the account again.

Step-by-Step Guide to Fix Reconciliation Issues in QuickBooks Online

Follow the steps below to identify discrepancies, correct transaction errors, and bring the account balance in QuickBooks Online in line with your bank statement.

Step 1: Check the Opening and Beginning Balances

• Verify the opening and beginning balances before you continue.

Step 2: Confirm the Ending Balance

• Review the ending balance in the Reconciliation Window and update it when necessary.

Step 3: Combine Related Transactions

• Combine transactions in QuickBooks when your bank records them as a single transaction.

Step 4: Match Correct Transactions

• Compare your bank statement with QuickBooks and mark the transactions that match.

Step 5: Enter Missing Transactions

• Check your bank statement for missing entries and add them to QuickBooks.

Step 6: Review Unmatched Transactions

• Find transactions in QuickBooks that do not appear on your bank statement and remove them when necessary.

Step 7: Check Transactions With Minor Differences

• Review transactions with small discrepancies and consult your accountant for guidance.

Step 8: Check for Financial Institution Errors

• Contact your bank or credit card company to investigate possible errors.

Step 9: Complete the Reconciliation

• Resolve all discrepancies and balance the account before completing the reconciliation in QuickBooks Online.

Step-by-Step Guide to Fix Reconciliation Issues in QuickBooks Desktop

Now, proceed with the following steps to review balance issues, identify transaction changes, and correct reconciliation discrepancies in QuickBooks Desktop.

Step 1: Review Opening and Beginning Balances

Examine your start and initial balances to confirm their accuracy before you continue.

Step 2: Review Changed, Deleted, or Added Transactions

Run a Reconciliation Discrepancy Report:

• Go to Reports, select Banking, and then choose Reconciliation Discrepancy.
• Review the discrepancies and discuss any changes with the person who made them.

Run a Missing Checks Report:

• Go to Reports, select Banking, and then choose Missing Checks.
• Review the report for transactions that do not appear on your bank statement.

Run a Transaction Detail Report:

• Go to Reports, select Custom Reports, and choose Transaction Detail.
• Filter the report by account and review transactions between the earliest and latest reconciliation dates.

Step 3: Check for Reconciliation Adjustments

• Go to Lists, select Chart of Accounts, and review the Reconciliation Discrepancies account.
• Check that the adjustments are accurate.
• Resolve any conflicts between the adjustments and your corrections.

Finalise the Reconciliation

After correcting the identified issues, complete the reconciliation process.

Conclusion

QuickBooks provides different ways to undo a Reconciliation in QuickBooks and correct it. QuickBooks Online users can close an unfinished reconciliation, undo an entire completed reconciliation, or unreconcile individual transactions. QuickBooks Desktop users can review reconciliation reports, identify transaction changes, and check reconciliation adjustments before completing the process again. Review the affected transactions and balances carefully before reconciling the account again to keep your records accurate.

Frequently Asked Questions