This topic discusses cash flow templates that you can create in Standards and Libraries > Cash Flow > Templates. For instructions on how to create cash flow curves, refer to the Unifier User Guide.
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 programs or company-level cash flow, you can create rollup curve templates. See Create Roll-up Templates.
Template creation methods are manual or 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 or shell. The major difference is you cannot select individual records in the template; these must be chosen from within the projects or shells.
The detail curve creates a worksheet in the project or shell that can include several curves. You can create detail curve templates at the following detail levels:
- Cash Flow by Project/Shell
Used to track the costs associated with an entire Project/Shell over time.
- Cash flow by CBS
Used to track cash flow at the CBS level as opposed to the project or shell level. Allows you to plot cash flow curves by specific CBS codes, or all codes, in the project or shell.
- Cash flow by Summary CBS
Used to track cash flow by summary CBS codes. In order 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
Used to plot and analyze cash flow data for a base commit record (including base commit, any change commits, and related invoices). You can choose a specific business process commitment record within the project/shell, such as a purchase order or contract, and track the cost information over time. Each commitment record can have one baseline curve.
Note: 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.
To create a new cash flow detail level curve in a template
- Do one of the following:
- To create a template: In Administration mode, go to the Company Workspace tab and click Standards & Libraries > Cash Flow > Templates in the left navigator.
- To create a detail curve in a project or shell template: In Administration mode, go to the Company Workspace tab and click Templates in the left Navigator. Open the project/shell template. Go to Cost Manager > Cash Flow. The Cash Flow log opens.
- Click the New button. The Properties window opens. Refer to the Unifier User Guide for instructions on completing the Cash Flow Curve properties.
- 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, then 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.
To add filters on a Cash Flow Curve template
- Go to Company Workspace tab > Admin mode > Templates > Project/Shells.
- Open your Project/Shell template > Cost Manager > Cash Flow.
- Click New to configure your Cash Flow curve or open an existing Cash Flow curve.
- Click View and select Filter.
Note: Alternatively, you can open the Filter window by way of clicking the filter icon on the upper right-hand corner of the Cashflow Worksheet window.
- Select which curves to display. Deselect any curves you do not want to display.
- In the Save As field box enter a name for the filter.
- Click OK to close the window.
- The name of the filter that you have saved appears on the upper right-hand corner of the Cashflow Worksheet window. This window contains a list of saved filters that have been saved.
Note: The Default View option allows you to select which particular filter to display when you open a Cash Flow Worksheet.
- You can click Edit > select Manage Filters to delete, set default view, change name, and change the description of your filter.
- In the Cash Flow log window, ensure that your Cash Flow curve is selected and click Update Shells.