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

Publikation: Beiträge in ZeitschriftenZeitschriftenaufsätzeForschungbegutachtet

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.

OriginalspracheEnglisch
ZeitschriftProblems and Perspectives in Management (PPM)
Jahrgang10
Ausgabenummer1
Seiten (von - bis)32-41
Anzahl der Seiten10
ISSN1727-7051
PublikationsstatusErschienen - 2012
Extern publiziertJa