Skip to content
logo Knowledgebase

Common terms when reconciling your bank account

Created on  | Last modified on 

Summary

An explanation of the phrases used on the bank reconciliation screen in Sage Accounting.

Description

Here's an explanation of the terms used on the reconciliation page and how we use them:

Statement date

The end date of the bank statement you're reconciling.

Statement end balance

The bank statement shows the closing balance.

Total received and paid

This shows the total value of reconciled payments (money out) and receipts (money in). We update these amounts as you mark each transaction as reconciled.

Starting balance

The Starting Balance is the total of reconciled transactions up to the current statement date. This may not always match the closing balance of your previous reconciliation. It'll include reconciled errors or late entries from prior periods. Check that the Starting Balance matches the opening balance on your bank statement. As long as your reconciled balance matches the closing balance on your bank statement, the reconciliation is successful.

Target balance

This is the same as your Statement End Balance. At the end of your reconciliation, the Reconciled Balance will match.

Reconciled balance

A vital part of reconciliation. This is the total of reconciled transactions, plus the starting balance. The aim of any bank reconciliation is to make sure that the closing balance on your bank statement matches the Reconciled Balance in Sage Accounting. When you start, this will always match the starting balance. As you tick transactions, the reconciled balance updates. You finish the reconciliation when the reconciled balance matches the target balance and your bank statement.

Difference

When you start, this is the difference between the Starting Balance and the Statement End Balance. As you reconcile, the Difference updates. The reconciliation is successful when the difference is zero.

For example: The starting balance is £1000.

You have two payments to reconcile for £500 and £300, making a total of £800. This reduces your bank balance to £200.

When you start the balances are:

  • Starting Balance =1000
  • Target Balance =200 (1000 -800)
  • Reconciled Balance =1000
  • Difference = -800

The bank reconciliation screen showing a starting balance of £1000 and a target balance of £200. The difference shows as -£800 and there are 2 unreconciled transactions.

When you reconcile the first transaction, the reconciled balance is 500, and the difference is 300.

The user now marks the first £500 transaction as reconciled, showing a difference of -£300.

When you reconcile the second, the reconciled balance is 800, and the difference is zero.

The user now marks the second £300 transaction as reconciled, showing a difference of 0.