Correcting a bank reconciliation in the Reconciliation Difference window

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

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:

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.

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.

 

---

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.

---

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.

---

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.
   
   
   
   
4. Click Yes then click Yes again.

---

Unsure of the reason

Click Print list to print the details of the transactions.

1. Click Cancel then click Transactions and find the transactions and check the following columns:
2. 1. 1. • 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?