Control Sheets - Cashflow

Cashflows in RIB CX

Open

The Cashflow 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.

Configuring Cashflow Control Sheets

Cashflow Option in Control Sheet Configuration

• Users can create a Cashflow Control Sheet directly from the Control Sheet configuration options.

• This feature allows the generation of cashflows specific to individual budgets.

Open

Cashflow Control Sheet Settings

• On the Cashflow Control Sheet settings page, users can select a Budget to define the cashflow scope.

The budget selections allows the control sheet to automatically import the rows within the budget into the cashflow control sheet.

You can then select the start and end dates for your cashflow analysis period. This will determine the months available in your Cashflow Control Sheet for your analysis.

Custom Configuration for Actuals Calculation

Users can configure how "Actuals" are defined within a cashflow control sheet i.e. which month the values from each claim will appear in as actuals.

Claim Date Field for Actuals

• Users can also select a Date Field to drive monthly cashflow actual values

  • By default, the Due Date is used.

  • Alternatively, if there is a custom date field on your claim form you will be able to select that date.

• Exclude List-Based Date Fields: Date fields that are part of a list are excluded. Only standalone date fields on the form are displayed.

• CLM Form Type Restriction: Only date fields present on any of the CLM form types will be available for selection.

• Form Layout Restriction: The system ensures that only date fields included in the form layout are displayed, providing a clear and relevant set of options.

Actuals Configuration

• Choose between Pending + Approved or Approved Only for which Claim values should be used as actual figures.

  • Pending + Approved = will include Claims which are pending and approved for a given month using the date field configuration mentioned above

  • Approved only = will only include claims in an approved status.

• This flexibility allows for more accurate cashflow tracking based on organisational preferences.

Multiple Cashflows per Budget

• Users can create multiple cashflows for the same budget by setting up a new Cashflow Control Sheet for each instance.

• To do this you can click on the Copy option for a cashflow to copy all the settings for a particular Cashflow control sheet.

• This supports tracking different cashflow perspectives or timeframes within a single budget.

Advanced Configurations

S-Curve Configurations

Configurable S-Curve with adjustable intersection and slope values.

By default these will be the s-curve values

• S-curve intersection (t) = 0.6

• S-curve slope at intersection (s) = 1.6

You can adjust these in the Control Sheet config page along with the rounding decimal place value.

Benefits:

• Customisability: Fine-tune cashflow projections to more accurately reflect project-specific spending patterns.

• Precision: Generate more accurate financial forecasts tailored to the project's cashflow dynamics.

Index Adjustment

What is Adjusting for Index?

Adjusting for Index is a powerful feature in the Cashflow Control Sheet that allows users to fine-tune monthly forecasts based on specific index values. By applying index percentages, users can model financial adjustments for underperformance or overperformance in projected cashflows, ensuring more accurate and dynamic budget management.

Benefits of Adjusting for Index

• Enhanced Forecast Accuracy:

  • Reflect real-world financial scenarios by adjusting cashflow projections based on performance indices.

• Flexible Financial Planning:

  • Support both positive and negative adjustments to align forecasts with evolving project conditions.

• Granular Control:

  • Apply adjustments at a monthly level, enabling targeted revisions without impacting unrelated periods.

• Improved Decision-Making:

  • Use dynamically updated forecasts to make better-informed financial and operational decisions.

Configuration Option for Index Row

Show weighting row can be toggled on or off. This configuration option if toggled on gives visibility of the Index Row on the Cashflow Control Sheet.

• Default Setting: The index row is visible.

• If turned off, the index defaults to 100% (1) for all months.

Refer here for how the Index Row works.