Edgar R. Fiedler was an American economist who served as Assistant Secretary to the Treasury between the years 1971-75. Edgar published a series of essays during the late 70âs and early 80âs once pithily stating âIf you have to forecast, forecast oftenâ something that seems especially relevant as we navigate the current economic climate of 2020.Â Â Â Â Â Â
As businesses of all shapes and sizes come to terms with the impact of the COVID-19 pandemic, executives and finance professionals continue to adapt to the changing landscape, turning to re-forecasting and scenario planning to help better predict what might be in store for the remainder of 2020 and beyond.Â Â
However, many organizations are finding out they are not as prepared as they should be, and do not have the right forecasting and reporting tools in place to support effective decision making during this difficult period.
Hereâs the Problem with Planning Budgeting and Forecasting
Forecasting at the best of times is a tough process. No one said it was easy predicting the future.
You will often hear organizations acknowledge inefficiencies around the whole budgeting and forecasting process, with many companies admitting theyâve put up with system limitations for far too long â inflexibility, no real time data, poor collaboration and lack of security are often cited.Â
While sub optimal, these challenges may have been at least manageable in a pre COVID-19 world, with organizations able to âmake doâ with what they have, but todayâs heightened environment is shining a light onto these legacy systems that typically rely on a complex web of Microsoft Excel based forms that are no longer fit for purpose.
Itâs becoming clear that these budgeting and forecasting bottlenecks are now taking a front row seat and will only serve to hinder an executiveâs ability to plot a way forward. Lots of finance teams realize that plans to modernize inhouse budgeting and forecasting tools can no longer be kicked into the long grass.
Top Five Planning Essentials in 2020Â
So, what exactly do companies have on their budget planning tools wish list in todayâs world? Many finance professionals are anxious and frustrated as they attempt to re-forecast and plan during these uncertain times.Â
Here are five key takeaways, in no particular order, captured during recent conversations with finance professionals from a multitude of industries to help improve your planning, budgeting and forecasting methods.Â
Finance teams need actuals to reside in one secure, central location and they tell us this should be in the Cloud. It needs to âjust happenâ and update in the background on a scheduled basis.Â
The juryâs decision is unanimous – manual exporting into Excel coupled with the necessary data manipulation and formatting just wonât cut it in todayâs world. It takes way too long and is greatly adding to frustration levels as executives continually push finance teams for accurate and meaningful data. A fully featured, structured data warehouse that may have once been viewed as a ânice to haveâ has now become essential for effective organizational wide forecasting and budgeting.Â Â
Multiple Versions & ScenariosÂ
High on the list is a renewed focus on the need to easily create and manage multiple forecasts and budget versions for analysis. Right now, scenario planning is crucial. The need to quickly run what-if analysis across a variety of different business scenarios has become an absolute necessity. It goes without saying that organizations need this to be on-demand, flexible and fully self-service.
Driver Based Forecasting
Speed and accuracy are vital to the planning process. Most organizations are familiar with the concept of driver-based forecasting, but quite often you will see a form of this deployed using traditional Excel. The following short video illustrates why companies are talking about the need for enhanced driver-based forecasting and budgeting.Â
The planning, budgeting and forecasting process has to be a partnership between business managers and finance. Too many finance teams tell us they carry too much of the burden when it comes to the planning process, yet it is difficult to adapt when companies are using traditional Excel models. To encourage wider budget ownership, we are seeing key requirements focused around a need for trackable assignments, automated workflow with review and approval functionality, coupled with a desire for real time updates and easy consolidation at the organizational level.Â Â
This will come as no surprise to anyone, but you wonât find many companies out there without a clearly defined Cloud strategy, and itâs safe to say that this includes forecasting and budgeting systems. Companies with traditional system deployments are now finding themselves fast-tracking cloud services due to the advent of increased remote working. Giving business managers faster and more reliable web-based access to centralized budgeting and forecasting assignments further supports the goal of wider stakeholder ownership, security, and auditability.Â
Does your Team Really Have the Correct Budgeting & Forecasting Tools?Â
Many organizations are using this time to evaluate Corporate Performance Management software as an efficient budgeting and forecasting tool. Yes, itâs another acronym into the mix, but if ever there were a finance technology category appropriate for these times, CPM could certainly make a strong play for the top spot.Â