Monthly Recurring Revenue Calculator
Enter your beginning MRR and this month's new, expansion, reactivation, contraction and churned revenue to see your ending MRR, net new MRR, ARR run-rate and revenue retention.
- Beginning MRR
- £10,000.00
- New MRR
- +£2,000.00
- Expansion MRR
- +£800.00
- Reactivation MRR
- +£200.00
- Less contraction MRR
- -£400.00
- Less churned MRR
- -£600.00
- Net new MRR
- +£2,000.00
- Ending MRR
- £12,000.00
- MRR growth rate
- 20.00%
- ARR run-rate
- £144,000.00
- Retention and churn
- Gross revenue retention (GRR)
- 90.00%
- Net revenue retention (NRR)
- 100.00%
- Revenue churn rate
- 10.00%
- Churned MRR rate
- 6.00%
- Customer churn rate
- 5.00%
How to use this calculator
- Pick your currency at the top of the calculator panel. It sets the formatting only and does not convert the figures.
- Enter your beginning MRR — the recurring monthly revenue from active customers at the start of the month.
- Add this month's new, expansion andreactivation MRR. These increase recurring revenue.
- Add this month's contraction and churned MRR as positive amounts — the calculator deducts them for you.
- Optionally, open Customer churn details and enter your customer count at the start of the month and how many churned, to see the customer churn rate.
The results update as you type. The headline figure is ending MRR; the overview figures give net new MRR, the MRR growth rate, the ARR run-rate and net revenue retention. The summary tab shows the full MRR movement bridge and the retention and churn rates.
Include recurring subscription income only. Exclude one-off setup fees, implementation fees, refunds, VAT or sales tax and other non-recurring payments. Convert annual contracts into a monthly equivalent by dividing by 12. MRR is not the total cash collected in the month.
How MRR is calculated
Every recurring revenue movement in the month is added to or taken away from your beginning MRR to give the ending MRR.
With a beginning MRR of £10,000, £2,000 of new MRR, £800 of expansion MRR, £200 of reactivation MRR, £400 of contraction MRR and £600 of churned MRR:
- Net new MRR is £2,000 + £800 + £200 − £400 − £600 = £2,000.
- Ending MRR is £10,000 + £2,000 = £12,000.
- MRR growth rate is £2,000 ÷ £10,000 × 100 = 20.00%.
- ARR run-rate is £12,000 × 12 = £144,000.
- Gross revenue retention is (£10,000 − £400 − £600) ÷ £10,000 × 100 = 90.00%.
- Net revenue retention is £10,000 ÷ £10,000 × 100 = 100.00%.
The five MRR movements
| Movement | Effect on MRR | What it is |
|---|---|---|
| New MRR | Added | Recurring revenue from customers who signed up this month. |
| Expansion MRR | Added | Extra recurring revenue from existing customers upgrading, adding seats or buying add-ons. |
| Reactivation MRR | Added | Recurring revenue from former customers who restarted a cancelled subscription. |
| Contraction MRR | Deducted | Recurring revenue lost when existing customers downgrade but stay subscribed. |
| Churned MRR | Deducted | Recurring revenue lost when customers cancel completely. |
Contraction and churned MRR are entered as positive amounts and deducted by the formulas, so you never type a minus sign. A customer who downgrades is contraction; a customer who cancels entirely is churn.
Gross retention, net retention and churn
Gross revenue retention (GRR) is the share of your starting MRR you kept after contraction and churn, excluding new and expansion revenue. It cannot go above 100%.
Net revenue retention (NRR) is your starting MRR after expansion, reactivation, contraction and churn, still excluding brand-new customers. It can go above 100% when upgrades from existing customers more than replace what was lost.
Revenue churn rate is the recurring revenue lost through downgrades and cancellations as a percentage of beginning MRR. Churned MRR rate counts only full cancellations.Customer churn rate is the share of customers who cancelled, which differs from revenue churn whenever the customers who leave are worth more or less than average.
What to include and exclude from MRR
- Include: monthly subscription fees and recurring add-ons and seats.
- Include: annual and multi-year contracts, divided by the number of months they cover.
- Exclude: one-off setup, onboarding and implementation fees.
- Exclude: refunds, credits and one-time discounts.
- Exclude: VAT, sales tax and any pass-through charges.
- Exclude: usage overages and professional-services revenue that is not recurring.
Important information
Important: this calculator is for general business planning and is not accounting advice. It uses the figures you enter and standard MRR arithmetic; it does not apply revenue recognition standards or tax rules. For a full revenue-to-net-profit breakdown once overheads and tax are in the picture, see the Profit Margin Calculator, or the Break-Even Point Calculator to find the sales needed to cover costs.