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. In AccountRight 2011 and later, click the Insert/Modify tab then click Show/Hide. Select Reconciled Date in the Available columns list then click Show then click OK.
- Click the Finishing tab and set the Sort By field to ID#. In AccountRight 2011 and later, click Sort (on the Filters tab) and sort by ID No. then by Date. Click OK.
- 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 Image RemovedImage Added 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 Image RemovedImage Added To correct this, please refer to 4. Reconcile the replacement transaction aboveto 3. Re-enter the transaction and reconcile the account above. |