Skip the Spreadsheet — Drive Productivity and Quality with EPM




  • — April 23, 2018

    Running a successful business starts with effective planning and control. These functions are otherwise known as performance management, and the data that is generated during these critical steps is among the most important and sensitive in an organization. A miscalculation or an oversight could sow the seeds of a future disaster for a department, line of business, or entire enterprise.


    Despite the high stakes, many businesses still rely on disparate, outdated tools for planning and performance management – usually a spreadsheet software like Excel — which must be manually reconciled by the finance department at the end of every reporting period or planning cycle.


    Consider Conviviality, one of the UK’s largest drinks wholesalers, which recently adjusted its EBITDA forecast to 20 percent lower than the £70m market expectation due to “a material error in the financial forecasts.” The error, Conviviality later admitted, was “a spreadsheet arithmetic error.” Upon reporting the materiality of this spreadsheet error, 60 percent of Conviviality’s share value was wiped out overnight, and within a few short weeks, Conviviality plunged into administration.


    At first glance, spreadsheets seem like an ideal choice for planning and performance management. They are easy to use and easily distributed. Plus, nearly everyone has a copy of Excel or its equivalent on his or her desktop. But, online spreadsheets are particularly vulnerable to human error, as they rely on manual data entry to create budgets and plans. If any part of the data is entered incorrectly, it may throw off the entire plan.


    Further, using a spreadsheet software to generate and maintain critical planning data is quite expensive in terms of resources and risk. E-mail handoffs and manual reconciliations are incredibly time-consuming (and error-prone). In addition, linked Excel files, especially those used during the FP&A process, can contain multiple links. The added complexity of file linkage makes distribution not only difficult to manage but also difficult to execute.


    The CFO is on high alert as they now reimagine their roles in an era of digital business transformation, increased regulatory transparency, and expectations that finance should help in response to increasing volumes of data and greater stakeholder scrutiny. We are at a crossroads where the CFO can seize upon the opportunity to define technology’s place within the office of finance, mitigating risk through broader engagement across the enterprise in business critical processes and increasing transparency and audit capabilities throughout the record to report process.


    Enterprise performance management (EPM) systems allow organizations to streamline their planning and performance management processes, keep sensitive data secure, and reduce the potential for human error. In addition to improving efficiency, the core aim of the technology is to reduce human error. EPM gives finance a unique opportunity to drive quality enhancements across the business as well. EPM Systems, like most enterprise applications, contain audit trails, security, and data input logs that can be used to verify the data loaded into it. Whether the data is loaded manually or through an automated routine, it is in a self-contained system. Additionally, EPM is highly preferred to traditional spreadsheets by regulators that require security features for audit and compliance.


    When it comes to keeping financial information accurate and secure, the stakes could not be higher. One misstep can catapult an entire organization into disarray. So, it is vital to find the right products and processes to ensure safe and precise calucation and storage – and finance leaders should anticipate that this responsibility will fall to them more and more in the future.

    Business & Finance Articles on Business 2 Community

    Author: Jim Perry


    View full profile ›

    (1)