Skip to main content

How to Add a Customer’s Opening Balance

Updated over 2 months ago

The opening balance is the amount owed by the customer at the beginning of a new financial period, resulting from previous unpaid invoices for goods or services.

Steps to Add an Opening Balance

1. Go to:
Sales & Customers > Customers

2. If the customer already exists:

  • Search for the customer’s name.

  • Click the gear icon (⚙️) under the "Actions" column > Edit.

3. If this is a new customer:

  • Click New and fill in the required details:

  • Customer name

  • Customer code

  • Customer phone number

ℹ️ When issuing tax invoices (B2B), make sure to enter:

  • Customer's VAT number

  • Commercial registration number or national ID

  • Address

4. To add the opening balance:

  • Check the box Set Opening Balance (✔)

  • Set the date

  • Enter the balance amount (must be a positive number; the system does not support negative values)

  • Click Save
    The data will be saved successfully. The opening balance will appear under Amount Due from Customer

Where the Opening Balance Reflects

  1. Journal Entries
    Go to: Accounting > Journal Entries
    The entry reflects based on the selected opening balance date, not the date it was added.

  2. Chart of Accounts
    Go to: Accounting > Chart of Accounts > Equity > Opening Balance

  3. Reports
    Go to: Reports > Financial > Account Statements

Editing the Opening Balance

You can edit a customer's opening balance before any payment is recorded.

Steps:

  • Go to Sales & Customers > Customers

  • Click the gear icon (⚙️) > Edit

  • Update the opening balance date and amount

  • Click Save


FAQs

  1. I entered an opening balance by mistake. Can I delete it?
    Unfortunately, you can’t delete the opening balance once it’s saved. However, you can edit it from the customer’s profile as long as no payments have been made.

  2. Can I import opening balances using an Excel file?
    No, importing customer opening balances via Excel is not currently supported. You must add them manually within the platform.

Did this answer your question?