Using the Deferred Revenue Reporting Dashboard

The Deferred Revenue Reporting dashboard provides a historic and forward-looking view of your services billing and revenue. You can view the following for a PSA project and the related milestones, timecards, expenses, and miscellaneous adjustments:

• The amount of revenue pending recognition.
• The amount of revenue recognized and the amount billed to date.
• The amount of billing currently being processed by your accounting system.
• The amount billed and scheduled to be billed, the amount of revenue recognized and deferred, and the variance between the two values per period.
• The related revenue recognition transaction lines.
• The related billing event items.

The sections below provide more information about the data and the charts included in the dashboard.

Data

The data displayed in this dashboard is derived from the following datasets:

• Deferred Revenue Reporting Billings
• Deferred Revenue Reporting Transactions
• Time Periods

Sources and Objects

The main source records for the dashboard are PSA projects. Throughout the dashboard, source refers to a project. For example, the Source Name field contains the name of the project. We further extended the basic project information with the related business records, namely milestones, timecards, expenses, and miscellaneous adjustments. These are referred to as objects in the dashboard. For example, the Object Type field contains the type of business record, for example, "Milestones" and the Object Name field contains the name of the, in this case, milestone.

For a project to be included in the dashboard, it or its related business records must have a revenue recognition template assigned.

You can filter the dashboard by sources and by objects. In the Revenue Transactions and Billing tables, these fields enable you to easily determine where the billing or recognition originated from.

Billing

The billing information is derived from billing event items in PSA.

If you recognize revenue at the project level, the dashboard includes all billing event items related to the project's milestones, timecards, expenses, and miscellaneous adjustments.

If you recognize revenue for the business records, only the billing event items related to the business record with a recognition template are included in the dashboard.

Recognized Revenue

The revenue recognition information is derived from revenue recognition transactions in Revenue Management. You might recognize revenue at the project level or for business records related to the project. The dashboard displays values from committed transactions.

Deferred Revenue

The deferred revenue information is derived from estimates versus actuals records in PSA.

Managing Filters

Your filter selections determine the data displayed on the dashboard charts. By default, the filters panel is hidden in this dashboard. You can toggle between hiding and displaying the filters panel by clicking . To set or change your filters, use the following drop-down options:

• Date Range: set the time period to define the data that you want to report on. This is set to "current month to 6 months ahead" by default. You can select a different period to focus on the relevant data.
• Company Name: select the company that you want to see data for.
• Account Name: select the account that you want to see data for.
• Source Name: select the project that you want to see data for.
• Object Name: select the business record that you want to see data for.
• Object Type: select the type of business record that you want to see data for.
• Currency ISO Code: select the project currency that you want to see data for.

Using Dashboard Charts

The Deferred Revenue Reporting dashboard contains the following charts.

Summary Tab

The Summary tab provides you an overview of the current status of revenue recognition and billing for the selected projects at a high level.

Revenue Pending Recognition Donut Chart

The Revenue Pending Recognition chart enables you to view the total revenue that has not been recognized yet per project. Each slice of the donut represents a project. You can hover over a slice to view the project name and the revenue pending recognition. This value is calculated by subtracting the recognized amount from the invoiced amount for each project. You can also click a slice of the donut to highlight a project. The stacked bar chart refreshes automatically to display only the data for the selected project.

Totals Stacked Bar Chart

The stacked bar chart enables you to view the following data for all the projects included in your filter criteria:

• Total booked revenue amount - this is the total bookings for the project.
• Total billed amount - this is the sum of all invoiced billing events.
• Total recognized amount - this is the sum of all committed revenue recognition transactions.
• Billing events awaiting invoicing - this is the sum of all billing events that have been released but not yet invoiced.

If you select a slice in the Revenue Pending Recognition donut chart, the values are only displayed for the selected project.

By Source Stacked Bar Chart

The By Source chart displays the same information as the Totals chart broken down by project. This can help you compare several projects.

Revenue Transactions Tab

This table chart enables you to view the revenue recognition transaction lines that were created after running the revenue recognition process for a project or its related business records.

This table contains the following columns:

• Account Name
• Source Name
• Object Name - this is the name of the record that the revenue was recognized for. Depending on how you recognize revenue, this might be the project or one of its related business records.
• Object Type - this is the type of record that the revenue was recognized for.
• Currency ISO Code
• Transaction Date
• Transaction Number
• Transaction Line Number
• Amount Recognized

Billing Tab

This details table enables you to view the billing event items that were generated for the business records related to the project.

This table contains the following columns:

• Account Name
• Source Name
• Currency ISO Code
• Object Name - this is the name of the record billed in this billing event item.
• Object Type - this is the type of record billed in this billing event item.
• Billing Date
• Billing Event Number
• Description - contains the number of the billing event item, followed by its description. You can click Open Record to open the billing event item. For more information, see Drilling Through to Records.
• Amount Billed
• Status

By default, only items that belong to invoiced billing events are displayed in the table. This means that they have been processed by your accounting system. You can use the Status filter to view billing events that have been released in PSA, but have not yet been processed by the accounting system.

Waterfall Tab

The Waterfall table enables you to view historic and forward-looking data of your billing and revenue per project and period.

For periods in the past and the current period, you can view the total amount billed, the total amount of recognized revenue, and the variance between the two amounts. The variance is the result of subtracting the recognized revenue from the billed amount.

For periods in the future, you can view an estimation of the billing and the deferred revenue. The billing information is derived from billing events awaiting release. The deferred revenue is derived from estimates versus actuals. The variance is calculated by subtracting the deferred revenue from the billed amount.

The variance is cumulative across periods. This helps you identify whether you are recognizing more than you are billing and the other way around.

This table contains the following columns:

• Account Name
• Source Name
• Currency ISO Code
• Total Billed
• Total Recognized
• Type
• Period
• Revenue

Drilling Through to Records

You can drill through to view details of records displayed in the dashboard. The table below provides more information about the drillable fields.

To view details of a selected record:

1. Click the field that you want to drill.
2. Click , then click Open Record.

Drillable Fields in the Deferred Revenue Reporting Dashboard

Chart	Field	Object	Required License	Notes
By Source	Source Name	Project	PSA
Revenue Transactions	Source Name	Project	PSA
	Object Name	Expense Milestone Miscellaneous Adjustment Project Timecard Split	PSA	This is a project record if you recognize revenue at the project level.
	Transaction Number	Revenue Recognition Transaction	Revenue Management
	Transaction Line Number	Revenue Recognition Transaction Line	Revenue Management
Billing	Source Name	Project	PSA
	Object Name	Expense Milestone Miscellaneous Adjustment Timecard Split	PSA
	Billing Event Number	Billing Event	PSA
	Description	Billing Event Item	PSA
Waterfall	Source Name	Project	PSA