More NewsGreater Control of Vulnerable Financial Data is Needed, Warns ClusterSeven

Greater Control of Vulnerable Financial Data is Needed, Warns ClusterSeven

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.

Related Articles

Infosys Finacle to power Santander UK’s international cash management system

More News Infosys Finacle to power Santander UK’s international cash management system

3w The Global Treasurer
Preparing for GDPR? Here’s four things to consider

More News Preparing for GDPR? Here’s four things to consider

4m Elliott Wiseman
Cash flow in focus for investors

Cash Management Cash flow in focus for investors

5m Conor Deegan
Treasury TV: Karen Pugsley, Domino's Pizza Group

More News Treasury TV: Karen Pugsley, Domino's Pizza Group

5m Victoria Beckett
Treasury TV: Yeng Butler compares US and European MMF reforms

Compliance Treasury TV: Yeng Butler compares US and European MMF reforms

5m Victoria Beckett
Treasury TV: Tim de Knegt, The Port of Rotterdam

10 Minutes With The Treasury Treasury TV: Tim de Knegt, The Port of Rotterdam

5m Victoria Beckett
Banks are selling clients short with short dated cash deposit U-turns

Banking Banks are selling clients short with short dated cash deposit U-turns

5m Victoria Beckett
What does sterling’s Brexit boost mean for UK manufacturers?

More News What does sterling’s Brexit boost mean for UK manufacturers?

6m Tasja Botha