Solution Properties
Solution ID:
200427112319653
Last Modified Date:
Wed May 13 14:00:36 UTC 2026
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. Go to Bank accounts and select the relevant account.
  2. Select Reports then Reconciled transactions.
  3. Select the Retrospective Bank Reconciliation report and choose Preview.
  4. Enter the date range from the day after your last reconciliation to 31/12/2099, then press OK.
If no data returns for the report, or the report doesn't open, this means there are no reconciled transactions. Press 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. Go to Bank accounts then select the relevant account.
  2. Select Reports then Reconciled transactions.
  3. Select the Retrospective Bank Reconciliation report and choose Preview.
  4. Enter the date range from 01/01/1980 to the date you last reconciled up to, then press OK.
  5. Check that the report total is the same as the last reconciled balance in the Reconcile window.

  6. 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. Go to Transactions then select 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. Go to Bank accounts then select the relevant account.
  2. Select Reports then Reconciled transactions.
  3. Select the Retrospective Bank Reconciliation then choose Preview.
  4. Enter the date range from 01/01/1980 to the date you last reconciled up to, then press OK.
  5. 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