How to Stop Losing Personal Injury Cases in Your Spreadsheet in 2027

Why do practices end up tracking personal injury in a spreadsheet at all?

Because the practice management system was not built for a payer that answers in a year.

Standard accounts receivable reporting assumes a rhythm. A claim goes out, a response comes back inside thirty days, and the aging buckets run 0 to 30, 31 to 60, 61 to 90, and 90 plus. Each bucket means something specific has gone wrong and can be worked.

Personal injury has none of that structure. Cases settle in twelve to eighteen months on the normal path and past twenty-four on complex ones, which means every personal injury case is already in the 90 plus bucket on the day it opens. The report shows one hundred percent of the book in the worst category, which is accurate and completely useless. A case four months along and moving well appears identical to one that stalled a year ago.

So the spreadsheet appears. Somebody in the practice decides the cases need tracking somewhere, opens a new sheet, and starts a list. It is a sensible response to a real gap, and it is how most personal injury books in the country are managed.

What is wrong with most personal injury spreadsheets?

They answer “who” and not “what is happening.”

Look at the columns on a typical one. Patient name. Attorney. Firm. Date of accident. Date of first visit. Perhaps a notes field. Every one of those is a fact that was true when the row was created and has not changed since.

Nothing on that sheet changes state. The sheet can be completely accurate and still tell you nothing about the health of the book, because recording and measuring are different activities.

This is also why these sheets quietly stop being updated. A list that never tells you anything new stops being worth opening, and then the cases drift somewhere nobody is looking. The sheet did not fail. It was never asked to do the job.

What should the spreadsheet actually tell you?

Four things. Add them to the sheet you already have.

This sounds trivial and is usually the hardest of the four.

Open cases tend to live in more than one place. Some sit in the practice management system, some on the spreadsheet, some in the memory of whoever handled intake that month, and some only in the law firm’s file. For a practice running personal injury across more than one system, even this first question usually requires manual reconciliation.

Building one list is the exercise. Not an estimate. A count.

What it tells you is whether the practice has a personal injury book, or an accumulation of individual arrangements nobody has looked at together. The second is more common than you would expect, and it is not a failure of competence. It is what happens when something grows without ever being formally adopted.

Add up the billed charges on every open case. Then be honest about the second number.

Billed is not collected. Attorneys negotiate reductions, particularly when a case settles for less than anyone hoped, and most providers who have worked personal injury for any length of time have had that conversation. A spreadsheet that tracks only billed charges will overstate what is coming, sometimes considerably.

The useful version carries both: what you billed, and what you realistically expect based on your own history with these firms. If you have never worked out the second figure, that is worth an afternoon of its own.

Between them, the two figures give you the size of the care you have already delivered and already covered the cost of, and a sober view of what is actually coming back.

Take the total and work out what share belongs to cases opened more than two years ago.

Past two years, an open case is usually one of two things. Genuinely complex and still progressing, which is normal. Or stalled, meaning the patient stopped treating, the firm changed, or the case quietly went nowhere. Those two look identical on a list and are completely different in reality.

That share is the part of the book needing a conversation rather than patience. You cannot tell which cases are which from a list of names, which is precisely the point.

Define quiet simply. No verified status update from the law firm in six months.

Verified matters. Not “we emailed them,” but an actual answer about where the case stands. Go through the list and mark them.

A quiet case is not necessarily a dead one. Long silences are ordinary in litigation and a firm with nothing to report may simply have nothing to report. But a quiet case is an unexamined one, and finding out which kind it is involves picking up the phone.

This is where the risk actually sits. Not in the cases that are old, but in the cases nobody has checked.

What do the answers tell you together?

They make a baseline, and a baseline is what makes every measurement after it meaningful.

A practice that has never run them knows only that there is money out there somewhere.

The four also point at different actions. A high count with a low total means many small cases, which is an administrative load question. A low count with a high total means concentration, which is a different exposure. A large share past two years means conversations with firms have been deferred. A long quiet list means nobody owns the relationships.

None of that is visible from a contact list. All of it is visible from four numbers on the same sheet.

When should a practice do this?

Year-end, for a practical reason. It is the one period when a practice is already looking at its numbers.

The books are being closed, the year reviewed, and whoever handles the finances has the systems open anyway. Adding the personal injury book to that review costs an afternoon, and the next year starts with a baseline instead of a guess.

One boundary worth naming. This is an operational exercise, not an accounting one. How personal injury receivables should be treated on your books, and what any of it means for your tax position, is a question for your accountant. The four questions here are about knowing what you have, which is useful regardless of how it is recorded.

What if the numbers are worse than expected?

They sometimes are, and that is worth saying plainly rather than letting anyone discover it alone.

Almost nobody sets out to let a personal injury book drift. It drifts because the reporting tools were built for a different payer, because personal injury grew without anyone formally deciding it should, and because every individual case felt manageable in isolation. A practice finding that a quarter of its book is older than two years has not been badly run. It has been working without an instrument.

The useful response is not alarm. It is a list, a few calls to the firms that have gone quiet, and a decision to run the same four numbers again in three months.

Where funding fits

The exercise is worth doing whether or not a practice ever works with a funding partner. Knowing what is in your own book is not a precondition for anything. It is just useful.

What funding changes is the position you are in once you know. A practice carrying twelve to eighteen months of its own delivered care is financing that gap out of operating cash, and the longer the book runs, the more of the practice’s working capital sits parked in it. Golden Pear’s healthcare solution closes that gap. Practices are paid on their personal injury receivables now, rather than at settlement.

* Either route can also be structured as an advance plus a back-end split, where the practice is paid now and stays in the deal, and when the case settles it shares in the outcome.

Golden Pear works across thirty-five markets: thirty-four states and the District of Columbia.

Frequently asked questions