Control Sheet - Cashflow
Cashflows in RIB CX
CASH FLOW Control Sheet are linked to your budget form. If you respond to your budget form and make changes, upon submitting, these changes WILL NOT be SAVED. The only way to adjust figures in your budget is to create budget variations or transfers. Please contact your RIB representative for more help.
The Cash Flow Forecasting feature in RIB CX allows users to compare the Final Forecast Cost with the Certified to Date amounts, providing a clear and accurate view of financial progress. Users can allocate remaining costs over future months using various distribution methods, including even distribution, S-Curve, or manual adjustments.
This streamlined functionality empowers project managers to efficiently monitor projected costs and maintain comprehensive financial oversight, ensuring better planning and control throughout their projects.
Cash Flow Display in Control Sheet Menu
Navigate to Contracts Admin → Control Sheets → Cash Flows Folder.
This folder is dedicated to Cash Flow management, enabling quick access within the control sheet structure.
Visibility Based on Permissions
Access to the Cash Flows folder is controlled through module matrix permissions.
Only users with the appropriate permissions will be able to view and interact with Cash Flows.
Single or Multiple Cash Flows View
When a user clicks on Cash Flows, they will be directed to either:
The single Cash Flow for the project, if only one exists.
A list of Cash Flows, if multiple Cash Flows are available, allowing the user to select and view each as needed.
Cash Flow Analysis
The Cash Flow page provides a detailed view of Cash Flows tied to specific budget lines, enabling both automated and manual adjustments to support accurate financial tracking.
Cash Flow Lines Based on Budget Lines
The lines and values on the Cash Flow page are derived from the budget lines of the selected budget specified in the configuration page.
The Cash Flow control sheet will display these columns from the budget
Item number
Code (if available)
Line item description
Final Forecast Cost
Certified to Date
Cost to Complete
Cash Flow Scenario Analysis Profile Types
Following on from the columns linked to your budget is the Cash Flow Profile type.
When conducting Cash Flow analysis on n projects there are 3 options available for each row::
S-Curve Analysis
Description: The S-Curve method in Cash Flow forecasting allows for the visualisation and analysis of cumulative costs over time, typically starting slow, increasing rapidly during the peak construction phase, and then slowing down again as the project nears completion.
Usage: Helps in understanding the overall financial progress and ensuring that spending aligns with project milestones. It adjusts dynamically based on actual costs and forecasts the remaining budget in line with the S-Curve pattern.
Switching to S-curve or Even Distribution Mode (From Manual):
No confirmation pop-up is shown.
Manual row values are automatically overwritten with the selected profile’s default values.
S-curve values are configurable. Click here to learn more about how to do this.
Even Distribution
Description: Even distribution spreads the projected costs evenly across the project timeline. This method assumes that costs are incurred uniformly over the project duration.
Usage: Ideal for projects with consistent financial outlays, this method simplifies forecasting and helps in maintaining a steady Cash Flow, avoiding peaks and troughs in financial requirements.
Manual Distribution
Description: Manual distribution allows project managers to input specific cost values for each period manually. This method provides the highest level of customisation and control over the Cash Flow forecast.
Usage: Suitable for complex projects with irregular spending patterns, this method accommodates unique financial arrangements and adjustments as the project evolves.
Switching to Manual Mode (From S-curve or Even Distribution):
When switching to Manual Mode, a confirmation pop-up appears with the following options:
Clear Values: Clears all forecast values in manual rows.
Keep Values: Retains current forecast values in manual rows.
Users can select their preferred option, and the system will apply the choice before switching to Manual mode.
You can apply any of these profiles to a row of the Cash Flow by simply changing the drop down option. This will adjust the values for the future months based on the option selected.
Start Date and Finish Date
You can then select the start and end dates for your cashflow analysis period for each row. This will determine the months available in your Cashflow Control Sheet for your analysis.
For example:
In the below snapshot changing the Start Date from Dec-2024 to Jan-2025 for 001.001 will make Dec-2024 $0 with the cost to complete figure being evenly distributed from Jan-2025 to Dec-2025.
Changing the End Date to Apr-2025 will spread the cost to complete evenly over the period of Dec-2024 to Apr-2025.
Breakdown by Contract and Forecast Components
You can expand a budget row in the cash flow to see a more detailed breakdown of its final cost. This breakdown shows the separate values contributing to the total cash flow, including contract amounts, variations (approved and submitted), and forecast entries like trade reserves and contingency.
To expand rows Hover near the Item Number and an Expand button will show.
Click on the Expand Button.
Child rows show up for each of the following if their value is not zero:
Contract Amount
Approved Variations
Submitted Variations (Variation amount Value)
Trade Reserves
Contingency
Any other forecast form types linked to that line
Child rows pull data directly from linked budget and forecast records.
The sum of all child rows matches the original row’s final forecast cost.
You cannot remove/collapse individual child rows - only collapse the whole set.
Once expanded, the parent header becomes read-only to prevent changes while child rows are visible.
Actuals will also be separated out to show the values that were claimed against either the contract, approved variations or Pending Variations.
The child rows will inherit the cashflow profile and start and end dates and break out the numbers automatically.
You can set individual profiles for the sub rows for further analysis if needed.
The breakdown only displays rows where a value (positive or negative) exists
Contract amount, approved variations, and submitted (open) variations are listed
Trade reserves, contingency, and other linked forecasts are shown individually
Expanded rows export cleanly to PDF, Excel, and API
Manual Adjustments
Users can add new lines at the bottom of the Cash Flow to input manual adjustments.
Positive and negative amounts are supported, providing flexibility for both revenue and expense tracking.
Click on the Append Row option to add a new row
Managing Actuals (Claims)
The Cash Flow displays static data by default.
Users can click the Update from Budget button to pull the latest data from the subcontractor budget control, ensuring the Cash Flow reflects any recent budget updates.
Based on the configuration provided here the actual values from claims can be added to the Cash Flow by clicking on the Update from Budget
Once you include the actual values, the Cost to Complete will be adjusted to reflect the actual values and the Cash Flow projects will be automatically adjusted based on the remaining months and values for each row Cost to complete column in the Cash Flow.
Actuals are shown below with adjusted Cash Flow projects for each month
Variance Analysis
Variances are highlighted in a new column, showing changes in red when there is a difference.
The variance highlighted here is the difference between the Cost to complete value and the projected Cash Flow data for each row.
Approval / Snapshot
Cash Flows can be approved similar to subcontract control sheets, with an approval button and Excel snapshot saving.
Benefits:
Record Keeping: Maintain a snapshot of approved Cash Flows for audit and compliance purposes along with using snapshot data for further data manipulation and graphical representation.
Index Row (Weighting)
A configuration option has been added to toggle the visibility of the Index Row on the Cash Flow Control Sheet.
Default Setting: The index row is visible.
If turned off, the index defaults to 100% (1) for all months.
The Index Row appears at the top of the Cash Flow grid.
Users can enter an index value (percentage) for each month:
Actuals: Always fixed at 100% (1).
Forecast Months: The total of the index values must equal the number of months in the Cash Flow.
In the example below, I have adjusted the month of May-25 to be 75% of the original forecast
And I have added back an extra 25% each for the months of Jun-25 and Jul-25. Which means the total index is now 25% over hence the index percentage are shown in red.
To resolve this you can distribute the percentages equally
Updating Forecasts
Users can update forecasts using one of two options:
Update Actuals: Calculates the revised forecast using the latest actual numbers and index values.
Update Revised Forecast: Recalculates the forecast amounts using updated index values.
Validation
The system validates that the total of the index values matches the total number of months in the Cash Flow:
If the values do not align, a validation message will appear, preventing updates until corrected.
Tools Available
Bulk Row Operations
Ability to bulk select rows and apply start/end dates or Cash Flow profiles.
Benefits:
Efficiency: Quickly update multiple lines, saving time on repetitive tasks.
Consistency: Apply uniform changes across multiple data points, ensuring consistency in Cash Flow projections.
Bulk Edit Monthly Values
When bulk editing in Manual Mode, a pop-up appears with options for editing manual rows in the selected forecast columns.
Editing Options are:
Set Values:
Prompts the user to input a value.
Updates all selected cells in the manual rows with the entered value.
Clear Values:
Clears all selected manual column values in the forecast columns.
Clear Selected Rows:
Clears all data from the selected manual rows.
Clickable Line Items in Cash Flows
Each line item in the Cash Flow Control Sheet is now a clickable link.
Clicking on a line item takes the user directly to the Budget History page for that specific row.
Column Filtering
Ability to filter columns
Copy and Paste Functionality
Users can copy and paste values for individual cells, similar to current control sheets.
Expand/Collapse Rows
Heading rows on the Cash Flow page can be expanded or collapsed, allowing users to view or hide detailed line items as needed for a clearer view of overall or specific data.
Export and API Access
Cash Flow data can be exported to Excel and accessed via REST API.
API can be accessed here - https://auweb06.au.itwocx.com/cxR/api/help/index#!/ControlSheet/ControlSheet_GetCash Flow
Benefits:
Accessibility: Easily share Cash Flow data with external stakeholders or integrate with other systems.
Flexibility: Export data for further analysis or reporting in external tools.
Tabbing
When tabbing through the Control Sheet, the cursor will automatically select the entire value in the cell as it moves to the next cell.
This allows users to easily:
Replace the value by typing a new one.
Clear the value quickly with a single action (e.g., pressing delete or backspace).