Skip to content
logo Knowledgebase

Change a bank opening balance

Created on  | Last modified on 

Summary

How to correct a bank opening balance in Sage Accounting.

Description

It's important that your records in Sage Accounting match your actual bank balance. How you correct an opening balance depends on whether it’s reconciled.

  • If it's not reconciled, you can edit it
  • If it’s reconciled, you can either delete the latest reconciliation or add an adjustment

NOTE:

You can only delete a reconciliation if it’s the most recent one. If you have completed later reconciliations, you must add an adjustment instead.

Use Receipt (Debit) for positive balances and Payment (Credit) for overdrawn balances.

Resolution

Change a bank opening balance

  1. Go to Settings, then select Opening balances.
  2. Find the relevant bank account.
  3. If you haven't already reconciled your opening balance, enter the correct amount.
  4. If you've already reconciled your opening balance, choose one of the following:
    • If the opening balance isn’t part of the latest reconciliation, add a new row to adjust the balance
    • If it's part of the latest reconciliation, go to Banking, open the bank account, then delete the latest reconciliation. Return to Opening balances, then update the amount
  5. If you add an adjustment:
    • Select the same bank account
    • Check the date defaults to the day before your accounting start date
    • Select Receipt (Debit) to increase the balance, or Payment (Credit) to decrease it
    • Enter the difference between the incorrect and correct balance
  6. Save your changes.

EXAMPLE:

If you entered £100 but the correct balance is £90, enter a Payment (Credit) for £10.

After you correct your opening balance, if you need to reconcile it, follow our article to reconcile your opening bank balance.

View More...