Revenue Comparison Report

The Revenue Comparison report is used to compare subscriber revenue (from revenue and grace-owed records) to the delivery cost (i.e., account credits) of the same period. In non-update mode, the report lists any discrepancies between the two. In update mode, it lists the discrepancies and also creates an adjusting GL batch with the journal code of “RevAdj”. A field in Publication Setup, Discrepancy GL Account, is used to identify the GL account to which adjusting entries are added.

Before running this report, be sure to run the Unearned Revenue and Grace Due reports in update mode. Then, run the Revenue Comparison report for the same time period.

To run the Revenue Comparison report:

• Select Revenue Comparison from the Management menu to display the Revenue Comparison Report window.
• Click Add and complete the following fields.

  Field

  Type

  What to enter

  ALL ACCOUNTS

  yes/no

  By default, All Accounts is selected, but you can specify account ranges by clicking the Account Ranges Entry button. This will display another window where you can specify the product and ranges of account IDs to include.

  PRODUCT

  setup

  If All Accounts is selected, enter the product.

  START DATE END DATE

  date

  Specify the date range. The date range must match the date range of the Unearned Revenue and Grace Due reports, which must be run before comparing revenue.

  REPORT TYPE

  predefined

  Specify whether you want a Detail or Summary report.

  INCLUDE MAIL SUBSCRIBERS

  yes/no

  Select this checkbox if you want to include the mail portion of the subscription.

  UPDATE

  yes/no

  Indicate if you are running this report in update mode.

• Click OK and then Continue to produce the report.

Example—Revenue Comparison Report