There are three things that will cause this:
- The reconciled transaction was deleted and has since been re-entered (but not yet reconciled).
- The reconciled transaction has been duplicated.
- The reconciled transaction has been changed and resaved
To determine which of the above has happened:
- Locate the bank statement you last reconciled your account to and note its closing balance.
- From the Banking command centre, click Reconcile Accounts.
- Set the Account field to your bank account then press the tab key on your keyboard.
- With no transactions selected as Cleared, does the Calculated Statement Balance equal the bank statement balance noted at step 1?
- Yes: This suggests the unreconciled transaction is a duplicate entry.
- No: This indicates the reconciled transaction was deleted and has since been re-entered, or changed and resaved.
The above can be quickly confirmed by using the Bank Register report.
- From the Banking command centre, click Reports.
- Highlight the Bank Register report then click Customise (or Display - depending on your software version).
- Set a date range to capture the transaction.
- Click Report Fields and select the Reconciled Date option.
- Click the Finishing tab and set the Sort By field to ID#.
- Click Display.
In Bank Register report 1 shown below, you can see cheque #4 is listed twice and only one copy of it has a Reconciled Date. From this you can see that cheque #4 has been duplicated. Your options to correct this are to either delete or reverse the unreconciled entry.
Bank Register report #1
In Bank Register report #2 shown below, you can see that cheque #4 is listed only once, and, it doesn't have a Reconciled Date. This shows the original reconciled entry was deleted and the one being reported is a replacement.
Bank Register report #2
To correct this, please refer to 43. Reconcile Re-enter the replacement transaction and reconcile the account above.