PSA Revenue Forecast Dashboard

This dashboard enables you to:

  • Embed analytics to display forecasted revenue broken down by actual, scheduled and unscheduled revenue.
  • View comparisons of your live forecast against a saved version, or comparisons of two saved versions.
  • Filter forecast versions by expected, best and worst case scenarios.
  • View the value of adjustments made to projects, opportunities and milestones, or aggregated adjustments at RPG level.

PSA Revenue Forecast Dashboard Guide

The PSA Revenue Forecast Overview contains the following elements.

PSA Revenue Forecast dashboard schematic highlighting the key elements of the dashboard.

Revenue Forecasting Overview Dashboard Elements

Element Number

Name

Description

Calculation

Referenced Calculation

Source Dataset

1 Forecast Version You can select either a saved forecast version or the live forecast version. Live is your most recent calculated forecast and can be used to display current actuals. Forecast Name   Revenue Forecast

 

See Revenue Forecast Dataset PS Cloud Analytics Output Fields for more information.

2 Revenue (Expected) Displays total revenue for your selected forecast version and case. (Actual + Forecast) Actual Value + Forecast Value
Revenue (Best Case) Actual Value + Forecast Best Case Value
Revenue (Worst Case) Actual Value + Forecast Worst Case Value
3 Actual Displays actual revenue for your selected forecast version. (Revenue Pending Recognition Value + Revenue Recognized To Date Value) Revenue Pending Recognition Value = Equal Split Milestone Pending Value + Equal Split Project Pending Value + Expense Pending Value + Milestone Pending Value + Misc Adjustment Pending Value + Percent Complete Milestone Pending Value + Percent Complete Project Pending Value + Timecard Pending Value

Revenue Recognized To Date Value = Equal Split Milestone Recognized Value +

Equal Split Project Recognized Value +

Expense Recognized Value +

Milestone Recognized Value +

Misc Adjustment Recognized Value +

Percent Complete Milestone Recognized Value +

Percent Complete Project Recognized Value +

Timecard Recognized Value

 

4 Forecast Displays forecasted revenue for your selected forecast version and case. (Scheduled Revenue Value + Unscheduled Revenue Value)

_Scheduled Revenue Value = Equal Split Milestone Scheduled Value + Equal Split Project Scheduled Value + EvA Scheduled Value + Milestone Scheduled Value + Percent Complete Milestone Scheduled Value + Percent Complete Project Scheduled Value

 

Unscheduled Revenue Value = Opportunity Unscheduled Value + Percent Complete Milestone Unscheduled Value + Percent Complete Project Unscheduled Value

Forecast (Best Case) Displays forecasted revenue for your selected forecast version and case. (Scheduled Revenue Value + Unscheduled Revenue Value)

_Scheduled Revenue Value = Equal Split Milestone Scheduled Value + Equal Split Project Scheduled Value + EvA Scheduled Value + Milestone Scheduled Value + Percent Complete Milestone Scheduled Value + Percent Complete Project Scheduled Value

Unscheduled Revenue Value = Opportunity Unscheduled Best Case Value + Percent Complete Milestone Unscheduled Value + Percent Complete Project Unscheduled Value

Forecast (Worst Case) Displays forecasted revenue for your selected forecast version and case. (Scheduled Revenue Value + Unscheduled Revenue Value)

_Scheduled Revenue Value = Equal Split Milestone Scheduled Value + Equal Split Project Scheduled Value + EvA Scheduled Value + Milestone Scheduled Value + Percent Complete Milestone Scheduled Value + Percent Complete Project Scheduled Value

Unscheduled Revenue Value = Opportunity Unscheduled Worst Case Value + Percent Complete Milestone Unscheduled Value + Percent Complete Project Unscheduled Value

5 Chart Legend

Legend for the information displayed on the chart, which consists of the following:

  • Actual revenue for the displayed month.
  • Scheduled revenue for the displayed month.
  • Unscheduled project for the displayed month.
  • Unscheduled opportunity for the displayed month.

Actual revenue = see point 3.

 

Scheduled revenue = Scheduled Revenue Value

 

Unscheduled project = Unscheduled Project Value

 

Unscheduled opportunity = Unscheduled Opportunity Value

 Scheduled Revenue Value = Equal Split Milestone Scheduled Value + Equal Split Project Scheduled Value + EvA Scheduled Value + Milestone Scheduled Value + Percent Complete Milestone Scheduled Value + Percent Complete Project Scheduled Value

 

 

Project Unscheduled Value = Percent Complete Milestone Unscheduled Value + Percent Complete Project Unscheduled Value
6 Forecast Version Select either a saved forecast version or the live forecast version, which is your most recent calculated forecast. Live can be used for current actuals. Forecast Name  
7 Forecast Version to Compare Select a baseline forecast for comparison. Forecast Name  
8 Variance Calculates the difference between the overlapping periods of the two selected forecasts. (Forecast Version - Forecast Version to Compare)  
9 Variance increase/decrease Increase/Decrease calculates the difference as a percentage, and then labels if there has been an increase or decrease. (Forecast Version - Forecast Version to Compare)/Forecast Version to Compare  
10 Forecast Version line Displays only the periods of the forecast version that match periods in the forecast version to compare, in a periodic view.    
11 Forecast Version to Compare line Displays only the periods of the forecast version that match periods in the forecast version to compare, in a periodic view.    
12 View Details Displays the details view of the revenue forecast dashboard.      

Details view of the PSA Revenue Forecast dashboard highlighting the key elements of the dashboard.

Revenue Forecast Details Dashboard Elements

Element Number

Name

Description

Calculation

Referenced Calculation

Source Dataset

13 Forecast Variance (Revenue and Percent Variance) Difference between the revenue on your current forecast and the revenue on your forecast version to compare as a percentage of forecast version to compare. (Forecast Version - Forecast Version to Compare) / Forecast Version to Compare Revenue = Total Value (if using expected) or Total Best Case Value or Total Worst Case Value (Uses the ‘Excl Adjustments’ versions of these measures if adjustments have been excluded on the global filter panel). Revenue Forecast

 

See Revenue Forecast Dataset PS Cloud Analytics Output Fields for more information.

14 View As Switches between periodic and cumulative views.    
15 Revenue Variance bar chart Variance between forecast version and forecast version to compare broken down by Region/Practice/Group or Project Manager/Project.   Revenue = Total Value (if using expected) or Total Best Case Value or Total Worst Case Value
16 Revenue Variance bar chart Variance between forecast version and forecast version to compare, which can be filtered by Project, Opportunity, Milestone, or Account. For each filter, you can view the 5 highest variances in ascending or descending order, the 10 highest absolute variances, or the variance for all filtered records.   Revenue = Total Value (if using expected) or Total Best Case Value or Total Worst Case Value
17 Details list

Details the revenue information for all projects, opportunities, milestones, and accounts in the selected forecast versions.

   
18 Zero Value Records filter Switches between showing and hiding records in the Details list that have zero values in the forecast version and forecast version to compare. By default, zero value records are hidden.    
19 Revenue Variance Difference between current forecast version and forecast version to compare in currency. Forecast Version - Comparison Revenue = Total Value (if using expected) or Total Best Case Value or Total Worst Case Value
20 % Variance Difference between current forecast version and forecast version to compare as a percentage of forecast version to compare. Revenue Variance / Comparison Revenue = Total Value (if using expected) or Total Best Case Value or Total Worst Case Value

The filters panel can be used to tailor the data displayed in the dashboard.

The filter panel elements

Name

Description

Dataset Field

Monthly Displays data by month.

Time Period End Date

switches group: by month

Quarterly Displays data in 90 day segments.

Time Period End Date

switches group: by quarter

Period From Displays data from a specified date. Display: Time Period Name Field used to filter data: Time Period Start Date
Period To Displays data up to a specified date. Display: Time Period Name Field used to filter data: Time Period End Date
Region Level Displays available levels for regions . Region Level 01, Region Level 02,Region Level 03
Region Displays regions at the level selected in Region Level. Uses field selected in Region Level, shows all values available
Practice Level Displays available levels for practices Practice Level 01, Practice Level 02, Practice Level 03
Practice Displays practices at the level selected in Practice Level. Uses field selected in Practice Level, shows all values available
Group Level Displays available levels for groups. Group Level 01, Group Level 02,Group Level 03
Group Displays practices at the level selected in Practice Level. Uses field selected in Group Level, shows all values available
Project Displays data for a specified project. Project Name
Account Name Displays the data for a specified account name. Account Name
Project Manager Name Displays the data for a specified project manager name. Project Manager Name
Opportunity Displays the data for a specified opportunity. Opportunity Name
Adjustments Displays the data with or without adjustments.

Exclude Adjustments: Total Best Case Value (excl Adjustments) OR Forecast Best Case Value (excl Adjustments) OR Forecast Worst Case Value (excl Adjustments) OR Total Worst Case Value (excl Adjustments) OR Forecast Value (excl Adjustments)

Adjustments Only: Adjustment Best Case Value Adjustment Worst Case Value Adjustment Value

This dashboard is designed to complement the enhanced Revenue Forecasting Workspace functionality available in PSA. For more information on this functionality, see the PSA Help.

The dashboard is available in the following apps:

  • PS Cloud Analytics: PSA Revenue Forecast dashboard
  • PSA Analytics Embedded Dashboards: Revenue Forecast (Embedded) dashboard

Prerequisites

This dashboard displays data from the Revenue Forecast dataset and requires access to the following objects in PSA:

  • Revenue Forecast Version
  • Revenue Forecast Version Detail
  • Revenue Forecast
  • Revenue Forecast Type

This dashboard is created as part of the PS Cloud Core Analytics app.

Before running the configuration wizard to create the Revenue Forecast dataset, you must carry out the following steps in the Revenue Forecasting Workspace:

  • Create Revenue Forecast Version
  • Recalculate Revenue Forecast

For more information on how to perform these tasks, see Revenue Forecasting Overview.

The following fields are used to represent different forms of revenue totals in the dashboard:

  • Actual Best Case Value
  • Actual Worst Case Value
  • Adjustment Best Case Value
  • Adjustment Value
  • Adjustment Worst Case Value
  • Forecast Best Case Value
  • Forecast Best Case Value (excl Adj)
  • Forecast Value
  • Forecast Value (excl Adj)
  • Forecast Worst Case Value
  • Forecast Worst Case Value (excl Adj)
  • Scheduled Revenue Value
  • Total Value (excl Adj)
  • Total Best Case Value (excl Adj)
  • Total Value
  • Total Worst Case Value
  • Total Worst Case Value (excl Adj)
  • Unscheduled Revenue Best Case Value
  • Unscheduled Revenue Value
  • Unscheduled Revenue Worst Case Value

For details of how these fields are calculated, see Revenue Forecast Dataset PS Cloud Analytics Output Fields.

Note:

The time displayed for updated forecast data in the dashboard is shown in the current dashboard user's time zone.

Suggested Use Cases

Explore and visualize the data displayed in this dashboard to answer critical business questions such as:

  • How much revenue have we generated to date?
  • How much revenue do we expect to generate going forward?
  • How much forecast revenue is not linked to scheduled work?
  • How accurate has our forecast been compared to our actuals?

Embedding the Dashboard

This dashboard is optimized to be embedded in the page layout for your Revenue Forecasting workspace in Lightning Experience.

For more information on how to embed the Revenue Forecast (Embedded) Dashboard, see Embedding PS Cloud Analytics Dashboards in a Lightning Page.

Warning:

We recommend you do not save views of this dashboard in Analytics Studio or the page you have embedded it in. Picker selections and dashboard elements in saved views of this dashboard might not load as expected. This is due to a Salesforce restriction.

Note: This Revenue Forecast Dashboard is also available as Revenue Forecast Summary Dashboard in the PS Cloud Advanced Analytics app in Analytics Studio. For more information, see PSA Revenue Forecast Summary Dashboard.