Skip to main content
The Actuary: The magazine of the Institute and Faculty of Actuaries - return to the homepage Logo of The Actuary website
  • Search
  • Visit The Actuary Magazine on Facebook
  • Visit The Actuary Magazine on LinkedIn
  • Visit @TheActuaryMag on Twitter
Visit the website of the Institute and Faculty of Actuaries Logo of the Institute and Faculty of Actuaries

Main navigation

  • News
  • Features
    • General Features
    • Interviews
    • Students
    • Opinion
  • Topics
  • Knowledge
    • Business Skills
    • Careers
    • Events
    • Predictions by The Actuary
    • Whitepapers
  • Jobs
  • IFoA
    • CEO Comment
    • IFoA News
    • People & Social News
    • President Comment
  • Archive

Topics

  • Data Science
  • Investment
  • Risk & ERM
  • Pensions
  • Environment
  • Soft skills
  • General Insurance
  • Regulation Standards
  • Health care
  • Technology
  • Reinsurance
  • Global
  • Life insurance
Quick links:
  • Home
  • The Actuary Issues
  • March 2016
03

Eight in 10 experience planning failure for Solvency II 

Open-access content 22nd March 2016

Some 80% of chief financial officers (CFOs) and financial directors (FDs) have reported a fault with their planning processes when filling their solvency returns for the first time, according to research.

2


Finance solution provider Accountagility, which carried out the study, said this was due to over-reliance on the use of internal spreadsheets. It said errors had occurred when data is mined and transferred into reporting templates. 

Based on a survey of 200 CFOs and FDs in a range of sectors such as insurance, asset management and banking, the study also found 73% of respondents were concerned about their reliance on the use of spreadsheets.

Problems include collecting, manipulating and the analysis of large amounts of data. Accountagility said changes in the finance functions were not matched by the progress of financial technology, meaning companies were still "heavily dependent" on tools that are over three decades old.

Robert Gothan, the firm's CEO and founder, explained reliance on spreadsheets for Solvency II had two main impacts: errors and process inefficiency. 

He added firms were spending "too little time" reviewing the data they had 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 who are required to file solvency returns across the EU," he said.

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

For pillar III of the Solvency II directive, firms are required to submit quarterly and annual quantitative data to the Prudential Regulation Authority in the form of standardised supervisory reporting templates, known as quarterly or annual solvency returns.

This article appeared in our March 2016 issue of The Actuary.
Click here to view this issue
Filed in:
03
Topics:
Regulation Standards
Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

IFRS 17 consultant

Hong Kong
Negotiable
Reference
118883

Wealth Investment Associate Manager

Edinburgh, Scotland / West Midlands, England, Birmingham / England, London
£40000 - £55000 per annum + bonus + benefits
Reference
118882

Lloyd's Managing Agency - Actuarial Analyst

London (Central)
Up to £65000 per annum + benefits
Reference
118881
See all jobs »
 
 
 
 

Sign up to our newsletter

News, jobs and updates

Sign up

Subscribe to The Actuary

Receive the print edition straight to your door

Subscribe
Spread-iPad-slantB-june.png
​
FOLLOW US
The Actuary on LinkedIn
@TheActuaryMag on Twitter
Facebook: The Actuary Magazine
CONTACT US
The Actuary
Tel: (+44) 020 7880 6200
​

IFoA

About IFoA
Become an actuary
IFoA Events
About membership

Information

Privacy Policy
Terms & Conditions
Cookie Policy
Think Green

Get in touch

Contact us
Advertise with us
Subscribe to The Actuary Magazine
Contribute

The Actuary Jobs

Actuarial job search
Pensions jobs
General insurance jobs
Solvency II jobs

© 2020 The Actuary. The Actuary is published on behalf of the Institute and Faculty of Actuaries by Redactive Publishing Limited, Level 5, 78 Chamber Street, London, E1 8BL. Tel: 020 7880 6200