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
    • Contributors
    • Editorial Guidelines
    • FP&A Trends Digest
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Austin
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • Miami
    • Munich
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • AI/ML Committee
    • Introduction
    • Meetings
    • Members
    • Resources
  • Video Content
    • Digital FP&A Boards
    • FP&A Webinars
    • Short Videos
  • Contact Us
  • About Us
    • Ambassadors
    • Privacy Policy
    • Company Policy
    • Our Sponsors & Partners
image

The FP&A Trends Webinar: The Winning Formula for FP&A Storytelling

Click here to view details and register

 

88% Spreadsheets Have Errors
New
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

FP&A Trends Survey 2023: Define the future of FP&A 

Click here to view details

Pagination

  • ‹‹ Previous
  • March 2023
  • Next ››
Su Mo Tu We Th Fr Sa
26
27
28
1
2
3
4
 
 
 
5
6
7
8
9
10
11
Five Critical Roles for Building a World-Class FP&A Team
 
Five Critical Roles for Building a World-Class FP&A Team
 
12
13
14
15
16
17
18
Five Critical Roles for Building a World-Class FP&A Team
 
Five Critical Roles for Building a World-Class FP&A Team
 
19
20
21
22
23
24
25
Five Critical Roles for Building a World-Class FP&A Team
 
Myths and Misconceptions of Rolling Forecast and Scenario Planning
 
26
27
28
29
30
31
1
Leveraging Predictive Planning and Forecasting within xP&A
 
 
All events for the year
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

Future Meetings

The FP&A Trends Webinar
The FP&A Trends Webinar The Winning Formula for FP&A Storytelling
April 4, 2023
The Face-to-Face London FP&A Board
The Face-to-Face London FP&A Board FP&A Storytelling in a Data-Driven World
April 20, 2023
The Face-to-Face Stockholm FP&A Board
The Face-to-Face Stockholm FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
April 25, 2023
The Face-to-Face Copenhagen FP&A Board
The Face-to-Face Copenhagen FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
April 27, 2023
Key FP&A Challenges and How to Address Them
The FP&A Trends Webinar Key FP&A Challenges and How to Address Them
May 4, 2023
The Face-to-Face Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
May 9, 2023
AI/ML
The FP&A Trends Webinar Digital FP&A: Deploying AI/ML for Planning, Budgeting & Forecasting
May 10, 2023
Brussels
The Face-to-Face Brussels FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
May 11, 2023
München FP&A Board
The Launch of the Face-to-Face Munich FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
May 16, 2023
Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
May 17, 2023

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
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • Munich
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0