How To Calculate MRR in Xero | Arithmix
Learn how to calculate Monthly Recurring Revenue (MRR) in Xero with our step-by-step guide. Understand the importance of MRR for your business and optimize your financial management.

Calculating MRR (Monthly Recurring Revenue) is an important metric for any business that offers subscription-based services or products. It helps you understand the predictable revenue that your business generates each month, which is crucial for forecasting and planning. In this article, we will discuss what MRR is, when it is valuable to calculate MRR, and how to calculate MRR in Xero.
What Is MRR?
MRR is the amount of revenue that a business generates from its subscription-based services or products each month. It includes all the recurring charges that customers pay on a monthly basis, such as subscription fees, maintenance fees, and support fees. MRR is a valuable metric because it helps businesses understand the predictable revenue that they can expect each month, which is crucial for forecasting and planning.
For example, if a business has 100 customers who pay $50 per month for a subscription-based service, its MRR would be $5,000 per month. If the business adds 10 new customers the following month, its MRR would increase to $5,500 per month.
When Is It Valuable To Calculate MRR?
Calculating MRR is valuable for businesses that offer subscription-based services or products. It helps businesses understand the predictable revenue that they can expect each month, which is crucial for forecasting and planning. MRR is also valuable for businesses that are looking to grow their customer base, as it helps them understand the impact of adding new customers on their revenue.
MRR is particularly valuable for businesses that are looking to raise capital or sell their business. Investors and potential buyers often look at MRR as a key metric to evaluate the health and potential of a business.
How To Calculate MRR in Xero
Xero is a cloud-based accounting software that can help businesses calculate their MRR. To calculate MRR in Xero, follow these steps:
- Log in to your Xero account and go to the "Sales" tab.
- Select "Repeating Invoices" from the dropdown menu.
- Click on "New Repeating Invoice" and set up a repeating invoice for your subscription-based service or product.
- Enter the monthly subscription fee and any other recurring charges that your customers pay each month.
- Xero will automatically calculate your MRR based on the recurring charges that you have set up in your repeating invoice.
Alternatively, you can use a third-party app or plugin to calculate your MRR in Xero. These apps and plugins can help you automate the process of calculating MRR and provide you with more detailed insights into your revenue.
In conclusion, calculating MRR is a valuable metric for businesses that offer subscription-based services or products. It helps businesses understand the predictable revenue that they can expect each month, which is crucial for forecasting and planning. Xero is a cloud-based accounting software that can help businesses calculate their MRR, but there are also third-party apps and plugins that can provide more detailed insights into revenue.
How Do You Calculate MRR in Xero
Xero itself isn’t naturally geared towards letting you calculate complex metrics like MRR. As an alternative, teams typically use products like Arithmix to import data from Xero and build out dashboards.
What is Arithmix?
Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers that’s powerful yet easy to use. With Arithmix you can import data from systems like Xero, combine it with data from other systems, and create calculations like MRR.
In Arithmix, data is organized into Tables and referenced by name, not by cell location like a spreadsheet, simplifying calculation creation. Data and calculations can be shared with others and re-used like building blocks, vastly streamlining analysis, model building, and reporting in a highly scalable and easy to maintain platform. Data can be edited, categorized (by dimensions) and freely pivoted. Calculations are automatically copied across a dimension - eliminating copy and paste of formulas.
Arithmix is fully collaborative, giving your entire team access to your numbers and the ability to work together seamlessly.

Calculating MRR in Arithmix
Calculating metrics like MRR is simple in Arithmix. Once you've created your free account, you’ll be able to import your Xero data, and use it to create natural language formulas for metrics like MRR.
Arithmix is designed to give you the power to build any calculations you want on top of your Xero data, while also being easy to use and collaborate on. You can share your dashboards with users inside and outside of your organisation, making it easy to empower your whole team.
Use Arithmix free