Disclaimer: QBO.support is an independent help resource, published by E-Tech Corporation. We are an Intuit Product Referrals Partner and may earn a commission when you subscribe through our links, at no extra cost to you. We are not endorsed or sponsored by Intuit Inc., and this site is not official Intuit support. “QuickBooks” and “QuickBooks Online” are registered trademarks of Intuit Inc., used for identification and reference purposes only. See our About page.

Reconciled

Fixing reconciled transactions and reconciliation issues

We understand that sometimes you need to correct transactions or adjust your books after a reconciliation is complete. While it is possible to make these changes, we generally recommend fixing errors rather than deleting entire reconciled periods or starting over.

Here is a guide on how to handle specific scenarios involving reconciled transactions.

Understanding transaction status

In the bank register, transactions have specific status indicators that affect how they appear in future reconciliations.

Changing accounts for a reconciled deposit

If you need to change the expense accounts associated with payments or sales receipts inside a deposit that is already reconciled, follow these steps to preserve your reconciliation history:

  1. Open the original deposit.
  2. Add a temporary line item for each account you need to change. You can use a “Miscellaneous” account; ensure the amounts match the original lines. You do not need to enter a name.
  3. Delete the original lines you intend to change.
  4. Save the deposit (do not close it yet).
  5. Open the original payments or sales receipts and make the necessary account changes.
  6. Return to the deposit window and click the Payments button.
  7. Select the amended payments to bring them back into the deposit.
  8. Delete the temporary “Miscellaneous” lines you added earlier.
  9. Save the deposit.

Restoring accidentally deleted reconciled transactions

If you accidentally delete a transaction that was previously reconciled, simply deleting it disrupts your Beginning Balance. To fix this:

  1. Manually re-enter the deleted transaction.
  2. Go to Settings (gear icon) and select Chart of Accounts.
  3. Locate the bank account and click View register (or Account history).
  4. Find the re-entered transaction in the list.
  5. In the Clr (Check) column, click until the R appears. This manually marks the transaction as reconciled.
  6. Click Save.
  7. Your Beginning Balance should now be correct.

Handling lost or stopped checks

If a check was created to pay a vendor but was lost or never cleared, you can void or replace it without breaking the previous reconciliation using a clearing account:

  1. Create a new Bank account named “Clearing” (or similar).
  2. Create a deposit in your main bank account and use the “Clearing” account as the From Account.
  3. Create a replacement check or EFT payment to the vendor.
  4. On the replacement check, use the “Clearing” account as the expense account (category).
  5. This results in the bank statement matching, the vendor showing as paid, the original reconciliation remaining untouched, and the clearing account returning to a zero balance.

Deleting transactions vs. fixing them

You may be tempted to delete all transactions for the year to start over. While you can delete transactions individually, we strongly advise against deleting entire reconciled periods.

Important note on manual unreconciliation

We do not recommend manually unreconciling transactions (changing an “R” to a blank or “C”) unless you are currently in the middle of a reconciliation and need to start over. Manually unreconciling past periods often causes more problems than it resolves and may hide the root cause of discrepancies. If you are experiencing issues with your reconciliation, we recommend reviewing our common reconciliation scenarios and solutions for the best path to resolution.

Still need help? Send us a message

Tell us about your QuickBooks Online question and we'll get back to you by email.