Flexible tool
We developed a tool that allows users to move selected cashflows to different days, weeks, or months. This enables easy updates to the model when cashflow changes are identified.
Automated integration
By implementing a process to automatically integrate cashflow data from Xero downloads into the daily timeline using power query, each cashflow is mapped to the right expenditure or income line.
Streamlined Excel ribbon
Adding a new tab on the Excel ribbon has consolidated all the macro buttons, which has made navigating the complex model and daily timeline far easier.
Challenge
Adjaye’s process for updating its daily cashflow model was laborious, inefficient and prone to error. The firm needed an improved model that incorporated automatic cash inflows and outflows based on project and cost descriptions, while maintaining flexibility to accurately reflect its operations.
Solution
We identified an enhanced Excel model was the best way forward and focussed on three key areas:
- Fixed payment section: For each specific expenditure, users can now specify the frequency of the cashflow, amount, start date and currency. The model schedules this cashflow to occur on the nearest working day to the specified date.
- Payment run section: Users can save payment run downloads from Xero to a designated folder where the model extracts cashflow data using Power Query. The user can then map each cashflow to an income or expenditure, with the model integrating these cashflows into the daily timeline.
- Overlay section: This enables users to manually overlay any cashflow on any date to ensure the model retains its flexibility. The user can input cash overlays in any currency, which the model translates to the reporting currency.
Results
The functionality achieved within Excel has created an accurate and effective model that Adjaye continues to use to track and forecast its daily cashflow, updating it with payment runs from Xero.
Related Success Stories
We’re trusted modelling advisors across a wide range of business industries, including 10 FTSE 100 companies and Fund Managers with over £1.75 Trillion of assets under management.
Basalt Infrastructure Partners
Infrastructure Fund
