The last reconciled balance has changed

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.

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.

---

Make any required corrections

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.