Billing Forecasting Overview

Notes:

Billing Forecasting is to be superseded by Revenue Forecasting at some point after the PSA Fall 2020 release. If you are already using Billing Forecasting, FinancialForce will provide you with a migration path after Fall 2020 to enable you to move to Revenue Forecasting. If you are not already using Billing Forecasting, we recommend that you choose Revenue Forecasting as your forecasting solution.

Billing Forecasting was previously called Enhanced Services Forecasting. It has been renamed to better reflect the functionality.

Billing Forecasting offers an efficient way of calculating billing forecasts for services projects and opportunities:

Objects Used in Billing Forecasting

Custom Objects

The following custom objects are available in PSA to support calculated forecast generation without the need for manual data entry.

Object

Description

Related Information

Billing Forecast Calculation Stores the parameters used to run a billing forecast calculation against a region, practice, or group. Billing Forecast Calculation Fields
Billing Forecast Calculation Log Stores details of any errors that occurred when a billing forecast calculation was run. Billing Forecast Calculation Log Fields
Billing Forecast Curve Contains one or more billing forecast curve details to measure varying anticipated revenue over a defined sequence of time (such as a quarter). Billing Forecast Curve Fields
Billing Forecast Curve Detail Represents a single sequence of time used within a billing forecast curve, and includes the percentage of the total forecast amount of revenue anticipated within that time period. Billing Forecast Curve Detail Fields
Billing Forecast Detail Stores the billing forecast records created for a project or opportunity. Billing Forecast Detail Fields
Billing Forecast Detail Category Stores the weighted category totals for the related project or opportunity. Billing Forecast Detail Category Fields
Billing Forecast Override Stores information on an override applied to a billing forecast summary category or billing forecast detail category. Billing Forecast Override Fields
Billing Forecast Run Info For internal use only. Used to input the information required for the billing forecast calculation run. Billing Forecast Run Info Fields
Billing Forecast Setup Contains the information required to configure and run a billing forecast calculation. Billing Forecast Setup Fields
Billing Forecast Setup Category Stores details about the weighted billing forecastt categories, such as Best Case or Expected, used in a billing forecast calculation. There must be at least one category assigned to the billing forecast setup details for a billing forecast calculation to run. Billing Forecast Setup Category Fields
Billing Forecast Summary Stores the billing forecast records created for a region, practice, or group. Billing Forecast Summary Fields
Billing Forecast Summary Category Stores the weighted category totals for the related region, practice, or group. Billing Forecast Summary Category Fields

Additional Objects

To use Billing Forecasting, you also need access to the following objects, which are used in the Billing Forecasting process:

Forecast Factors

Forecasts can be based on multiple factors:

Billing Forecasting gives you the flexibility to choose which factors you want to include: when configuring your billing forecast setup, you can enter "0.00" as the weighting for forecast factors you want to omit.

Staff with appropriate permissions can use different sets of weightings for the different billing forecast categories available, which are Best Case, Expected and Worst Case.

Note:

Forecast factors are displayed on the Billing Forecast page for billing forecast calculations run after the Spring 2019 release.

Example of Weightings on a Billing Forecast Calculation

This table provides an example of how weightings are applied to the different forecast factors within a billing forecast category, resulting in different forecast values for a given project and time period. For more information on using weightings on billing forecast calculations, see Configuring Billing Forecasts.

Project A Q3 Forecast

 

Forecast Factor

 

$ Amount

Billing Forecast Categories

Best Case Expected Worst Case
Actuals $5,000 1.00 1.00 1.00
Expenses $200 1.00 1.00 1.00
Scheduled Assignments $5,000 1.25 1.00 0.50
Held Resource Requests $1,000 1.00 1.00 0.50
Unheld Resource Requests $2,000 1.00 1.00 0.00
Scheduled Milestones $10,000 1.00 1.00 0.50
Unscheduled Backlog $12,000 1.25 1.00 0.00
Opportunities $5,000 1.00 0.80 0.50
TOTAL FORECAST $40,200 $44,450 $39,200 $15,700

Formulas Used to Calculate Forecast Factors

The tables below describe how we arrive at the opportunity and unscheduled backlog values used in billing forecast calculations.

For more information on the formulas used in billing forecast calculations, see How Billing Forecasting Calculations Work.

Calculating Opportunity Values

Order

Data

Multiplied By

Result

1 Value of the opportunity. For more information, see Opportunities. Value of the Percent Burndown field on the Billing Forecast Curve Detail record. The adjusted burndown.
2 The adjusted burndown. Value of the Probability (%) field on the opportunity record. The probability and adjusted burndown.
3 The probability and adjusted burndown. Weightings defined in the appropriate Opportunity Category multipliers on the Billing Forecast Setup page. For more information, see Billing Forecast Setup Fields. The opportunity forecast.
Calculating Unscheduled Backlog Values

Order

Data

Multiplied By

Result

1 Unscheduled Backlog (Budget minus Actuals minus Backlog). Value of the Percent Burndown field on the Billing Forecast Curve Detail record. The adjusted burndown.
2 The adjusted burndown. Weightings defined in the appropriate Project Category multipliers on the Billing Forecast Setup page. For more information, see Billing Forecast Setup Fields. The calculated unscheduled backlog on a project.

Billing Forecasting Permission Sets

This table shows the permission sets you can assign to users for access to Billing Forecasting.

Permission Set Name Level Description
PSA - Forecasting 2 Assign to users who need full access to Forecasting.
PSA - Forecasting - Commit 3 Assign to users who need to commit forecasts.
PSA - Forecasting - Overrides 3 Assign to users who need to perform overrides.
PSA - Forecasting - Project Manager 3 Assign to users with a Project Manager role, who need to view forecasts for their projects and opportunities. If a project manager needs to use the Billing Forecast page, you must also assign them the Regional Manager permission set.
PSA - Forecasting - Regional Manager 3 Assign to users with a Regional Manager role, who need to view forecasts for the regions, practices and groups they cover, and for relevant projects and opportunities. Users who need to use the Billing Forecast page must be assigned this permission set.
PSA - Forecasting - Run 3 Assign to users who need to run forecasts.
PSA - Forecasting - Setup 3 Assign to users who need to configure the setup for forecasts.