Subscriptions reports

The Subscriptions module allows you to run an array of detailed reports which give you invaluable insights into your subscribers, their behaviour and subscribing patterns as well as statistical information on things such as your subscription numbers, new and renewing subscribers and revenue.

The reports allow you to analyse your subscriptions on dimensions such as:

  • Cancellation reasons
  • Movement types
  • Subscription source
  • Gratis orders

Reporting in IP1 Subscriptions provides you with detailed information enabling you to make better business decisions which ultimately increases your revenue.

The following reports are available to analyse your subscriptions:

  • Customer Subscription Listing – This subscriptions report can be output to either a printer file or a disk file. The report is sorted by customer/delivery number and shows Charge to and send to customer addresses, Subscription code and title, Quantity, Reference, Start, Renewal and Cancel dates, Status, Charge method, Gratis code and Discount % (if selected).
  • Multiple Subscription Lists Report – displays Customer, address, phone, fax, normal quantity and gratis quantity and the total by normal orders and gratis orders.
  • Subscription Cancellation Report – report displays Customer, Subscription list ID, quantity multiplier, cancellation codes and phone & fax for the selected Subscription ID or all Subscription IDs.
  • Subscription Movement Report – used to analyse the movements of subscribers to different Subscription Lists. The report can be defined by summary, gratis and subscription level.
  • Subscription Reports and Lists – a range of reports are included within this menu option. The reports available here are listed in Control File TMSSM/RPTSEL.
  • Subscriptions Renewal Report – displays Gratis/non gratis orders and units for each subscription list in the selected range of months (up to 12 months).
  • Subscriptions Renewal/Forecasting Report – displays a break down of type of sales for individual ISBNs within each subscription product. In addition to the number of orders and units, the report also shows the values of these orders and units for each month.

Other reports include:

  • Deferred revenue report
  • Payment methods and deferred revenue

The Subscriptions module supports multiple payment methods; Pay As You Go (PAYG), payment by instalments, and more subscription specific methods such as Pay In Advance Anniversary and Pay In Advance Fixed. Both of these subscription specific payment methods require the subscriber to make a payment for the entire subscription term at one specified time. However, a subscription product is despatched to the subscriber at different times within the subscription term. Reporting this payment in one period is not a true indication of the revenue generated throughout the term of the subscription. To help depict a true picture of the revenue generated throughout the subscription term, the Subscription Module uses the Deferred Revenue feature.

When a subscriber makes their payment the amount is placed in a deferred revenue account. Based on the length of the subscription a user-defined fraction of this amount is posted to the general ledger every time a product is despatched to the subscriber. This ensures that the financial reports show a constant stream of revenue throughout the subscription term and gives a more accurate indication of how revenue was generated.