Revenue Churn: The Gross and Net Formulas, Worked Through Properly

Revenue churn is the proportion of recurring revenue you lose in a period from customers who were already paying you when the period began. It is a retention metric, which is why new customers are excluded from both the top and the bottom of the fraction. Adding them would let a strong sales month disguise a leaking base, and disguising exactly that is the failure mode the metric exists to prevent.

There are two versions because there are two questions. Gross revenue churn asks how much money left. Net revenue churn asks whether growth inside the existing base covered what left. Both are legitimate, they are not interchangeable, and the great majority of confused conversations about churn come from one person quoting the net figure while the other hears the gross one.

Gross

Gross revenue churn equals cancelled recurring revenue plus downgraded recurring revenue, divided by opening recurring revenue, times one hundred. Cancelled means the account ended and its recurring revenue went to zero. Downgraded means the account survived at a lower amount, and the figure used is the size of the reduction, not the whole account. Opening recurring revenue is the total for that same set of customers on the first day of the period, frozen and stored.

Net

Net revenue churn equals cancelled plus downgraded minus expanded, divided by opening recurring revenue, times one hundred. Expanded means increases in recurring revenue from that same opening group through upgrades, additional products, extra seats or higher usage. Because expansion can exceed losses, this figure can be negative, and a negative reading is good news.

The same month calculated both ways

Open the month with 20,00,000 in monthly recurring revenue across 260 customers. During the month, seven customers cancel, taking 60,000. Eleven customers downgrade, reducing their spend by 20,000 in total. Thirty-one customers expand, adding 1,10,000. New customers won in the month bring 3,40,000, which is excluded from both calculations.

Gross revenue churn is 80,000 divided by 20,00,000, or 4 per cent. Net revenue churn is negative 30,000 divided by 20,00,000, or negative 1.5 per cent. Both are correct and they describe the same month. A company reporting only the second one is telling the truth and leaving out the fact that four per cent of its opening revenue walked away.

The row that matters most is the fourth one. A business with severe cancellation and a few very fast-growing accounts can post attractive net churn indefinitely, right up until the growing accounts stop growing. Publishing the pair removes that blind spot at no cost.

The first is a moving denominator. If opening recurring revenue is recomputed from a live table each time the report runs, backdated corrections, late cancellations and currency revaluations all shift history, and last quarter's churn figure will not reproduce. Freeze the opening value for each period and store it as a fact.

The second is renewal discounts recorded as pricing rather than as contraction. When an account renews at a lower price to prevent it leaving, the recurring revenue fell and the metric should say so. Teams that exclude these on the grounds that the customer stayed end up with a healthy-looking churn number and no visibility at all into how much revenue is being conceded to hold the base together.

The third is unit confusion. Mixing annual recurring revenue in the numerator with monthly recurring revenue in the denominator, or comparing a monthly churn rate against an annual one without converting properly, produces figures that are wrong by an order of magnitude and are almost never caught, because nobody expects the error to be that large.

Good revenue churn is low on a gross basis, stable across quarters, and unremarkable in its reasons. It is spread thinly across many small accounts rather than concentrated in a few large ones, and it does not spike in the months following a price change or a release. When you segment it, the picture stays similar across plans and industries, which suggests the product is delivering roughly what it promised to everyone who bought it.

Bad revenue churn has a shape. It concentrates in large accounts, which means each event is a relationship failure that somebody could have seen coming. It clusters at renewal dates, which points to a value case that was never established after the sale. Or it appears mainly as contraction rather than cancellation, with accounts quietly shrinking every renewal, which is the slowest and most easily ignored version of losing a customer.

Gross retention is the complement of gross revenue churn and cannot exceed one hundred per cent. Net revenue retention is the complement of net revenue churn and can. Contraction is the downgrade component in isolation. Expansion is the growth term that separates the net calculation from the gross one. Logo churn measures the same events by customer count and will disagree whenever your customers are unequal in size, which is exactly when the disagreement is worth investigating.

More on retention, pipeline and the systems that make these numbers reproducible:what a CRM is, sales automation, AI lead scoring and insights, lead management software, CRM versus Excel, and product features.