Using the Deferred Revenue Reconciliation (Beta) Dashboard

The Deferred Revenue Reconciliation (Beta) dashboard enables you to perform the following actions:

  • Review the activity on your deferred revenue account.
  • Reconcile your general ledger account against the subsystems that create your invoicing and recognition transactions.
  • Identify variances such as missing recognition transactions.

This dashboard is a beta feature and is currently in development. For more information, and to leave your feedback for this product, see Deferred Revenue Reconciliation (Beta) Dashboard Feedback.

Datasets

Data displayed in this dashboard is derived from the following datasets:

  • Recognition Transactions. This dataset uses objects and fields derived from Revenue Management.
  • Billing Documents. This dataset uses fields derived from the Billing Document object in Billing Central, and additional objects and fields derived from Accounting and Foundations.
  • Financial Transactions. This dataset uses objects and fields derived from Accounting.

For more information on these datasets and the preconditions for their creation and use, see Dashboards, Billing Documents Fields, Financial Transactions Output Fields Recognition Transactions Fields.

Managing Filters

Your filter selections determine the data displayed on the Reconciliation, General Ledger, Revenue Management and Billing Documents pages. By default, the filters panel is displayed in this dashboard. To hide the filters click . Click to show the filters. To set or change your filters, use the following drop-down options:

  • Company: select the company you want to see data for.
  • Currency: select the documents you want to see data for, based on their currency.
    Note: This dashboard runs in document currency only.
  • GLA: select the GLA you want to see data for.
  • Period: select the financial year and period you want to see data for.
Warning:

When picking your initial values for this dashboard, we recommend that you apply and save global filters from the Reconciliation page only.

Using Dashboard Pages

The Deferred Revenue Reconciliation (Beta) dashboard contains the following pages, tables, local filters and components:

Note:

To order columns displayed in the tables on the General Ledger, Revenue Management and Billing Documents pages, hover over the column header and click .

Reconciliation Page Components

Component

Description
General Ledger Enables you to view the net movement between the opening and closing balance of your selected GLA for your selected period and year.
Source Documents

Enables you to review the net movement on revenue recognition derived from billing documents. This component displays:

  • Billing Documents: displays the value of billing documents that are completed and marked as posting to the deferred revenue GLA selected on the filter panel.
  • Revenue Management: displays the value of revenue that has been recognized and marked as posting to the deferred revenue GLA selected on the filter panel.

The Reconciliation status of your transactions:

  • If the net movement value displayed in Source Documents matches the net movement value displayed in General Ledger, then this is displayed as "Reconciled" and is highlighted in green.
  • If the net movement value displayed in Source Documents does not match the net movement value displayed in General Ledger, then this is displayed as "Not Reconciled" and is highlighted in red.
  • The variance in net movement between the General Ledger and Source Documents is displayed as a percentage under Variance to GL Net Movement.

Displays transactions posted to the general ledger account you have specified for deferred revenue. This page enables you to check for discrepancies between your invoicing and recognition subledgers and your general ledger.

The data displayed in the General Ledger summary table is derived from the Financial Transactions dataset. For details of these fields used in this dataset, see Financial Transactions Output Fields.

Summary details for each transaction are displayed in the table. These are:

  • Account Name
  • Transaction Date
  • Transaction Type
  • Transaction Name
  • Transaction Line Name
  • Transaction Document Number
  • Document Value

Local Filters

In addition to the global filters available on this page, you can apply further local filters to the data displayed in the summary table. These local filters are:

  • Account Name
  • Transaction Type
  • Transaction Name
  • Transaction Document Number

 

Displays committed revenue recognition transactions for the general ledger account you have specified for deferred revenue. This page enables you to check for discrepancies between your invoicing and recognition subledgers and your general ledger.

The data displayed in the Revenue Management summary table is derived from the Recognition Transactions dataset. For details of the fields used in this dataset, see Recognition Transactions Fields.

Summary details for each transaction are displayed in the table. These are:

  • Salesforce Account
  • Recognized Date
  • Transaction Number
  • Transaction Line Number
  • Product Name
  • Primary Object Record Name
  • Level 2 Object Record Name
  • Status. By default, this is set to "Committed".
  • Amount Recognized

Local Filters

In addition to the global filters available on this page, you can apply further local filters to the data displayed in the summary table. These local filters are:

  • Salesforce Account
  • Transaction Name
  • Transaction Line Name
  • Status

Displays completed billing documents for the general ledger account you have specified for deferred revenue.

This page enables you to check for discrepancies between your invoicing and recognition subledgers and your general ledger.

The data displayed in the billing documents summary table is derived from the Billing Documents dataset. For details of the fields used in this dataset, see Billing Documents Fields.

Summary details for each billing document are displayed in the table. These are:

  • Account Name
  • Document Date
  • Document Number
  • Document Line
  • Product Name
  • Contract Name
  • Document Type
  • Billing Document Status. By default, this is set to "Complete".
  • Posting Status
  • Reporting Net Value

The total value of all billing documents is displayed in the top row of the Reporting Net Value column. By default, rows in this table are sorted in descending order by date.

Local Filters

In addition to the global filters available on this page, you can apply further local filters to the data displayed in the summary table. These local filters are:

  • Billing Documents
  • Account Name
  • Document Number
  • Billing Document Status
  • Posting Status

Drilling Through to Documents

You can drill through to view details of records displayed in rows under the following table columns:

Drillable Columns

Page

Column
General Ledger Transaction Name
Transaction Line Name
Transaction Document Number
Revenue  Management Transaction Number
Transaction Line Number
Primary Object Record Name
  Billing Documents Document Number
Document Line
Contract Name

To view details of a selected record:

  1. Click the cell you want to drill. Drillable cells are highlighted in bold blue text. Depending on your selection, a Billing Central or Revenue Management license is required to view further details.
  2. Click Arrow , then click Open Record.
  3. The source record opens in the Billing Central or Revenue Management app.