CRM vs spreadsheet for mortgage brokers

Plenty of profitable brokerages run on a spreadsheet. Plenty of others bought a platform and quietly kept the spreadsheet open on a second monitor. Both facts are worth taking seriously, because the spreadsheet is not a sign of amateurism — it is a sign that something about the alternative did not fit.

This is a straight comparison of where each option genuinely wins.

Where the spreadsheet is better

It is faster to change. If you decide on Tuesday that you want to track which cases came from which estate agent, you add a column and you are done. In a platform that same request may be a configuration ticket, a paid customisation or an outright no.

It shows everything at once. One screen, fifty rows, and a broker can scan the whole pipeline in a glance. Many systems bury the equivalent view behind filters, and some never quite reproduce it.

It costs nothing and nobody has to be trained. A new administrator can be productive in an afternoon.

It calculates whatever you want. Weighted pipeline value, procuration fee reconciliation, adviser splits, expected completion by month — all trivial in a grid, and often surprisingly awkward in a product that has decided what reports you need.

Nobody should feel embarrassed about any of this. A well-kept sheet, owned by one person who cares about it, beats a badly adopted platform every time.

Where the spreadsheet fails

Concurrency is the first crack. Two people editing, one overwrites the other, and nobody notices for a fortnight. Cloud spreadsheets mitigate this but do not remove it, because the failure is silent.

There is no history. When a case status changes from one word to another, the previous value is gone. You cannot answer how long that case sat in underwriting, or when the client was told, or who made the change.

Documents live somewhere else. The sheet knows the case exists; the payslips are in an inbox or a shared drive. Anything that reconstructs a file therefore involves two systems and a naming convention that only half the team follows.

Nothing happens on its own. A cell that says a rate expires in March does nothing in January. Someone has to look. That works while the book is small and fails invisibly as it grows, because the failure is a client you did not contact, and you never find out.

And there is a data protection dimension. A spreadsheet containing client names, dates of birth, income and property addresses is personal data. Emailed to a colleague, downloaded to a laptop, or copied to a home machine, it becomes very hard to say where that data is. Access controls in a platform are imperfect but they exist.

Where a platform is better

Audit trail, mainly. A system records who changed what and when, which is the difference between asserting that a client was kept informed and demonstrating it.

Automation, secondly. Rate expiry alerts, document request chasers, task creation on stage change — these are the jobs that a human does badly not through carelessness but because they are dull and infinite.

Continuity, thirdly. When an adviser leaves, their cases stay legible. Spreadsheets tend to leave with the person who understood them.

Shared definitions, fourthly and least obviously. A dropdown of eight statuses forces a firm to agree what its process actually is. That argument is uncomfortable and usually overdue.

The comparison nobody runs

Before switching, price the spreadsheet properly. Count the hours per month spent updating it, reconciling it, and answering questions it cannot answer. Add the value of business lost to rate expiries that passed unnoticed — you can estimate this by pulling last year's completions and checking how many of the previous cohort you retained.

Then price the platform properly. Subscription, yes, but also migration effort, the weeks of reduced output while people learn it, and the ongoing cost of the person who becomes its unofficial administrator.

Firms that do this arithmetic sometimes conclude the spreadsheet is fine for another year. That is a legitimate result.

The hybrid that actually happens

In practice most firms end up with both for a while, and that is manageable if you are deliberate about it.

Pick one system as the record of truth for client data and case status. The other may exist for analysis only, refreshed by export, never edited directly. The moment people start updating both, you have two versions of reality and no way to tell which is right.

Set a date to kill the spreadsheet, and make killing it someone's explicit responsibility. Hybrids that were meant to last a quarter have a way of lasting four years.

A rough dividing line

One adviser, fewer than about forty live and pipeline cases at a time, strong personal discipline: a spreadsheet is defensible.

Two or more people touching the same cases, an administrator, or a back book you intend to retain: the spreadsheet is now costing you money you cannot see.

Whichever way you go, the thing that decides the outcome is not the tool. It is whether one named person is responsible for the data being right, and whether anyone would notice if it stopped being right.