The Challenges of Spreadsheet-Based Forecasting
Spreadsheets are an indispensable tool for most organizations and understandably so; it is easy to use and adaptable to a wide range of uses. Despite its benefits, however, spreadsheet software is like any other software in that the appropriateness of its use for a given function depends on a variety of factors. Consider, for example, the planning and forecasting process – as an organization grows and matures, the planning and forecasting process requires supporting technology that offers features not required by a smaller organization, including centralized administration, collaboration and versioning features. When organizations reach this critical mass, they begin to seek out a more shareable, scalable, and trackable finance solution like cloud-based enterprise performance management (EPM) software.
This post discusses some of the ways over-dependence on spreadsheets can hinder the performance of small or medium-sized businesses (SMBs) with annual revenue under a billion dollars. The good news for SMBs is that they can now afford to take advantage of new versions of enterprise software that have been perfected by Fortune 500 companies and are now available in inexpensive cloud-hosted versions.
Six Challenges of Financial Reporting with Excel
Everyone has a favorite Excel nightmare. From incorrect or overridden formulas to employees drawing growth charts then working backward to the numbers needed to generate “the curve we want,” the decentralized nature of spreadsheets facilitates their misuse, whether intentional or not.
The potential for a spreadsheet-based solution to yield incorrect results increases with the number of users involved in the process and is often exacerbated when the users involved are not collocated. What began as a seemingly straightforward spreadsheet exercise may quickly escalate into a complex series of inter-dependent workbooks and worksheets, naturally increasing both the potential for errors and the time required to troubleshoot such errors.
Here are some of the major problems you are inviting by keeping a legacy Excel system going rather than taking advantage of new SaaS opportunities:
Inability to forecast accurately more than three months out. That means you can do cash flow well enough to get by, but good luck trying to project financial results for new markets or products.
The bomb that shows up at the worst possible time. Finance spreadsheets are likely to continually evolve, increasing in complexity and therefore in susceptibility to errors. If the spreadsheet models are not properly maintained and reviewed, errors may be discovered at the worst moment.
What-if scenarios are more like what-the scenarios. What happens if interest rates increase a half a percent in the next year? With a spreadsheet-based solution, it can be challenging to answer questions like these, questions which will inevitably come with an expectation that the answers be turned around quickly. Without a flexible, robust budgeting and forecasting platform, this type of scenario analysis often requires considerable overtime from those involved in the process.
You say “potato,” they say “tuber.” Whenever you have unique users creating and editing their own finance spreadsheets, which then must be merged to arrive at consolidated results, you will eventually encounter a mapping or terminology issue that yields skewed results.
Who has access to this spreadsheet? Attempting to maintain some semblance of security with a spreadsheet-based solution can be challenging to say the least. Security on network shares is normally out of the control of Finance, meaning that IT must regularly be engaged to help ensure that access is appropriately restricted. Unsecured spreadsheets are prone to unauthorized changes, improper disclosure of financial projections and a myriad of other issues.
The Two Biggest Problems with Using Excel for FP&A
In case you need more ammunition to convince the powers-that-be that you should abandon spreadsheet-based solutions, among the list of the problems such solutions may cause for planning, budgeting and accounting, including:
Data Integrity Problems
Lack of Communication Capacity
But the two biggest problems the white paper identifies are the wasted time and wasted talent that result from continuing to nurse a legacy spreadsheet system when a better solution is available at an affordable price.
Spreadsheet-based solutions cost time because each user invents a unique solution to a common problem. His or her original solution is often unseen because it gets erased in the merger of data into a single format. Time is wasted merging the data, reviewing the consolidated results and correcting errors.
Spreadsheet-based solutions waste talent by forcing valuable, highly-skilled people spend hours combing through spreadsheets to confirm the accuracy/integrity of formula, troubleshoot errors and try to adapt to the changing nature of the business. Talented professionals who feel their skills are not being utilized or that their development is being stunted may choose to pursue other opportunities.