Calculation rolling revenue(in Year)

Smart CRM & Sales Hub Dashboards & Reporting
1

Hello everyone,

I would like to achieve the ability to collect monthly fee data for a Deal using line items and present the total amount for the year in a report. For example, let’s say we have a Deal (Deal A) that has reached the Close Won stage, and we have associated a line item with this Deal. I would set the Billing Start Date as 02/01/2023, the Term (in months) as 12, the Billing Frequency as Month, and the Unit Price as $25,000.

Based on the above setup, I want to be able to see in the report how much I should charge this customer by the end of the year. Using the example mentioned, it is currently June, and we have already passed 4 months since 02/01/2023. So, I should charge a total of 4 * $25,000 = $100,000. Of course, if it were the end of the year (12/31/2023), I would expect to see $250,000 on the report.

My question is, is it possible to set it up this way? If not, what approach should I take? Thank you all in advance!

2

@samike - A few ways I can think of achieving this..

  • Use the recurring revenue report in HubSpot: Track recurring revenue in HubSpot
  • Build a dataset to calculate the number of months between the billing start date and today’s date and multiple the line items MRR by this: Create and use datasets
  • Create a custom-coded workflow action that calculates the time in months between the ‘Billing start date’ and ‘Today’s date’ and copies the value across to a custom ‘Months active’ number property. Create a calculation property that multiples the value in ‘Months active’ and the value in the ‘MRR’: Create workflows & Create calculation properties

N.B Option 2 & 3 require use to create a ‘Today’s date’ property that enrolls into a workflow every day and stamps the property with the date of the step.