Churn and retention calculator
Turn customer counts and revenue into churn rate, retention rate, NRR and GRR.
Churn and retention calculator
Paste your subscriber counts and this tool turns them into the metrics a subscription business tracks every period: customer churn rate, customer retention rate, net revenue retention (NRR) and gross revenue retention (GRR). Enter one line per period as period;start;churned;new;revenue — for example Jan;500;40;25;12000 — and it works out how many customers you ended with, what share of the starting base you kept, and how revenue moved with them. Add more lines to see the trend over time.
The period option labels rows as months, quarters or years, which sets how the churn rate is annualized or converted to a monthly equivalent — handy when a monthly figure needs restating in annual terms. Turning on "Account for revenue expansion and downgrades" stops NRR and GRR from simply mirroring customer retention: it estimates how much of each period's revenue came from new customers rather than the existing base, so upsells can push NRR above 100% while GRR stays capped there to isolate churn and downgrades. "Show average customer lifetime" adds an estimate — 1 divided by the latest churn rate — of how long a typical customer stays. Pick a currency for the revenue figures and text or a tab-separated table for the layout.
A line that doesn't split into exactly five semicolon-separated fields, or where churned customers outnumber the starting count, is flagged with the offending text quoted back. Windows and Unix line endings both work, and the live tally under the output always shows the latest period's churn and retention rate as you type.
Everything runs locally in your browser — customer counts and revenue never leave your device. Copy the result, download it as a .txt file, or send it back to the input to add another period.