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
  • September 2015
09

Accountants warn of corporate losses caused by 'spreadsheet failure'

Open-access content Thursday 10th September 2015 — updated 5.50pm, Wednesday 29th April 2020

Two thirds of accountants (68%) think over the next two years a large UK firm will suffer financial or reputational losses due to a spreadsheet-based data failure.

2

A survey of 101 accountants found more than half (58%) of respondents said the frequency of spreadsheet errors was "very high" or "fairly high", and almost three quarters (72%) ranked spreadsheet risk as a "major business risk".

The study, commissioned by technology firm ClusterSeven and supported by Institute of Chartered Accountants in England and Wales (ICAEW), also reported 90% of respondents believed over the next two years, regulators and other stakeholders such as auditors will take an increasing interest in the use of spreadsheets and data management.

The top reason for errors to be found on spreadsheets was there was no system in place for checking or tracking who made the changes and when, as cited by 54% of respondents. Another 42% said too many people had access to key spreadsheet and 39% cited insufficient training or understanding of the use of spreadsheets.

Richard Anning, head of ICAEW's IT Faculty, said flawed spreadsheet design and lack of formalised training added "significant costs" to organisations, but errors often remained "unspotted" and damage would be "difficult to recognise or measure". 

"With nine out of ten respondents agreeing finance professionals will increasingly rely on spreadsheets and data management, this is a major concern for both businesses and the UK economy," he said.

ClusterSeven said one in 10 (9%) spent more than 30% of their time checking spreadsheets for errors and only half stated they could fully understand the historical changes made during the recent use of spreadsheets.

Ralph Baxter, CEO of ClusterSeven, said: "Accountants and financial professionals are exposed to spreadsheets and similar applications more than most people, and the message they are sending is that the propensity for critical errors on spreadsheets is profound - unsurprisingly, almost three quarters (72%) ranked spreadsheet risk as a major business risk. 

"The challenge for businesses and financial institutions is that the quality of data held and managed on spreadsheets, and the processes behind validating this data, are increasingly being reviewed by stakeholders such as regulators, as the inherent fallibility of spreadsheets becomes ever more apparent."

This article appeared in our September 2015 issue of The Actuary.
Click here to view this issue
Filed in
09
Topics
Professional

You might also like...

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

Latest Jobs

New Fast-Growing Team - Actuarial Systems Development

London (Greater)
Excellent Salary Package
Reference
143762

Actuarial Pension Consultant – Scotland/Remote – Up to £90,000 plus bonus

Edinburgh / Glasgow / Remote working
Up to £90,000 + Bonus
Reference
143761

Part Qualified Pensions Actuary– Specialised Pensions Consultancy - Scotland/Remote - Up to £70,000

Edinburgh / Glasgow / Remote working
Up to £70,000 + Bonus
Reference
143760
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