Correct a customer or supplier opening balance
Description

To correct an incorrect customer or supplier opening balance in Sage 50 Accounts, you can post another opening balance to reverse the original then enter the correct opening balance. Let's do this now.

Cause
Resolution

Correct an opening balance

  1. Click either Customers or Suppliers, then select the required record and click New/edit or Edit.
  2. In the Details tab, under Balance click the   button and enter the following details:

    RefO/Bal correction
    DateEnter the original opening balance date.
    TypeIf the original opening balance was a invoice, select Credit.

    If the original opening balance was a credit, select Invoice.
    Gross - Standard VAT onlyEnter the gross value of the correction.
    Net - VAT Cash Accounting onlyEnter the net value of the correction.
    T/C - VAT Cash Accounting onlyEnter the tax code on the original opening balance.
    VAT - VAT Cash Accounting onlyEnter the VAT value of the correction.
  3. Click Save then, under Balance, click the  button.
  4. Enter the required Ref and Date and enter the correct opening balance and click Save.

Once posted, you must allocate the opening balance correction to the original opening balance:

  • Customers - for help allocating, please refer to the section Allocate credit notes or payments on account to invoices, in this article >
  • Suppliers - for help allocating, please refer to the section Allocate credit notes or payments on account to invoices, in this article >


[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions