Hi, I’m submitting this idea post on behalf of my customer.
My customer would like the default deal property, Monthly Recurring Revenue (MRR), to be capable of reflecting dynamic, point-in-time MRR based on the billing start and end dates of the different recurring line item(s) added to the deal.
At the moment, the MRR property is defined as:
- Monthly recurring revenue (MRR): the recurring revenue each month for this deal. This is calculated using the values and term length of the recurring line items associated to the deal (i.e., the total value divided by the number of months in the term length). It does not take into account the value in the Amount property. This is shown in the deal’s currency, if your HubSpot account uses more than one currency.
In my customer’s use case, they sell monthly subscriptions, and sometimes they offer their customers a one month free trial, and then 50% off for the next three months, before they start paying the actual monthly price. Example below:
- Product: Starter Plan at $169 per month
- Line item 1:
- 1 month free trial, i.e. $0
- Billing period: 1st November - 30th November 2025
- Line item 2:
- 50% discount for the next 3 months i.e. $84.50 per month
- Billing period: 1st December 2025 - 28th February 2026
- Line item 3:
- Actual price, i.e. $169 per month
- Billing period: Starting from 1st March 2026, Automatically renew until cancelled
What they’re hoping to see is:
- If they’re looking at the deal’s MRR in November 2025, the MRR property should reflect $0.
- If they’re looking at the deal’s MRR anytime between December 2025 and February 2026, the MRR property should reflect $84.50.
- If they’re looking at the deal’s MRR anytime from 1st March 2026 onwards, the MRR property should reflect $169.
However, the way the MRR property works at this time is that it takes the total value divided by the number of months in the term length. So in the example above, the deal’s MRR property currently shows $253.50, and will not change based on the date you’re viewing it.
It would be great if there’s a built-in way to track the deal’s dynamic, point-in-time MRR based on the billing start and end dates of the different line items added to a deal.
This is also discussed here and here.
Thank you!