Renewal Fix Guide
How to get NRR, GRR and renewal rate right in HubSpot
When renewal revenue is assembled in a spreadsheet at quarter end, the number you take to the board is stale the moment it is built and easy to get wrong. If you have ever thought 'I don't trust our forecast, but I have to defend it anyway,' this is why. Here is how to report NRR, GRR, and renewal rate accurately in HubSpot, starting with the fact that HubSpot does not have these reports.
- 1
Build the inputs · 30 min
HubSpot has no native NRR or GRR report, so you build the inputs first: a Previous Contract Value property (populated by workflow at renewal), a Deal Type (Renewal / Expansion / Contraction), and a Churn Reason.
- 2
The formulas · 10 min
Renewal Rate = renewed / due. GRR = (starting − contraction − churn) / starting. NRR = (starting + expansion − contraction − churn) / starting. As a health check, NRR above 110% is strong; GRR above 90%.
- 3
Build the reports, finish in a spreadsheet · 45 min
Create custom deal reports segmented by Deal Type and filtered to Pipeline = Renewal, then do the final division in a spreadsheet or BI tool. Partial automation exists only on paid tiers: Operations Hub Enterprise datasets, or Sales Hub Enterprise Revenue Analytics, which needs you to re-model onto HubSpot's recurring-revenue line-item properties.
- 4
Avoid the two traps · 10 min
Forecast by Renewal Date, not Close Date, or multi-year deals distort every quarter. And do not double-count expansion on both the renewal deal and a separate expansion deal.
↓ Download the NRR / GRR calculator template (CSV)
What this costs you to run by hand
The number leadership reports to the board is assembled by hand in a spreadsheet from custom reports, so it is stale the moment it is built and easy to get wrong: double-counted expansion, mixed pipelines, or Close Date instead of Renewal Date. Automating it properly means paying for Operations Hub or Sales Hub Enterprise and re-modelling your data. Meanwhile you are defending a figure you privately don't fully believe, every board meeting.
The faster way. The build snapshots ARR, MRR, and the full revenue waterfall daily and computes NRR and GRR for your renewal book without Operations Hub or Sales Hub Enterprise, with renewal type as a hard category so expansion is never double-counted. The audit's ARR integrity check tells you the exact percent your current reporting is off, and the specific deals that cause it.
Want the long version? Read HubSpot NRR and GRR dashboards for renewal revenue reporting.
Common questions
Our numbers are basically fine, aren't they?
Run three checks and see: double-count (ramped deals summed into one ARR figure), flat-line (year-2 increases invisible because line items share a start date), and term-blind (ACV equal to TCV means the term was ignored). If the gap is over 5 percent, decide which number the board should hear going forward.
Isn't this a finance or BI problem, not a HubSpot fix?
The reports are wrong by construction because the underlying deals are structured wrong: missing line items, no renewal dates, multi-year deals miscounted. Fix the renewal operations upstream and the reports come out right, without a separate BI project.
Find out how wrong your board number is
The renewal audit's ARR integrity check gives you the exact percent your reporting is off and the deals behind it, against your real portal. $600, credited in full toward any build. It starts with a free 30-minute call.
Book a Renewal Alignment Call