Reconciling Your Bank Account in Sage 50

By Jane E. Kelly

Before you begin a bank reconciliation in Sage 50, you need to ensure that you have entered the majority of your financial transactions for the period that you are reconciling. Traditionally, bookkeepers would reconcile the bank account at the end of each month, once they received their bank statements. However, the advent of online banking means that it is now easier to reconcile your bank account on a much more regular basis. In theory, you could reconcile your transactions daily, although weekly is perhaps more likely.

Here is a list of things that you need to ensure you’ve posted prior to reconciling the bank account:

  • Check that all sales invoices are posted and updated on your accounts system. This ensures that any remittances received can be allocated to the correct invoice.

  • Ensure all receipts which have been paid into the bank account manually are posted to the accounts system. You can post any BACS receipts directly from the bank statements.

  • Make sure that you’ve posted any cheques onto the accounting system that you’ve written and sent.

  • Check that you’ve posted all supplier invoices onto the system. This ensures that any payments you make to your suppliers can be allocated against the correct invoice.

  • If you’re using Sage 50, ensure that you’ve processed any bank recurring entries that you may have set up for regular payments made or received.

When you are satisfied that you’ve completed all the above tasks, you can begin the reconciliation process.

  1. From the Bank Accounts module, select the account you want to reconcile and click the Reconcile icon.

    This will open up the Statement Summary window where you need to enter a title for the bank reconciliation and enter the bank statement balance you are reconciling to and the date of the statement.

  2. When you click OK, the bank reconciliation screen will open and you’ll be able to use your bank statements to tick off all the transactions that are currently showing in Sage 50 against the bank statements themselves.

    If any items have not been ticked off, such as direct debits and BACs receipts, you can add these by using the adjustment button and selecting the appropriate type of payment or receipt.

    Don’t forget that you can save the reconciliation at any point in time, so if you get interrupted, you can save the reconciliation and return to it later. Any matches that you’ve made will be saved. Just make sure that when you open the bank reconciliation the next time, you click the ‘Used Saved’ option and not the ‘Discard Saved’, otherwise you will have to start all over again!

  3. When you are happy that you’ve matched all the items in Sage with an entry on your bank statements and that no remaining items are left un-ticked on your actual bank statement, you are in a position to finalise the reconciliation process.

    However, before you click the Reconcile button, ensure that the ‘Difference’ box in the bottom right hand corner is showing zero. If not, check that you have the correct bank statement amount entered, and double check all your items that you’ve ticked off. You may have inadvertently matched an additional item by mistake.

  4. When you are happy that your figures are accurate and the difference box is zero, then click Reconcile. Job done!

    A copy of your bank reconciliation will be saved in the archives for future reference.