How to Calculate SaaS Net MRR Churn
To accurately determine your SaaS Net Monthly Recurring Revenue (MRR) Churn Rate, follow these steps:
- Identify the Churned MRR. This is the total MRR lost due to cancellations or downgrades during the month. For example, if you had $5,000 in MRR lost due to cancellations, your Churned MRR is $5,000. (Protip: Check your monthly sales reports or billing system for these figures.)
- Determine the Expansion MRR. This is the additional MRR gained from selling more to existing customers in the same month. For instance, if upgrades added $2,000 in MRR, your Expansion MRR is $2,000. (Protip: Review upgrade and cross-sale reports for this data.)
- Subtract the Expansion MRR from the Churned MRR to find the Net Churned MRR. Using the figures above, $5,000 – $2,000 = $3,000 in Net Churned MRR.
- Identify the Beginning MRR. This is the total MRR at the start of the month. Example: If your Beginning MRR was $100,000, then it remains $100,000. (Protip: This is usually the final MRR from the previous month.)
- Calculate the Net MRR Churn Rate. From the example: $3,000 / $100,000 x 100 = 3.0%. Hence, the Net MRR Churn Rate is 3.0%. This metric is crucial to monitor for the health of your recurring revenue.