Solution Properties
Solution ID:
200427112313525
Last Modified Date:
Wed Sep 30 10:54:04 UTC 2026
Taxonomy Path:
Case category//How do I...//banking/reconciliation
Author:
[email protected]
Reconcile your bank account
Description

To ensure your transactions and bank balances in Sage 50 Accounts are accurate. Reconcile your bank account each time you receive a statement from your bank. 

TIP:

Use our Bank Feeds service to connect directly to your bank for reconciliation.

Cause
Resolution

Skip to:

Before you start

Before reconciling your bank account, ensure you've entered all of your transactions up to the end date of your bank statement.

Enter your statement summary

 

  1. Go to Bank accounts, then click the relevant bank account.
  2. Select Reconcile.

If the 'The bank account selected has been marked as not requiring bank reconciliation' message appears, follow the steps on the article.

  1. Enter the Ending Balance from your statement.
  2. Enter the Statement Date from your statement.

    This is the end date that your statement goes up to.

  3. Enter any Interest Earned and the Date.
  4. Enter any Account Charges and the Date.
  5. Press OK.

If necessary, you can change statement summary information in the Reconcile window by selecting Edit or the pencil icon.

Check your last reconciled balance

 

  1. In the Matched transactions pane, check the Last reconciled balance.
  2. Does the Last reconciled balance match the opening balance on the bank statement you're reconciling?
    • Yes, it does match - continue to Match your transactions
    • No, it doesn't match - you must identify the reason why

Match your transactions

 

In the Un-matched transactions pane:

  1. Select the first transaction that appears on your bank statement.
  2. Press Match >>

    The transaction moves from the Un-matched transactions pane to the Matched transactions pane.

  3. Repeat Steps 1 and 2 until all transactions match your bank statement.

    TIP:

    Hold CTRL to select multiple transactions, or amend your settings to allow you to select multiple records. 

     

  4. If you haven't entered a transaction into Sage 50 Accounts, post an adjustment.

You can save the reconciliation at any point and complete it later by selecting Save progress. To open the saved reconciliation, press Use Saved.

At any point before you reconcile, to see a list of currently unmatched items, press Report.

Reconcile your bank statement

 

Once you match all the relevant transactions:

      • Check the Matched Balance and the Statement Balance are the same

        The Difference will be zero. If the difference:
        Is zero  Select Reconcile.

        A progress bar appears while the software flags your transactions. It also creates a PDF file of your reconciled statement.
        Isn't zero You must find out why it isn't zero.

        If required, select Save progress. 

        Next time you open the Reconcile window, to open the saved reconciliation, choose Use Saved.

View reconciled report - optional

  1. Go to Bank accounts then select the relevant bank account.
  2. Select Reconcile then OK.
  3. Select View history.

    A PDF file appears for each reconciliation. The file name is the bank account and the reconciliation date.

  4. Double-click the required pdf file.
[BCB:191:UKI - #GetMoreFeedback:ECB]
  [BCB:99:Limitless - 50 Accounts - Bank:ECB]
Steps to duplicate
Related Solutions