Recent studies by ClusterSeven, risk consultant Protiviti and accountancy institute the ICAEW have concluded that organisations are putting themselves at considerable financial and reputational risk by failing to properly control the way they use spreadsheets. The Protiviti/ICAEW survey revealed that three quarters (75%) said that their company did not have a policy or processes in place relating to the design, development and/or control of spreadsheets.
Of those accountants surveyed, almost a quarter (23%) claim their organisation has experienced financial or reputational losses that can be directly attributed to the use of spreadsheets or poor controls governing the use of spreadsheets.
According to ClusterSeven, financial institutions will continue to report high profile instances of data mismanagement and fraud unless they take 100% control of the vulnerable financial data files that move and manipulate information between their business systems. These include files known as comma separated variable (CSVs) plus spreadsheets and databases.
“Spreadsheets and CSVs are the ‘glue’ that joins everything else together. If this ‘glue’ is contaminated – such as bad data values – then this will be extremely difficult to spot further down the line. Many firms get used to accepting exceptions in this data such as test values or balancing items. However, these loopholes can hide more malicious entries for long periods. Many firms do not realise how vulnerable their unstructured data processes are until it is too late as they lack formal processes and tools to make sure all these critical data files are accurate and truthful,” said Ralph Baxter, chief executive officer (CEO) of ClusterSeven.
The intense focus on data management by banks and insurers, particularly in light of Basel III, Solvency II and other regulatory moves, has shone the spotlight on the highly sophisticated spreadsheets and CSVs that underpin modern businesses.
A report by broking group Marsh examines the repercussions from the administration of the South Korean company, which filed for bankruptcy protection at the end of August.
Global research by C2FO suggests that smaller businesses are less concerned with the repercussions of Brexit and the upcoming US presidential election.
A squeeze on skilled talent means it now takes an average of seven weeks to fill open permanent roles in finance in the UK according to new research from financial services recruitment firm Robert Half.
Early-stage merger and acquisition deals in Asia-Pacific show nearly 10% year-on-year growth in recent months.