How to find missing insurance commissions

A practical guide for small and midsized P&C insurance agencies.

A missing commission is hard to catch because nothing tells you it's missing. There is no line on the statement and no error. The policy is in your book, the client is covered, and the money never arrives.

Finding it takes a deliberate check, and it helps to know which of two different problems you are looking at.

Missing vs. unmatched: two different problems

Missing means you expected a payment and it isn't there. The policy is in your book, but no statement line covers it.

Unmatched means a payment is there and you can't tell what it's for. The statement has a line, but you can't connect it to a policy in your book.

They need different follow-up. A missing commission is usually a question for the carrier. An unmatched one is usually a question for your own records first. Sometimes they are the same problem seen from both sides: the carrier paid a policy under a number or name you didn't recognize, so it looks unmatched on one side and missing on the other.

Why commissions go missing

It isn't due yet. Depending on the carrier, commission may be paid in one lump sum or in payments over the policy term. A policy that hasn't paid yet may simply not be due.
It was paid under something you didn't recognize. A different policy number, insured name, or coverage-part number can hide a payment you did receive. See why carrier policy numbers don't match.
The policy was set up differently on the carrier's side. For example, under the wrong producer or agency code, or without the commission you expected.
The rate was different than you expected. A payment can arrive, but for less than your records say it should be.
A change wasn't carried through. An endorsement, a renewal or a rewrite may not have produced a payment.
It was reduced after the fact. A cancellation or return premium change can turn a payment into a chargeback.
It was paid by someone else. The statement may come from an MGA or wholesaler rather than the carrier, so you have to look in the right place.

How to find what is missing

Start from your book, not the statement. Make a list of policies you expect to be paid on for the period. A statement can only show you what was paid. Your own records are the only place a missing payment shows up.
Compare the list to the statements. Mark each policy that has a line, then look at what's left.
Rule out "not due yet" before you call it missing. Check the effective date and how that carrier pays, whether in a lump sum or over the term.
Look back, not just at this month. A payment that is missing this month may have arrived last month, or may still be on its way. Check recent statements before you raise it.
Check for a payment you didn't recognize. Search the unmatched lines by insured name, effective date, and premium. This is often where the "missing" policy turns out to be.
Treat your own expected amount as an estimate. What your system says you should be paid is a calculation. The statement is the record of what was actually paid. A gap between them is worth a look, not an automatic error on the carrier's part.

What to do when something is still missing

Send the carrier a short, specific note. Include the policy number, the insured, the effective date, the statement period you expected it in, and the amount you expected. Keep a log of what you asked and when so nothing is asked twice or forgotten. Most of the work is in having the details ready.

What to do with unmatched lines

An unmatched line is a payment you can't place. Before assuming anything is wrong, check whether the policy is in your book at all, whether the number or insured name is formatted differently, and whether more than one policy could be the match. If more than one fits, review it by hand rather than guessing. For the full process, see how to reconcile carrier commission statements.

How EZ Commissions fits in

EZ Commissions starts from the amount actually paid on each statement line. Upload a CSV, Excel file or PDF. There is no template to fill in. It identifies the policy number, insured, effective date, premium and commission, then checks each line against your book and shows a confidence score.

Lines that don't match are flagged with the reason, such as no policy number, a policy not in your book, or more than one possible match, so you can review them instead of searching for them. When you resolve a line by hand, EZ Commissions remembers that carrier's policy-number and insured-name variations for your agency, and the next statement can use those mappings.

Explore the workflow at your own pace with a private, 48-hour demo using sample data. No appointment or live demonstration needed.

Request a demo