Skip to main content
MRR Monthly Recurring Revenue Report
Updated over 6 months ago

The MRR (Monthly Recurring Revenue) Report shows a measure of recurring, predictable revenue on a monthly basis. In this report, we take a look at the revenue you will receive on a monthly basis. You can utilize the date ranges to analyze how your monthly recurring revenue has increased or decreased over a chosen period, helping you track growth or spot potential areas for improvement in your sales process.

About This Report

What the MRR Report includes

This report includes revenue from classes and appointment plans only and does not include revenue from enrollments.


Accounting basis used in the MRR report

This report uses amortization to calculate revenue. If a client pays a year ahead of time, but the service can only be delivered monthly, then a formula is used to recognize the revenue monthly.


What the MRR Report analyzes

This report has multiple views, allowing you to analyze your revenue by Revenue, Plans, and Clients. Select each icon on the slider bar to view data corresponding to each of the three sections.


How to view MRR graphs

The graph on the right will adjust to reflect the date range selected so you can understand purchase and revenue trends. Hover your cursor over the bars in the graph to view revenue totals for the selected month.


Recurring Revenue Totals

Recurring Revenue is the total revenue for the selected period for recurring plans. This total is compared to the same period last year. Average per month looks at the selected date range, totals the revenue for each month, and divides the number of months selected to determine the average.

This month so far looks at the total recurring revenue for the current month to date and Projected displays the projected revenue for the current month. Revenue is before taxes and before the Stripe transactions and payouts fee is removed.

Plan Totals

Total plans reflects the total plans over the selected period. This month reflects the total plans for the selected period. Average per month over the period totals all plans over the selected period, then divides the total by the number of months of the selected period.

Total Clients in Period

Total Clients in period displays the total number of unique clients with recurring plans for the selected period. Total Clients this month reflects the total number of clients with recurring plans. This section also compares the total number of recurring plans from the previous month, the prior three months, prior six months, and prior year.

Monthly Detail by Client

The orange text is a clickable filter so you can view client or plan data. Viewing Monthly detail by client displays a list of clients who made a payment for a recurring plan during the selected period.

The quantity is the number of payments the client made during the selected period. The Monthly total column displays the total amount the client paid for all recurring payments for the selected period.

Monthly Detail by Plan

Viewing Monthly detail by plan displays all plans sold in during the selected date range, the number of plans on client’s accounts of that particular plan type during the selected period. Plans count towards the quantity column if they are active or paused. The Monthly column is the total revenue from that particular plan type for the selected period.


How Totals are Calculated

All recurring plans that are paid for in advance are amortized. These plans will be reported per month according to their plan details.

Monthly

Plan Cost with Tax / # of months

Weekly

Weekly Cost with Tax / # of Weeks * 4.3452

4.3452 is the average weeks in a year/month


Weekly recurring plan calculation example

In our example, our plan bills every 7 weeks and has a weekly cost of $50.

There are 52 weeks in a year, so we divide this number by 7 weeks, giving us 7.42.

So, in one year you’re going to charge that customer 7.42 times.

The total for the year will be $371, which is $50 x 7.42.

To determine our monthly cost, we would take $371 divided by 12, which gives us $30.92 a month.


Annual plan calculation example

If a $1,200 annual membership is sold, the total amount will be broken down by month to calculate the monthly recurring revenue you will receive from that sale.

We would take $1,200 and divide it by 12, giving us $100 per month reflected in the report.

Did this answer your question?