Project Forecasts

Project forecasts display the actual and forecasted revenue and cost for your projects in a table, broken down by time period and the relevant business record. For example, your project forecast might look like the Project Forecast Example table.

Project Forecast Example
Time Period End Date (Year) 2027
Time Period End Date (Month) 01 02
Revenue/Cost Revenue Cost Revenue Cost
Hierarchy Amount (Record Currency) Amount (Record Currency) Amount (Record Currency) Amount (Record Currency)
 Acme Company - Managed Services-Project Part 1 USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
 Actuals USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Deliverable: Timecard USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Resource: Jamie Smith USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Pending Recognition USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Recognized to Date   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 9,722.23 USD 0.00 USD 9,722.23
Pending Recognition   USD 9,722.23   USD 9,722.23
Recognized to Date   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 3,965.00 USD 0.00 USD 3,965.00
Pending Recognition   USD 3,965.00   USD 3,965.00
Recognized to Date   USD 0.00   USD 0.00
 Timecards USD 4,755.00 USD 0.00 USD 4,755.00 USD 0.00
Pending Recognition USD 4,755.00   USD 4,755.00  
Recognized to Date USD 0.00   USD 0.00  
 Forecast USD 7,850.00 USD 2,788.89 USD 6,850.00 USD 1,788.89
 Deliverable: Assignment USD 0.00 USD 2,788.89 USD 0.00 USD 1,788.89
 Resource: Jamie Smith USD 0.00 USD 1,750.00 USD 0.00 USD 750.00
Scheduled   USD 1,750.00   USD 750.00
Unscheduled   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 388.89 USD 0.00 USD 388.89
Scheduled   USD 388.89   USD 388.89
Unscheduled   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 650.00 USD 0.00 USD 650.00
Scheduled   USD 650.00   USD 650.00
Unscheduled   USD 0.00   USD 0.00
 Deliverable: EVA USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
 Est vs Actuals USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
Scheduled USD 7,850.00   USD 6,850.00  
Unscheduled USD 0.00   USD 0.00  

In the example, the columns represent the year and the month that a value is for, followed by an additional level that determines whether the value is revenue or cost.

Note:

Depending on how your org is configured, you might see the name of the time period in the column header, instead of the year and month.

The first row provides the total values for the project, followed by an additional level that determines whether the values are actuals or forecasts. Each lower level provides additional information about the business record that the value originates from. You can click the name of a business record to view its details.

When the forecast is first created, the columns and rows are automatically sorted in ascending order, except the Revenue/Cost column. However, as the forecast is continuously updated with new data, the new data is added to the right and at the bottom of the table. This might result in an unexpected order. If this happens, you can reorder the columns and rows manually. For more information, see Changing the Position of a Column in a Forecast and Changing the Position of a Row in a Forecast.

By default, the values are displayed in the project's currency. If you want to view the values in the corporate currency, you can switch between the currencies. For more information, see Switching Between Project and Corporate Currencies in a Forecast.

In some cases, you might want to temporarily reflect an expected change to a value that hasn't yet been recorded in your business records. You can do this by making an adjustment. For more information, see Forecast Adjustments.

As you collaborate with others on your forecasts, you can start comment threads on specific cells. This can be useful to ensure that everyone has visibility into why a value was adjusted or to highlight any risks. For more information, see Cell Comments in Forecasts.

Project forecasts are periodically updated with the latest operational data using a scheduled background process. The frequency of the process executions depends on how your org is configured. In some cases, you might not want to wait until the next scheduled execution. If that happens, you can manually update the data. For more information, see Generating Forecast Data for a Project and Updating a Project Forecast with the Latest Data.

Each update or adjustment made to a cell's value is recorded in the cell's history. You can view the history entries to gain insight into who made an adjustment, when they made it, and the reason for making it. You can also see when the data was updated. The forecast-level history enables you to view a summary of multiple changes grouped together. For more information, see Forecast and Cell History.

Using the PSA Project Forecast dashboard, you can view forecasted versus budgeted revenue, cost, and margin at project level or by individual project item, such as a milestone, expense, or miscellaneous adjustment. You can also view a breakdown of forecasted revenue, cost, or margin by individual project item for the current quarter, next quarter, and future project periods. For more information, see PSA Project Forecast Dashboard.