
Dan Patiño
AI Strategy & Innovation at Coderhouse
Data
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:
Generate one row per customer per month in which the subscription was active.
Convert each subscription to a monthly amount (for example, annual amount divided by 12).
Sum by month to get total MRR.
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:
Data Analytics Course — learn SQL, Python and dashboards to build metrics like MRR movements and explain what drives them.
Forward Deployed AI Engineering Course — learn to build AI systems that connect to business data and automate reporting.
GTM Engineer Course (waitlist) — join the waitlist for early access to the program focused on systems that drive pipeline and revenue.
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.