Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function

Recognizing that the use of spreadsheets within finance will likely not subside in the near future, this paper discusses a major barrier that is preventing more organizations from adopting enterprise spreadsheet management programs. But even without a corporate mandated effort to improve spreadsheet controls, finance functions can still take simple yet effective steps to start managing the risk of errors in key spreadsheets by strategically selecting controls that complement existing user practice

💡 Research Summary

The paper “Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function” addresses the persistent reliance on spreadsheets in finance and the difficulty many organizations face in implementing enterprise‑wide spreadsheet management programs. The authors argue that the main obstacles are not technical but cultural: users resist intrusive controls, there is no single owner for spreadsheets, and the perceived cost and disruption outweigh the loosely quantified benefits.

To overcome these barriers without a top‑down mandate, the authors propose a “bottom‑up” approach that tailors controls to the typical finance user profile. They describe three dominant characteristics of finance spreadsheet creators: (1) they are “casual designers” with basic Excel skills rather than professional developers; (2) much of the review process still occurs on printed paper, so any new control must fit into that workflow; and (3) formal training focuses on features, not on internal‑control or risk‑mitigation principles.

Based on this profile, the paper recommends three lightweight, non‑intrusive controls that can be embedded directly in the spreadsheet:

1. Data Validity Checks (Check Cells) – Separate cells that pull reference values from an external source or a dedicated “validation” sheet and compare them to the main inputs or calculated outputs. Simple formulas (e.g., SUM, VLOOKUP, or hash totals) are sufficient; no VBA or complex macros are required. This provides immediate error detection while preserving the user’s familiar formula‑entry style.

2. Clear Data Placement and Labels – Organize the worksheet so that input cells, calculation cells, and output cells occupy distinct zones, and label each row/column with content description and units. This visual segregation reduces misinterpretation, speeds up paper‑based reviews, and eases onboarding for new users.

3. Display of Constants – Extract all assumptions (growth rates, discount rates, tax percentages, etc.) into dedicated cells that are clearly labeled and referenced by formulas. By avoiding hard‑coded numbers inside formulas, any change to an assumption propagates automatically, and reviewers can see the assumptions at a glance.

To validate the practicality of these controls, the authors conducted a case study with two publicly traded U.S. companies—a global financial‑services firm (data from 2010) and a global manufacturing firm (data from 2011). They examined eight to nine “critical” spreadsheets per organization, totaling 13 files, and scored each file against the three control criteria. Findings:

• In the financial‑services firm, “Display of Constants” was present in 75 % of the files, while the other two controls appeared in only 25 % of the files.
• In the manufacturing firm, each control was present in roughly one‑third of the files (33 %).
• Overall, only 13 % of the spreadsheets contained all three controls, and 36 % contained none.

These results demonstrate that even without a formal spreadsheet governance policy, finance teams are already implementing some best‑practice elements, but adoption is uneven. The authors conclude that a pragmatic, incremental strategy—starting with the three controls as a standard template within the finance function—can achieve meaningful risk reduction without provoking the resistance associated with a full‑scale, centrally mandated program.

The paper’s key contributions are: (1) a user‑centric taxonomy of finance spreadsheet behavior; (2) a set of three concrete, low‑cost controls that align with existing paper‑based review practices; (3) empirical evidence that these controls are feasible and partially adopted in real‑world settings; and (4) a roadmap for finance departments to improve spreadsheet reliability, reduce manual review effort, and free up resources for higher‑value analytical work.