[Paper Review] The Importance and Criticality of Spreadsheets in the City of London

Grenville J. Croll|ArXiv.org|Sep 26, 2007

Spreadsheets and End-User Computing7 references71 citations

TL;DR

This paper investigates the critical role of spreadsheets in the City of London's financial institutions, drawing on insights from senior practitioners to highlight widespread uncontrolled use of mission-critical spreadsheets. It argues that this reliance poses significant reputational risks due to lack of governance, and calls for improved spreadsheet management practices to ensure reliability and resilience in financial systems.

ABSTRACT

Spreadsheets have been with us in their present form for over a quarter of a century. We have become so used to them that we forget that we are using them at all. It may serve us well to stand back for a moment to review where, when and how we use spreadsheets in the financial markets and elsewhere in order to inform research that may guide their future development. In this article I bring together the experiences of a number of senior practitioners who have spent much of their careers working with large spreadsheets that have been and continue to be used to support major financial transactions and manage large institutions in the City of London. The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.

Motivation & Objective

• To examine the extent and impact of spreadsheet usage in major financial institutions within the City of London.
• To identify systemic risks arising from the uncontrolled use of spreadsheets in high-stakes financial operations.
• To understand practitioner experiences with large, mission-critical spreadsheets over decades of use.
• To highlight the lack of formal governance and quality assurance in spreadsheet development and maintenance.
• To advocate for improved practices and frameworks to manage spreadsheet-related risks in financial systems.

Proposed method

• Conducts qualitative interviews with senior financial practitioners who have extensive experience with large-scale spreadsheets.
• Analyzes real-world case studies of spreadsheet use in major financial transactions and institutional operations.
• Synthesizes practitioner insights on spreadsheet development, maintenance, and failure modes over time.
• Evaluates the current state of spreadsheet governance in financial institutions, identifying gaps in oversight.
• Draws on industry reports and prior research on spreadsheet risks to contextualize findings.
• Proposes a framework for improved spreadsheet management based on observed industry practices and identified vulnerabilities.

Experimental results

Research questions

• RQ1 How are spreadsheets currently used in mission-critical financial operations within the City of London?
• RQ2 What are the primary risks associated with the uncontrolled use of spreadsheets in financial institutions?
• RQ3 What lessons can be drawn from long-term practitioner experience with large, complex spreadsheets?
• RQ4 Why is there a lack of formal governance for critical spreadsheets despite their operational importance?
• RQ5 What improvements in practice or policy could reduce the risk of spreadsheet failure in financial systems?

Key findings

• Spreadsheets are extensively used in the City of London for managing major financial transactions and institutional operations.
• Many critical spreadsheets are developed and maintained without formal documentation, version control, or testing procedures.
• The absence of governance mechanisms exposes financial institutions to significant reputational risk from spreadsheet errors.
• Practitioners report that spreadsheet failures have already caused material financial and operational disruptions.
• Despite their central role, spreadsheets are often treated as informal tools rather than core system components.
• The paper concludes that current practices are unsustainable and demand urgent reform in spreadsheet management standards.