Configure Workspace-level Cash Flow Settings for Projects or Programs

You can specify where the Planned Budget, Forecast, Actuals, and Benefits values for projects or programs come from at the workspace level. By default, these values are entered manually.

You can also specify, at the workspace level, whether certain project or program fields are calculated by the system and how the system determines cash outflow when calculating Net Present Value.

To configure workspace-level cash flow settings for projects or programs:

  1. Navigate to the Project configuration page

    or

    Navigate to the Program configuration page.

  2. Select the Cash Flow tab.
  3. In the Configure Field Sources section, select data sources for the Planned Budget, Forecast, Actuals, and Benefits curves. The options available here depend on whether you are configuring field sources for a project or program.
    • Manual: The Start and Finish dates, Total Cost, and time distributed values are all manual entry fields.

      Use capital and expense breakdown: If Manual is selected for Planned Budget, Forecast, or Actuals, then this option is also available. When selected, the corresponding row is broken down into capital and expense sub-rows on the Cash Flow page. For example, if you select this option for the Planned Budget cost curve, then back on the Cash Flow page, the Planned Budget row will become read-only, and will be accompanied by two editable sub-rows: Capital Planned Budget and Expense Planned Budget.

    • Project Budget Roll-up, Project Forecast Roll-up, Project Actuals Roll-up, Project Benefits Roll-up: When selected for any of the field sources, the project roll-up option sets the configured field source to the corresponding cash flow values of all the projects included in the program. These options eliminate the need to manually calculate totals across all of the projects in the program. For example, if you set the Forecast source to Project Forecast Roll-up, then the Forecast row on the Cash Flow page will show totals from all projects in the program. With these options selected, start dates and end dates are calculated based on the earliest start and latest end dates among the included projects, if the dates are outside of the program's start or end dates.
    • Project Current Budget: When selected for the Planned Budget source, the Total Cost value is pulled from the Project Current Budget column of the Project Cost Sheet. The Planned Budget Total Cost is read-only and is only updated when the Project Current Budget value changes on the Cost Sheet. You can manually enter the start and finish dates, and distribute the total cost over time.
    • Project Current Actuals: When selected for the Actuals source, the total of all approved Actuals records within the project roll up to the Actuals curve Total Cost column. The Start and Finish dates are set based on the earliest and latest approved actual record. The individual approved actuals total amounts roll up to the appropriate month and year in the time phase distribution for the curve.
    • (Actual Cost from P6): If costs are updated through a connection with P6 EPPM, discuss the frequency of the updates with your administrator. The values in the Actuals curve will stay in sync with the Actual Cost from P6 curve. The Actuals curve is read-only.
    • (Configured Cost Sheet Field): Planned Budget, Forecast, and Actuals values can be populated using a configured Project Cost Sheet field that uses a financial formula. The Total Cost field is populated with this value, which cannot be updated manually. The Total Cost can be distributed manually by time phase. Start and Finish dates are manually entered.
    • Integration: Integration with Primavera Unifier is performed by a Primavera Unifier administrator. When selected, the values for Planned Budget, Forecast, and Actuals are updated with data from Primavera Unifier. If Capital and Expense breakdown selections do not match for Forecast and Actuals, or if Forecast is set to Integration, the option to Link Actuals and Forecast will be disabled. Data must then be sent from Primavera Unifier. When a project is updated with Primavera Unifier cash flow data, you can select the View Integration Project Updates link on the General tab to view a detailed table of projects that have been updated with data from Primavera Unifier. The Cash Flow page will display the Unifier Project Source information at the top of the page.
  4. In the Calculate Financials section, set the following options:
    • Calculate Financials: Use this setting to specify whether the Net Present Value, Payback Period, Internal Rate of Return, and Return on Investment fields should be calculated by the system.
    • Use Planned Budget as cash outflow: If an annual discount rate is specified, use this option to determine which information the system interprets as cash outflow when calculating the Net Present Value. When this option is not selected, the system uses Forecast information. When it is selected, the system uses Planned Budget information.
  5. Select Save.