This report is used to analyze the amount of invoiced but not yet provided services for the 12-month period beginning from the starting month of the report period. Basically, this report is the part of the Revenue Recognition report, which shows only non-completed business transactions that could not be recognized.
It produces a distribution of subscription recurring fees (it does not include one-time fees) into months going after the report starting month. The subscription fee in the report is split into monthly fees in the following cases:
- Billing period exceeds one month: the subscription is billed by billing period
- Subscription period exceeds one month: the subscription is billed before subscription period
The report shows amounts starting from the next month after the subscription purchase (that is, the subscription purchased in July will only be included in the August report or later).
The report displays:
- Pro-rated monthly prepay amount for each of twelve months
- Plan category information
- Service plan information
- Subscription period information
- Subscription information
Note: This report is a guidance, but not a replacement for accounting system and revenue management and reporting tool.
You can select from the following types of the report:
- Report by Plan Category – view the report grouped by service plan categories with possibility to drill down to service plans, subscription periods, and subscriptions.
- View Detailed Report – view a report grouped by subscriptions. This report includes all plan categories and all service plans.
The report has the following structure:
To view the report grouped by service plan categories, select the starting month and currency, and click View Report by Plan Category. The list of subscriptions grouped by plan category appears.
- Plan Category ID – a unique identifier of a service plan category.
- Plan Category Name – a name of a service plan category.
- Click the link under Plan Category ID or Plan Category Name to access the report grouped by service plan.
- Click the link under Plan ID or Plan Name to access the report grouped by subscription.
- Account ID – a unique identifier of a customer account (owner of a subscription).
- Account Name – a name of a customer account.
- Period Duration – a period for which the subscription fee is billed. If the subscription fee is billed before the subscription period starts, the field displays the duration of a whole subscription period. If the fee is billed before or after a billing period, the field displays the duration of one billing period.
- Type – a period type (day, month, year).
- Subscription ID – a unique identifier of a subscription.
- Subscription Name – a name of a subscription.
- Subscription Start Date – a date of a subscription start.
- Subscription Status – a current status of a subscription.
- Plan Category – a name of a plan category.
- Customer Class ID – an identifier of the class (created in Billing) to which a customer belongs.
- Customer Class Name – a name of the class to which a customer belongs.
- Plan ID – a unique identifier of a service plan of the selected plan category.
- Plan Name – a name of a service plan.
- Subscription Cancellation Date – a date of canceling a subscription.
- Month names columns – display pro-rated monthly prepay amount for each of twelve months starting from the Starting Month.
- Future – a total remaining prepay for the period after 12 month.
Click the link under Account ID or Account Name to access the subscription information.
Unlike the Report by Plan Category report, the View Detailed Report report shows a list of all subscriptions.