Project or Shell Level Cash Flow Worksheet Overview Section
The project or shell level cash flow worksheet overview section provides a visualization of key information, snapshot changes, and system snapshots for faster understanding of project financial conditions. This section of the cash flow worksheet displays the current, at completion, and remaining cost-related information for the project, as well any remaining forecast amount and time, for the selected curve. click the Show More option, on the lower-left corner to expand the screen and see more details.
The following provides information about assigning inflow, outflow, variances, and forecast.
Assigning Inflow and Outflow
- Inflow = the amount assigned to the project as the budget. For example, this may come from either a cost sheet column or a system activity sheet in the system.
- Outflow= the amount that has been spent and forecasted to be spent. For example, the Actuals (Spends), Invoices, Forecast (coming from Cost Sheet), are considered Outflow in the system.
Variance Analysis
You can view inflow vs. outflow analysis in the three tiles at the top of the cash flow worksheet:
- Current Cost Variance shows the difference between the current cost inflow and the current cost outflow. The change in current cost variance against the last snapshot displays beside the total.
- At Completion Cost Variance shows the difference between the at completion cost inflow and the at completion cost outflow. The change in the at completion cost variance against the last snapshot displays beside the total.
- At Completion Schedule Variance shows the difference between the at completion schedule inflow and the at completion schedule outflow in months. The change in the at completion schedule variance against the last snapshot displays beside the total.
A bar chart corresponding to the colors of the curves is visible below the variance amount. Hover over a bar to display a tooltip with corresponding information, and click Click to Open to open the curve worksheet.
Variance Analysis Table
Click Show More at the bottom of the tile to view a Variance Analysis Table containing the following columns:
- Curve Name
- Current total
- Changes from last Snapshot
- At Completion Total
- Changes from last Snapshot
- End Date
- Changes from last Snapshot
Forecast Analysis
Forecast curves include a separate forecast analysis section in which you can view Spends versus Forecast analysis and Forecast versus Baseline analysis. This section contains the following tiles:
- Remaining <Forecast Curve Name> Amount shows the difference between the at completion forecast amount and the approved spends till date. The change in the remaining forecast amount against the last snapshot is displayed beside the total.
- Remaining <Baseline Curve Name> Amount shows the difference between the at completion baseline amount and the approved spends till date. The change in the remaining baseline amount against the last snapshot is displayed beside the total.
- Remaining <Forecast Curve Name> Time shows the difference in date between the forecast curve end date and the actuals end date. The change in the remaining forecast end date against the last snapshot displays beside the total.
- Remaining <Baseline Curve Name> Time shows the difference in date between the baseline curve end date and the actuals end date. The change in the remaining baseline end date against the last snapshot displays beside the total.
Forecast Analysis Table
Click Show More at the bottom of the tile to view a Forecast Analysis Table containing the following columns:
- Curve Name
- Total
- Changes from last Snapshot
- Remaining Total
- Changes from last Snapshot
- End Date
- Changes from last Snapshot
- Remaining Time
- Changes from last Snapshot
Last Published Sunday, July 20, 2025