How to track commissions at a small insurance agency
Work out what each carrier owes you, check what was actually paid, and catch the short payments, without an accounting system.
Most small agencies know roughly what they earn, and very few know exactly what each carrier owes them. The gap between the two is where short payments hide. Tracking commission doesn’t need an accounting system; it needs three numbers per policy.
The three numbers
For each policy term:
- Premium: the premium for the term.
- Commission rate: the carrier’s rate for that line, as a percentage.
- Commission expected: premium × rate. A $1,200 policy at 12% is $144.
Then one more, when the carrier pays:
- Commission paid: what actually arrived, and the date.
Expected minus paid is the number that matters. Across a book, it tells you which carrier is behind.
Start with each carrier’s usual rate
Most carriers pay a standard rate per line of business: new business and renewals may differ. Write down each carrier’s usual rate once. New policies then start from it, and you only change the ones that differ.
Look at it by carrier, then by line
A total for the whole agency hides problems. Sort expected commission by carrier: if one carrier’s paid total is well below its expected total, look at that carrier’s statement line by line. Then by line of business, to see where the agency’s income actually comes from.
Check statements against the list, monthly
When a carrier statement arrives, mark each policy’s commission as paid, with the date. Anything still unpaid a month or two after the term started is worth a question to the carrier.
Common reasons for a short payment
- the carrier used a different rate than you expected (a renewal rate, or a changed schedule);
- a policy was cancelled or rewritten mid-term;
- a premium change after an endorsement;
- the policy was placed under another producer code.
None of these are unusual. They only cost you money if nobody notices.
Doing it in Renewal Book
Renewal Book keeps premium, commission rate and expected commission on every policy term. Give each carrier its usual rate once, and every policy of that carrier with no commission yet takes it. The Commissions screen shows what you should earn by carrier, line and segment, what’s been paid, and the gap, so a short payment stands out. Import your policy list with its premiums, and it’s there on day one.
More guides
- How to track insurance renewals and stop missing themA simple system for a small independent agency to see every renewal coming, work each one on time, and know what happened to it.
- The insurance renewal spreadsheet, and a free templateThe columns an agency's renewal spreadsheet needs, how to lay it out so it stays useful, and a free blank template to download.
- How to measure and improve your agency's retention rateHow to calculate policy retention for a small independent agency, why it's the number that drives agency value, and what to do about the renewals you lose.
- A 90-day renewal checklist for independent agenciesWhat to do 90, 60 and 30 days before a policy renews, and on the day, so renewals are worked early and nothing lapses.