Report#: Q0071

This report determines predictive revenue recognition on service agreements and other warranty/deferred record types by customer in a given period.

Purpose:

• To see where deferred revenue will be recognized to assist with forecasted decision-making/planning and understanding the value of deferred revenue-based business.
• To see spikes and drops in revenue recognition by customer including detail by contract item. This will assist in understanding when and where more revenue is expected to be recognized to support key decision makers in planning and accounting to have set expectations.
• To keep an eye on existing deferred revenue, whether invoiced or not, to notice customers that may have contracts setup incorrectly or revenue recognized in the wrong place.

Filters:

• Time Period – Start Date/End Date: Operate based on the period for which the revenue will be recognized and will display a different number of columns (broken out by month) depending on the length of time selected.
• CompanyNo
• Branch
• Type: Based on Contract Type, derived from General Codes and presented on Service Contract Header
• Incl. UnBilled: Options are Yes and No. Determines whether unbilled service contracts should be included in the report.
• Invoiced Before: A date range that works in conjunction with the initial time period filter. This filter focuses on timing of service contract invoicing to display only contracts invoiced before the given date.

Report Results:

• Depending on the time period set in the filters, the number of columns (displaying months ahead for revenue forecasting) will change
  • • I.e. Calendar Year: 12 revenue recognition periods starting from January

   

• Prior to the month columns, the report displays Link/Drill-in,CustomerNo, Company, Ext. Price and Starting Balance:
  • • Zoom/Link/Drill-in: This link provides details of Customer Service Contract Revenue Forecast broken out by service contract line item
    • CustomerNo (hyperlink): 1 row per CustomerNo
    • Company: Company Name corresponding to CustomerNo
    • Ext. Price: The sum of the Ext. Price of each service contract line item (number of periods/months multiplied by revenue recognized per month)

   

• Starting Balance: The starting balance of what revenue remains to be recognized on the contract (at the start of the period for which the report has been run)
• Month Columns (denoted by Month and Year) displays revenue to be recognized across all service contract line items in that given month
  • • If the cell is highlighted in green, it means more service contract revenue for that customer will be recognized in that month than the month prior
    • If the cell is highlighted in red, it means less service contract revenue for that customer will be recognized in that month than the month prior

   

• Additional Columns: End Balance and SEQ
  • • End Balance is the balance of revenue remaining to be recognized by the end of selected time period
    • SEQ: TBD. Updated information to be provided soon

   

For information on other key reports, check out the webinar here.