Skip to content

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:

  1. Customers.
  2. Products.
  3. Plans, with their products, prices and limits.
  4. 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?
Customers, then products, then plans, then subscriptions.
What's the difference between "Current" and "Historical"?
"Current" is for today's subscriptions and their cycles, and "Historical" for cycles that ended before the "Subscriptions start date", all invoiced.
Are invoices issued for imported cycles?
Not for a cycle with Invoiced = Yes; it comes in invoiced because the old system invoiced it.
What do I do with the rows held back?
Fix them in the file using the reason shown beside each, then attach the file again.

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.