Why Mortgage Firms Still Using Spreadsheets Are Losing Their Best Clients

There's a moment every growing mortgage firm recognises. You open the shared spreadsheet to update a case, and three cells are already highlighted in yellow by someone else. The status column says "APPLICATION" but the client called last Tuesday to say they'd already had an offer. The "last contacted" column is two weeks out of date. The document checklist is in a separate tab. The note about the lender's income cap is in a comment somewhere.

This is the point where the spreadsheet stops being a productivity tool and starts being a risk.

The Numbers Behind the Problem

In a firm managing fewer than twenty active cases, a well-maintained spreadsheet can work. Updates happen in sequence rather than in parallel. One adviser can hold the context of every case in their head. Clients are patient because you respond quickly.

Scale that to fifty cases, three advisers, and a coordinator, and the failure mode becomes structural. Studies across professional services firms consistently find that when teams exceed five people sharing a single source of record, data accuracy degrades by 30–40% within six months — not because people become careless, but because concurrent editing, informal communication, and the absence of enforced process make drift inevitable.

For mortgage firms, that drift has direct consequences.

What Spreadsheets Cannot Do

They cannot enforce a process. A spreadsheet records whatever you type. If an adviser forgets to log a suitability conversation, the spreadsheet has no way to surface that gap. It cannot tell you that a case moved from "Submitted" to "Offer Received" without anyone updating the compliance notes. The FCA expects a contemporaneous record; a spreadsheet that nobody updated for four days is not one.

They cannot replace you in client communication. When a client submits a form, uploads a document, or needs a reminder about an outstanding item, a spreadsheet cannot tell them. You have to. This means a significant fraction of an adviser's day — studies in financial advisory suggest 15–25% — is spent on case administration rather than advice.

They cannot scale permissions. When a new adviser joins your firm, do they get access to every case? When a coordinator needs to chase a client for documents on three specific cases, do you share the entire sheet? Most firms end up with either over-sharing (everyone sees everything) or under-sharing (people work from outdated copies).

They cannot create an audit trail. An FCA visit focuses heavily on whether your record-keeping reflects the advice given. Spreadsheets can be edited without trace. A deleted row, an amended figure, a cell someone overwrote — none of these are captured. If a client complaint goes to the Financial Ombudsman Service, a spreadsheet is a liability, not a defence.

The Real Cost: Client Experience

The operational problems above are significant. But the commercial damage is more immediate.

Clients applying for mortgages — particularly buy-to-let remortgages, complex residential applications, and product transfers — have specific expectations shaped by their experiences with other professional services. They expect to know where their case stands. They expect documents to be requested once, not twice. They expect that the adviser they spoke to last week knows about the conversation they had with the coordinator yesterday.

Spreadsheet-driven firms consistently fail on these expectations. Not through negligence, but through the inherent limitations of a tool designed for data tabulation being used as a case management system.

The adviser who can tell a client "your application is at underwriting, the valuation is booked for Thursday, and the one outstanding item is your latest payslip — I've sent a reminder" is not doing something extraordinary. They're using a system that makes that information immediately visible.

The adviser using a spreadsheet is spending twenty minutes finding the same answer.

The Compliance Inflection Point

The most serious risk is regulatory. The FCA's expectations around record-keeping have become increasingly specific since the Consumer Duty came into force. The requirement is not simply that you made good decisions — it is that you can demonstrate, with documentary evidence, that your advice process was appropriate for the client's circumstances at the time.

That means:

• A record of every suitability conversation
• Documentation of the client's stated objectives, risk appetite, and circumstances
• Evidence that you considered alternatives
• A timestamped trail showing when key decisions were made and communicated
• Client consent records, particularly for buy-to-let and portfolio landlord applications

None of this is naturally provided by a spreadsheet. Some firms try to approximate it by embedding links to documents, adding comment trails, or maintaining a separate log. These workarounds add complexity without resolving the underlying problem: the spreadsheet has no concept of a case lifecycle, a compliance obligation, or an audit-required event.

What the Transition Looks Like

The firms that have moved away from spreadsheets consistently report two things. First, the transition is faster than they expected — a properly structured migration of case data typically takes a weekend rather than a month. Second, the productivity gains appear within the first fortnight, before any optimisation has happened.

The reason is straightforward. When case status, client communication, document requests, and compliance notes all live in one place — and that place is accessible to the whole team, updated in real time, and structured around how mortgage cases actually work — the overhead of coordination disappears. Advisers spend their time on advice. Coordinators spend their time on coordination. The system handles the record.

The spreadsheet served you well when you started. It got you here. But the question isn't whether it worked then — it's whether it will work at double your current case load, under increased FCA scrutiny, with clients whose expectations are shaped by modern digital experiences.

For most growing mortgage firms, the honest answer is no.