The last reconciled balance has changed
Description

A change can happen from one of the following reasons:

  • A reconciled transaction has been deleted, amended, or moved to a different bank account
  • The bank reconciliation flag has been removed from a transaction that was reconciled
  • Other transactions have been reconciled since your last bank reconciliation
  • An opening balance has been posted to the bank account

You must correct the balance before you continue with your reconciliation.  Don't worry, you can correct this by following the steps below.






Cause
Resolution

1 - Check for recently reconciled transactions

You need to check if you've reconciled any transactions since your last bank reconciliation.

  1. Click Bank accounts and select the relevant account.
  2. Click Reports then click Reconciled transactions.
  3. Click Retrospective Bank Reconciliation and click Preview.
  4. 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.

  1. On the navigation bar click Bank accounts then select the relevant account.
  2. Click Reports then click Reconciled transactions then click Retrospective Bank Reconciliation and click Preview.
  3. Enter the date range from 01/01/1980 to the date you last reconciled up to then click OK.
  4. Check that the report total is the same as the last reconciled balance in the Reconcile window.
  5. 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:

  1. On the navigation bar click Transactions then click Filter.
  2. Enter the following details, replacing 1200 with your required bank if different:
    JoinFieldConditionValue
    WhereBank reconciled dateIs Greater Than Or Equal To01/01/1980
    AndAccount ReferenceIs Equal To1200
    AndTransaction deleted flagIs Equal ToYes
    OrBank reconciled dateIs Greater Than Or Equal To01/01/1980
    AndNominal CodeIs Equal To1200
    AndTransaction deleted flagIs Equal ToYes
    Add the following to include a date range:
    AndDateIs Greater Than Or Equal ToEnter start date
    AndDateIs Less Than Or Equal ToEnter end date
  3. Click Apply then click Close.

    This shows all deleted transactions that have previously been bank reconciled. This helps identify bank reconciled transactions that are deleted and may not have been bank reconciled when re-entered.

TIP: If you're unable to pinpoint why your balance is different and feel it would be easier to undo then redo previous reconciliations, you can use the easy bank reconciliation reversal feature.


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.

  1. On the navigation bar click Bank accounts then select the relevant account.
  2. Click Reports, click Reconciled transactions, click Retrospective Bank Reconciliation then click Preview.
  3. Enter the date range from 01/01/1980 to the date you last reconciled up to, then click OK.
  4. 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]
Steps to duplicate
Related Solutions