Cash Flow Curve Templates
You can create cash flow curve templates that can be used to create cash flow curves in projects and CBS-code based shells. If you are using company-level cash flow, you can create roll-up curve templates. See Create Roll-up Templates.
Template creation methods are manual or involve copying an existing one. After creating a template, you can set refresh frequency and activate or deactivate curves.
Creating and setting up a template is essentially the same as setting up the curves manually in a project/shell. The major difference is you cannot select individual records in the template; these must be chosen from within the projects/shells. See Cash Flow Curves in the Unifier Managers User Guide.
The detail curve creates a worksheet in the project/shell that can include several curves. You can create detail curves and detail curve templates at the following detail levels:
- Cash flow by project or shell: You can track the costs associated with an entire project/shell over time.
- Cash flow by CBS: The creation of a CBS detail curve is similar to cash flow by project/shell. Use this option if cash flow needs to be tracked at the CBS level as opposed to the project/shell level, which lets you plot cash flow curves by specific CBS codes, or all codes, in the project/shell.
- Cash flow by Summary CBS: The creation of a Summary CBS detail curve is very similar to cash flow by CBS. Use this option if cash flow needs to be tracked by summary CBS codes. To select this option, the project/shell cost sheet must use a tree structure—and therefore has summary CBS codes—rather than a flat structure.
- Cash flow by commitment: This option lets you plot and analyze cash flow data for an entire commit record (including base commit, any change commits, and related invoices). You can choose the specific business process commitment record within the project/shell, such as a purchase order or contract, and track the cost information over time.
Notes:
- You can set up the automatic creation of a cash flow curve when a base commit record is created and completed or reaches a particular step. This is done in the BP Setup for the business process. For more information, see Setting Up Auto-Creation of Cash Flow Curves from Contracts.
- You can define views for each cash flow detail level to include in the template. You can also select one view per detail level to function as the default view. For more information, see Defining Global Cash Flow Views for Inclusion in Templates.
To create a cash flow detail level curve in a template:
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, do one of the following:
- To create a detail curve in a project/shell template, select Templates. Open the project/shell template. In the left Navigator, select Cost Manager, and then select Cash Flow. This cash flow model can be copied during project/shell cloning.
- To create a template, select Standards & Libraries, select Cash Flow, and then select Templates. This is a template users can select at run time. This option is available in Classic view only.
The Cash Flow log opens.
To create a cash flow detail level curve in a template from Templates:
- Click Create. The New Cash Flow Worksheet window opens.
- Fill out the General block of the form by defining the name, description, and detail level.
- Configure the additional options as needed:
- Filter CBS Codes or Filter Summary CBS Codes
- Rollup cashflow data to company?
- Time Scale: Set the period type, choose by month or by year, and set the format of the curve dates. If you select Financial Period, for a project/shell template, you can define the Cutoff Spends and the snapshot date in the Period Close Settings for cash flow curves by Project, by CBS, and by Summary CBS for the shell templates.
- Add curves in the right pane. Select a curve type from the drop-down list and fill out all fields.
- Click Save & Close when finished.
To create a cash flow detail level curve in a template from Standards & Libraries (Classic view):
- Click the New button. The Properties window opens.
- Fill out the following tabs, and click OK when finished.
- General tab: Define the name, description, detail level, time scale and period close settings.
- Curves tab: Define individual curves (Baseline, Forecast, Actual (or Spends), Portfolio Budget, Derived, and Custom curves) that will be part of the group of curves that make up the cash flow detail curve.
- Filters tab: Limit the cash flow data on your curve to a particular set of CBS codes or (if the cost sheet is tree structure) summary CBS codes. If you do not specify a filter, all codes will be used for the data.
- Options tab: Define the format to use for the numbers displayed on the cash flow worksheet.
- Schedule tab: Enable automatic refresh of the cash flow curve, and set the refresh schedule.
- Summary tab: A Summary Cash Flow Curve displays selected cash flows from your project.
Last Published Monday, October 7, 2024