For context, we have a client who added on features to our product starting in June. They had their original contract started in January.
We’re pro-rating the addition so that they only pay from June to the end of the year. At the end of the year this will renew and be combined with their existing quote/deal at the end of the year.
The add on cost $4000 for the year, the pro rated cost is $2333. Monthly the cost is $333.
On this quote we created if we use one time billing of $2333 we don’t get arr/mrr fields calculated which we would like to have as it will be recurring. If we do recurring annually the MRR and ARR are correct, however the TCV becomes $4000. We only want to count what we’re adding for the rest of this year ($2333) as the TCV since that is the net new for this year.
How can we achieve the correct numbers. Can you pro-rate billing so that if we did an annual subscription but it starts in June, what would the TCV be for the remainder of this year?
Hi, @DrewSlade ,
I’ve done this for another client. The key is to not have the products with an annual value in the first place. Have them as a monthly value. Then, you can co-term the existing product with the new that’s pro rata and this way you can get the correct values.
I hope that helps,
Eli
Hi @elizheleva, thanks for sharing. In your experience, could this work even if the billing frequency is set to Annual instead of Monthly?
Let’s say I’ve already set the line item as a monthly amount, and I set the term to 9 months (since I’m prorating it to match the existing subscription). When I do this, I can’t set the billing frequency to annual because it has to be a multiple of the term… ![]()
Thanks in advance!
It’s butchery but it works…
Set you original line item to the 12 month amount.
Then add a second line ited, set the value to 0, and the discount to the difference between the 12 month amount and the reduced amount for part of the year. For the discount line item, set it to “One-time” and your ARR should be calculated correctly
We have the same issue. What we do it add the 12 month line item to the quote, then use the quote discount line item to show the pro-rated credit applied for that term. The customer sees what they are going to pay annually, the ARR is correct, and the amount the customer pays is correct too.
Hi @JFrost
Thanks for sharing how you’re handling it — that’s a really practical approach, and I’m sure it’ll help others who are running into the same MRR/ARR/TCV mismatch with proration.
I’d love to pull in a few Community members who are deep in quoting/subscriptions to see if there are any product-native improvements or alternative patterns teams are using.
@karstenkoehler @Mike_Eastwood @RubenBurdin — hope you’re all having a great week! Have you seen other reliable ways to represent pro-rated terms while keeping MRR/ARR/TCV accurate, or is the “annual line item + discount credit” pattern the most common/clean workaround today?
Appreciate any insights you can share here.
Victor
We are no longer quoting out of HubSpot, but when we were, we created a custom deal property that would multiply the Monthly Recurring Revenue property by 12. The Monthly Recurring Revenue field on the deal object is a standard HubSpot property. We then used that custom ARR property on any reports and forecasts.
@JFrost Can you by chance post a screen shot of what this looks like? I’m having trouble visualizing it in my head.
@JFrost How do you get it to subtract off the amount due on quotes? I’m unable to enter a negative amount on line items.
That’s correct, it needs to be set to monthly in order to co-term. The issue, and I have asked our HubSpot consultant about this, is that the ARR does not calculate correctly for terms that are not 12 months. It sets it the same at the total amount.
Hi Eli
i dont think this solution works - as the ARR is incorrectly calculated.
If you required upsell of users, and sold 9 months left - you ARR is increasing by 12 months = 1200. I think the problem lies in the Billing Terms not able to process that this will be renewable at the full ARR. This is because choicing “renew until cancelled” then defaults the duration to 0 - and you cannot change it as it defaults back to fixed payments.
I am really struggling with this issue at the moment. We have a quoting tool that geenrates our line items however i cannot post the terms (number of months) value to hubspot under the current configurations.
1. The property is a text field hs_recurring_billing_period
2. Its limitations in the calculations that Annual Billing Frequency or even Once-Off cannot have a value in the property that effects the ARR.
This is a big annoyance currently. HubSpot should make it easier to do pro-rata purchases.

