Using Activity Sheet Data to Track Baseline, Forecast, and Spends in Cash Flow
You can perform Cash Flow analysis based on the budgets, forecast projections, and actuals received by using the Planned, Remaining Cost, and Actual Costs received from the Activity Sheet. In summary, for:
Cash Flow curves: CBS Detail, Baseline, and Forecast (Activity level)
Ability to define Baseline and Forecast Cash Flow curves with the Activity Sheet (Activity level) selected as a source for distribution or cost. In this scenario:
The period distribution for each CBS Code will be received at Activity level, from the selected Activity Sheet. The value is the sum of all the planned units for each CBS code by day which it will be used to distribute the costs. The schedule will be disabled after you select Activity Sheet as the distribution source.
The cost distribution for each period can either be calculated based on the units and total cost received from cost sheet column, or based on the cost spread received from Activity Sheet (Activity level).
You can get data either from the current project or the baseline.
Cash Flow curves: CBS Detail, Baseline, and Forecast (Resource level)
Ability to define Baseline and Forecast Cash Flow curves with the Activity Sheet (Resource level) selected as a source for distribution or cost. In this scenario:
The period distribution for each CBS Code will be received at Resource level, from the selected Activity Sheet. The value is the sum of all the planned units for each CBS code by day which it will be used to distribute the costs. The schedule will be disabled after you select Activity Sheet as the distribution source.
The cost distribution for each period can either be calculated based on the units and total cost received from cost sheet column, or based on the cost spread received from Activity Sheet (Resource level).
You can get data either from the current project or the baseline.
Cash Flow curves: CBS Detail, Spends (Activity level)
You can define Spends Cash Flow curves when the Activity Sheet (Activity level) is selected as a source for cost. The value is the sum of all the actual costs for each CBS code per day across the activities.
Cash Flow curves: CBS Detail, Spends (Resource level)
You can define Spends Cash Flow curves when the Activity Sheet (Resource level) is selected as a source for cost. The value is the sum of all the actual costs for each CBS code per day across the activities.
Similar to the P6 Summary Sheet, you can use the Activity Sheet as a source in Cash Flow.
The following table explains the details:
Type | CBS |
|---|---|
Baseline (Distribution) | Activity Sheet (Activity Level) Sum all the planned units for each CBS code by day which will be used to distribute the costs. You can select either the current project or the baseline. (Schedule disabled) Activity Sheet (Resource Level) Sum all the planned units for each CBS code by day which will be used to distribute the costs. You can select either the current project or the baseline. (Schedule disabled) |
Baseline (Cost) | Cost Sheet Column Activity Sheet (Activity Level) Sum all the planned costs for each CBS code by day. You can select if this is from the current project or the baseline. Activity Sheet (Resource Level) Sum all the planned costs for each CBS code by day. You can select if the from the current project or the baseline. |
Baseline (Schedule) | Schedule is derived from the unit distribution. |
Spends (Cost) | Activity Sheet (Activity Level) Sum all the actual costs for each CBS code by day. Activity Sheet (Resource Level) Sum all the actual costs for each CBS code by day. |
Forecast (Distribution) | Activity Sheet (Activity Level) Sum all the remaining or at completion units for each CBS code by day which will be used to distribute the costs. (Schedule disabled) Activity Sheet (Resource Level) Sum all the remaining or at completion units for each CBS code by day which will be used to distribute the costs. (Schedule disabled) |
Forecast (Cost) | Cost Sheet Column Activity Sheet (Activity Level) Sum all the planned costs for each CBS code by day. Activity Sheet (Resource Level) Sum all the remaining or at completion costs for each CBS code by day. |
Forecast (Schedule) | Schedule is derived from the unit distribution. |
Note: Be aware that when the cost and schedule are brought in from the System Activity Sheet or a manual Activity Sheet and the Project Type is Baseline or Current, the cash flow uses the earliest date across Planned, Actual, or Remaining Cost as the From Date and the latest date as the To Date.
In This Section
Last Published Wednesday, July 2, 2025