Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
88% Spreadsheets Have Errors
July 26, 2017

By Ian Yates, Managing Director at Barcanet

FP&A Tags
FP&A Analytics
Financial Planning and Analysis

Companies large and small spend countless hours every month developing, amending and updating the spreadsheets that measure performance and drive strategic decision-making.

So it’s critical the data contained and output generated by these spreadsheets is timely, simple and above all, accurate.  But is it?

Although spreadsheets have proven themselves as useful productivity tools for many years, they are poorly suited for managing the disparate and sizeable data produced by the modern business.

Errors are common, even with experienced users - the more data sources, the more formulas, the ‘larger’ the spreadsheet, the greater the chance for small errors to be magnified.

We have all experienced ‘version numbering’ issues and outputs that don’t match as changes are made and ‘master’ spreadsheets not updated.

Exposing organisations to significant levels of risk.

According to experts, there are three primary error types;

  1. Mechanical error – inputting, typing, copy/paste errors which may appear small but can fundamentally impact the integrity of the entire model as the complexity of the spreadsheet grows
  2. Logic error – flawed calculations generated from inappropriate or incorrect formulas and algorithms
  3. Omission – one of the most common and most difficult to spot errors is where data is simply not incorporated in the first place

So what is the better way?

In recent years, a new type of business analytics software and service has surfaced. 

Platforms that readily digest huge amounts of data, across different sources, in multiple formats - centralising and ‘normalising’ data.

They contain powerful analytics tools, allowing users to configure reports relevant to their roles. Most extend to visualising the insight in simple dashboards. Some embed workflow processes and collaboration tools enabling users and decision makers to make quick, simple and effective data-driven decisions.

All without a single spreadsheet being produced.

These tools are available for every size of business. Whether you require enterprise-wide solutions driven by in-house analyst teams or bespoke functionality bringing insight to your operational KPIs, there is something available.

What are the key benefits of using these platforms and services over spreadsheets?

  1. Data integrity – single ‘truth’ of accurate data to make decisions from
  2. Breadth of data – increased data for more informed decisions
  3. Value - Powerful analytics for insights generating competitive advantage
  4. Speed – live insights accessible anytime, anywhere
  5. Efficiency – saves hours preparing immediately out-of-date spreadsheets
  6. Collaboration – enforce the power of teamwork
  7. Scalable – from bespoke requirements to enterprise-wide initiatives
  8. Simplicity – analytics in the hands of users – no need for teams of analysts
The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

Webinar: FP&A Trends Survey 2025
The FP&A Trends Webinar 2025 FP&A Trends Survey: Benchmarks, Priorities, and Best Practices

July 9, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0