About a-team Marketing Services
The knowledge platform for the financial technology industry
The 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: Hearing from the Experts: AI Governance Best Practices

9 September 2025 10:00am ET | 3:00pm London | 4:00pm CET Duration: 50 Minutes The rapid spread of artificial intelligence in the financial industry presents data teams with novel challenges. AI’s ability to harvest and utilize vast amounts of data has raised concerns about the privacy and security of sensitive proprietary data and the ethical...

BLOG

10 Major Financial Regulations Reshaping Capital Markets in 2025 (and How to Stay Ahead of Them)

From sweeping reforms in operational resilience and AI governance to the first-time application of AML obligations to buy-side firms, the scope and depth of regulatory change shows no sign of slowing down in 2025. In this post, we present a selection of the most strategically significant regulations coming into effect or having significant impact on...

EVENT

TradingTech Briefing New York

Our TradingTech Briefing in New York is aimed at senior-level decision makers in trading technology, electronic execution, trading architecture and offers a day packed with insight from practitioners and from innovative suppliers happy to share their experiences in dealing with the enterprise challenges facing our marketplace.

GUIDE

AI in Capital Markets: Practical Insight for a Transforming Industry – Free Handbook

AI is no longer on the horizon – it’s embedded in the infrastructure of modern capital markets. But separating real impact from inflated promises requires a grounded, practical understanding. The AI in Capital Markets Handbook 2025 provides exactly that. Designed for data-driven professionals across the trade life-cycle, compliance, infrastructure, and strategy, this handbook goes beyond...