PlumHelp
Help · Revenue

Importing licenses

Bring your existing customers' recurring revenue in from a spreadsheet, so ARR and the revenue reports start from the right numbers. Nothing is recorded until you've checked the preview.

Owners, admins and revops

Open Bring your data, linked from the Get set up checklist on the Overview, from Integrations and from the other import pages, and select Licenses. It works with Excel, Google Sheets and Numbers.

  1. Choose an Excel (.xlsx) or CSV file, or copy the rows from your spreadsheet, header row included, paste them in and select Continue. In an Excel file, the first sheet is read.
  2. Match your columns. Company and Start date are required, with either a Monthly amount or an Annual amount. End date, Term in months, Status, Offer and Company website or domain are optional.
  3. Check the preview. Rows that can't be recorded are listed by row number with the reason.
  4. Select Import.

What Plum reads

  • Amounts such as $4,000, 4k or 1.2M. An annual amount is divided by 12 to give the monthly amount.
  • Dates such as 2026-11-14, Nov 14, 2026 or 14 Nov 2026, and dates in Excel files as they are. Dates with slashes are read month first.
  • Terms such as 12, 12 months or 1 year.
  • Status: active, live and current read as Ongoing; lost and expired as Lapsed; complete and ended as Completed; Renewed and Churned as themselves. A blank status is Ongoing. Any other word is reported, not guessed.
  • Offer: the name of an offer in your library, ignoring case. A blank is fine; a name the library doesn't have is reported.
  • Companies are matched to accounts by website or domain, then by name, ignoring case and spacing. A company with no match becomes a new account.

What happens

Either every license is recorded or none is. Each one is recorded exactly as if you had typed it in on the account: the earliest license on an account is its new customer revenue, later ones are expansion, and an account with an ongoing license becomes a customer.

A license already on the account with the same start date and monthly amount is left as it is, so importing the same sheet twice is safe. Afterwards, the page says how many licenses were recorded and how many were already there.

A license whose status is churned, lapsed or completed has already ended. It needs its end date, and Plum records it as revenue that arrived on its start date and left on its end date, so past years' retention includes it. To record a customer leaving today, end their license from its page instead, where you can give the reason.

You can import up to 2,000 rows at a time.

Related