How to Calculate SaaS Net Revenue Retention Rate (NRR)
To calculate your SaaS net revenue retention rate, please follow these steps:
- Determine your Starting MRR. This is your total Monthly Recurring Revenue at the beginning of the period. For example, a small startup might have a Starting MRR of $10,000, while a larger company could start with $500,000. Find this data in your financial records for the beginning of the period.
- Calculate your Expansion MRR. This is the additional revenue generated from existing customers through upgrades or add-ons during the period. For instance, a company might have an Expansion MRR of $1,500 if some customers upgraded to premium plans. Check your sales records to track expansions.
- Determine your Churned MRR. This is the revenue lost from customers who canceled their subscriptions during the period. Suppose a business loses $500 in recurring revenue from cancellations; this is their Churned MRR. Review your cancellation records for this number.
- Add your Expansion MRR to your Starting MRR. Using our example, this would be $10,000 (Starting MRR) + $1,500 (Expansion MRR) = $11,500. This gives you the total revenue before accounting for churn.
- Subtract your Churned MRR from the result of step 4. In our case, this is $11,500 – $500 (Churned MRR) = $11,000. This is your net revenue after accounting for expansions and losses.
- Divide this result by your Starting MRR. Continuing with our example, $11,000 / $10,000 = 1.1. This will give you the NRR as a decimal.
- Multiply by 100 to get your SaaS Net Revenue Retention Rate (NRR) as a percentage. In our example, 1.1 * 100 = 110%. Therefore, your NRR is 110%. For a larger company with a Starting MRR of $500,000, an Expansion MRR of $60,000 and a Churned MRR of $20,000, the NRR would be 108% (($500,000 + $60,000 – $20,000) / $500,000 * 100)
Note: Ensure you are calculating MRR consistently across all variables. If your expansion and churn are collected based on the current billing cycle, make sure your initial MRR reflects the first billing cycle you use.