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
Why Not to Use Spreadsheet-Based Budgeting
December 11, 2018

By Thorsteinn Siglaugsson, Consultant / Corporate trainer / Manager

FP&A Tags
Financial Planning and Analysis
Planning and Budgeting
FP&A Technology

Spreadsheets are a great tool to build and maintain ad-hoc calculations, quickly draft a business plan and create good-looking reports. But when it comes to planning and budgeting in a complex business environment the flexibility of spreadsheets is often quick to become an obstacle instead of an asset in your planning process.

What characterizes a good planning, budgeting and forecasting process?

1. A budget should be a management tool

Planning, budgeting and forecasting is an advanced process. If it is supposed to add value to the company it must involve a number of people. For example, the sales planning process has to involve people who know the products and the customers. The production plan must involve the people who understand the, often complex, production capacity, processes and material requirements and planning for general resources must involve the right people.

The budget should not only be a source of an annual report for the board and bank. To achieve this it must be based on assumptions that take into account the external and internal environmental factors and it has to be easy to build scenarios that address changes. This calls for a streamlined process that is not too time-consuming.

2. Accuracy and assumptions

Accuracy is a big part of a good planning and budgeting process. Users should be able to trust the assumptions they use and those must be precise enough to reflect reality. The product mix is constantly changing, for example, so you have to be able to extract the true revenue and cost by product and product line. Furthermore, calculation errors, once they get into your model, will often affect the whole downstream process, igniting uncomfortable questions from experienced board members when you finally get to the all-important board presentation.

3. Workflow is important

As mentioned above it is very important that the people who know the business are involved in the planning process. It is also important and can give companies advantage, to use and advanced tool where the data is stored centrally, and the planners get access to the part of the business they are responsible for. Other important factors are that the tool reflects the workflow and best practices in work procedures, keeps track of who did what when, the status of the planning work and possibility to see the expected outcome. When the planning process has finished it should be easy to transfer the data for use in business reports for comparison.

Now, knowing spreadsheets, how well do they really fulfill all those criteria?

1. Spreadsheets are documents, not a database

A spreadsheet is not a database. Workbooks are documents, stored in your file system, they can get lost, copied and changed and often you end up with multiple versions of the truth. If you want to distribute your work the only way is to create multiple excel workbooks and then spend countless hours consolidating them, with mixed results.

2. Is error checking the best use of your time?

Everyone who uses spreadsheets for planning, budgeting and forecasting recognizes how easy it is for errors to find their way into the workbooks. Once you have an error in a complex workbook, let alone multiple interlinked workbooks, finding and correcting it can be a major headache.

3. A good budget has many levels and dimensions

To build a well-grounded budget or forecast you must be able to base it on sound assumptions. Since spreadsheets do not allow you to drill down, work at multiple levels or with multiple dimensions at the same time, you will have to rely on estimated averages for example when it comes to unit prices, utilization rates or the effects of currency changes or raw material prices to name some examples.

4. Your company is a repository of knowledge – Use it!

No single individual or a single department in a corporation has all the answers. The sales managers understand the clients, the marketing managers understand the brands, production managers understand the production requirements. Finance understands – well, finance. So why make them responsible for all the inputs? Is it perhaps because you use excel and preserving the integrity of the spreadsheets has become even more important than getting really value-adding inputs based on sound knowledge, not just last year’s figures?

 

Planning, budgeting and forecasting do not have to be an annual, time consuming, low value-added process. It can be a great tool to manage your business and avoid letting the ever-changing reality surprise you. But to do that you must turn away from spreadsheet-based budgeting – even though Excel comes almost free of charge. Your time and the success of your business are worth more.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

88% Spreadsheets Have Errors
July 26, 2017

Companies large and small spend countless hours every month developing, amending and updating the spreadsheets that...

Read more
Analytic Model vs Spreadsheets
September 21, 2017

Spreadsheets are without doubt the ‘killer’ application that turned the PC into an indispensable business tool...

Read more
+

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 Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

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

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

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