The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

New Research Points to Systemic Failure of Spreadsheet Risk Management Within UK Organisations

A new survey* from ClusterSeven, an international provider of strategic spreadsheet and data management software, shows that 56.5% of spreadsheet users have never received formal training on the spreadsheet package they use. Worryingly, 47% have never even been offered spreadsheet training.

Of those surveyed by ClusterSeven, 72% admitted that no internal department checks their spreadsheets for accuracy. Only 12.9% said that Internal Audit reviews their spreadsheets, while a mere 1.1% receive checks from their risk department.

Spreadsheets enable organisations to quickly and flexibly perform analysis that would otherwise be difficult or time consuming, says ClusterSeven. As a result, businesses tend to place undue trust in the integrity of the analysis captured in their spreadsheets.

Ralph Baxter, CEO of ClusterSeven, said: “This research is a clear indication that organisations are systemically failing to properly control the way in which spreadsheets are being used and managed. Over the last number of years, high profile cases have brought spreadsheet usage to the forefront of organisations risk management procedures, but unfortunately governance has yet to catch up.. Organisations need to understand the risks they now face, and not when a serious financial error has arisen.”

Further research by ClusterSeven has shown that 47.2% of users made between one and four errors on their spreadsheets, while 11.6% made between five and 10 errors. Shockingly 6.6% made more than 11 errors following the construction of their spreadsheets.

Ralph Baxter continued: “It is clear that the prospects for serious errors occurring within spreadsheets are very likely, with over 65% of interviewees admitting to making mistakes. This is extremely worrying considering that organisations rely on carrying out business critical data processes using this tool, which some cases involve millions of pounds in transactions.

“Currently no department is charged with reviewing and securing spreadsheets, leaving this process entirely in the hands of the end-user. As our research has shown, this needs to change, with one department charged with maintaining policy for the review and security of all business critical spreadsheet usage. This can be carried out cheaply and effectively with the tools readily available, coupled with user training and individual risk assessment of spreadsheets.”

Related content

WEBINAR

Recorded Webinar: Managing Valuations Data for Optimal Risk Management

This webinar has passed, but you can view the recording here. Our panel of experts delves into how to ensure valuations data quality for optimal risk management. Post-Credit Crisis, valuations have emerged as a key data set for addressing risk of exposure to illiquid and other hard-to-value over-the-counter instruments. Regulators are pressing for more transparency...

BLOG

GoldenSource Ushers Reference and Pricing Data into the Front Office with Quant Workbench

Extracting value from data is a priority for financial institutions as the business looks to increase efficiency, reduce costs, identify new opportunities and gain competitive advantage. Some source in-house tools to improve the quality and accessibility of internal and external data, others look to third-parties for solutions. A new tool from GoldenSource, Quant Workbench, brings...

EVENT

Data Management Summit Virtual

The Data Management Summit Virtual will bring together the global data management community to share lessons learned, best practice guidance and latest innovations to emerge from the recent crisis. Join us online to hear from leading data practitioners and innovators from the UK, US and Europe who will share insights into how they are pushing the boundaries with data to deliver value with flexible but resilient data driven strategies.

GUIDE

Best Practice Client Onboarding

Client onboarding is central to the success of banks, yet it continues to present challenges and the benefits of getting it right are difficult to achieve. The challenges arise from siloed systems, manual processes and poor entity data quality. The potential benefits of successful implementation include excellent client experience, improved client acquisition and loyalty, new business opportunities, reductions in costs, competitive advantage, and confidence in compliance.