When the spreadsheet stops working

Nearly every appraisal practice I know of started the same way, with a spreadsheet, an inbox, and a folder structure that made perfect sense on the day somebody set it up. That works, and it tends to work for a good deal longer than people expect, because a spreadsheet is genuinely a fine tool for twenty files.

What is harder to see is the point where it stops working, and the reason it is hard to see is that it does not stop all at once. It degrades slowly, and while it is degrading the whole thing mostly just feels like being busy.

The signs, roughly in the order they show up

The first one is that you start answering "where is that file?" out of memory. Early on that feels like competence, and it is worth noticing that it is actually the first sign the record lives in your head rather than in your system — and your head is the part that does not scale and cannot be handed to anybody else.

Then there is the column somebody added that nobody fills in. Usually it is something like status, or next step. It was a good idea when it went in, and it is now three quarters empty, which is arguably worse than never having had it, because a half-kept field is one you cannot trust and cannot sort by.

After that you start finding out that a file went quiet by accident. Someone mentions a claim in passing and you realize nothing has happened on it for six weeks. Nothing failed, nobody dropped anything, and no one did anything wrong; it simply was not in front of anybody, and a spreadsheet has no way of raising its hand.

Somewhere along the way the money ends up living somewhere else entirely. Invoices in one place, what has actually been paid in another, what you owe an assignee in a third, and reconciling the three of them becomes a job you do at month end that takes an evening.

Eventually two people cannot work at the same time. The moment a second person needs the same view you are having a negotiation about who currently has the file open.

What is really breaking

It is worth being precise about this, because "you need a system" is not useful advice to anybody.

A spreadsheet stores what you typed into it. What a practice needs as it grows is something that stores relationships and notices absences — that this claim has a carrier appraiser named on it and that one does not, that an inspection happened on this file but no report ever followed, that an invoice went out and only half of it came back.

Those are all questions about what is missing, and a spreadsheet is simply not built to answer them. You cannot filter for the thing that nobody entered.

That, I think, is the real threshold, and it is not about how many files you have or how many people work for you. It is the point where the question that matters most quietly changes from "what did I write down?" to "what has not happened yet?"

What to do about it

Do not migrate everything. The instinct is to move five years of history across first, and as far as I can tell that is the single biggest reason these projects stall out. Move the open files, and let the closed work stay where it is or get exported once and kept as an archive.

Export before you commit to anything at all. Get your existing data out as a CSV first, whatever you end up choosing, because that will show you what you actually have — which is usually a good deal less structured than you remember it being — and because it is the format any sensible system is going to accept on the way in.

Expect the first week to feel slower, because it will be. You are typing things you used to carry around in your head, and that is simply the cost of getting them out of there.

Then insist on being able to get your data back out. Whatever you pick, check that exporting is an ordinary feature rather than a support ticket or an extra fee, because a system you cannot leave is one you will resent sooner or later.

The honest version

Plenty of practices run on a spreadsheet for years and do perfectly well. If yours is working, then the cost of changing it is real and immediate and the benefit is speculative, and you should not move just because somebody wrote an article telling you to.

Move when the questions you cannot answer start costing you real money — the file that went quiet, the half of a fee that never turned up, the deadline nobody was watching. Those things have a price attached to them, and at some point that price is higher than the price of moving.

---

We built The Claim King to import from a CSV and to export back to one at any time and at no charge, and it is priced on the website so you can decide whether it is worth it to you before speaking to anybody at all.