Three Kinds of Reconciliation Friction That Quietly Bleed Margin

Plenty of agency owners can tell you their loss ratio, their retention rate and roughly how much new business came in last quarter. Ask what reconciliation costs them each month and you'll usually get a shrug, or a guess that's off by half.

That's not carelessness. Reconciliation cost doesn't show up as a line item. It hides inside salaries you're already paying, and it grows a few minutes at a time. Nobody notices until the person doing it gives notice, or until the month-end close starts running into the second week of the following month.

So let's put numbers on it. Not industry numbers, because those are mostly marketing. Your numbers, using a model you can redo with your own inputs in about ten minutes.

The example agency

Picture a fairly ordinary independent agency. Twenty people. Personal and commercial lines. Twenty-two carrier appointments, of which maybe fifteen send meaningful volume. One full-time accounting person, plus an office manager who helps at month end.

We'll say the accounting person's loaded cost (salary, payroll taxes, benefits) works out to $38 an hour. Change that to whatever yours actually is. It matters more than any other number here.

Now the three sources of friction.

1. Chasing statements that didn't arrive

Every month, a handful of carriers are late. The statement didn't post to the portal yet, or it went to the email address of someone who left in March, or the portal password expired and the reset link goes to a shared inbox nobody checks.

Each one of these is small. Log in, notice it's missing, check email, check the other email, call or message the carrier, wait, check again two days later. Call it 45 minutes of actual effort per missing statement, spread across a week.

If four carriers are late in a given month, that's 3 hours. At $38, about $114.

That doesn't sound like much, and on its own it isn't. The bigger cost is that you can't close the month until the last statement is in, so everything downstream (producer payouts, the P&L your banker wants, the trust account tie-out) waits on the slowest carrier.

2. Retyping PDFs that should have been data

This one is usually the largest, and it's the one people underestimate most, because the work feels productive. You're entering numbers. Things are getting done.

Say eight of your carriers only give you a PDF, or give you a CSV so badly formatted that it's faster to work from the PDF. Those eight average 120 lines a month each, so roughly 960 lines.

Matching a line by hand (find the policy, confirm the premium, confirm the rate, key the commission, flag anything odd) takes most people somewhere around 30 to 60 seconds when they're in a rhythm. Use 40 seconds.

960 lines at 40 seconds is 640 minutes, or about 10.7 hours a month. At $38, that's roughly $405.

Then there are the typos. Even careful people mistype now and then. If one line in 200 goes in wrong, that's about five errors a month. Each one gets found later, usually when something doesn't tie, and finding it takes far longer than making it. Twenty minutes each is generous to the finder. Five errors, 100 minutes, call it 1.7 hours and another $63.

3. The producer split nobody wrote down

Almost every agency has one. A producer took over a book from someone who retired. Or two producers share a large commercial account and agreed on a split over lunch three years ago. Or there's a house account that one producer services and gets "something" on.

When the arrangement isn't written down, the person running payouts reconstructs it every month. They look at what was paid last time, check an old email, maybe ask the owner. If you have three of these arrangements and each one eats two hours a month (including the occasional "that's not what we agreed" conversation), that's 6 hours, or $228.

This is also the friction with the worst tail risk. An undocumented split is fine right up until the producer leaves, and then it becomes an argument about money with someone who no longer has a reason to be friendly.

Adding it up

For the example agency:

• Chasing missing statements: 3 hours, $114
• Retyping PDF statements: 10.7 hours, $405
• Finding typos later: 1.7 hours, $63
• Reconstructing undocumented splits: 6 hours, $228

That's 21.4 hours and about $810 a month, or roughly $9,700 a year, in labor alone. That's before counting the commission you never collect because a mismatch got waved through, which is a separate and harder number to pin down.

Your figures will be different. Maybe you have fewer PDF carriers and more producers with handshake deals. That's the point of doing the math yourself.

What to do with the number

You don't need software to attack most of this. Some of the cheapest fixes are boring:

Send every carrier a single, shared intake address for statements, one that doesn't belong to a person. Then update it on every portal and agency agreement. It takes an afternoon and permanently removes a chunk of the chasing.

Write down every split. One page per arrangement: who, what accounts, what percentage, effective date, signed by both people and the owner. If someone won't sign, you've just learned something important about that arrangement.

For the PDF problem, start by asking each carrier whether a download format exists that you're not using. More often than you'd expect, there's a CSV or Excel export buried in a different menu.

The retyping is where tooling genuinely earns its keep, since parsing and matching statements automatically is the job PolicyBalance was built for. But fix the free stuff first. It's free.

And whatever you decide, redo the math in six months. Friction has a way of creeping back.