Change a customer opening balance

Summary

How to change a customer opening balance if entered incorrectly or in error in Sage Accounting.

Description

You may have entered the wrong customer opening balance or entered a balance in error. Open the opening balance transaction to change or delete it.

If you have paid or allocated the opening balance, you must unallocate the payment first. You can then change it.

Resolution

Amend or delete an opening balance

  1. Go to Settings, then Business Settings. Scroll down to the Opening Balances section.
  2. Select Supplier.
  3. To edit an opening balance, select the opening balance transaction. Make the necessary changes and Save.
  4. You can delete an opening balance. Select the Delete button next to the relevant opening balance transaction.

The opening balance has been paid or allocated

If it's already allocated, you can't edit the opening balance

For opening balance invoices, this means the customers paid the invoice.

For opening balances that are credit notes, you've already allocated the credit note to an invoice or a refund.

Before you edit the opening balance, you need to unallocate it.

Unallocate an opening balance invoice

  1. Go to Contacts, then Customers. Select the relevant customer.
  2. Open the payment that's been allocated to the opening balance.
  3. Remove the tick from the opening balance and Save.
    Image

     

     

    You'll be shown a message asking if you want to save the payment as a payment on account. Choose Yes. You can then re-allocate the payment to the amended opening balance later.

     

Unallocate a refund

You can only create refunds for the exact amount of the credit note they are paying. You must delete the refund rather than unallocate it.

Once you've amended the opening balance, you can re-enter the refund if required.

  1. Go to Banking, then select the relevant bank account.
  2. From the Activity tab, select the check box next to the refund.
  3. Select Delete.



Related Solutions

Solution Properties

Solution ID
222001000100713
Last Modified Date
Wed Mar 13 13:39:37 UTC 2024
Views
0