Importing Data into "Subscriptions"
Last updated: November 17, 2026
When you move to "Subscriptions" from another system or from spreadsheets, you have hundreds of customers and subscriptions, and each subscription has past cycles invoiced there. Entering them one by one takes days, and a customer gets invoiced twice if an old cycle goes in as a new one.
The import brings them all in from Excel files, and checks every row before it adds anything, showing the rows held back and why. A cycle the old system invoiced comes in invoiced, with no new invoice.
Follow the Steps
The Import Order
Each list has its own import from "More" › "Import", and each has a template from "Download template". Because each list refers to the ones before it by name, import in this order:
- Customers.
- Products.
- Plans, with their products, prices and limits.
- Subscriptions, with their cycles and each cycle's lines.
Note: Set the "Subscriptions start date" in the settings before importing subscriptions, because the check rejects any cycle that ends before it. See Setting Up "Subscriptions" Settings.
The Three Subscription Files
- Subscriptions: a row per subscription, with Name and Customer Name, plus Workspace, Reference, Sales Person, Contract Date and Service Start Date if you have them.
- Cycles: a row per cycle, with Cycle Key, Subscription Name and Plan Name, plus Start Date, Length, End Date, Status and Invoiced. Previous Cycle Key links the cycle to the one before it in the same subscription.
- Cycle lines: a row per product in each cycle, with Cycle Key and Product Name, plus Quantity, Unit Price, Tax and the discount.
So a subscription is linked to its cycles by its name, and a cycle to its lines by its key.
"Current" or "Historical"
- Current: today's subscriptions and their cycles. Invoiced = Yes only on a cycle that started before the "Subscriptions start date", because the old system invoiced it, and never on a "Draft" cycle.
- Historical: cycles that ended before the "Subscriptions start date", all invoiced, so Invoiced = Yes on every cycle.
A cycle with Invoiced = Yes comes in invoiced, with no new invoice and no revenue schedule.
Importing Subscriptions
- From the "Subscriptions" list open "More" › "Import".
- Under "Upload" choose "Current", and attach the three files.
- Under "Check" every row held back shows with its reason, such as a plan that wasn't found.
- Fix the file and attach it again, then review the "Preview" and import.
Some reasons a row is held back in the "Check":
- A customer, plan or sales person that wasn't found.
- A missing or invalid date.
- A Length or Exchange Rate that isn't greater than zero.
- A Previous Cycle Key for a cycle in another subscription.
- A cycle that ends before the "Subscriptions start date".
Important Things to Know
- Import the customers, products and plans before the subscriptions, because the subscriptions refer to them by name.
- The import adds nothing until every row passes the "Check".
- An imported invoiced cycle doesn't get a new invoice.
- After the import, enter each customer's balance under "Opening balances". See Entering and Importing Customer Opening Balances in "Subscriptions".
Try It Yourself
Sample data — it doesn't affect any real data. Open "More" › "Import", attach the three files, then fix the row held back and import.
You May Be Wondering
In what order do I import?
What's the difference between "Current" and "Historical"?
Are invoices issued for imported cycles?
What do I do with the rows held back?
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.