Renewal Billing Report

[Rolando]

I am looking to find a way to know much of my net billings (product and billing term) are renewal vs. new. Am I able to get this in one report? If not, what combination of reports would I need to run to get this information?

[Rolando · Accepted solution]

You can generally tell whether an invoice item is related to a renewal or new subscription by looking at the Subscription: Term Start Date and the Subscription: Subscription Start Date:

• if the term start date and subscription start date are the same, it's a new subscription
• if they are different, this should be a subscription that has been renewed for another term

Because of this logic, you will need to pull the data from our reporting feature and match up the dates in Excel and filter accordingly. We do not have an out-of-box method of accomplishing this exact report.

To start, you can use the "Gross billing over time" default report. From this report you can add the fields Subscription: Term Start Date and the Subscription: Subscription Start Date.

For more information please check out our Knowledge Center article regarding Customizing a Standard Report.

[DataCamp_HM]

I do not see the Gross Billing over time report.

I tried using the invoice report but that didn't have subscription information.
I tried using the invoice item but that has multiple rows for the same invoice(mainly for expansions and refunds).

I'm looking to get a report that shows all invoicing with a column that shows Net invoice amount (so exclude lines for refund/negative invoices and apply those to one of the positive invoices),
Quantity (Net quantity and not total new quantity, i.e. if customer expands from 5 to 10 seats I want it to show 5 for the invoice and not 10)
Subscription Term Start Date
Subscription Start Date
Subscription Term End Date
Subscription End Date
Type: New, Upgrade/Downgrade, Renewal -> If we can't get this and this needs to be calculcated in excel that is fine based on the logic mentioned above.