Why carrier commission statements don’t match your agency management system

TL;DR

• A statement and your agency management system record the same policies differently: different policy number formats, different dates, and different premium figures.
• Most mismatches come from formats, timing, mid-term changes, cancellations and non-commissionable fees. Rule those out first.
• What’s left after that, a policy truly absent or paid at the wrong rate, is what to raise with the carrier.
• Sometimes the error is in your own system. A missing endorsement in the book looks exactly like a carrier mistake.

Anyone who has tried to tie a commission statement to an agency management system export knows the feeling: half the lines don’t match, and it isn’t obvious which differences matter. We’re building Lapidar to do this matching automatically. It’s in development, so in the meantime here’s what we’ve learned to look for, roughly in the order it causes trouble.

1. Policy numbers are written differently

This is the first wall everyone hits. The same policy can appear in several forms:

The first four can be handled with a match key: a column that removes spaces, dashes, leading zeros and known prefixes on both sides. Be careful with suffixes, which some carriers use for the policy term. If you strip them, add the effective date to the match so two terms don’t collapse into one.

The last row is harder. Some carriers issue a new policy number at renewal or when a policy is rewritten. If your system still holds the old number, the renewal looks missing and the new number looks like a stranger. Matching on named insured and line of business as a fallback usually finds it.

2. The dates don’t line up

Your system records a policy when it’s written, on its effective date. A direct bill statement records commission when the carrier collects the premium, and the statement for a month often arrives the following month. Three consequences:

• A policy effective late in the month may not be paid until next month’s statement.
• A policy on installments is paid in pieces, one line per installment.
• A carrier’s statement period may not be a calendar month. Check its cut-off date.

So an item absent from this month’s statement isn’t necessarily missing. Put it on a watch list and check the next statement before you raise it. Something absent for two cycles deserves a question.

3. Mid-term changes and endorsements

When a policy changes mid-term, an added vehicle, a new location, a higher limit, the carrier usually charges or returns the premium for the rest of the term, and the commission follows. That shows up on the statement as a separate line, often months after the original.

Endorsement at mid-term · EX-10477Example data

Annual premium change

+$600.00

Share of the term remaining

×6/12

Additional premium charged

$300.00

Rate on your schedule

×15.00%

Expected on the endorsement line

$45.00

Two things go wrong here. The endorsement exists at the carrier but was never entered in your system, so a line appears that you can’t match. Or it was entered in your system but the carrier hasn’t processed it, so you expect a line that isn’t there. Either way, compare the endorsement with the policy’s own history, not with the original premium.

4. Cancellations, reinstatements and chargebacks

A cancellation produces a negative line: the carrier returns unearned premium to the insured and takes back the commission on it. Cancellation for non-payment, followed by reinstatement, can produce a negative line and then a positive one, sometimes on different statements. If you only look at one month, you’ll see half the story.

When you see a negative line, find the transaction in your system that explains it, check the return premium, and check that the commission taken back is at the rate originally paid. We cover this in detail in commission chargebacks explained.

5. The premium isn’t the same premium

Your system may hold the total the insured pays. The carrier calculates commission on commissionable premium, which often excludes:

• policy and installment fees;
• taxes and surcharges, including surplus lines taxes where they apply;
• some state assessments.

On auditable policies, such as workers’ compensation or general liability rated on payroll or sales, the premium also changes after the audit, and commission follows the audited premium, up or down. Your agency agreement or the carrier’s schedule says what counts.

6. The rate isn’t the rate you think

A line can match perfectly on premium and still be off on rate. Common reasons:

• New business and renewal rates differ. Plenty of carriers pay less on renewals. If you expected the new business rate on a renewal, the line looks underpaid when it isn’t.
• Rates differ by line of business, and sometimes by state or program.
• The schedule changed. A new schedule may apply to policies effective after a certain date. Make sure you’re using the schedule in force for that policy’s effective date.

If the rate is wrong under the schedule that applies, that’s money to raise. If you were using the wrong schedule, fix your schedule, not the carrier.

7. The error is on your side

It’s uncomfortable, but a good share of mismatches start in the agency’s own data: an endorsement never entered, a renewal premium never updated, a policy filed under the wrong carrier, a transfer of a policy to another agent never recorded. Reconciling regularly is how those get found. It’s worth fixing them in your system, because next month’s reconciliation will trip over the same record.

8. Agency and producer codes

If your agency has more than one code with a carrier, or writes some business through a network or cluster, a policy can be paid under a code you aren’t looking at, on a different statement. When a line is truly missing, it’s worth asking whether it was paid somewhere else before asking whether it was paid at all.

A checklist for an unmatched line

1. Normalize the policy number and try again.
2. Check for a new policy number by insured name and line.
3. Check the effective date against the statement period. Too recent? Watch list.
4. Installment plan? Expect a partial amount.
5. Endorsement, cancellation or reinstatement in the policy history? Net them.
6. Fees or taxes in your premium figure? Remove them.
7. New business or renewal? Use the right rate.
8. Another agency or producer code? Check those statements.
9. Still unexplained: raise it with the carrier, with the line, premium, rate and amount.