Participante

## Calculation rolling revenue(in Year)

resolver

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!

Solución
Colaborador líder | Partner nivel Elite

## Calculation rolling revenue(in Year)

resolver

@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 workflowsCreate 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.

 Hannah Fisher CRM Platform Consultant @ Elite HubSpot Partner BabelQuestUnlock the potential of HubSpot

 Did my post help answer your query? Help the Community by marking it as a solution
1 Respuesta 1
Solución
Colaborador líder | Partner nivel Elite

## Calculation rolling revenue(in Year)

resolver

@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 workflowsCreate 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.

 Hannah Fisher CRM Platform Consultant @ Elite HubSpot Partner BabelQuestUnlock the potential of HubSpot

 Did my post help answer your query? Help the Community by marking it as a solution