Spreadsheet Tracking vs Structured Platform: Consumer Duty Monitoring

Overview

The Consumer Duty, which came into force on 31 July 2023 for open products and services, represents the most significant shift in the FCA's approach to consumer protection in over a decade. At its core, the Duty requires firms to act to deliver good outcomes for retail customers — and, critically, to monitor whether those outcomes are actually being achieved. This monitoring obligation is not a one-off exercise. It is a continuous requirement that demands ongoing data collection, analysis, and reporting throughout the year, culminating in an annual board-level assessment.

For most firms, the practical question is how to operationalise this monitoring. The two primary approaches are spreadsheet-based tracking — using Excel, Google Sheets, or similar tools to manually record and analyse outcome data — and structured compliance platforms purpose-built for regulatory monitoring, which automate data capture, analysis, and reporting. The choice between these approaches has significant implications for the quality of the firm's Consumer Duty evidence, the efficiency of its compliance operations, and its ability to satisfy the FCA's supervisory expectations.

The first round of Consumer Duty annual board reports, completed in mid-2024, exposed a sharp divide between firms with structured monitoring and those relying on manual processes. Firms with platforms produced comprehensive, data-driven assessments supported by complete audit trails. Firms working from spreadsheets frequently produced reports that were late, incomplete, or based on data assembled retrospectively rather than collected systematically throughout the year. The FCA has signalled that it expects the quality of these reports to improve materially in subsequent years, which raises the stakes for firms still relying on manual approaches.

This comparison is grounded in the practical realities of Consumer Duty monitoring rather than abstract platform capabilities. The question is not whether a spreadsheet can theoretically track outcome data — it can. The question is whether it can do so reliably, consistently, and with the evidential quality that the FCA expects when it examines your monitoring arrangements.

When Spreadsheet-Based Tracking Makes Sense

Spreadsheet-based monitoring can be appropriate for firms with narrow product ranges, limited customer numbers, and straightforward distribution models. A firm offering a single product to a well-defined target market, with fewer than a thousand customers and a small compliance team, may find that a well-designed spreadsheet captures the necessary data without undue complexity. At this scale, the compliance officer can maintain personal oversight of the data quality, and the volume of monitoring activity is manageable within manual processes.

Firms in the early stages of Consumer Duty implementation may also use spreadsheets as an interim solution while they determine their monitoring requirements. The first year of monitoring typically involves experimentation — testing different metrics, refining data collection methods, and learning what the FCA actually examines during supervision. Building this understanding using a flexible, low-cost tool before committing to a platform avoids the risk of configuring an expensive system around requirements that have not yet been validated. The spreadsheet serves as a prototype, and the lessons learned from operating it inform the eventual platform specification.

Cost-constrained firms — particularly sole traders and micro-enterprises — face a genuine affordability question. If the choice is between spending the compliance budget on a platform licence or on substantive compliance activities such as file reviews, training, and vulnerability assessments, the firm may be better served by investing in the activities and managing the tracking manually. This is a pragmatic choice, not an ideal one, and it requires the firm to acknowledge the limitations of the approach and invest disproportionate effort in maintaining data quality and evidence standards.

When Structured Compliance Platform Makes Sense

The case for a structured platform strengthens rapidly as the firm's complexity increases. Firms with multiple products or services must monitor outcomes across each product line, which means managing parallel data streams, comparing performance metrics across products, and identifying where outcomes diverge from expectations. A spreadsheet that tracks outcomes for one product becomes unwieldy at three products and unmanageable at ten. The risk is not just operational burden — it is that the firm fails to identify poor outcomes in one product line because the data is buried in a complex, manually maintained workbook.

Firms with supervisory engagement — those in a fixed or flexible supervisory portfolio, those that have received FCA correspondence requesting Consumer Duty evidence, or those expecting a supervision visit — should treat platform-based monitoring as essential. When the FCA asks for evidence, it expects comprehensive, well-organised data delivered promptly. A structured platform can produce this evidence in hours. A spreadsheet-based firm facing a supervisory request typically enters a period of frantic data assembly, during which gaps become visible, inconsistencies emerge, and the firm's credibility is undermined before the substantive discussion even begins.

The annual board assessment is the single most demanding Consumer Duty deliverable, and it is where the difference between approaches becomes most acute. A board-quality assessment requires data covering all four outcome areas, trend analysis showing how outcomes have changed over the monitoring period, evidence of actions taken in response to identified issues, and an honest evaluation of where the firm is delivering good outcomes and where it is not. Producing this from spreadsheets requires weeks of manual compilation. A platform produces the underlying data automatically, allowing the compliance team to focus on the analysis and narrative that give the assessment its substance.

Firms operating across group structures, with appointed representatives, or with outsourced service providers face additional complexity. Consumer Duty monitoring must cover the entire customer journey, including activities performed by third parties. A platform that aggregates data from multiple sources and provides a consolidated view of outcomes is substantially more effective than attempting to reconcile spreadsheets across multiple entities.

Key Considerations

The audit trail is the most consequential difference between the two approaches. The FCA's supervisory methodology includes examining whether the firm can demonstrate when data was collected, by whom, what the data showed at the time, what decisions were made on the basis of that data, and what actions resulted. A spreadsheet records the current state of the data; it does not reliably record the history. Cell values can be overwritten without trace. Version-controlled copies help but create their own problems — which version is authoritative? When was the backup taken? A structured platform maintains an immutable audit trail by design, and this is precisely the type of evidence the FCA values in supervisory engagement.

Data integrity is closely related. Spreadsheets are vulnerable to formula errors, broken cell references, manual transcription mistakes, and accidental deletions. Research consistently shows that a significant proportion of large spreadsheets contain material errors. For a compliance function that relies on spreadsheet data to assess customer outcomes and report to the board, these errors are not just operational inconveniences — they are governance failures. A board that makes decisions based on incorrect MI is not discharging its oversight obligations effectively, and the FCA will examine the reliability of the data underpinning board-level assessments.

The opportunity cost of manual monitoring deserves honest assessment. A compliance officer spending two to three days per month collecting, cleaning, analysing, and reporting Consumer Duty data from spreadsheets is not spending that time on substantive compliance activities — file reviews, training, risk assessments, and the analytical work that actually improves customer outcomes. A platform that automates data collection and reporting frees the compliance function to focus on the activities that generate regulatory value. For most firms, this reallocation of compliance resource is the strongest practical argument for a platform investment.

Regulatory expectations are not static. The FCA has indicated that its supervisory approach to Consumer Duty will intensify over time, with increasing expectations around data quality, granularity of outcome monitoring, and the sophistication of board assessments. Firms that are managing with spreadsheets today may find that their approach is insufficient within one to two years as the FCA raises its expectations. Investing in a structured platform now positions the firm to meet evolving requirements without the disruption of a forced transition under supervisory pressure.

The Bottom Line

For firms with any meaningful degree of product complexity or customer volume, a structured compliance platform for Consumer Duty monitoring is the more prudent investment. The combination of automated audit trails, consistent MI production, real-time visibility, and inspection-ready evidence addresses the FCA's core supervisory expectations in a way that spreadsheet-based approaches struggle to match. The initial cost is real, but it is modest relative to the cost of a compliance officer's time spent on manual data management, and trivial compared to the cost of regulatory remediation if the FCA identifies monitoring deficiencies.

Spreadsheet-based tracking remains a viable option for the smallest, simplest firms — sole traders with single products and minimal customer volumes — and as a short-term interim approach while firms determine their monitoring requirements. Beyond these narrow circumstances, the question is not whether to move to a structured platform, but when. The firms that are best positioned for the FCA's next round of Consumer Duty supervision are those that made this transition early enough to have a full year of platform-captured data supporting their annual board assessment.