RegionsEEAOver-reliance on spreadsheets ‘hampers Solvency II compliance’

Over-reliance on spreadsheets ‘hampers Solvency II compliance’

Many firms filing solvency returns since the new capital adequacy regime was introduced at the start of this year are struggling, according to Accountagility.

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.”

Related Articles

“Destroy or democratise” – how Open Banking will impact connectivity

Banking “Destroy or democratise” – how Open Banking will impact connectivity

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
Money market reforms: Navigating LVNAV, CNAV and VNAV

EEA Money market reforms: Navigating LVNAV, CNAV and VNAV

6m Victoria Beckett
The Challenge of Building and Maintaining a Central Treasury Operation in a Decentralized Company

EEA The Challenge of Building and Maintaining a Central Treasury Operation in a Decentralized Company

6m BELLIN
The Treasury Challenge of a Post-Merger Integration

EEA The Treasury Challenge of a Post-Merger Integration

6m BELLIN
The Challenge of Integrating Worldwide Subsidiaries into one TMS

Baltics The Challenge of Integrating Worldwide Subsidiaries into one TMS

6m BELLIN
Q&A with BMG's treasury : BELLIN - We Love Treasury 2

EEA Q&A with BMG's treasury : BELLIN - We Love Treasury 2

6m BELLIN
PSD2: dull name, but seismic effect

Clearing & Settlement PSD2: dull name, but seismic effect

6m Alex Kwiatkowski