Improving efficiency in budgeting: An interventionist approach to spreadsheet accuracy testing

Research output: Journal contributionsJournal articlesResearchpeer-review

Authors

Over the past three decades, the reliance on sophisticated spreadsheets for budgeting has emerged as a standard in most organizations (Hesse and Hesse Scerno, 2009). Despite these technological advancements, rich empirical evidence documents that technologically induced 'spreadsheet errors' can substantially lower the accuracy of spreadsheets (Powell et al., 2009). These errors lead to suboptimal decision making and biased performance assessment. The aim of this paper is to examine how spreadsheet error can be detected and prevented in the budgeting process. The research design applies models of spreadsheet accuracy testing (SAT) from Kruck (2006) and Vessey (1985). The paper, thereby, illustrates the error reduction process in budgeting as well as future spreadsheet error prevention through the use of VBA. The authors base the analyses on a unique dataset (interviews, participating observations, technical artifacts) gathered through 'action research' at a Chinese-Danish government organization, which uses budgets for assessing applications on research funding. Our results confirm and extend existing theory in the field of budgeting and SAT and provide interesting findings. First, the paper shows that later spreadsheet error in budgeting is already rooted in a poor conceptualization of the budget template, in non-workflow-oriented imputation of data and poor documentation of data requirements. Second, it illustrates how the accuracy of spreadsheets substantially improves by introducing even simplistic VBA. Third, we present evidence that the flexibility of the budgeting template itself to changes in the organizational environment fosters spreadsheet accuracy in the long term.

Original languageEnglish
JournalProblems and Perspectives in Management (PPM)
Volume10
Issue number1
Pages (from-to)32-41
Number of pages10
ISSN1727-7051
Publication statusPublished - 2012
Externally publishedYes

    Research areas

  • Budget, Non-profit and governmental organization, Public management, Spreadsheet accuracy testing (SAT), Spreadsheet error, VBA
  • Management studies

Recently viewed

Publications

  1. OPERATIONALIZING DIGITAL TRANSFORMATION FROM MULTIPLE PERSPECTIVES
  2. Multi-agent systems' asset for smart grid applications
  3. Enhancing Community Interactions with Data-Driven Chatbots - The DBpedia Chatbot
  4. Collaboration and Open Science Initiatives in Primate Research
  5. Developmentalities and donor-NGO relations
  6. Introduction
  7. Trust in scientists, risk perception, conspiratorial beliefs, and unrealistic optimism
  8. AUC Maximizing Support Vector Learning
  9. Series foreword of Series Editors
  10. Group formation in computer-supported collaborative learning
  11. Homogenization approach based on laminates
  12. Substance Flows Associated with Medical Care - Significance of Different Sources
  13. Manual construction and mathematics- and computer-aided counting of stereoisomers. The example of oligoinositols
  14. Responsibility and environment
  15. Rational Design of Molecules by Life Cycle Engineering
  16. New Methods for the Analysis of Links between International Firm Activities and Firm Performance: A Practitioner’s Guide
  17. Introduction
  18. Learning and Re-learning in Chat-based CSCL
  19. Navigating pluralism
  20. Embedded, not plugged-in
  21. Transcending the Locality of Grassroots Initiatives
  22. Data quality assessment framework for critical raw materials. The case of cobalt
  23. Qualitative and Quantitative Human Error Analysis in Hazardous Industries
  24. Mathematical Model of Double Row Self-Aligning Ball Bearing
  25. Assembly history modulates vertical root distribution in a grassland experiment
  26. How to measure the substantive representation of traditionally excluded groups in comparative research
  27. Concept Maps in der Hochschullehre
  28. Introduction to Kant's Anthropology
  29. (Un)Bestimmtheit
  30. Impact of Auditor and Audit Firm Rotation on Accounting and Audit Quality
  31. Fallstudie
  32. An experimental approach to the optimisation of customer information at the point of sale
  33. Lifestyle-TV – Critical Attitudes towards „Banal” Programming
  34. Fallstudie
  35. Methodology for Integrating Biomimetic Beams in Abstracted Topology Optimization Results
  36. Effect of laser peening process parameters and sequences on residual stress profiles
  37. The science-policy interface on ecosystems and people
  38. Influence of Long-Lasting Static Stretching on Maximal Strength, Muscle Thickness and Flexibility
  39. Industrial Application Study and Development of a Control Strategy for an Ice Clamping Device
  40. Biodiversity buffers pollination from changes in environmental conditions
  41. EURODEMO - Improving the uptake of efficient soil and groundwater remediation technologies
  42. Das Schreiben, das Interpretieren, die Tatsachen
  43. Brain Drain
  44. L'agenda 21 locale
  45. International Master’s Programme in Sustainable Development and Management
  46. Critical evaluation of commonly used methods to determine the concordance between sonography and magnetic resonance imaging: A comparative study