Efficiency-led cost savings can be achieved by automating financial and compliance processes in spreadsheets
This year, the number of organisations instituting automated controls for spreadsheet management will increase as they recognise the risks these applications pose to their business. This approach will make the use and business purpose of spreadsheets more transparent, but importantly, organisations will gain operational efficiency cost savings.
Our research shows that today 88% of internal audit, finance, compliance and risk management professionals recognise the risks posed by spreadsheet applications. Only 24% of organisations are systemically enforcing a manual control policy; and a mere minority have actually instituted automated controls to mitigate spreadsheet risks. Professionals are spending, on average, 43% of their time monitoring and validating information on spreadsheets. Those in management, are spending closer to 47% of their time on this activity.
In the absence of technology-led automated processes, the burden of manually ensuring the accuracy of data held in spreadsheets is falling entirely on the professionals. Consequently, with a vast number of business-critical processes being undertaken in often poorly controlled spreadsheets, the benefit of the spreadsheet to users is gradually diminishing. The advantages of using spreadsheets – i.e. flexibility, agility, efficiency and productivity – are negating as managing them is becoming a drain on the time and resources of users. Also, nearly 50% of risk, finance and compliance professionals expect a significant financial and/or reputational loss event attributed to spreadsheet error to occur in the next two years.
Despite this and paradoxically, the use of spreadsheets for business-critical processes is expected to grow over the next two years according to auditors (nearly 60%), regulators (40%) and risk and compliance professionals (nearly 45%). Clearly, spreadsheets are a valuable tool for certain processes and tasks. They do the job, where perhaps corporate financial systems, which are the preferred option for operational processes, fall short of meeting user requirements. Spreadsheets are extensively used in financial environments for complex calculations and modelling. At the same time, spreadsheets are one of the key contributors of financial, regulatory, operational and reputational risk.
There is no merit in running a business using uncontrolled spreadsheet applications. These tools warrant the same level of scrutiny and management as that accorded to corporate financial systems. By automating the management of the financial and compliance processes in the spreadsheet environment, organisations reduce the risk of losses, compliance-related penalties and long-term reputational damage. Importantly, organisations optimise their efficiency and productivity gains and thereby make tangible financial savings as a result of reduced manual effort.
Here’s a simplistic scenario: there’s a population of 100 operational spreadsheets in an organisation, with an average of eight hours per month being spent on each application by an employee costing $50 an hour. So, each spreadsheet costs the company $400 per month or $4,800 annually to operate. For the full spreadsheet population, the tangible, operational cost to the organisation is $480,000.
Automation enables organisations to achieve a well-managed, controlled and yet flexible and agile spreadsheet environment. Technology can support spreadsheets across their lifecycle – from creation through to retirement and decommissioning by incorporating them into the core enterprise systems. This entirely eliminates the risk and inefficiency of manual checking, and offers assurance that the outputs derived from the data in spreadsheets are indeed accurate.
Get in touch
Let's talk about how ClusterSeven can increase transparency and control around your spreadsheets and give you confidence in your business critical processes and the accuracy of your data empowering you to make informed business decisions.Contact Us