You can reverse a bank or credit card reconciliation in QuickBooks Desktop by using the built-in "Undo" function, which restores the account to its state before the reconciliation was completed. This process corrects errors such as missed transactions, incorrect balances, or misapplied payments without deleting records.
Reconciling accounts ensures your books match your bank statements. When done incorrectly, it creates discrepancies that affect reports like profit and loss and balance sheets. The "Undo" feature exists specifically to fix these mistakes while preserving audit trails and transaction history.
QuickBooks Desktop allows reversal only within the same accounting period and only if no new transactions were added after reconciliation. If you've closed the period or added entries since, you must manually adjust the account instead.
When you reconcile an account, QuickBooks marks it as "reconciled" and stores the ending balance. The system tracks all changes to the account during the reconciliation process. If you later find a mismatch-such as a missing deposit or an incorrect cleared date-you can reverse the entire reconciliation.
Undoing a reconciliation removes the reconciliation status and resets the account's ending balance to the previous statement balance. It does not delete transactions, remove cleared status from matched items, or alter the original bank statement. All data remains intact, but the reconciliation flag is removed.
For example, if you reconciled your checking account on June 30 and discovered a $125 deposit wasn't recorded, you can undo the reconciliation, add the deposit, then reconcile again. This avoids creating duplicate entries or distorting your financial reports.
You cannot undo a reconciliation if:
According to Intuit's official documentation, the undo function is available only for the last reconciliation performed on an account. If multiple reconciliations exist in a single period, only the most recent one can be undone. You must have the appropriate user permissions-typically "Full Access" or "Accountant" level-to perform this action.
Important: Undoing a reconciliation does not automatically update the bank statement. You must still verify the actual bank statement and ensure all transactions match. Failing to do so may result in future mismatches.
Once undone, you can re-enter missing transactions, correct dates, or fix cleared statuses. Then run the reconciliation again using the updated statement details.
For accuracy, always print or save a copy of the bank statement before undoing. This allows you to cross-check against the corrected reconciliation.
Users often assume that undoing a reconciliation deletes transactions or erases all changes. This is false. The undo function only reverses the reconciliation status and resets the ending balance. All transactions remain in the register and are still visible in reports.
A frequent error is attempting to undo a reconciliation after posting new transactions. QuickBooks prevents this to avoid data corruption. If you encounter a "Cannot undo reconciliation" message, check whether any new entries were added after the reconciliation. If so, you must manually adjust the account balance instead.
Another mistake is reversing a reconciliation without verifying the actual bank statement. Always compare the statement with your ledger. For instance, if a $200 payment was mistakenly marked as cleared, undoing the reconciliation lets you unmark it-but you must confirm the bank didn't clear it in reality.
If you cannot undo a reconciliation due to a closed period or new transactions, create a journal entry to correct the balance. For example, if you reconciled on March 31 but forgot a $450 transfer, and April transactions were posted, you can:
This adjusts the balance without altering the reconciliation. The entry appears in the general ledger and affects reports but doesn't interfere with the reconciliation status.
Intuit's support guidelines recommend using journal entries for corrections in locked periods. This preserves data integrity and supports audit compliance.
Understanding the difference between undo, delete, and manual adjustment prevents data loss and ensures accurate reporting.
| Action | Effect on Transactions | Best Use Case |
|---|---|---|
| Undo Reconciliation | Removes reconciliation status, resets ending balance. Transactions remain. | Correcting a mistake in the same period before closing. |
| Delete Transaction | Permanently removes the entry. May break audit trail. | Only if the transaction was entered in error and no other records depend on it. |
| Manual Adjustment (Journal Entry) | Adjusts balance via entry. Preserves history. | When reconciliation is locked or new transactions exist. |
Deleting a transaction after reconciliation can cause discrepancies in reports. The undo function is safer because it maintains the full audit trail.
I once worked with a small business owner who reconciled their business checking account on May 31. After reviewing the bank statement, they noticed a $675 vendor payment was missing. They attempted to undo the reconciliation but received an error message.
Investigation revealed that a payroll entry had been posted on June 1. Since the period was closed and new transactions existed, undo was blocked. We created a journal entry dated May 31: debit Accounts Payable $675, credit Checking Account $675. The balance corrected, and the reconciliation remained valid.
This method preserved the integrity of the books and avoided reprocessing months of data.
Always verify the bank statement before undoing a reconciliation. Confirm that the discrepancy isn't due to a timing delay in bank processing. Some transactions take 1-3 business days to appear.
Use the "Undo" function only when necessary. Frequent reversals suggest inconsistent bookkeeping practices. Regular reviews and timely reconciliations prevent recurring issues.
Knowing how to undo a reconciliation in QuickBooks Desktop protects your financial records from inaccuracies. It's a critical skill for maintaining trust in your accounting data.