Coderhouse goes global

🌍

Read more

What Is Monthly Recurring Revenue (MRR)? How Analysts Calculate MRR and ARR

AI Engineering

Build and ship real applications with LLMs, agents and automation.

8 weeks · Live online · View course →

Data Analytics

Go from zero to job-ready analyst with SQL, Python and BI tools.

10 weeks · Live online · View course →

Dan Patiño

AI Strategy & Innovation at Coderhouse

Data

What Is Monthly Recurring Revenue (MRR)? How Analysts Calculate MRR and ARR

What Is Monthly Recurring Revenue (MRR)? How Analysts Calculate MRR and ARR

Monthly recurring revenue (MRR) is the predictable revenue a subscription business expects to earn every month from its active customers. It normalizes every plan, whether billed monthly, quarterly or annually, into a single monthly figure, so teams can see how the recurring part of the business is growing or shrinking. Annual recurring revenue (ARR) is the same idea expressed per year.

MRR is one of the first metrics data analysts meet in SaaS, subscription apps and membership businesses. Founders report it to investors, finance uses it for forecasting, and product and growth teams use its components to understand what is driving change. Calculating it correctly, and explaining why it moved, is a very practical analytics skill.

Why MRR matters

Total revenue mixes one-time fees, services and refunds with subscription income, and it jumps around when large annual invoices are paid. MRR strips that noise away. As Stripe's guide to monthly recurring revenue explains, it gives subscription businesses a consistent view of the income they can expect to repeat. That makes it useful for:

  • Tracking growth month over month.

  • Forecasting cash and hiring plans.

  • Measuring the impact of pricing changes, upgrades and churn.

  • Calculating related metrics such as net revenue retention, ARPU and CAC payback.

How to calculate MRR

The basic formula is simple:

MRR = sum of the normalized monthly subscription value of all active customers

A quick approximation is number of paying customers multiplied by average revenue per account, but analysts usually calculate it customer by customer from subscription data. The key rules:

  • Normalize billing periods: an annual plan of 1,200 counts as 100 of MRR, not 1,200 in the month it was paid.

  • Include recurring charges only: exclude setup fees, one-off services, taxes and usage that does not repeat predictably.

  • Apply recurring discounts: if a customer pays 20% less every month, use the discounted amount.

  • Exclude free trials: count a customer once they are paying.

  • Handle cancellations consistently: decide whether churn is counted when the customer cancels or when the paid period ends, and apply it the same way every month.

MRR movements: the components behind the number

The real insight comes from breaking MRR change into movements. Subscription analytics tools such as ChartMogul use a similar breakdown:

  • New MRR: revenue from customers who started paying this month.

  • Expansion MRR: increases from existing customers through upgrades, added seats or add-ons.

  • Contraction MRR: decreases from downgrades or fewer seats.

  • Churned MRR: revenue lost from customers who cancelled.

  • Reactivation MRR: revenue from former customers who came back.

Net new MRR = New + Expansion + Reactivation − Contraction − Churned

Worked example

A company starts the month with 100,000 of MRR. During the month it adds 8,000 in new MRR, gains 4,000 in expansion, loses 1,500 to contraction and loses 3,000 to churn.

  • Net new MRR = 8,000 + 4,000 − 1,500 − 3,000 = 7,500

  • Ending MRR = 100,000 + 7,500 = 107,500

  • Month-over-month growth = 7,500 / 100,000 = 7.5%

  • ARR = 107,500 × 12 = 1,290,000

The headline is 7.5% growth, but the components tell the story: churn and contraction ate 4,500, more than half of new business. That is the conversation leadership actually needs.

MRR vs ARR

  • MRR suits monthly plans and businesses that want to see changes quickly.

  • ARR is common in B2B companies with annual contracts and is usually calculated as MRR × 12.

  • Both measure recurring revenue only. Neither is the same as recognized revenue in accounting, which follows different rules.

Calculating MRR in SQL

Analysts usually build MRR from a subscriptions table with a customer, plan amount, billing interval, start date and end date. A common approach:

  1. Generate one row per customer per month in which the subscription was active.

  2. Convert each subscription to a monthly amount (for example, annual amount divided by 12).

  3. Sum by month to get total MRR.

  4. Compare each customer's MRR with the previous month to classify the change as new, expansion, contraction, churn or reactivation.

Window functions such as LAG() make step four straightforward: if the previous month was zero and this month is positive, it is new or reactivation; if both are positive, the difference is expansion or contraction; if this month is zero, it is churn. The output feeds an MRR waterfall chart in Power BI, Looker Studio or Tableau.

Common MRR mistakes

  • Booking the full value of annual contracts in the month they are paid.

  • Including one-time fees or services in recurring revenue.

  • Counting trials or unpaid invoices as active MRR.

  • Mixing currencies without a consistent exchange rate policy.

  • Reporting only total MRR, which hides rising churn behind strong new sales.

FAQ

Is MRR the same as revenue?

No. MRR is an operating metric for recurring subscription income. Revenue in financial statements follows accounting recognition rules and includes non-recurring items.

Should usage-based revenue be included in MRR?

Many companies include a committed minimum and track variable usage separately. The important thing is to document the definition and apply it consistently.

What is a good MRR growth rate?

It depends on company stage, market and size. Analysts usually focus on the trend and the mix of movements rather than a single benchmark.

Keep learning with Coderhouse

Turning raw subscription data into MRR, ARR and retention reporting is everyday work for data analysts. Explore the paths that fit your goals:

Dan Patiño

I'm Dan Patiño, head of AI Strategy & Innovation at Coderhouse. My day-to-day work involves merging the tactical management of e-commerce (CRO, Email Marketing and SEO) with the development of disruptive solutions. I specialize in building internal AI-powered apps to automate tasks and boost innovation within the team. I firmly believe that technology is strategy's best ally. To dive deeper into my professional journey, I'll be waiting for you on my LinkedIn profile.