Renewal Book

Guides

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:

  1. Premium: the premium for the term.
  2. Commission rate: the carrier’s rate for that line, as a percentage.
  3. Commission expected: premium × rate. A $1,200 policy at 12% is $144.

Then one more, when the carrier pays:

  1. 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.

Start free, no card

More guides