Spotting a Commission the Carrier Never Paid You
An overpayment eventually finds you. The carrier notices, sends a correction, and a negative line appears on a statement.
An underpayment doesn't work that way. If a carrier never pays commission on a policy, nothing happens. No line, no notice, no email. The money just isn't there, and unless someone in your office goes looking, it stays not there.
That's why missing commissions are so easy to lose. You can't reconcile a line that doesn't exist.
Why year-end is too late
A lot of agencies do a big cleanup in December or January, partly because it's when the accountant asks questions and partly because it's when people finally have a moment to look back.
The problem is that by then, the trail has gone cold. The policy that was missing commission in March has been through nine statement cycles. The person who wrote it might not remember the details. Carrier contacts change. And some agency agreements put a limit on how far back the carrier will adjust commission, so read yours, because an item you find in January might be past whatever window applies.
There's a quieter cost, too. Every month a missing commission goes unnoticed is a month your financials are slightly wrong, and your producers might be paid on numbers that won't hold.
So the goal is to find gaps within a cycle or two, not within a year.
Four reports that surface them
None of these need special software, though they're much easier when your policy data and statement data live in the same place.
1. Expected versus received, by policy
For each policy written or renewed in a given month, calculate the commission you expect (premium times your agreed rate) and compare it to what's actually come in on statements so far.
The output you care about is the list of policies where received is zero, or far below expected, more than two statement cycles after the effective date. Two cycles gives normal carrier timing room to play out. Anything past that is worth a look.
2. New business without a first payment
A narrower version of the first report, and often the most productive. Take every new policy issued in the last 90 days and check whether any commission at all has appeared for it.
New business is where feed problems tend to show up first. A policy wasn't tagged to your agency code, or the producer code was wrong, or a downloaded record never made it into the carrier's commission system.
3. Commission yield by carrier, by month
Divide commission received by written premium, per carrier, per month. Watch the trend rather than the absolute number.
If a carrier's yield is steady for months and then drops, something changed. It might be a legitimate rate change you weren't told about. It might be a block of policies that didn't pay. Either way, the drop tells you which carrier to look at before you start checking policies one by one.
4. Renewals that didn't renew the commission
Pull policies that renewed in the last quarter and check that a renewal commission appeared. Renewals get renumbered, moved between programs, or re-rated, and any of those can break the link between your agency and the payment.
This one is easy to skip because renewals feel routine. That's exactly why things slip through.
What to do when you find one
First, double-check it's really missing. Search every statement from that carrier for the insured's name, not only the policy number, in case it posted under a different number or a different agency code.
If it's genuinely missing, send the carrier's commission or agency accounting department a short, specific request: policy number, insured name, effective date, written premium, your expected commission, and a note that you've checked statements from the effective date forward. Group all of that carrier's missing items into one message.
Log the date you sent it. Follow up on a schedule you set, not whenever someone remembers.
Make it routine
The simplest version of all this is a monthly 30-minute review, done right after reconciliation, that runs reports 2 and 3. Report 1 can be quarterly if your volume is high. Report 4 fits naturally into whatever renewal review you already do.
PolicyBalance flags expected-but-unpaid commission automatically, but the habit matters more than the tool. The agencies that recover the most missing commission aren't the ones with the best year-end cleanup. They're the ones who never let a gap get old enough to need one.
Get new articles by email
Practical writing on reconciliation, commissions, and trust accounting. Roughly weekly. Unsubscribe in one click.