Pro Tip: Calculating Your Monthly Recurring Revenue
Recurly’s Monthly Recurring Revenue (MRR) report is a helpful tool that gives you a best effort approximation of your monthly recurring revenue at any given time. Using the MRR report in your admin console, you can drag your cursor along the graph to find your MRR on any given day, including your current MRR.
MRR is calculated as the sum of the total_recurring_amount of all of your live subscriptions (this includes add-ons and VAT, if applicable), normalized to a monthly interval. If you’re curious as to how to calculate your MRR, or if you want to view the underlying data of the MRR report, you can calculate your MRR by doing the following:
1) Pull a CSV export of all of your Live subscriptions
2) If your subscription plans have varying billing intervals (ie; monthly, semi-annual, annual, etc.), sort the CSV by the "plan_code" column and group all of your subscriptions with the same intervals together
3) Sum the "total_recurring_amount" column for all of your subscriptions
For any subscription plans with a billing interval greater than 1 month, divide the sum of the total_recurring_amount by the billing interval (ex: divide the sum of all annual subscriptions by 12, or all semi-annual subscriptions by 6) – this will normalize the sum to a monthly interval
4) Combine the sums and you’ll get your current MRR
(If you only have monthly subscription plans, you can simply sum the total_recurring_amount to get your MRR – there’s no need to perform steps 2 and 3.1 above)
Note: We always recommend running and viewing any reports using the UTC timezone, as this will give you the most accurate results. If you’re not currently in UTC, you can change your timezone by clicking on your name in the upper right side of the Recurly admin console, then clicking the “Edit Your Profile” button. You’ll then see the option to select and set a new timezone.
As always, if you have any questions about this don't hesitate to drop us a line at firstname.lastname@example.org.