Two teams can report different NRR figures from the same customer base because they have used different periods, revenue definitions, or rules for reactivations. The first task is to agree the calculation, not to choose a chart.
Write down the cohort and revenue basis
Choose the customers with recurring revenue at the start of the measurement period. Record their starting recurring amounts using one basis, such as MRR. Keep that customer set fixed while tracking the period.
New-customer revenue does not belong in the existing-customer retention calculation. Agree how you handle currencies, usage-based charges, paused accounts, and reactivations before comparing reports. Keep one documented definition.
Reconcile the account-level movements
For each starting account, identify churn, contraction, and expansion using the same basis. Check the opening amount, movements, and closing amount. Investigate discrepancies before they become a portfolio percentage.
Common problems include mixed billing periods, duplicate customer records, contract amendments recorded twice, or a one-time service fee treated as recurring revenue. The source owner needs to help resolve these.
Calculate and check the result
NRR equals starting recurring revenue minus churn and contraction plus expansion, divided by starting recurring revenue, multiplied by 100. A zero starting amount makes the rate undefined; report it as unavailable rather than manufacturing a percentage.
Keep the opening customer count and revenue next to the result. Compare account-level totals with the source and review changes to your definition. A consistent method is essential when you compare periods.
Make the report useful to the team
Show the movements and the accounts behind them. Give leaders enough context to understand concentration, changes in account mix, and unresolved data issues. Record who owns the calculation and when the source was last updated.
Use the report to guide investigation and planning. The metric describes an outcome for a cohort; it does not explain why an individual customer expanded or left. That still requires the account story.
Write the movement rules before building the spreadsheet
Choose the recurring revenue basis, review period, and starting customer group. Decide how your reporting treats contraction, churn, expansion, and reactivation, and document those choices. New-customer revenue should not be mixed into the existing-customer retention calculation.
Use your billing or finance source for recognised revenue movements rather than deriving them from product activity. A rise in usage may suggest something to investigate, but it is not a billed expansion. Keep operational signals and revenue movements connected without treating them as interchangeable.
Reconcile an account before trusting the portfolio total
Choose an account with several changes during the period and trace its opening amount, movements, and closing amount. Check dates, currency handling, discounts, plan changes, and account mapping against the agreed source. Resolve unexplained differences before adding more charts.
A second account may expose a different edge case, such as several subscriptions under one customer. Record the rule your team uses and apply it consistently. This work can look less impressive than a dashboard, but it gives the report a foundation that colleagues can inspect.
Preserve the starting group during analysis
When filtering a report, check whether you are following the original group or selecting customers based on their later status. Excluding customers because they subsequently left can distort the question the cohort was meant to answer. Keep the selection rule visible beside the result.
If your team uses several segment definitions, label them clearly. A current-segment view and an original-cohort view can both be useful, but they answer different questions. Do not compare their percentages as if they were the same measure.
Make the operational review separate from the calculation
Once the report reconciles, choose material movements for investigation. Ask which customer need changed, what evidence is available, and who will review the account context. The number tells you where to look; it does not establish why a customer expanded or left.
Bring the findings back to the team with a bounded next step. Keep definition changes in a log so the next review can distinguish an operating change from a reporting change. That makes the report more useful than a headline percentage whose meaning shifts from month to month.
Put it into practice
- Define the starting cohort and revenue basis.
- Document movement and reactivation rules.
- Reconcile the contributing account records.
- Name an owner for the calculation.
References & further reading
PUT THE IDEA TO WORK
Analytics & Reporting in atEaseAI
Connect customer context with the next step your team needs to take.