Cost: Cash Flow Forecasting

Access a project-level cash flow analysis and quickly visualize the difference between planned actual and forecast with built-in dynamic charts to ensure plans are being met, risk is mitigated, and profit is maximized.

Built-In Forecast Distribution Curves

  • Perform forecast distributions for each budget line item with four built-in forecast distribution curves, including front-loaded, rear-loaded, typical, and linear (when required, you can manually override).
  • There are three ways to access the distribution curve functionality.

 

    • OPTION 1: Via the Forecast Distribution section of the budget item’s details flyout panel.

Option 1

    • OPTION 2: Within the Forecast Tool via the more menu (three-dot menu) of a budget line item in the Cost & Time view.
      • From this view you can also select multiple budge items and batch create forecast distributions.

Option 2

    • OPTION 3: Within the Forecast Tool via the more menu (three-dot menu) of a budget line item in the table in the Cashflow view.

Option 3

  • A Create Forecast Distribution dialog box will appear when creating a forecast distribution, add in the distribution start and end date. When performing distributions to items connected to the schedule, dates automatically pull in. 
  • Choose the Curve from the drop-down menu; front-loaded, rear-loaded, typical, and linear. Note, a Budget with a time-based unit can only be distributed with a linear curve.
  • Select, Create. 
Page break

  • The details flyout panel will update to display a graphic representation of the distribution
  • Choose to display the information by amount or percent. 
  • Select the three dot more menu to delete the distribution.
  • Use the control icon to access the chart’s settings to display the chart by period, cumulative, or cumulative & by period. 
  • Select the arrow icon to expand the chart view. 

  • Hover over a specific point on the chart to view detailed information. 
Page break

  • In the table, scroll to view the distribution periods.
  • If needed, customize the distribution further by adding periods or deleting the last period via the buttons at the bottom of the table. 
  • Easily edit the amount within the forecast final cost field when making projections.
  • The system will auto-flag if the distribution total doesn’t match the forecast-final cost.

 

    • If a forecast adjustment already exists, you will need to manually distribute the adjustment.
    • If a forecast adjustment does not exist, you can choose to have the system add the adjustment (quantity forecast adjustment or unit forecast adjustment). 

 

  • The graph will update to display the original plan versus the delta as changes are made.
Page break

Project Level Cash Flow Analysis

  • Once all budget line items are forecasted, teams can access a project-level cash flow analysis to easily visualize the cash flow distribution throughout the project lifecycle.
  • This real-time summary enables teams to see planned actual and forecast quickly. It also provides the ability to drill into details if needed.
  • To access this, open the Forecast tool via the left sidebar then, select the Cashflow tab.

Time-Versus-Money Chart Navigation

 

  • To display the built-in dynamic time-versus-money chart, select the chart icon.
  • Click Revised Budget, Work Completed, Actual Cost, or Forecast Final Cost to switch between views. 
  • Choose to display the information by amount or percent. 
  • Use the control icon to access the chart’s settings to display the chart by period, cumulative, or cumulative & by period. 
  • Hover over a specific point on the chart to view detailed information. 

Table Navigation

 

  • Use the control icon to rearrange columns and hide/show months. 
  • Use the filter icon above the cart to filter/group the information within the table. 
  • To save views, select Default View, then Save Current Views. 
Page break

  • To dive deeper, hover to the right of the line item’s name to access the option to open details view. 

  • With the details view open, select the name of a budget item to view specific information/make updates within the details flyout panel. The graph will also change to display the information relevant to that item for the particular view you’re in. 
  • To delete distribution directly from the table select the three dot more menu.
Page break

Forecast Distribution Date in Details Flyout Panel

  • When a budget payment application, cost payment application or expense is approved, the ‘Forecast Distribution’ date field within the details flyout panel will display the same date as the ‘Approved’ date.
  • However, it can manually be modified manually to meet your needs.

Back to the top