Within Sage go to ‘Bank Accounts’ on the left hand task bar

Highlight the Bank Account

Click ‘Reconcile’

The Statement summary window will appear – Sage will automatically enter a ‘Statement Reference’ based on your bank account nominal code and the date – you may want to change this to the bank statement received reference (this is a compulsory field)

Enter ‘Statement Reference’

Enter ‘End Date’ from your statement so that only those transactions up to and including the date are available for reconciliation.

Enter ‘Interest Earned’ shown on your bank statement (if you have not already entered this when entering Bank Receipts.)

Enter ‘Date’ the interest was entered on to your bank statement and the Nominal Code

Any ‘Bank Charges’ shown on your statement can be entered in the same way

Click ‘OK’

The Bank Reconciliation window will appear – The last reconciled balance will be brought forward (if this is the 1^st time you have reconciled the balance will be ‘0.00’)

Work through the bank statement, one line at a time

‘Match’ a transaction on your bank statement by ‘Double clicking’ on the item to take individual items from the top to the bottom – you can select a number of items at once and choose ‘Match’

There is a sub-total at the side for if you are matching items that may be linked to one transaction, for example – paying in slip or when balancing separate items that make up one transaction

Choosing the ‘Match’ option moves the items from the top to the bottom, these items are the ones that have been matched to the statement

(Before making an adjustment, check that the process has been carried out, i.e. payment recorded to the supplier or received from a tenant)

The ‘Adjust’ button will allow you to enter a ‘Bank Receipt’, ‘Customer Receipt’, ‘Supplier Refund’, ‘Bank Payment’, ‘Supplier Payment’ or ‘Customer Refund’, for any transaction that may be missing.

Click on ‘Adjust’ and the ‘Adjustment’ window will appear.

Choose the ‘Adjustment Type’ and click ‘OK’

Depending on the type of bank adjustment you choose, you will be taken to the corresponding window, for example ‘Bank Receipt’ has been chosen

Enter the details as normal and ‘Save’

If you do not want to complete reconciling the bank at this point you can click ‘Save Progress’ in the ‘Reconcile’ window and this will allow you to go in and out of the reconcile window and add any missing entries, make adjustments or save the work, until a later time, if you have not finished.

For example – if you have not posted a bank transfer, you would need to save the reconciliation and post the transfer from the bank menu, as that type of transaction is not allowed using the ‘Adjustment’ icon

When returning to the reconciliation after a save, you will be asked if you want to use the ‘Previous Statement’ that was saved or discard it – make sure you choose ‘Use Saved’ or you will lose all work you have saved

Any additional postings you may have made, after saving, will appear in the top. Go through the matching procedure as above until your balances are correct and click ‘Reconcile’ –