Candidates quote net retention as a single figure without being able to say what went into it, which an interviewer tests by asking for the arithmetic.
Cohort: the 10 accounts you had at the start of the year
Starting annual recurring revenue 1,000,000
During the year:
2 accounts churned entirely -140,000
1 account reduced its licence count -30,000
4 accounts expanded seats or modules +220,000
---------
Ending ARR from that same cohort 1,050,000
Gross retention = 1,000,000 - 140,000 - 30,000 = 830,000
830,000 / 1,000,000 = 83%
Net retention = 1,050,000 / 1,000,000 = 105%
Two numbers, one cohort, and the difference between them is the whole story. Gross retention counts only losses and is therefore capped at one hundred per cent; it answers "how much of what we had did we keep". Net retention adds expansion back in and can exceed one hundred; it answers "did this cohort grow".
The trap is reading the net figure alone. At 105% net and 83% gross this business is losing roughly a sixth of its revenue base every year and covering it with growth inside the surviving accounts. That works while the expansion holds and collapses the moment it does not, because expansion is concentrated in a handful of accounts while the losses are spread across many. An interviewer asking about this is checking whether you understand that a healthy net figure can conceal a retention problem that will surface a year later.
Two more details matter. New customers acquired during the year are excluded, otherwise you are measuring sales rather than retention. And the cohort must be fixed at the start of the period, or a shrinking denominator flatters the result.