Tracking Commission on Mid-Term Endorsements

If you sort a month's reconciliation variances by cause, the big ones are usually easy to explain. A missing policy. A wrong rate. A cancellation nobody recorded.

The small ones, the $11.40 here and $37.92 there that never quite tie out, are very often endorsements.

Endorsements are mid-term changes to a live policy: adding a driver, removing a vehicle, raising a limit, adding a location. Each one changes the premium for the rest of the term, which changes the commission, and the carrier pays (or takes back) that change on whatever statement cycle it happens to land in. Get the recording wrong and the variance just floats there, too small to chase and too frequent to ignore.

Let's walk through one.

The example

An auto policy. Annual premium $2,400. Your commission rate on this carrier's personal auto is 12%, so the original commission is $288, paid when the policy was written.

With 245 days left in the 365-day term, the insured adds a second vehicle. The carrier rates the new vehicle at $600 a year.

Nobody is going to pay $600 for 245 days of coverage, so the carrier pro-rates:

$600 × 245 ÷ 365 = $402.74 additional premium.

Commission on that, at 12%:

$402.74 × 0.12 = $48.33.

So the endorsement should produce a $48.33 commission line on a future statement. Simple enough.

Now here's where the variances creep in.

Where it goes wrong

The rate isn't what you think. Some carriers pay a different commission rate on endorsement premium than on new business, or a different rate for certain coverages. If your system assumes 12% and the carrier pays 10% on endorsements, you'll be $8.05 off on this one line ($402.74 × 0.02, rounded). Small. Now multiply by every endorsement on every policy with that carrier.

The pro-rata method differs. Most carriers pro-rate by days, but rounding conventions differ. One system might round the daily rate before multiplying, another might round only at the end. That's usually pennies, but pennies are enough to make an exact match fail.

The effective date is off by a day or two. If your AMS has the endorsement effective on the date the request came in, and the carrier made it effective the next day, you're computing on 245 days when the carrier used 244. On this example, that's $1.64 of premium and about 20 cents of commission. Again, small. Again, enough to break a match.

The endorsement shows up in a different month than you expect. You processed it in March. The carrier processed it in March. It shows on the May statement. If you're expecting it in March or April, it looks missing for two months, then looks like an unexpected extra.

Several endorsements net together. Add a car in April, remove a different car in May, and the carrier may show one combined line in June. Your records show two separate transactions.

How to record endorsements so they reconcile

A few habits fix most of this.

Record every endorsement as its own transaction. Don't edit the policy's premium in place and move on. Keep the original premium, then add a dated endorsement record with its own premium change, effective date and expected commission. That way, when a line shows up, there's something specific for it to match against.

Store the carrier's actual endorsement rate. If the carrier pays a different rate on endorsements, record it per carrier (and per line, if it varies by line). Then calculate expected commission using that rate, not the new-business rate.

Use the carrier's effective date. When the endorsement confirmation comes back, check its effective date against what you entered and correct yours if they differ. This is a ten-second habit that removes a whole category of penny variances.

Allow a small tolerance. Decide on a threshold, say a dollar or two per line, under which a difference is auto-accepted and logged as rounding. Too tight and you spend your afternoon chasing pennies. Too loose and real rate errors slip through. Revisit the threshold if you find a pattern hiding inside it.

Match by policy and amount, not by month. Don't assume an endorsement will appear on the next statement. Keep unmatched expected endorsement commissions open for a few cycles, and match incoming endorsement lines against any open expectation for that policy.

Handle combined lines explicitly. If a carrier nets two endorsements into one line, mark both of your records as matched to that one line and confirm the sum. Don't just mark one and leave the other hanging.

A quick check you can run today

Pull every unmatched variance under $50 from your last three months of reconciliation. Sort by carrier, then look at the policy history for each one.

If most of them line up with an endorsement, you've found your leak. And if most of them come from one or two carriers, the cause is probably a rate or method difference specific to those carriers, which means one setting change could clear a large share of them.

It's not glamorous work. But endorsement variances are one of the few reconciliation problems where a bit of up-front discipline pays off on every single statement afterward.