Bank reconciliation is an essential part of accounting in QuickBooks Online, helping businesses match their bank statements with recorded transactions. However, mistakes can happen—such as reconciling the wrong statement, entering incorrect opening balances, or matching duplicate transactions.
In such cases, you may need to undo a bank reconciliation in QuickBooks Online to correct the records and maintain accurate financial reports.
This guide explains how to undo reconciliation, when it should be done, and what precautions to take.
What Does Undoing a Bank Reconciliation Mean?
Undoing a bank reconciliation means reversing previously matched transactions so they return to an “unreconciled” state. This allows you to:
- Correct incorrect reconciliations
- Fix mismatched transactions
- Adjust opening or closing balances
- Re-run reconciliation accurately
In QuickBooks Online, this action should be done carefully because it affects financial reports, bank balances, and audit history.
When Should You Undo Bank Reconciliation?
You should only undo reconciliation if:
- Wrong transactions were marked as cleared
- Bank statement was selected for the wrong period
- Opening balance was incorrect
- Duplicate entries were reconciled
- Accountant requests corrections
Avoid undoing reconciliation unless necessary, as it can impact financial reporting accuracy.
Important Things to Know Before Undoing Reconciliation
Before proceeding, keep in mind:
- Undoing affects historical financial reports
- It may change tax reports and balances
- You may need accountant approval
- Changes are visible in audit logs
If unsure, consult your accountant before making changes.
How to Undo Bank Reconciliation in QuickBooks Online
There are two main methods depending on your access level.
Method 1: Undo Individual Transactions
This method is suitable if only a few transactions need correction.
Steps:
- Open QuickBooks Online
- Go to Accounting
- Select Chart of Accounts
- Find the bank account
- Click View Register
- Locate the transaction marked as “R” (Reconciled)
- Click the transaction
- Change status from R (Reconciled) to C (Cleared) or blank
- Save the changes
This removes the transaction from reconciliation without undoing the entire statement.
Method 2: Undo Entire Reconciliation (Recommended for Accountants)
This method is used when an entire reconciliation period is incorrect.
Steps:
- Go to Settings (⚙️ icon)
- Select Reconcile
- Click History by Account
- Choose the bank account
- Find the reconciliation period
- Click View Report
- Select Undo for the reconciliation
If the undo option is not available, you may need accountant access or use journal adjustments.
What Happens After Undoing Reconciliation?
Once reconciliation is undone:
- Transactions become unreconciled
- Bank balance updates automatically
- Previous reconciliation reports change
- You can re-reconcile correctly
Always verify changes before redoing the reconciliation.
Common Issues When Undoing Reconciliation
1. No Undo Button Available
This usually happens if:
- You don’t have accountant permissions
- Reconciliation was locked
2. Transactions Still Showing as Reconciled
Clear browser cache or refresh account register.
3. Balance Differences After Undo
Check for missing or duplicate transactions.
Best Practices for Bank Reconciliation in QuickBooks Online
To avoid future issues:
- Reconcile accounts monthly
- Avoid editing reconciled transactions
- Keep accurate opening balances
- Review statements before reconciling
- Work with an accountant if needed
Frequently Asked Questions
Can I undo a reconciliation in QuickBooks Online?
Yes, you can undo reconciliation using the History by Account feature or by changing individual transaction status.
Will undoing reconciliation affect my reports?
Yes, it will update financial reports and account balances.
Can I undo old reconciliations?
Yes, but you may need accountant access depending on permissions.
Is it safe to undo reconciliation?
It is safe if done carefully, but it should only be done when necessary.
Final Thoughts
Undoing a bank reconciliation in QuickBooks Online is a powerful feature that helps correct accounting errors, but it should be used carefully. Whether you are fixing a single transaction or redoing an entire statement, always review changes thoroughly to ensure financial accuracy.
Proper reconciliation practices help maintain clean books, accurate reports, and smooth business financial management.
You May Also Read: QuickBooks Online Running Slow
