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
    • AI / ML FP&A Committee
    • FP&A Trends Digest
    • FP&A Talks Series
    • FP&A Trends E-Books
    • Our Authors
  • FP&A Board
    • Amsterdam
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • Webinars
    • FP&A Board Connect
  • FP&A Videos
  • About Us
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
  • Contact Us
This block is broken or missing. You may be missing content or you might need to enable the original module.
 FP&A’s Role in Capital Planning: Getting Beyond the “Traditional”

The FP&A Trends Webinar: FP&A’s Role in Capital Planning: Getting Beyond the “Traditional”

Click here to view details and register

 

88% Spreadsheets Have Errors
July 26, 2017

By Ian Yates, Managing Director at Barcanet

FP&A Tags
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

 FP&A Roadmap: How to Master Rolling Forecasts

The FP&A Trends Webinar: FP&A Roadmap: How to Master Rolling Forecasts
Click
here to view details and register

Pagination

  • ‹‹ Previous
  • February 2021
  • Next ››
Su Mo Tu We Th Fr Sa
31
1
2
3
4
5
6
 
The Digital Pan-Asian FP&A Board: From Traditional to Better and Beyond Budgeting
 
The Digital Swiss FP&A Board: The Power of FP&A Scenario Planning
 
7
8
9
10
11
12
13
The FP&A Trends Webinar: A New Age of Zero-Based Budgeting
 
14
15
16
17
18
19
20
The Digital Middle Eastern FP&A Board: The Future of FP&A: Moving from Traditional Management Accounting to xP&A
 
21
22
23
24
25
26
27
The FP&A Trends Webinar: Planning for Uncertainty: The Building Blocks of Agile FP&A
 
28
1
2
3
4
5
6
 
 
 
 
 
 
All events for the year

Future Meetings

Digital German FP&A Board
The Digital German FP&A Board: Moving From Traditional Controlling to Extended Planning and Analysis (xP&A)
March 4, 2021
The FP&A Trends Webinar
The FP&A Trends Webinar: FP&A Data Visualization: Moving from Insight to Impact
March 9, 2021
The FP&A Trends Webinar
The FP&A Trends Webinar: FP&A Roadmap: How to Master Rolling Forecasts
March 16, 2021
UK-Ireland Board
The Digital UK & Ireland FP&A Board: The Art and Science of xP&A Business Partnering
March 18, 2021
Nordic-Benelux - March
The Digital Nordic-Benelux FP&A Board: Moving From Traditional Business Controlling to Extended Planning and Analysis (xP&A)
March 23, 2021
Capital Planning
The FP&A Trends Webinar: FP&A’s Role in Capital Planning: Getting Beyond the “Traditional”
March 25, 2021
xP&A Business Partnering
The Digital Pan-Asian FP&A Board: The Art and Science of xP&A Business Partnering
April 8, 2021
The Digital North American FP&A Board
The Digital North American FP&A Board: From Traditional to Better and Beyond Budgeting
April 13, 2021
Advanced AnalyticsArtificial Intelligence (AI)Behavioural FinanceBetter BudgetingBeyond BudgetingBig DataBrexitCash PlanningCollaborative PlanningCorporate Performance Management (CPM)Cost PlanningCOVID-19DashboardsData ManagementData QualityData VisualisationDriver Based PlanningExtended Planning & Analysis (xP&A)Financial Planning and AnalysisForecasting QualityFP&A AnalyticsFP&A Business EnvironmentFP&A Business PartneringFP&A Case StudiesFP&A DigitalisationFP&A Maturity ModelsFP&A PeopleFP&A SkillsFP&A StorytellingFP&A Talks SeriesFP&A TechnologyFP&A TransformationFP&A Trends E-BooksFP&A Trends InitiativesIntegrated FP&AKey Performance Indictators (KPI)Machine Learning (ML)Management AccountingModelling and ForecastingPlanning and BudgetingPredictive AnalyticsProfitability AnalysisRisk ManagementRobotic Process Automation (RPA)Rolling ForecastScenario PlanningStrategic FinanceStrategic PlanningTeam BuildingWhat is FP&AZero-Based Budgeting (ZBB)

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

info@fpa-trends.com​

              

Foot menu

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

Footer countries

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

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

0