About MRR Churn Calculator
Monthly Recurring Revenue (MRR) churn is the silent killer of SaaS businesses. While founders obsess over new customer acquisition, the rate at which existing revenue leaks out the back door often determines whether a subscription company survives, stagnates, or scales. A business generating $50,000 in MRR that churns 5% per month is effectively losing $2,500 in predictable revenue every 30 days, or $30,000 over a year. That is more than half an annual salary for a senior hire, evaporating purely because customers cancel or downgrade. This MRR Churn Calculator gives you a clear, numbers-driven picture of that leakage by measuring churned MRR, expansion MRR, new MRR, net MRR change, and your overall MRR churn rate. Understanding MRR churn is not just an accounting exercise, it is a strategic imperative. Investors routinely scrutinize churn and net revenue retention before pricing a SaaS round. A company with 120% net revenue retention can grow even with flat new sales because existing customers expand faster than they leave. Conversely, a company with 110% new logo growth but 10% monthly churn is often masking a broken product-market fit. By tracking both gross churn and net MRR change, you can separate growth theatrics from genuine business health. This tool matters whether you are a founder, CFO, customer success leader, or SaaS operator. It helps you identify if cancellations are outpacing expansion, whether your new MRR is enough to offset losses, and how much runway your current trajectory consumes. You will learn how small changes in churn compound over quarters, why expansion revenue is often cheaper than new logo revenue, and how to set realistic targets for net MRR growth. The calculator turns raw subscription data into an actionable dashboard, so you can move beyond vague metrics and make retention a growth lever.
How It Works
The calculator takes four inputs, starting MRR, churned MRR, expansion MRR, and new MRR, and combines them into three outputs that describe your subscription momentum. Starting MRR is the recurring revenue you had at the beginning of the month. Churned MRR is the revenue lost from customers who canceled or downgraded. Expansion MRR is the additional revenue captured from existing customers through upgrades, add-ons, or seat increases. New MRR is fresh revenue from customers who started paying during the month. Net MRR change is simply new MRR plus expansion MRR minus churned MRR. If that number is positive, your recurring revenue base grew. Ending MRR is starting MRR plus the net change. The MRR churn rate divides churned MRR by starting MRR to show what percentage of your existing revenue base you lost in the period. This is a normalized metric, so a $100,000 MRR business losing $2,000 looks the same as a $10,000 MRR business losing $200, both churning 2%. The distinction between gross churn and net churn is important. Gross churn only measures what you lost. Net churn layers in expansion, so it can be negative when upgrades exceed cancellations, a hallmark of strong product-led growth. The calculator presents both angles, giving you a complete picture of revenue retention.
Formula & Calculation Logic
The core formulas are straightforward but powerful. Net MRR Change equals new MRR plus expansion MRR minus churned MRR. Ending MRR equals starting MRR plus net MRR change. MRR Churn Rate equals churned MRR divided by starting MRR, multiplied by 100 to express as a percentage. Each variable matters. Starting MRR establishes the baseline against which retention is measured. Churned MRR reflects revenue attrition, expansion MRR reflects growth from the installed base, and new MRR reflects acquisition. The calculator assumes all figures are in the same currency and time period, typically one month. It also assumes that expansion and churn are mutually exclusive categories for the period being analyzed. If starting MRR is zero, the churn rate returns zero to avoid division errors. The tool does not annualize the rate automatically, so a 2% monthly churn compounds to roughly 21.5% annual churn, a detail users should keep in mind when benchmarking.
Step-by-Step Guide
- Step 1: Enter your starting MRR, the total recurring revenue at the beginning of the month.
- Step 2: Enter churned MRR from cancellations, downgrades, and expired subscriptions during the month.
- Step 3: Enter expansion MRR from upgrades, add-ons, usage increases, or seat expansions.
- Step 4: Enter new MRR from first-time paying customers acquired in the month.
- Step 5: Review net MRR change, ending MRR, and MRR churn rate to assess your subscription health.
Example Calculations
- Scenario 1: Healthy Growth. Starting MRR $40,000, churned MRR $800, expansion MRR $2,500, new MRR $5,000. Net change is $6,700, ending MRR is $46,700, and churn rate is 2.0%.
- Scenario 2: Flat but Resilient. Starting MRR $25,000, churned MRR $1,000, expansion MRR $1,000, new MRR $1,000. Net change is $1,000, ending MRR is $26,000, and churn rate is 4.0%.
- Scenario 3: Concerning Leak. Starting MRR $60,000, churned MRR $4,200, expansion MRR $900, new MRR $2,500. Net change is negative $800, ending MRR drops to $59,200, and churn rate is 7.0%.
Common Use Cases
- Founder reporting monthly SaaS metrics to investors or the board.
- Customer success teams setting retention and expansion OKRs.
- Finance teams forecasting revenue and building operating plans.
- Sales leaders proving that new bookings outweigh churn and downgrades.
- Product managers measuring whether feature launches drive account expansion.
Pro Tips
- Segment churn by customer cohort to find whether newer customers leave faster than long-tenured ones.
- Track logo churn separately from revenue churn, a few large accounts can distort the percentage.
- Aim for negative net MRR churn, where expansion from existing customers exceeds revenue lost.
- Annualize your monthly churn rate to compare against public SaaS benchmarks.
- Investigate downgrades as aggressively as cancellations, they are early warning signals.
Common Mistakes to Avoid
- Counting one-time professional services revenue as recurring MRR.
- Ignoring downgrades and only reporting gross cancellation dollars.
- Comparing monthly churn rates against annual churn rates without conversion.
- Including trialing or free-tier users in churn calculations.
- Panic-reacting to a single bad month instead of watching rolling averages.
Why Use This Tool?
- Get a single-screen view of retention, expansion, and new revenue.
- Spot revenue leakage early before it compounds into a growth crisis.
- Benchmark subscription health against SaaS industry norms.
- Make data-backed decisions about customer success investment.