Bank reconciliation

You can use the bank reconcile option to match the bank transactions entered in Sage One with those on the statement from your bank. Reconciling these values means the bank balances and transactions are accurate.

You should reconcile your bank account each time you receive a statement from your bank. Before reconciling your bank account, you should make sure you’ve entered all of your transactions up to the end of your bank statement. If you use an online banking service, you may be able to download your bank transactions instead of entering them manually.

Watch a video

Downloaded bank transactions

If you use Bank feeds or the Import Statement option to download your bank transactions. This saves time as the transactions are automatically marked as reconciled in the Bank Reconciliation option.

You can’t reconcile cash accounts.

The downloaded transactions also have a cleared status. If you want to amend or delete an imported payment or receipt, you must remove the status first.

To remove a cleared status
  • 1. Banking > click relevant bank account link.
  • 2. Activity > select the check box for the relevant transaction.
  • 3. More > Remove Cleared Status.

The cleared status is removed.

To reconcile your bank account

  • 1. Banking > click relevant bank account link.
  • 2. Connect to Bank drop-down arrow > Reconcile.

If you use bank feeds and have already connected to your bank, click X New Transactions drop-down > Reconcile.

  • 3. Enter the following information:
Statement Date * Enter the end date of the actual bank statement you’re about to reconcile.
Statement End Balance * Enter the ending balance from the bank statement.
Reference Enter a reference for this reconciliation, for example, you could use the statement page number or date.

* These details are compulsory.

  • 4. Check the bank account is correct > Apply.

If you previously started a bank reconciliation and saved it for later, the saved reconciliation appears. If you want to undo this reconciliation, amend the statement date and end balance as required and apply the changes > Interest and Charges drop-down menu > choose Unreconcile All Entries > OK.

  • 5. Complete the bank reconciliation as follows:
  • To reconcile all transactions at once > Interest and Charges drop-down menu > Reconcile All Entries.
  • To reconcile transactions one at a time > for each transaction select the check box in the Reconciled? column.
  • To unreconcile a single transaction matched in error > clear the check box in the Reconciled? column.
  • To unreconcile all transactions at once if matched in error > Interest and Charges drop-down menu > Unreconcile All Entries.
  • To record bank interest or charges > Interest and Charges > complete the relevant information > Save.

As you reconcile your transactions the reconciled balance adjusts. The starting balance is your last reconciled balance. Once you’ve reconciled all of your transactions, the reconciled balance should match the target balance and the difference should be zero. If the difference isn’t zero, please refer to the following sections.

The reconciliation is not reversible. If required, you can save the reconciliation and return to it later, for example if you can’t reconcile the difference to zero now. To save the reconciliation, from the Finish drop-down menu, choose Save for later.

  • 6. Click Finish.
  • 7. To print details of the reconciliation, click Print.

Depending on your Internet browser, the report opens in a new window or tab. You can print the report from your browser menu bar then close the new window or tab.

You’ve successfully reconciled your bank account. When you view the bank activity a tick appears against the transactions in the reconciled column. You can view details of this and previous reconciliations from the Banking tab > click the required bank account > Reconciliations.

The bank activity shows all your bank transactions. If a transaction has previously been reconciled, a tick appears in the Reconciled? column.

A transaction doesn’t appear in the Bank Reconciliation option

The Bank Reconciliation option only shows transactions that are currently unreconciled and are dated on or before the statement end date for the specified bank.

If a transaction doesn’t appear:

  • Check you’ve entered the correct statement date. Only transactions up to and including this date are available to reconcile. If the date is incorrect, enter the correct date > Apply > check the transaction appears.
  • Check if the transaction has already been reconciled. To do this, save the reconciliation you’ve done so far by choosing Save for Later from the Finish drop-down menu. Activity > Refine > check the from and to date covers the date of the transaction and that transaction appears. If it does appear and there’s a tick in the Reconciled? column, the transaction has already been reconciled.
  • If the transaction doesn’t appear on the bank activity, check the from and to date are correct. It may be possible the transaction was entered with a date outside the range. To make sure it hasn’t been entered with an incorrect date, try entering a date range for example, 01/01/2000 to 31/12/2020. If the transaction has been entered with an incorrect date, save the reconciliation you’ve done so far by choosing Save for Later from the Finish drop-down menu. Activity > click the relevant transaction > amend the date > Save.
  • If the transaction still doesn’t appear, check the activity of your other bank accounts to make sure it hasn’t been entered against a different account. If it has, delete the transaction then re-enter it using the correct account.
  • If the transaction isn’t showing against any of your other accounts, it’s likely it hasn’t yet been entered into Sage One. You should enter all of your transactions up to your statement end date before reconciling your bank account.

The difference isn’t zero

If you can’t reconcile the difference to zero:

  • Check the Statement End Balance is correct. If it isn’t, enter the correct amount > Apply > check the difference is now zero.
  • Ensure the correct transactions have been reconciled and none have been missed. If you’ve reconciled a transaction in error > clear the Reconciled? check box.
  • Check the value of your reconciled transactions. If a transaction has been entered with the incorrect value > clear the Reconciled? check box. You can then save the reconciliation that you’ve done so far and return to the bank activity. From here you can click the relevant transaction and amend the value.

Let us know what you think...