Company Level Roll up Cashflow Curve Worksheet
To open a Company level Roll up Cashflow curve worksheet for an existing curve:
- Go to the Company Workspace tab and switch to User mode.
- In the left Navigator, select Cost Manager, and then select Cash Flow to open the Company level Cash Flow log.
If you cannot see the Cash Flow sub-node, ensure that your company administrator has granted you the necessary permissions to the sub-node.
- Select a Company level Roll up Cashflow curve from the Company level Cash Flow log and double-click the curve to open the Company level Roll up Cashflow curve worksheet window.
The Company level Roll up Cashflow curve worksheet window is divided into two panes. You can open the right pane by way of moving the split screen (slider) to display the cash flow details pane, as shown in the following typical screen capture.
Company Level Roll up Cashflow curve worksheet Window Toolbar
The toolbar options are:
- View drop-down
Use this option to "Create New View" for the worksheet, or to "Manage Views" that have been created.
Similar to the errors and warnings in BPs, if there are any alerts or errors on the cash flow curve (errors due to mismatch in time scale of project cash flows), an error icon is displayed the "View" controls that shows the number of errors. When you click the error icon, a window opens that lists the error messages corresponding to the project cash flow curves.
- Edit View
When you click the Edit View option, the Edit View window opens. In this window you can select the curves that you want to view on the log (for Curves, Inflow, and Outflow). In this window you can also add columns and group your columns when you click the Group By tab.
- Print
Select one or more cash flow curves from the log and click Print from the toolbar to access the following print options:
- Print
To open a window that lets you select a method to print the selected curves.
- Export to CSV
To open a dialog box that lets you save a Microsoft Excel Comma Separated Values (CSV) File version of the selected curves, so you can export the file to a desired destination.
- Export to Excel
To open a dialog box that lets you save a Microsoft Excel Worksheet version of the selected curves, so you can export the file to a desired destination.
Notes:
- For export to Microsoft Excel, the system currently supports only Euro (EUR) and United States Dollar (USD) currency symbols.
- If you export data from a business process (BP) record, sheet (such as an Activity Sheet), or log (such as Company Funding Sheet Log) to Excel, be aware that depending on how your negative values are formatted, you might need to configure your columns in Excel to match the correct data type (Number). Otherwise, the columns will not be treated as numeric and will not sum as expected. One supported format includes placing the negative sign between the currency symbol and the amount (for example, $-1,000).
- Print
- Snapshot menu drop-down
For important details about this option, see Working with Company Level Snapshots.
Company Level Roll up Cashflow curve worksheet Window Graphs View
The graphs view pane provides graphs presentation for the following Roll up Cashflow curves:
- Cumulative curve
A Cumulative curve displays the net of all cash flows over a period of time.
- Incremental curve
An incremental curve displays the cash flow for a certain period.
Company Level Roll up Cashflow curve worksheet Window Cash Flow Details
Note: Use Expand or Dock (upper-right corner) to maximize or to adjust the cash flow details pane (All Curves) screen for better visibility.
The View option in the cash flow details pane lets you switch between the Incremental and Cumulative data values. The data sources that have been selected in the properties, are listed within each view selection. If you double-click and open each of the data sources, you can see pertinent details for that data source, as described below.
Actuals (Spends)
If you select the Incremental view and click Actuals (Spends) (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Approved Budget
If you select the Incremental view and click Approved Budget (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Baseline
If you select the Incremental view and click Baseline (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Forecast
If you select the Incremental view and click Forecast (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Original Budget
If you select the Incremental view and click Original Budget (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Shared Budget
If you select the Incremental view and click Shared Budget (under the Name column), the actual spent amounts, per time period, are displayed. These values are not editable and cannot be distributed. You can use the toolbar options to:
- Export
To export one or more curves to a CSV file, which is automatically named after the cash flow worksheet.
- Refresh
To update the data, or amounts, on the page.
- Find on Page
To find a particular amount.
If you select the Cumulative view, the net of all cash flows, over a period of time is displayed, with the same toolbar options as for the Incremental view.
Related Topics
Last Published Wednesday, July 2, 2025