For a head office treasury or finance team, setting up new cash forecasting process or refreshing an existing process can bring many benefits. Being able to accurately forecast a company’s future cash position reduces risk of future liquidity issues and minimises the opportunity cost of holding uninvested cash. Also, having fast access to reliable cash flow data allows the treasury and finance team to consistently contribute to the strategic decisions being made within their organisation.
However, designing and rolling out any new reporting process in a large organisation can be challenging. Especially if adequate preparation is not done in advance. Dealing with multiple peoples in multiple places using multiple systems might seem like a daunting task, but taking a structured approach to the design and roll-out of a new process, as well as carefully managing the communication with all stakeholders, will enable a smooth roll-out and ongoing operation.
CashAnalytics has created an in-depth guide to assist people who want to set-up a cash forecasting process in their company. This guide follows a number of straightforward stages and mirrors the successful roadmap we use with our own clients. This roadmap covers five key areas:
1. Setting business objectives
2. Designing a forecasting model
3. Scoping and planning
4. Process set-up
5. Communication and roll-out
1. Setting Business Objectives
The business objectives are the reason the new cash forecasting process is being put in place. Cash forecasting supports a range of high value business activities, and the business case for putting a process in place can have a number of dimensions.
The headline activities supported by cash forecasting often include:
|Working Capital Management||Ensuring the short-term cash and working capital needs of the business are adequately planned and provisioned for.|
|Debt and Interest Reduction||Gaining the required forecast visibility to confidently and safely use excess cash to reduce debt levels and interest costs.|
|Covenant and Key Date Visibility||Being able to accurately project expected cash levels on key reporting dates, thereby understanding the impact on covenant levels.|
|Liquidity Risk Management||Cash forecasting may not instigate a direct action but, in many cases, it is used simply as an early warning signal of future problems.|
2. Designing a forecasting model
The design of the forecasting model itself is a critical task. At a basic level, the forecast model outlines the level of reporting detail required and the forecast time horizon.
Often the level of reporting detail in a cash forecast mirrors the level of detail in management reporting packs. This, at the very least, is a useful starting point.
It’s always a good idea to start with the simplest model first. One that provides the base level of required information. This can then be scaled to a more detailed or complex model over time.
3. Scoping and Planning
Once the business objectives have been set and the forecast model designed, the next step is to scope the project and set a plan.
This planning process won’t be much different to planning for any other project, but it remains an important consideration. A planning document should identify:
- Required timelines and other events that may impact the delivery of the project (e.g. year-end closing)
- Key stakeholders and their availability.
- Other dependent systems and data sources.
- Setting the project team and assigning responsibilities.
4. Process Set-up
The process set-up is a practical step that brings the requirements outlined in the design, scoping and planning stages to life. Whether using a manual tool such as excel or a dedicated cash flow forecasting software solution designed to automate the manual parts of the process, the three steps outlined below will need to be covered.
Step 1: Tool Configuration
Configure the chosen tool so that it mirrors the required reporting structure and maps to the correct master file data (business unit names, etc.)
Step 2: Map to Data Sources
Mapping to other data sources such as ERP systems is a key automation step than needs to be considered, but is often left until after the base reporting process is in place.
Step 3: Testing
The testing phase ensures that the implemented structures produce the required reporting output, and that the data interfaces are working correctly.
5. Communication and roll-out
Clear communication to all stakeholders will be required throughout the project. However, communication is particularly important in and around the time the process is ready to be rolled out to the wider organisation.
It is a factor that is sometimes overlooked but clear and consistent communication with stakeholders, particularly those people contributing forecast information, is key success factor in both the initial roll-out and ongoing operation of the forecasting process.
During the roll-out part of the project, training will need to be provided to everyone involved. This typically takes the form of webinars supported by training documentation. On an ongoing basis, dialogue and communication will centre on feedback, business analysis and the continuous improvement of forecast quality.
Bank reporting connectivity: the key to live cash flow visibility
Many people working in corporate treasury and finance teams struggle to gain visibility over current cash flow levels due to an unwieldy number of accounts. The vast array of different accounts means that the manual, slow, and administratively heavy task of accessing bank account information prevents any kind of real-time, ...John Champion - April 11, 2019
Product Updates: March 2019
Continuing our monthly Product Update series, this blog post offers a retrospective look at software upgrades made by CashAnalytics over the previous month. Below, you’ll find a close look at a couple of key improvements, which demonstrate our commitment to client lead product innovation. New: Updated User Interface Over ...John Champion - April 05, 2019
Big Data in Finance
As “Big Data” and analytics facilitate the finance team’s transition from cost-centre to strategic business partner, new opportunities are opening up for individuals willing to acquire the necessary skills. Why is this in focus now? In recent years, new technologies and lower computing costs have made it possible for ...John Champion - March 26, 2019