Skip to content

Entering and Importing Customer Opening Balances in "Subscriptions"

Last updated: November 17, 2026

When you start working in "Subscriptions", some customers still owe you for invoices from the old system that haven't been paid. If you don't enter these amounts, the customer's statement starts from zero, and shows them owing less than they actually do.

The opening balance is what each customer owed on the day Subscriptions went live, in each currency they deal in. It's entered once, and it's the first line on their statement, followed by the subscription invoices and payments.

Follow the Steps

The Balance Date

Every opening balance is dated on the "Subscriptions start date" in the settings, the day Subscriptions went live, such as 2026-01-01. So set it before entering the balances. See Setting Up "Subscriptions" Settings.

Entering Opening Balances

  • Check the "Subscriptions start date" under "System" › "Settings" › "Subscriptions".
  • From "Subscriptions" open "Customers", and click "Opening balances".
  • Type each customer's "Opening balance" in its currency, such as EGP 12,000 for "Pioneers Factory", then click "Save".
  • Open "View statement" from the customer's menu, and the balance shows at the top of the statement.

"Opening balances" has a row for each customer in each currency they deal in. So "Horizon Distribution" has two rows: a balance in pounds, and a balance of USD 350.

Note: To enter many customers' balances in one go, click "Export" to download the list as an Excel file, type the balances in it, then "Import".

Important Things to Know

Try It Yourself

Sample data — it doesn't affect any real data. Click "Opening balances", change any customer's balance, then click "Save".

You May Be Wondering

What date is the opening balance recorded on?
The "Subscriptions start date" in the settings, for every balance.
Can a customer have a balance in two currencies?
Yes, each customer has a balance in each currency they deal in.
Where does the opening balance show?
At the top of the customer's statement, before the invoices and payments.
How do I enter many customers' balances?
Click "Export", type the balances in the file, then "Import".

If you encounter any challenges or have questions during these processes, you can contact our technical support team, who are ready to assist you at any time.