Solution Properties
Solution ID:
200427112319653
Last Modified Date:
Mon Mar 17 11:57:37 UTC 2025
Taxonomy Path:
Case category//I have a problem with...//banking/reconciliation
Author:
[email protected]
The last reconciled balance has changed
Description

A change can happen from one of the following reasons:

  • You deleted, amended, or moved a reconciled transaction to a different bank account
  • You removed the bank reconciliation flag from a reconciled transaction
  • You have reconciled other transactions since your last bank reconciliation
  • You posted an opening balance to the bank account

Correct the balance before you continue with your reconciliation.

Cause
Resolution

Table of Contents

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 returns for the report, or the report doesn't open, this means there are no reconciled transactions. Click OK and move on to the next step.

Find when the balance last agreed

As a starting point, establish when the last time the end balance agreed with the closing balance of the bank statement. This helps you find the transactions that are causing this difference in your last reconciled balance.

  1. On the 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. Ensure the report balance at the end of the previous reconciliation matches the bank statement balance 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.

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 stem from any of the reasons listed earlier, and changes could have occurred in various reconciliations.

To help identify deleted transactions, apply the following search:

  1. Click Transactions, then click Filter.
  2. Enter the following details, replacing 1200 with your required bank if different:
    Join Field Condition Value
    Where Bank reconciled date Is Greater Than Or Equal To 01/01/1980
    And Account Reference Is Equal To 1200
    And Transaction deleted flag Is Equal To Yes
    Or Bank reconciled date Is Greater Than Or Equal To 01/01/1980
    And Nominal Code Is Equal To 1200
    And Transaction deleted flag Is Equal To Yes
    Add the following to include a date range:
    And Date Is Greater Than Or Equal To Enter start date
    And Date Is Less Than Or Equal To Enter end date
  3. Click Apply then click Close.
    This shows all deleted transactions that have previously been bank reconciled.

TIP: If you can't identify why your balance differs and prefer to undo and redo previous reconciliations, use the bank reconciliation reversal feature.

Make any required corrections

When you find the difference, such as a transaction on your bank statement but not on the report, make the necessary correction. If you re-enter previously reconciled transactions, you must reconcile them again.

A useful report to use is the Bank Reconciliation PDF. Use this report, created during the original reconciliation, as a substitute for your bank statement.

Once you've corrected your errors, continue to the next section.

Check the balance now agrees

We now need to check that the corrections we have made have resolved the last reconciled balance.

  1. Click Bank accounts then select the relevant account.
  2. Click Reports, click Reconciled transactions, then select 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 is, you can now continue with your current bank reconciliation.

    If it's different return to find when the balance last agreed and repeat the process.

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions