We pulled twelve months of payment data for the owner of a nine-location group because of something she noticed on a site visit. She wasn’t there about money. She was there about a lease. But the office manager mentioned, almost in passing, that one big insurer had gotten strange since spring, and the owner realized she had no way to know if that was true. Nothing she read each month said anything about one insurer at one location.
What the group report showed
Her consolidated report was calm. Days-to-pay for the group had held steady all year, moving about one day. And the number wasn’t wrong. Every location’s data was in there, added up honestly. It was answering the question it was built for, how is the group doing, and that question has no bad quarters in it. Blend nine locations and the strong ones absorb the weak one automatically. That’s what blending is.
What the location’s own history showed
Then we asked a different question. We took that one location and put that one insurer against its own past twelve months. The insurer was running 31 days off its own pace, and had been for a full quarter. Real money, arriving late, at one address, for three months. At group altitude it rounded away. At location altitude it was the difference between a comfortable quarter and a tight one, and the office manager had felt every week of it. She knew. The report didn’t.
Sit with that for a second, because it’s the real finding. Nine locations means nine office managers who each know something the consolidated report doesn’t, and none of them had anywhere to send it. The group’s early-warning system was whichever location the owner happened to visit that month, for whatever reason brought her there. A lease negotiation had just outperformed the entire reporting stack.
Why do consolidated reports miss location problems?
Because blending is the job: nine locations average into one number, and one location’s bad quarter rounds away. The wider the group, the duller the blend, and the location-level answer never surfaces.
Why averages do this
Nobody built the report wrong. Averaging is what averages do, and the effect gets stronger as you grow. Every location you add widens the range the blended number calls normal, so the threshold for what looks worth asking about rises with each acquisition or opening. A two-location group notices a bad quarter at one address. A nine-location group notices a bad year, maybe. The instrument gets duller exactly as the thing it watches gets bigger, which is the opposite of what an owner assumes scale buys.
A different question needs a different instrument
The group question and the location question can’t share a report. The location question is: for each insurer at each location, how does this month compare to that insurer’s own last twelve months at that address? Three ways it can break. Slower, the days drift past their own range. Lighter, the payments arrive on schedule with fewer cents on the dollar in them. Quieter, less money arrives than that insurer’s history says should, even when every payment that does arrive looks fine. Any of the three flags the week it starts, with a location, an insurer, a date, and a dollar figure attached.
At group scale the output stays small on purpose. One weekly list. A normal week reads empty, or one line. When a line appears, it routes to that location’s manager the same day, and the group watches one thing about it afterward: how long it stays open. The owner never went looking for problems again. The problems learned to introduce themselves, properly dressed, with their paperwork attached.
What she found, what we built, what holds
Found: one insurer at one location, 31 days off its own pace for a quarter, sitting invisibly inside a consolidated number that moved one day.
Built: the location-by-insurer panel. Every payer at every address against its own history, refreshed weekly, with breaks surfacing as a short list instead of a feeling somebody has to mention during a lease visit.
Holds: the accident became a system. The office manager who knew now has somewhere to send what she knows, and the owner reads a list that’s usually empty and occasionally the most important thing on her desk. The next drift got flagged in its second week, at a different location, from an insurer nobody was worried about.
Your version
If you run more than one location, try this with your biggest insurer. Chart its days-to-pay at each location separately, twelve months back. If the lines move together, your blend is honest. If one line has wandered off on its own, your consolidated report has been averaging away exactly the thing you needed to see, and the people at that location already know which line it is. While you’re in there, check whether your location ranking is grading geography and whether your newest location is coasting on a grace period.
We’ll run every insurer at every location against its own twelve-month history and hand you the list your average has been eating. Grab 30 minutes with us. Prep nothing.