...
Heading rows on the Cashflow 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.
...
Bulk Row Operations
...
Ability to bulk select rows and apply start/end dates or cashflow profiles.
...
Benefits:
Efficiency: Quickly update multiple lines, saving time on repetitive tasks.
Consistency: Apply uniform changes across multiple data points, ensuring consistency in cashflow projections.
Export and API Access
...
Cashflow 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_GetCashFlow
Benefits:
Accessibility: Easily share cashflow data with external stakeholders or integrate with other systems.
Flexibility: Export data for further analysis or reporting in external tools.
Approval / Snapshot
...
Cashflows can be approved similar to subcontract control sheets, with an approval button and Excel snapshot saving.
...
Benefits:
Record Keeping: Maintain a snapshot of approved cashflows for audit and compliance purposes along with using snapshot data for further data manipulation and graphical representation.
Column Filtering
...
Ability to filter
...
columns
...
Copy and Paste Functionality
...
Users can copy and paste values for individual cells, similar to current control sheets
...
Benefits:
...
Efficiency: Streamline data entry processes, saving time and reducing errors.
...
.
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
Description: Users can adjust index values per month to calculate revised forecasts.
Benefits:
...
Adaptability: Adjust cashflow projections based on changes in project conditions or financial outlooks.
...
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
A new configuration option has been added to toggle the 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.
...
...
Index Row on Cashflow Control Sheet
The Index Row appears at the top of the cashflow 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 cashflow.
...
Calculating Revised Forecast with Index Values
The revised forecast is calculated using the index values for each month:
Factors < 100% (Negative Adjustments):
Calculate the negative percentage (e.g., 80% = -20%).
Determine the negative amount (e.g., 20% of $100,000 = $20,000).
Total the negative amounts and calculate the weighted negative distribution across affected months.
Adjust the monthly forecast for negative months accordingly.
Factors > 100% (Positive Adjustments):
Calculate the positive percentage (e.g., 110% = +10%).
Proportionally distribute the positive adjustments based on the total negative impact.
Adjust the monthly forecast for positive months accordingly.
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 cashflow:
If the values do not align, a validation message will appear, preventing updates until corrected.