Over-reliance on spreadsheets could cause major problems for insurers and other firms in the financial service sector that are struggling to get to grips with the Solvency II regime, which took effect across the European Union at the start of this year, claims Accountagility.
The UK-based financial software provider says that less than three months since Solvency II was introduced, “the cracks are beginning to show” among firms filing their solvency returns for the first time.
The company researched a range of UK companies in the financial services sector, including building societies, challenger banks, international banks (US firms based in the UK), property/casualty (P&C) insurers, life insurers, asset managers, private banks and wealth managers.
The survey, which had responses from 200 chief financial officers (CFOs) and financial directors (FDs), found that 73% of their CFOs are concerned about their reliance on spreadsheets. Responses also showed that four in five CFOs have reported a fault with their planning processes when using spreadsheets over the past year, which Accountagility says evidence that these cumbersome approaches are not working as efficiently as they should be.
It adds that the continuing transformation of the finance function has not been matched by progress in financial technology, which means that many departments are still heavily dependent on tools that are over three decades old.
Particular problems occur for firms grappling with Solvency II in terms of the large amount of data collection, manipulation, analysis and output required. When a tool such as Excel or another spreadsheet function is used for these processes, productivity is compromised and an element of risk is added.
“Relying on spreadsheets for Solvency II has two principal impacts – errors and process inefficiency,” said Robert Gothan, chief executive officer (CEO) and founder of Accountagility.
“Firms dealing with spreadsheets are spending too little time reviewing the data they have created, leaving errors potentially undiscovered for months to come. Given that the Solvency II framework does not contain allowances for either mechanical error or lack of efficiency, the review stage is the most important, particularly for firms required to file solvency returns across the EU.
“Our research shows that four in five CFOs cite problems with their spreadsheets, which is truly concerning. Businesses should be wary when relying on spreadsheet tools for their solvency returns, and should consider using automated solutions to streamline these processes in the future.”
The US money market fund reforms came into effect in 2016 and are already dramatically shaping US fund industry with investors flooding out of prime funds and into government securities. While the reforms are similar, they are not the same. GTNews interviews Yeng Bulter, global head of the cash business at State Street Global Advisors on the differences.
As the May 25 deadline for Europe’s General Data Protection Regulation (GDPR) inches closer, many treasurers are being lumped with the task of ensuring their wider company is compliant.
APIs may be a solution to MT940 challenges, says Karen Fagan, treasury operation manager, for British television company, ITV.
The top five sectors Asian fintech investors are interested in are data analytics, blockchain, lending, payments and regtech, according to Gary Hwa, EY regional managing partner.