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
    • Moody's - Climate Risk Insurers series
    • Webinars
    • Podcasts
  • Jobs
  • IFoA
    • CEO Comment
    • IFoA News
    • People & Social News
    • President Comment
  • Archive
Quick links:
  • Home
  • The Actuary Issues
  • March 2016
03

Eight in 10 experience planning failure for Solvency II 

Open-access content Tuesday 22nd March 2016 — updated 5.50pm, Wednesday 29th April 2020

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

You may also be interested in...

ta filler

Stephen Crabb is new DWP boss

Stephen Crabb was appointed as the new secretary of state at the Department for Work and Pensions (DWP) over the weekend.
Tuesday 22nd March 2016
Open-access content
ta

UK healthy life expectancy improves but satisfaction falls, says ONS

People are living healthier longer lives, but are less satisfied with their well-being, according to the Office for National Statistics (ONS).
Wednesday 23rd March 2016
Open-access content
2

IFoA sets out best practice for operational risk models

The Institute and Faculty of Actuaries (IFoA) has outlined measures to address the issues of operational risk for banks, insurers and other financial services firms.
Wednesday 23rd March 2016
Open-access content
2

Combination of drawdown and annuity can help address longevity issues

People can benefit from hybrid plans such as a combination of annuity and drawdown to protect themselves against the financial risk of living longer than anticipated, according to a report.
Thursday 24th March 2016
Open-access content
2

Three quarters of finance professionals reluctant to ask for pay rise

Some 72% of people employed in financial services have not asked for a pay increase at all in the past three years, according to a survey.
Thursday 24th March 2016
Open-access content
2

US commercial insurance prices 'nearly flat'

Commercial insurance premiums in the US continued to moderate in the last quarter of 2015 but had “yet to sink to negative territory”, according to a survey conducted by Willis Towers Watson.
Friday 18th March 2016
Open-access content

Latest from Regulation Standards

tfd

A matter of adjustment

Private assets will continue to shine even under the Treasury’s proposed changes to the Solvency II matching adjustment, says Ziling Jiang
Wednesday 2nd November 2022
Open-access content
ykf

A home run: reducing inequality through impact investing?

Sophie van Oosterom, Wojciech Herchel and Mark Callender consider how ‘impact investing’ in social housing could help to reduce inequality
Wednesday 5th October 2022
Open-access content
hgv

Exchange of ideas: IFRS 17 implementation in the Caribbean

Servaas Houben considers how IFRS 17 principles could benefit insurers in the Caribbean – and what European insurers could learn from the region when it comes to implementing the standard
Wednesday 31st August 2022
Open-access content

Latest from March 2016

IFoA funds three actuarial research programmes

The Institute and Faculty of Actuaries (IFoA) has today announced three leading research programmes to address issues in pensions and insurance such as longevity and health.
Thursday 31st March 2016
Open-access content
ta filler

PPI 'the most complained-about product', says FCA

Payment protection insurance (PPI) has the highest number of complaints among financial products and services, the Financial Conduct Authority (FCA) has found.
Thursday 31st March 2016
Open-access content
Pancakes and blueberries © Shutterstock

Risky portfolios do not match investors' appetites

The majority of the UK's ISA portfolios are in sectors with top risk ratings, but investors do not have the same requirements, a firm has warned.
Thursday 31st March 2016
Open-access content

Latest from small_opening_image

2

COVID-19 forum for actuaries launched

A forum for actuaries has been launched to help the profession come together and learn how best to respond to the deadly coronavirus sweeping the world.
Wednesday 25th March 2020
Open-access content
2

Travel insurers expect record payouts this year

UK travel insurers expect to pay a record £275m to customers this year as coronavirus grounds flights across the world, the Association of British Insurers (ABI) has revealed.
Wednesday 25th March 2020
Open-access content
2

Grim economic forecasts made as countries lockdown

A sharp recession is imminent in the vast majority of developed and emerging economies as the deadly coronavirus forces businesses to shut down across the world.
Tuesday 24th March 2020
Open-access content

Latest from 03

IFoA funds three actuarial research programmes

The Institute and Faculty of Actuaries (IFoA) has today announced three leading research programmes to address issues in pensions and insurance such as longevity and health.
Thursday 31st March 2016
Open-access content
ta filler

PPI 'the most complained-about product', says FCA

Payment protection insurance (PPI) has the highest number of complaints among financial products and services, the Financial Conduct Authority (FCA) has found.
Thursday 31st March 2016
Open-access content
Pancakes and blueberries © Shutterstock

Risky portfolios do not match investors' appetites

The majority of the UK's ISA portfolios are in sectors with top risk ratings, but investors do not have the same requirements, a firm has warned.
Thursday 31st March 2016
Open-access content
Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

Senior Pricing Associate

Scotland / England, London
Up to £60000 per annum
Reference
149081

Outside IR35 - Reserving Contract - 6-8 months

London (Central)
Daily rate contract - outside IR35
Reference
149079

Actuarial Analyst - Longevity Reinsurance

England, London
Up to £55000 per annum
Reference
149080
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

Topics

  • Data Science
  • Investment
  • Risk & ERM
  • Pensions
  • Environment
  • Soft skills
  • General Insurance
  • Regulation Standards
  • Health care
  • Technology
  • Reinsurance
  • Global
  • Life insurance
​
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

© 2023 The Actuary. The Actuary is published on behalf of the Institute and Faculty of Actuaries by Redactive Publishing Limited. All rights reserved. Reproduction of any part is not allowed without written permission.

Redactive Media Group Ltd, 71-75 Shelton Street, London WC2H 9JQ