Revenue Trend

Overview

This report will facilitate revenue comparison between current month and prior months at various levels in the hierarchy, plus drill down to underlying activity, to investigate variances. Revenue generated in ORMB will consist of Current month end accruals, Reversal of prior month end accrual, Invoiced revenue, Write-offs and Provisions. Given that current month accruals are generated/available in ORMB starting from LBD-5, (in status approval in progres), although they are not yet sent to GL, they must be included in the revenue trend report, to facilitate review of draft revenue prior to month end.

Revenue Trend

Column Description
Division Division or business unit associated with the record.
Customer ID Unique identifier assigned to each customer in the system.
Account ID System-generated identifier that uniquely represents an account.
Customer Name Name of the customer.
PriceItem The product against which the revenue is recorded
Revenue Type Revenue type for the product code
Currency Currency used for the transaction.
Amount Revenue amount (Positive for accrual and negative for reversal)

Filters

You can filter the report using the following parameters:

  • Division
  • Revenue Type

Variance

Column Description
Division Division or business unit associated with the record.
Revenue Type Revenue type for the product code
Accounting Period Month for which the report is generated
Currency Currency used for the transaction.
Variance Difference between the revenue amount
Amount Revenue amount (Positive for accrual and negative for reversal)

Filters

You can filter the report using the following parameters:

  • Division
  • Revenue Type