Deferred Revenue Reclassification Report
The functions discussed in this topic require the Revenue Commitments feature to be enabled.
This report shows the detailed information for line level deferred revenue reclassification. This topic is for the legacy revenue commitment report. For the advanced revenue management context, see Deferred Revenue Reclassification Report. The topics are similar, but the related reports are different.
Use this report to audit the reclassification activities shown in the Deferred Revenue Activity Report. It provides detailed information about the how the reclassification journal entry amounts are calculated for each order line. You can also use this report to forecast the recognition periods for current outstanding deferred revenue balances.
Use this report only after line level deferred revenue reclassification is enabled for your account.
Report results are grouped by customer, sales order, and individual order lines. You can filter this report for a range of sales order transaction dates, and select the effective date for the transaction report results. Customize the report to add filters such as currency and customer.
This report includes the following columns:
-
Line Number
-
Currency
-
Total Amount (Tran Curr) – the total amount for the line from sales order in transaction currency
-
Total Revenue Allocation Amount (Tran Curr)
-
Gross Cumulative Billing Amount (Tran Curr) – total cumulative amount billed including gross amount, carve in/out amount, and effective amount in transaction currency
-
Carve Out Amount (Tran Curr) – the deferred revenue amount required to reduce the gross cumulative billing amount to the effective cumulative billing amount in transaction currency
-
Carve In Amount (Tran Curr) – the deferred revenue amount required to increase the gross cumulative billing amount to the effective cumulative billing amount in transaction currency
-
Effective Cumulative Billing Amount (Tran Curr) – the total billing amount plus the carve in/carve out amount in transaction currency
-
Gross Cumulative Billing Amount (Base Curr) – the total cumulative amount billed including gross amount, carve in/out amount, and effective amount in base currency
-
Carve Out Amount (Base Curr) – the deferred revenue amount required to reduce the gross cumulative billing amount to the effective cumulative billing amount in base currency
-
Carve In Amount (Base Curr) – the deferred revenue amount required to increase the gross cumulative billing amount to the effective cumulative billing amount in base currency
-
Effective Cumulative Billing Amount (Base Curr) – the total billing amount plus carve in/carve out amount in base currency
-
Average Billing FX Rate
-
Current Period Deferred Revenue Adjustment (Base Curr) – the amount posted by the carve in/carve out calculation in this period to reach the effective cumulative billing amount.
-
Deferred Revenue Balance (Base Curr)
-
Deferred Revenue Balance (Trans Curr) – deferred revenue balance (base currency) / average FX RAte
-
Deferred Revenue Account
-
Rev Rec Schedule
-
Cumulative Rev Rec Amount (Tran Curr)
-
Cumulative Rev Rec Amount Before FX Adjustment (Base Curr)
-
Average Rev Rec Rate – cumulative revenue recognition amount before FX adjustment (base currency) / cumulative revenue recognition amount (transaction currency)
-
Overlapping Amount (Tran Curr)
-
Cumulative Gain/Loss
-
Current Period FX Adjustment
-
Cumulative Rev Rec Amount After FX Adjustment (Base Curr)
-
Revenue Account
On this report, the order level unbilled receivable adjustment line displays results only for the following columns:
-
Line Number
-
Currency
-
Current Period Deferred Revenue Adjustment (Base Currency)
-
Deferred Revenue Balance (Base Currency)
-
Deferred Revenue Balance (Transaction Currency)
-
Deferred Revenue Account
-
Cumulative Rev Rec Amount After FX Adjustment (Base Currency)
This report shows all transactions, not only those marked for revenue commitment.
This report does not support reporting by period even when the Report by Period preference is set to All Reports. The Report by Period preference can be configured at Home > Set Preferences, the Analytics subtab.
To view the Deferred Revenue Reclassification Report
-
Go to Reports > Revenue > Deferred Revenue Reclassification
-
Select More to expand the footer.
-
For the Date, From, and To fields, select a date range that includes the date of the sale order or sales orders you want to run the report for. This is the date the sales order was created. For example, to view revenue reclassification activity for a sales order dated 7/15/2013, you must enter a date range that includes 7/15/2013.
-
For the As of date, select the ending period date to run the report for. The report returns the deferred revenue reclassification activity through this date. For example, if you select As of 07/31/2013, the report shows revenue reclassification activity for the selected sales orders through 7/31/2013. If you enter 10/31/2013, the report shows activity from the sales order date through 10/31/2013.
-
Select a subsidiary in the Subsidiary Context field.
-