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.
- C (Cleared): The transaction has cleared the bank and has been checked off, but it has not yet been reconciled. It will still appear in the reconciliation screen.
- R (Reconciled): The transaction has been successfully reconciled. It will not appear in the next reconciliation window.
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:
- Open the original deposit.
- 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.
- Delete the original lines you intend to change.
- Save the deposit (do not close it yet).
- Open the original payments or sales receipts and make the necessary account changes.
- Return to the deposit window and click the Payments button.
- Select the amended payments to bring them back into the deposit.
- Delete the temporary “Miscellaneous” lines you added earlier.
- 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:
- Manually re-enter the deleted transaction.
- Go to Settings (gear icon) and select Chart of Accounts.
- Locate the bank account and click View register (or Account history).
- Find the re-entered transaction in the list.
- In the Clr (Check) column, click until the R appears. This manually marks the transaction as reconciled.
- Click Save.
- 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:
- Create a new Bank account named “Clearing” (or similar).
- Create a deposit in your main bank account and use the “Clearing” account as the From Account.
- Create a replacement check or EFT payment to the vendor.
- On the replacement check, use the “Clearing” account as the expense account (category).
- 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.
- Deleting: When you delete an expense, it is as if it never happened; the bank balance updates automatically. However, deleting reconciled items creates discrepancies in your Beginning Balance that are difficult to track.
- Fixing: It is usually less work and safer for your data integrity to correct the specific errors (like incorrect dates or amounts) than to delete and re-enter data.
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.