How to Calculate Net MRR

Mike Preuss
Learn How to Calculate Different Forms of MRR
Unlock your investor relationships. Try Visible for free for 14 days.
Start your free trial

Learn How to Calculate Different Forms of MRR

This post is part of our Most Valuable Metrics series, helping your company understand how to develop a holistic framework for tracking your performance and telling your story to everyone who matters to your business. You can find previous posts in the series here:

Like every SaaS business, consistent subscription revenue is vital to your success. That’s why knowing your Monthly Recurring Revenue, or MRR, is so important. MRR is a measurement of the total predictable revenue you expect to make on a monthly basis.

Here’s a very simple example of MRR. You have three customers with the following subscription rates.

  • Customer X pays $75/month
  • Customer Y pays $50/month
  • Customer Z pays $25/month

Your total MRR is $75 + $50 + $25 = $150.

Net MRR gives your company a holistic overview of revenue gained from new subscriptions and upsells/upgrades and revenue lost from downgrades and cancellations.

MRR might not be part of GAAP (Generally Accepted Accounting Principles) or IFRS (International Financial Reporting Standards) but because of its importance in raising capital and gauging your sales and marketing success, it is crucial to understand and calculate correctly. Unintentionally misrepresenting your business to potential investors or developing your business plan on faulty data could spell disaster for your company.

To start, when calculating your MRR, do not include the following.

Full value of multi-month contracts: If you have quarterly, semi-annual, or annual contracts, normalize them to a monthly rate. Take the full subscription amount paid and divide it by the number of months in the contract. For example, your customer pays you $1,200 for an annual subscription. Dividing that by 12 gives you a monthly rate of $100 which you should use in your MRR calculation instead of $1,200.

One-time payments: One-time payments are not recurring, so you shouldn’t include them in your MRR calculation. One-time payments are not the same as multi-month payments. Even though a customer is paying a lump sum payment for those months, you expect the customer to make another lump sum payment at the end of the subscription period. With one-time payments, you don’t expect the customer to make another subscription payment.

Trialers: Until trial customers convert to being regular customers, don’t include their expected subscription values in your MRR calculation.

Now that you know how to determine your MRR and understand what should be excluded, you can calculate your net MRR. Net MRR includes the following:

New MRR: MRR from new customers

Expansion MRR: MRR from gained from existing customers when they upgrade their subscriptions

Churned MRR: MRR lost from existing customers when they downgrade or cancel their subscriptions
So, the formula for calculating Net MRR is:

Knowing the three elements of Net MRR is critical to understanding how your business is growing. Ideally your Expansion MRR should be greater than your Churned MRR each month. If it is, then you’re doing something right with your existing customers!

Want to read more on Monthly Recurring Revenue and how it impacts your business as your grow?

You may also enjoy:
Product Updates
Product Update: Turn Emails Into Insights With Visible AI Inbox
Structured data. The holy grail of business intelligence. Structured data unlocks a realm of possibilities, from setting benchmarks to enhancing decision-making processes. Yet, in the venture capital landscape, accessing reliable, structured data remains a formidable challenge. This is precisely why we created the Visible AI Inbox. With unique features like automated metric detection and file parsing, the Visible AI Inbox stands out as a pioneering solution for portfolio monitoring. Discover how it can transform your data strategy by meeting with our team. Turning email into insights We believe that investors should spend time sourcing new deals and helping founders, not manually copying and pasting data from email 🙂. The AI Inbox helps aggregate insights that exist siloed in data, files, and updates across a venture firm. Updates from founders often stay stuck in one team member's inbox because it's too time-consuming to extract and enter the data and files into a more centralized repository. Visible AI Inbox makes this possible within seconds. Requests + AI Inbox = A Complete Picture The addition of the AI Inbox continues to advance our market-leading portfolio monitoring solution. The pairing of Requests + the AI Inbox will give investors a holistic view of portfolio company performance across a fund. Visible continues to be the most founder-friendly tool on the market. We’ll continue to build tools in existing workflows where both founders and investors live every day. How Does it Work? Visible AI Inbox works in three simple steps. Forward emails to a custom AI inbox email address Visible AI automatically maps data and files to portfolio companies Investors can review and approve content before it is saved From there, dashboards, tear sheets, and reports are all automatically updated on Visible. Learn more about how Visible AI Inbox can streamline workflows at your firm by meeting with our team. FAQ Will this be available on all plans? Visible AI Inbox is only available on certain plans. Get in touch with your dedicated Investor Success Manager if you want to explore adding this to your account. How is Visible addressing privacy and security with Visible AI Inbox? No data submitted through the OpenAI API is used to train OpenAI models or improve OpenAI’s service offering. Visible AI Inbox leverages OpenAI GPT 4 and proprietary prompts to extract data in a structured way and import it into Visible. If you’re uncomfortable with utilizing OpenAI to optimize your account, you can choose not to utilize this feature. Please feel free to reach out to our team with any further questions. These processes adhere to the guidelines outlined in Visible’s privacy policy and SOC 2 certification. Visible AI Inbox Best Practices We'll be sharing best practices for how investors are leveraging Visible AI Inbox in our bi-weekly newsletter, the Visible Edge. Stay in the loop with best practices and product updates by subscribing below:
Metrics and data
[Webinar] VC Portfolio Data Collection Best Practices
Customer Stories
Case Study: How Moxxie Ventures uses Visible to increase operational efficiency at their VC firm
How to Start and Operate a Successful SaaS Company