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
  • January 2011
01

Actuaries raise doubts over insurance data processes

Open-access content Tuesday 10th January 2012 — updated 5.13pm, Wednesday 29th April 2020

Only one in five actuaries and insurance finance professionals are fully confident of their firm’s data control processes and spreadsheet supervision, according to research from ClusterSeven.

2

Only one in five actuaries and insurance finance professionals are fully confident of their firm's data control processes and spreadsheet supervision, according to research from ClusterSeven.

Two in five respondents (40%) to the data management software provider's survey stated that corporate controls around spreadsheet access could be improved and 13% warned they are simply not confident at all about the oversight process behind spreadsheets.

According to the firm, only 28% say that there is full and sufficient documentation in place for others to manage their spreadsheets in case of their absence.

Over half (53%) believe that a qualified actuary or similar specialist would have to rely on their skills and experience as the documentation process is not sufficient. Most critically, 19% warned that a qualified actuary would probably have to rebuild spreadsheets given a lack of basic continuity protocols.

ClusterSeven said that the study highlights how exposed modern financial institutions have become to data risks as demands placed on their spreadsheet-based systems have expanded.

In particular, the processes currently in place to protect and support best-practice spreadsheet management remain far from watertight. Asked how many people have the ability to make changes to spreadsheets or those that feed data into them, nearly half (46%) of respondents to the survey said that between four and 10+ people could change their critical spreadsheets. Some 12% did not know how many people in their organisation have access to business-critical spreadsheets.

The survey found that 49% of respondents use spreadsheets more than any other software application for modelling, data management and reporting activities, including 9% that solely use spreadsheets for these activities.

Only 16% of respondents said they either did not use spreadsheets at all, or less than other applications.

Ralph Baxter, CEO of ClusterSeven, said: "Actuaries hold the keys to excellence in data management and the spreadsheets that underpin data processes. The survey indicated that people had real concerns about the inability of other qualified individuals to understand their company's spreadsheets and the lack of standardisation of data management."

In brief

*         Two in five respondents (40%) stated that corporate controls around spreadsheet access could be improved

*         Over one in ten (13%) warned they are simply not confident at all about the oversight process behind spreadsheets.

*         Over half (53%) believe that a qualified actuary or similar specialist would have to rely on their skills and experience as the documentation process is not sufficient

*         One in five respondents rated spreadsheet risk very serious while a further 31% put it as fairly serious

This article appeared in our January 2011 issue of The Actuary.
Click here to view this issue
Filed in
01
Topics
General Insurance

You might also like...

Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

Pensions Actuarial Analyst

London, Midlands, Scotland
£Market Competitive
Reference
143788

Senior Manager/Director level roles - Life insurance

Stirling
Generous salary with excellent bonus and benefits
Reference
143787

Reinsurance Pricing Actuary

London (Central)
£60-90K depending on experience
Reference
143786
See all jobs »
 
 

Today's top reads

 
 

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