Sales Hub Tools

ABarr
Membro | Parceiro Diamante
Membro | Parceiro Diamante

Line Items Reporting - recurring revenue

resolver

Hi all,

I'm trying to report on recurring revenue with a "billing start date" and "billing frequency" that should be the end of the billing date.

 

I did manage to create a report for this, but the issue is that even though I set the billing frequency be 4 months for example, it still shows recurring revenue after the 4 months as well. 

This happens for all the deals, so unless I filter them out somehow, they will still be shown in the report, even if they ended up paying.

 

Ideally, I would like to see all recurring revenue monthly- past and future in one report to see the curve.

 

Am I missing something here? 

 

Thanks for the help!

 

0 Avaliação positiva
2 Solução aceitas
TomasVR
Solução
Membro

Line Items Reporting - recurring revenue

resolver

Hi,

To report on recurring revenue with a "billing start date" and "billing frequency" that represents the end of the billing date, you can follow these steps:

  1. Create a report using the desired criteria, including the "billing start date" and "billing frequency" fields.

  2. To filter out deals that have already ended, you can add a filter based on the current date. This will exclude any deals that are past their billing end date.

  3. If you want to see both past and future recurring revenue in one report, you can remove the filter mentioned in step 2. This will include all deals, regardless of whether they have ended or not.

By adjusting the filters and criteria in your report, you can get the desired view of recurring revenue and visualize the curve.

I hope this helps! 

 

Exibir solução no post original

HFisher7
Solução
Orientador(a) | Parceiro Elite
Orientador(a) | Parceiro Elite

Line Items Reporting - recurring revenue

resolver

@ABarr - What is your subscription type? On Enterprise, you'll be able to access the Revenue Analytics report: https://knowledge.hubspot.com/deals/track-recurring-revenue-with-revenue-analytics


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

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

Exibir solução no post original

4 Respostas 4
DaveParry
Colaborador(a) | Parceiro Elite
Colaborador(a) | Parceiro Elite

Line Items Reporting - recurring revenue

resolver

We have developed a solution for this and written it up as a short case study here: 

 

https://www.wellmeadow.co.uk/case-study-revenue-forecasting-using-hubspot

0 Avaliação positiva
HFisher7
Solução
Orientador(a) | Parceiro Elite
Orientador(a) | Parceiro Elite

Line Items Reporting - recurring revenue

resolver

@ABarr - What is your subscription type? On Enterprise, you'll be able to access the Revenue Analytics report: https://knowledge.hubspot.com/deals/track-recurring-revenue-with-revenue-analytics


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

Did my post help answer your query? Help the Community by marking it as a solution
TomasVR
Solução
Membro

Line Items Reporting - recurring revenue

resolver

Hi,

To report on recurring revenue with a "billing start date" and "billing frequency" that represents the end of the billing date, you can follow these steps:

  1. Create a report using the desired criteria, including the "billing start date" and "billing frequency" fields.

  2. To filter out deals that have already ended, you can add a filter based on the current date. This will exclude any deals that are past their billing end date.

  3. If you want to see both past and future recurring revenue in one report, you can remove the filter mentioned in step 2. This will include all deals, regardless of whether they have ended or not.

By adjusting the filters and criteria in your report, you can get the desired view of recurring revenue and visualize the curve.

I hope this helps! 

 

MCarter9
Participante

Line Items Reporting - recurring revenue

resolver

Hello Tomas,

 

I'm having a similiar issue to the original poster and would like to try your work around. Can you give more details around how to get the monthly view of each of my Line Items from their Billing Start Date to the end?

 

Thanks!

0 Avaliação positiva