SpunkArt
Numbers and money maths

How to calculate monthly recurring revenue (MRR)

Monthly recurring revenue is the subscription income a business can expect each month if nothing changes. It is the core number for any subscription product, and it is easy to inflate by accident. Here is how to count it and how to explain why it moved.

MRR bridge calculator

What counts as MRR

MRR includes only recurring subscription charges, expressed as a monthly amount. It leaves out one-off setup fees, consulting work, usage overages that are not committed, taxes, and refunds of past periods. The simplest form is:

MRR = paying customers × average revenue per account (ARPA)

With 160 paying accounts at an average of $125 per month, MRR is 160 × 125 = $20,000.

Normalise every plan to one month

Customers on longer billing cycles must be converted to a monthly figure, or MRR jumps in the month a big invoice is sent and falls the next.

BillingAmount billedContribution to MRR
Monthly$125$125 per month
Quarterly$270270 ÷ 3 = $90 per month
Annual$1,2001,200 ÷ 12 = $100 per month

Apply discounts too. If a customer pays a reduced price for the first three months, count what they actually pay, not the list price.

The MRR bridge

To explain a change, split it into five movements:

  • New: MRR from customers who started paying this month.
  • Expansion: upgrades, extra seats or add-ons from existing customers.
  • Contraction: downgrades and removed seats.
  • Churned: MRR from customers who cancelled.
  • Reactivation (optional): returning former customers, kept separate from new.
ending MRR = starting MRR + new + expansion − contraction − churned

Example month. Start $20,000. New $2,400, expansion $900, contraction $300, churned $1,100.

  • Ending MRR: 20,000 + 2,400 + 900 − 300 − 1,100 = $21,900
  • Net new MRR: $1,900
  • Gross MRR churn: (300 + 1,100) ÷ 20,000 = 7.00%
  • Net revenue retention (NRR): (20,000 + 900 − 300 − 1,100) ÷ 20,000 = 97.50%
  • Run-rate ARR: 21,900 × 12 = $262,800

NRR leaves out new customers on purpose. It answers one question: did the customers you already had pay you more or less? Above 100% means expansion outran losses.

Revenue churn versus customer churn

If 6 of 160 accounts cancel, customer (logo) churn is 6 ÷ 160 = 3.75%. If those 6 were large accounts worth $1,100 together, revenue churn is 5.50%. Report both; they tell different stories about which customers leave.

Common mistakes

  • Booking annual plans in full. A $1,200 annual plan is $100 of MRR, not $1,200.
  • Counting free trials. Add a customer to MRR only when they start to pay.
  • Mixing cash and MRR. MRR is a run rate, not the money collected this month.
  • Hiding churn inside net figures. A healthy net number can cover a churn problem. Keep the bridge.

FAQ

Is ARR just MRR times 12?

For run-rate purposes, yes. It is a snapshot of the current month scaled up, not a forecast.

When does a cancelled customer leave MRR?

Pick one rule and keep it. Most teams remove it when the paid period ends, not on the day the cancel button is clicked.