Skip to content
logo Knowledgebase

Correcting a bank reconciliation in the Reconciliation Difference window

Created on  | Last modified on 

Summary

How to correct a difference in a bank reconciliation in Sage 50 Accounts.

Description

In Sage 50 Accounts, if you change a bank reconciled transaction since you last reconciled, you can view the transactions that are causing the difference.

When you bank reconcile, you see a message informing you the balance is different, followed by the Reconciliation Difference window:

Image

Take a look at the transactions and compare them to your bank statement, or other records. How you proceed depends on why the transactions are different and why this has happened.

Resolution


Deleted transaction

Re-enter the transaction using the buttons at the top of the Reconciliation Difference window.

Once re-entered, click Continue to bank reconciliation and double-click the transaction in the Unmatched transactions window to move it to the Matched transactions window.

 

Image


Total has changed

Either use the buttons at the top of the Reconciliation Difference window to make up the difference, or correct the existing transaction in Transactions.

Image


Transaction has been un-reconciled

Click Continue to bank reconciliation and double-click the transaction in the Unmatched transactions window to move it to the Matched transactions window.

Image


Transaction is reconciled in error

  1. Make a note of the transaction number then click Cancel.
  2. Click Transactions then click the required transaction and click Edit.
  3. Clear the Bank rec. on check box then click Save.

    Image

  4. Click Yes then click Yes again.

Unsure of the reason

Click Print list to print the details of the transactions.

Image

  1. Click Cancel then click Transactions and find the transactions and check the following columns:
        • Account \ Nominal - check this is the correct bank account
        • Bank - check this is reconciled, R, or not, N
        • Details - check if the transaction is marked as deleted

If you still can't work out why the bank reconciliation is showing a difference, please refer to our guide, Why doesn't my bank reconciliation balance?