Written by Nils R. | Jun 11, 2021 7:00:00 AM
What is a
Monthly Subscription Sales Report
? Monthly subscription sales reports are considered recurring revenue analysis tools and are used by CFOs and sales managers to analyze subscription revenues for any given period. Some of the main functionality in this type of report is that it presents KPIs and charts as a summary on top of the report with detailed transactions at the bottom. KPIs include: Number of new subscriptions, number of renewals and number of renewal customers, as well as the total monthly sales amount. The detailed section of the report shows quantity and sales amount by product, by organization (e.g. reseller or customer) and region. You find an example of this type of report below.
Purpose of
Subscription Sales Reports Technology companies use Subscription Sales Reports to get a summary as well as a detailed picture of subscription business taking place in any given month. When used as part of good business practices in Accounting and Sales departments, a company can improve its sales strategies and as a result increase revenues, and it can reduce the chances of accounting mistakes and lack of clarity in revenue streams from new sales and renewals.
Example of a
Subscription Sales Report Here is an example of a Monthly Subscription Sales Report with KPIs and transactional details. [caption id="" align="alignnone" width="2560"]
Example of a Monthly Subscription Sales by Category Report for a Technology Company[/caption] You can find hundreds of additional examples
here
Who Uses This Type of
Report
? The typical users of this type of report are: CFOs, analysts, accountants, sales managers, subscription renewal managers.
Other Reports Often Used in Conjunction with
Subscription Sales Reports Progressive Accounting and Sales departments sometimes use several different Subscription Sales Reports, along with ARR and MRR reports, churn reports, subscription renewal reports, subscription revenue dashboards, sales forecast and other management and control tools.
Where Does the Data for Analysis Originate From? The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others. In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.
What Tools are Typically used for Reporting, Planning and Dashboards? Examples of business software used with the data and ERPs mentioned above are:
- Native ERP report writers and query tools
- Spreadsheets (for example Microsoft Excel)
- Corporate Performance Management (CPM) tools (for example Solver)
- Dashboards (for example Microsoft Power BI and Tableau)
Corporate Performance Management (CPM) Cloud Solutions and More Examples
