MRR= revenue of monthly subscriptions
Monthly Recurring Revenue (MRR) is the revenue that your business generates every month. It is an important indicator to forecast your company's cash flows.
If your service offers a yearly subscription, you can find your MRR with this formula: Annual Recurring Revenue / 12
Notes: If you want to calculate your ARR, make sure to check here.
For this template, we will be calculating MRR using the database we created for the fake B2B SaaS startup, Awesome Company.
On Outcode, you can create an MRR Databoard in under 10 minutes.
Sample MySQL database
This is what Awesome Company's MySQL database looks like.
To track your MRR, you need the following data:
- payment amount
- payment dates
- refund status
- monthly subscription status
How to calculate the MRR in SQL
We need to bring
is_monthly, and the
is_refund data from the payment table.
You can easily copy and paste the query below to find your own.
You can also create your own Databoard and share it with your team.
select DATE_FORMAT(created_at, '%Y-%m') as 'Month', sum(amount) as 'Monthly Recurring Revenue' from payment where is_refund = 0 and is_monthly = 1 group by DATE_FORMAT(created_at, '%Y-%m') order by DATE_FORMAT(created_at, '%Y-%m')
Do you have a better way to find MRR? Please reply below and inspire your fellow Outcoders!
Want to do more with your data?
- You can calculate your recurring revenue by year with the same data.
- Try adding a table to view your MRR by product.
- Check out our templates and see how you can use your data here.
Share and automate
Outcode helps you to track measures in real-time with the Databoard.
- Share your Databoard or data table with other team members. Copy and paste the page URL anywhere you like.
- Get your MRR sent via Slack or email with Outcode's quick automation feature.