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
- Enter the opening balances after adding or importing the customers. See Importing Data into "Subscriptions".
- Each customer has one balance in each currency.
- An opening balance doesn't create an invoice; it shows as the first line on the statement.
- The statement starts with the opening balance, then every invoice and payment. See Viewing a Customer Statement in "Subscriptions".
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?
Can a customer have a balance in two currencies?
Where does the opening balance show?
How do I enter many customers' balances?
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.