The hidden cost of reconciling commissions by hand

The leak nobody logs

A supplier short-pays a commission and, in most agencies, absolutely nothing happens. No alert fires. No row turns red. The spreadsheet doesn't know what the number was supposed to be, because the person who booked the trip never wrote it down anywhere the person doing the close can see — so whatever shows up on the statement becomes, by default, the truth.

The mechanics are mundane. A booking written in January pays out in April. By then the advisor has written forty more, the rate the supplier quoted lives in an email thread, and the statement lands as a lump sum across a dozen bookings. Matching each line back to what was promised means archaeology, and archaeology doesn't happen on a Friday close. So the lump sum gets accepted, deposited, and split.

Owners who eventually go back and audit a full year of statements tend to describe the same feeling: not one dramatic loss, but a slow leak — a percent or two of what they expected to earn that was never disputed, never chased, just never compared against anything. The leak persists precisely because it never fails loudly. A missed payment that nobody expected is indistinguishable from a payment that was never owed.

The time cost is the visible one

Ask an owner what reconciliation costs and they'll describe the time: a weekend a month, sometimes more, spent cross-referencing supplier statements against a spreadsheet that was already slightly wrong before the month began. Every row is a small investigation — which booking is this, what rate applied, whose split, was part of this already paid last cycle. None of it is hard. All of it is slow.

The quieter problem is that this work almost always lives in one head. There is a person who "knows the spreadsheet" — its color conventions, which tab is stale, why row 214 is negative. When that person is on a ship in the Baltic, the close waits. When they leave the agency, the close breaks. A process that only one human can run isn't a process; it's a dependency with a vacation schedule.

What good looks like

The fix isn't a better spreadsheet. It's moving the moment of record to the moment of booking. When a trip is written, the numbers that reconciliation will one day need should attach to it right then: the supplier, the trip's value, the commission the advisor expects, and the split that applies. Not because anyone needs them that day — because in ninety days, nobody will remember them.

Do that consistently and the close changes shape. A statement arrives, and instead of reconstructing what each line should have been, you're confirming it: expected number on the left, actual number on the right, and attention goes only to the rows where they disagree. Most rows match. The handful that don't are the entire job — and they're exactly the rows the spreadsheet was silently absorbing.