Skip to main content

How to Add a Customer Opening Balance

Learn how to add a customer’s opening balance, edit it, and understand how it reflects on the accounting system and reports.

Updated yesterday

The customer opening balance is the amount a customer owes at the start of a new financial period, resulting from old (goods or services) invoices that are still outstanding and have not yet been settled.


Steps to Add an Opening Balance

  • Go to Sales & Customers > Customers

  • If the customer already exists:

    • Search for the customer’s name.

    • Click the ⚙️ icon in the Actions column > Edit.

  • If the customer is new and not yet added to the platform:

    • Click New and add the required data:

      • Customer Name

      • Customer Code

      • Phone Number

ℹ️ For issuing VAT invoices (B2B), make sure to add:

  • Customer Tax Number

  • Commercial Registration Number or National ID

  • Address

To add the opening balance:

  • Tick the checkbox Set Opening Balance.

  • Select the date.

  • Enter the opening balance amount (must be entered as a positive value; negative amounts are not currently supported).

  • Click Save.

The opening balance will appear under the column Debit Amount from Customer.

How the Opening Balance Reflects

Journal Entries

  • Go to: Accounting > Journal Entries

  • The entry will reflect based on the opening balance date entered, not the date it was added.

Chart of Accounts

  • Go to: Accounting > Chart of Accounts > Equity > Opening Balance

Reports

  • Go to: Reports > Finance > Account Transactions

Edit an Opening Balance

You can edit the customer’s opening balance as long as no payment has been made.

  • Go to: Sales & Customers > Customers

  • Click the ⚙️ icon in the Actions column > Edit.

  • Update the date and outstanding balance.

  • Click Save.


FAQs

  1. I mistakenly added the wrong opening balance for a customer, can I delete it?
    No, you cannot delete an opening balance after saving. However, you can edit it from the customer’s details page, provided no payments have been made.

  1. Can I import customer opening balances using an Excel file?
    No, importing customer opening balances via Excel is not currently supported. They must be added manually within the platform.

Did this answer your question?