You need to check if you've reconciled any transactions since your last bank reconciliation.
- Click Bank accounts and select the relevant account.
- Click Reports then click Reconciled transactions.
- Click Retrospective Bank Reconciliation and click Preview.
- Enter the date range from the day after your last reconciliation to 31/12/2099 then click OK.
If no data is returned for the report, or the report doesn't open, this means no transactions have been reconciled. Click
OK and move on to the next step.
2 - Find when the balance last agreed
As a starting point we need to establish when was the last time the end balance last agreed with the closing balance of the relevant bank statement. This helps you find the transactions that are causing this difference in your last reconciled balance.
- On the navigation bar click Bank accounts then select the relevant account.
- Click Reports then click Reconciled transactions then click Retrospective Bank Reconciliation and click Preview.
- Enter the date range from 01/01/1980 to the date you last reconciled up to then click OK.
- Check that the report total is the same as the last reconciled balance in the Reconcile window.
- Check that the balance on the report at the end of the previous reconciliation is the same as the closing balance on the bank statement for that period.
If they're the same, move on to the next step.
If they're different, work back through the previous reconciliations until you find when the balances last agreed. Once you find this, move on to the next step.
3 - Find transactions causing the difference
The point where the end balance last agreed with the closing balance of the relevant bank statement is our new starting point. This tells us that the transactions causing the difference occurred after this point.
To identify the differences, compare the transactions on the report for that period with the relevant bank statement.
Remember differences could be any of the reasons listed earlier and changes could have been made to transactions in a number of different reconciliations. To help identify transactions that have been deleted, you can apply the following search:
4 - Make any required corrections
When you find the difference, for example, a transaction is on your bank statement but doesn't appear on the report, you must make the relevant correction. If you re-enter any transactions that were previously reconciled, you must also reconcile them.
A useful report to use is the Bank Reconciliation PDF. This is the report created when you originally reconciled, and can be used in place of your bank statement.
Once you've corrected your errors, continue to the next section.
5 - Check the balance now agrees
We now need to check that the corrections we have made have have resolved the last reconciled balance.
- On the navigation bar click Bank accounts then select the relevant account.
- Click Reports, click Reconciled transactions, click Retrospective Bank Reconciliation then click Preview.
- Enter the date range from 01/01/1980 to the date you last reconciled up to, then click OK.
- Check the report total is now correct.
If it's correct you can now continue with your current bank reconciliation.
If it's different you should return to Step 2 - Find when the balance last agreed and repeat the process.
[BCB:99:Limitless - 50 Accounts - Bank:ECB]