About a-team Marketing Services
The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

Financial Institutions Should Focus on Unstructured Financial Data in the Rush for Effective Risk Management, Warns ClusterSeven

Subscribe to our newsletter

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 CSVs* (comma separated variable), plus spreadsheets and Microsoft Access Databases. Systemic failings in the way these files are tracked and monitored remain unresolved; for many businesses this will lead to financial misreporting, leading to financial and reputational losses.

Ralph Baxter, CEO of ClusterSeven, an international provider of software to manage unstructured financial data, said: “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.”

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 – yet many people fail to realise this basic fact.

Recent studies by ClusterSeven (June 2011) and by risk consultant Protiviti and accountancy institute the ICAEW (July 2011) 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.

It is not just banks and insurance firms susceptible to data management challenges. On 12 August this year, the ONS issued a correction after admitting an “arithmetical error” had caused it to overstate the strength of the UK construction industry for Q2 by 180 basis points. According to the ONS’s initial calculation, the sector grew 2.3% in the three months to June (enough for some economists to revise upwards UK economic prospects); the ONS subsequently cut the number to 0.5%.

Ralph Baxter, CEO of ClusterSeven, added: “Most people know of some spreadsheets that help run their business, but these are only the tip of the iceberg of all the unstructured financial data activity in their organisation. We see an increasing demand for our software from firms big and small. However, the worry remains that significant shortcomings remain at the heart of many of the world’s financial institutions. This is a shame as, rather than being a weak link in a firm’s risk management process, properly managed unstructured financial data will strengthen it.”

Subscribe to our newsletter

Related content

WEBINAR

Upcoming Webinar: Adding value and improving efficiencies in sanctions screening

Date: 18 May 2022 Time: 10:00am ET / 3:00pm London / 4:00pm CET Duration: 50 minutes Sanctions have been headline news this year. They are growing in number, sanctions lists are changing on a daily basis, and there can be conflict between sanctions issued by different jurisdictions – the whole calling for financial institutions to...

BLOG

SmartSearch Releases High-Risk Country Report Service in Response to Sanctions Against Russia

SmartSearch, an anti-money laundering (AML) specialist, has released a high-risk country report service in response to the introduction of sanctions against Russia. The service enables regulated businesses to scan existing clients and check for residency or citizenship in Russia, Belarus, or any other high-risk countries. The reporting tool instantly checks all clients that the regulated business has...

EVENT

ESG Data & Tech Summit 2022

The inaugural ESG Data & Tech Summit will explore challenges around assembling and evaluating ESG data for reporting and the impact of regulatory measures and industry collaboration on transparency and standardisation efforts. Expert speakers will address how the evolving market infrastructure is developing and the role of new technologies and alternative data in improving insight and filling data gaps.

GUIDE

ESG Data Handbook 2022

The ESG landscape is changing faster than anyone could have imagined even five years ago. With tens of trillions of dollars expected to have been committed to sustainable assets by the end of the decade, it’s never been more important for financial institutions of all sizes to stay abreast of changes in the ESG data...