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. Integratives Gendering in der Lehre
  3. Large trees are keystone structures in urban parks
  4. Early subtropical forest growth is driven by community mean trait values and functional diversity rather than the abiotic environment
  5. Tree and mycorrhizal fungal diversity drive intraspecific and intraindividual trait variation in temperate forests
  6. Interactive sequential generative models for team sports
  7. Evidence for singlet state β cleavage in the photoreaction of α-(2,6-dimethoxyphenoxy)-acetophenone inferred from time-resolved CIDNP spectroscopy
  8. Biodiversity in space and time - towards a grid mapping for Mongolia
  9. Education and Communication as Prerequisites for and Components of Sustainable Development. Reflections for Policies, Conceptual Work, and Theory, Based on Previous Practises
  10. Why Fun Matters: In Search of Emergent Playful Experiences
  11. Deconstructing and reconstructing diversity in client-provider-relationships of social work
  12. Using frequency tagging to investigate social processing in autism
  13. Horizontal, but not vertical canopy structure is related to stand functional diversity in a subtropical slope forest
  14. Influences of RVE topology, discretization and boundary conditions in practical multiscaling - a comparison
  15. (Un)Bestimmtheit
  16. Repatriation, Public Programming, and the DEAI Toolkit
  17. Integrating inductive and deductive analysis to identify and characterize archetypical social-ecological systems and their changes
  18. Gamen
  19. Framework for empirical research on science teaching and learning
  20. Germination changes can restructure communities through priority effects
  21. Development and Validation of a Us and German Short Version of the Later Life Workplace Index (llwi- S)
  22. Latent trees for coreference resolution
  23. Fulfillment of Heterogeneous Customer Delivery Times through Decoupling the Production and Accelerating Production Orders
  24. Monitoring fast-moving animals—Building a customized camera system and evaluation toolset
  25. Experimental Tests for an Innovative Catamaran Prototype
  26. Counteracting electric vehicle range concern with a scalable behavioural intervention
  27. Living Labs for Product Circularity: Learnings from the ‘Innovation Network aiming at Sustainable Smartphones’