Key takeaways
- Recurring only. Setup fees, services, hardware, and taxes are revenue but they are not MRR.
- Normalise to a month. An annual contract contributes one-twelfth of its value each month.
- ARR is a run-rate, not a forecast. It assumes the current month repeats twelve times.
- Churn and expansion decide the trend. Gross MRR growth can hide a shrinking base.
- MRR is not cash. Prepayment puts money in the bank before it is earned.
What counts as MRR
MRR includes subscription fees that recur on a predictable schedule, normalised to one month. A monthly plan contributes its monthly price. An annual plan contributes one-twelfth of its annual value. A quarterly plan contributes one-third of its quarterly value. A usage-based plan contributes an average or a committed minimum, and the choice must stay the same from month to month.
MRR excludes anything that does not recur: onboarding and implementation fees, professional services, training, hardware, shipping, and sales tax or VAT collected on behalf of a government. It also excludes one-off overage charges unless you have decided that committed usage is part of the recurring product, in which case state the rule and apply it every month.
The test is not whether the money is welcome, but whether a customer could reasonably cancel it next month. A fee that appears once is revenue; a fee that repeats is MRR.
The formulas
Base MRR = paying customers × average monthly revenue per customer
Total MRR = base MRR + monthly expansion revenue
ARR = MRR × 12 | ARPU = MRR ÷ paying customers | Expansion share = expansion ÷ MRR × 100
Worked example: 100 customers at $50 gives $5,000 of base MRR. Adding $500 of expansion from upgrades and add-ons gives $5,500 total, $66,000 ARR, and $55 ARPU. Expansion supplies 9.1% of MRR. With no expansion, ARPU equals the average monthly charge and ARR is simply twelve times the base.
Two edge cases need an explicit rule rather than a default. At zero customers ARPU and the expansion share are undefined, not zero, and a report should say so. At zero MRR the same applies. Silently printing 0.0% hides the fact that there is no base to divide by.
Three worked scenarios
| Customers | Avg monthly | Expansion | MRR | ARR | ARPU | Expansion share |
|---|---|---|---|---|---|---|
| 100 | $50 | $500 | $5,500 | $66,000 | $55.00 | 9.1% |
| 250 | $99 | $0 | $24,750 | $297,000 | $99.00 | 0.0% |
| 40 | $500 | $2,000 | $22,000 | $264,000 | $550.00 | 9.1% |
The third business has 40 customers and nearly the MRR of the second with 250, which is the point of ARPU: it describes the shape of the revenue base. A high-ARPU, low-count business is more exposed to losing any single customer, and a low-ARPU, high-count business has more diversification and more support load per dollar.
Churn: logo, gross revenue, and net revenue
Logo churn counts customers: lost customers ÷ starting customers. Revenue churn weighs them: lost MRR ÷ starting MRR. If 4 of 100 customers leave and they were paying $200 in total against $5,500 of opening MRR, logo churn is 4.0% and gross revenue churn is 3.6%.
Both are gross measures: they ignore expansion. Net revenue retention includes it, and it is the metric that tells you whether the existing base is growing or shrinking on its own:
NRR = (starting MRR + expansion − contraction − churn) ÷ starting MRR
Worked example: starting MRR $50,000, expansion $3,000, contraction $2,000, churn $2,500. NRR = (50,000 + 3,000 − 2,000 − 2,500) ÷ 50,000 = 48,500 ÷ 50,000 = 97%. Above 100% means the existing base grows without a single new logo; below 100% means new sales are replacing lost revenue before they add to it.
Growth efficiency: the quick ratio
NRR excludes new customers by design. Add them back and you get a measure of how efficiently growth is being bought:
Quick ratio = (new MRR + expansion MRR) ÷ (churned MRR + contraction MRR)
With $6,000 of new MRR and $3,000 of expansion against $2,500 of churn and $2,000 of contraction, the ratio is 9,000 ÷ 4,500 = 2.0. A ratio above 1 means the base is growing; a ratio well above 4 often means the company could profitably spend more on acquisition, while a ratio below 1 means the business is filling a leak.
A monthly MRR bridge connects all of this. Starting MRR $5,000, new $600, expansion $300, contraction $100, churn $250, ending $5,550. Every movement has a name and a number, and the bridge ties to the billing system in a way that a single growth percentage cannot.
MRR is not cash
An annual prepayment of $12,000 puts $12,000 in the bank on day one and contributes $1,000 of MRR. Cash flow is strong in the month of the sale and weak in the eleven months that follow, while MRR stays flat. A business that plans spending on collections rather than on MRR can feel rich in January and constrained in June.
Accounting makes the same separation. Under IFRS 15, revenue is recognised when the performance obligation is satisfied, which for a subscription is over the service period; the prepayment sits as a contract liability until it is earned. MRR is a management metric aligned with that recognition pattern, not with the bank statement, and deferred revenue is the bridge between the two.
MRR also ignores taxes collected and pass-through charges, which are liabilities rather than revenue. Mixing them in inflates every per-customer metric and makes the number impossible to reconcile to the accounts.
Common mistakes
- Reporting annual contract value as if it were MRR, which overstates monthly revenue twelvefold.
- Including onboarding, services, or hardware because they arrived with a subscription.
- Netting churn into new sales silently, so the base looks stable while it is being replaced.
- Changing the definition mid-year, which makes every prior comparison invalid.
- Treating ARR as a cash forecast rather than a run-rate.
- Counting trials, pipeline, or signed-but-not-started contracts as MRR.
- Adding expansion to base MRR and again to the total, double counting it.
Practical caveats
Discounts and coupons should be reported net, because the customer’s actual recurring charge is what will be collected. Mid-month starts need a proration rule: prorate or do not, but never switch. Reactivations are usually counted as new MRR rather than expansion, and the choice should be documented so the bridge can be audited.
Usage-based and hybrid pricing break the simple formula. If revenue varies with consumption, either report the trailing average as MRR and disclose the method, or report committed recurring revenue separately from variable usage. Currency matters too: convert at a stated rate and keep the rate consistent within a reporting period.
Percentages become noisy at small numbers. A 2% churn rate on 40 customers is a single cancellation, and a monthly NRR swing on a small base is not a trend. Cohort views, which follow a group of customers from their start month, are more informative than a blended average for anything under a few hundred accounts.
Reporting cadence and what to show
Report MRR monthly, on the same day of the month, from the same source system, and reconcile the total to the billing platform before publishing it. A one-page view with MRR, ARR, ARPU, gross revenue churn, NRR, and the movement bridge covers what most operators and investors ask for, and each line has a definition behind it.
Review the bridge rather than the total. A flat MRR month made of $10,000 of new sales and $10,000 of churn is a very different business from a flat month with no movement at all, and only the bridge distinguishes them.
Frequently asked questions
Does ARR equal annual revenue?
No. ARR is MRR multiplied by twelve, a run-rate. Annual revenue is what the accounts recognise over the year, which differs when customers start, upgrade, or cancel mid-year.
Should one-time fees be included in MRR?
No. Setup, onboarding, services, and hardware are revenue but not recurring revenue. Including them inflates MRR and makes it unstable.
How do I handle annual plans?
Divide the annual value by twelve and recognise that amount each month. The cash arrives once; the MRR is spread.
What is a good net revenue retention rate?
There is no universal target. Above 100% means the existing base grows on its own; below 100% means new logos are needed just to stand still. Compare within your segment and over time.
Is churn calculated monthly or annually?
Calculate it monthly on a consistent base and annualise only for presentation. Mixing periods is the most common reason two teams disagree about the same number.
Why is ARPU different from the average plan price?
ARPU uses total MRR, including expansion and multiple products, divided by all paying customers. The average plan price usually reflects only the base subscription.
Further reading
Keep exploring
Decision path