ARR= revenue of yearly subscriptions
Annual Recurring Revenue (ARR) is the amount of revenue that your business generates every year. This metric is particularly useful if you want to only track the revenue from your service or subscription.
If your service offers a monthly subscription, you can find your ARR with this formula: Monthly Recurring Revenue * 12
Notes: If you want to calculate your MRR, make sure to check here.
For this template, we will be calculating ARR using the database we created for the fake B2B SaaS startup, Awesome Company.
On Outcode, you can create an ARR Databoard in under 10 minutes.
Sample MySQL database
This is what Awesome Company's MySQL database looks like.
To track your ARR, you need the following data:
- payment amount
- payment dates
- refund status
- monthly subscription status
How to calculate the ARR 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') as 'Year', sum(amount) as 'Annual Recurring Revenue' from payment where is_refund = 0 and is_monthly = 1 group by DATE_FORMAT(created_at, '%Y') order by DATE_FORMAT(created_at, '%Y')
Do you have a better way to find ARR? Please reply below and inspire your fellow Outcoders!
Want to do more with your data?
- If you want to analyze your recurring revenue more thoroughly, you can also calculate it by month.
- Try adding a table to view your ARR 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 ARR sent via Slack or email with Outcode's quick automation feature.