Report Description & Purpose

The MRR by Parent Customer and Subscription Report gives users insight into the predictable monthly revenue by reflecting ending MRR values for Parent Customers with recurring charges. This report does not have conditions based on the Customer Status of Active or Inactive.

Note: The data source for all MRR/ARR Movement reports is refreshed every 24 hours at midnight. This means that the data is not instantaneously refreshed. Therefore, we recommend only running an MRR/ARR report 24 hours after data has been adjusted. All other Analytics reports update instantly.

Features & Primary Benefits

• View MRR by Parent Customer for a given time period.
• Drill down into MRR for each month to understand which Customers, Subscriptions, Plans and Products are contributing to total MRR.

Predefined Filters

The following filters are automatically applied to the MRR by Parent Customer and Subscription Report. Click the Filters arrow to expand the section and adjust the criteria as needed. 

Report Calculations Explained 

Monthly Recurring Revenue (MRR) in this report is determined by the MRR associated with each Subscription Charge. Each Subscription Charge in Ordway will calculate MRR based on the total billing amount and the number of months between the Charge Start Date and Charge End Date.

This MRR amount will be displayed in the report for every month between these dates, and aggregated for each Parent Customer and Subscription.

The MRR/ARR Start Date will determine when MRR for a given Subscription first appears in the report. There are three options to provide flexibility in MRR reporting:

• Contract Effective Date - MRR will begin during the month of the Contract Effective Date associated with the Subscription.
• Service Start Date - MRR will begin during the month of the Service Start Date associated with the Subscription.
• Billing Start Date - MRR will begin during the month of the Billing Start Date associated with the Subscription.

When to Schedule this Report

The timing of when to run this report will vary based on the policies of your organization. One common example is to run this report at the end of a financial period to understand how much revenue should be expected from recurring products, and project recurring revenue for future periods.