Invoiced includes analytics and reports to help you understand the health of your recurring revenue business. You can track common subscription key performance indicators (KPIs) like monthly recurring revenue (MRR), customer lifetime value (LTV), churn, and more.
Invoiced includes the following subscription metric reports out of the box. Many of these reports support segmentation (month, customer, plan) and filtering.
- Monthly Recurring Revenue
- Annual Recurring Revenue
- MRR Movements
- Total Subscribers
- Average Sale Price
- Lifetime Value
- Net Revenue Retention
If you have access to the report builder then you can build custom MRR reports with your own filtering and segmentation, as well as drill down into the line item level detail behind MRR. You can use the MRR Item and MRR Movement reporting data types to do this.
Monthly recurring revenue (MRR) is the basis for tracking recurring revenue. On Invoiced, MRR is derived from recurring line items that were billed. A recurring line item is any line item that has an associated subscription plan and a service period.
The MRR of each line item is normalized depending on the plan interval. If the line item is prorated then the service period is an additional factor used to convert the billed amount to MRR. We only track MRR for what has been billed to a customer. Subscription events such as upgrades and cancellations are derived from line items and not from the subscription itself.
For example, if a customer was billed $120 for a yearly subscription, then this would add $10 to your MRR for each month covered by the service period.
Subscription metrics are periodically calculated. When viewing reports please pay attention to the last calculation date to know whether recent changes were included in your metrics.
MRR movements capture the types of changes that can happen to your MRR. As your recurring revenue base grows you would see this reflected as MRR movements. We calculate MRR movements from the line items that are billed to customers. As your customer's MRR changes month over month we break these down into the specific line items that caused the MRR change.
There are five different types of MRR movements that we will explain.
- New Business
All MRR in the first month of a customer's relationship with you is considered new business.
Expansion occurs when a customer's MRR increases from the previous month. The previous month MRR must be non-zero for it to be considered expansion revenue.
When a customer's MRR decreases from the previous month but has not churned, then this is considered a contraction. Since this is a decrease in MRR, contraction MRR should be a negative value.
Lost MRR is observed when a customer has churned and their MRR has gone to zero. Since this is a decrease in MRR, lost MRR should be a negative value.
Reactivation MRR is similar to New Business with one important distinction. We categorize MRR as reactivation if the customer previously had MRR but had previously canceled. Reactivation is the first month of MRR that occurs after the customer has canceled.
These are the formulas we use to calculate each subscription metric that you see in the application, charts and reports.
When user churn is 0% then Lifetime Value then the calculation becomes: