Glossary · Insurance agency commissions
Commission variance
A commission variance is the difference between the commission an agency expected on a transaction, from its premium and the agreed rate, and the commission the carrier actually paid; it can be a shortfall, an overpayment, a duplicate or a payment with no matching policy.
What it means
Every reconciliation produces variances; the work is deciding which ones matter. A few cents are rounding. A difference of one rate point on a large commercial account is real money. IA Magazine’s What Compensation Administration Means to the Agent-Carrier Relationship puts the problem plainly: “Even when everything is accurate, verifying commissions takes time away from serving clients and writing new business.”
How it works: expected commission is premium times the rate in your commission schedule. Subtract what was paid, line by line, and classify the result: short, over, paid twice, paid on a policy you do not have, or not paid at all (unpaid commission).
How it shows on a commission statement
The statement shows only what was paid. The expected side comes from your records, which is why a variance is only as good as the premiums and rates in your system.
In reconciliation, and what Lapidar does
Lapidar computes the expected commission as book premium times the schedule rate for the carrier, line and new or renewal business, divided by installments where they apply, and classifies each policy as OK, Underpaid, Overpaid, Paid twice, Not in book, Missing or Chargeback. Differences within a tolerance you set, in dollars or as a percentage, count as rounding. Where no rate or premium is available, the line is marked Unchecked rather than guessed.
Example
| Policy | Premium | Expected | Paid | Variance |
|---|---|---|---|---|
| EX-84001 | 2,000.00 | 240.00 | 240.00 | 0.00 |
| EX-84002 | 3,100.00 | 372.00 | 310.00 | −62.00 |
| EX-84003 | 1,250.00 | 150.00 | 149.60 | −0.40 |
| EX-84004 | 900.00 | 108.00 | 216.00 | +108.00 |
EX-84002 was paid at 10% instead of 12%; EX-84003 is rounding; EX-84004 was paid twice. Only the first is money to claim, and the last may be taken back later.
Common mistakes to check
- Chasing rounding differences while a whole missing renewal goes unnoticed.
- Keeping overpayments without noting them; carriers often take them back.
- Calculating the expected side from an out-of-date schedule.
Questions
What is a commission variance?
The difference between the commission you expected on a transaction and what the carrier paid.
What tolerance should I use for commission variances?
That is an agency decision. A small dollar floor catches rounding on small policies; a percentage scales for large ones.
Should I report overpayments to the carrier?
Your agreement may require it, and carriers often find and reverse them later. Record them either way so a later chargeback does not surprise you.
Sources
- IA Magazine, What Compensation Administration Means to the Agent-Carrier Relationship, September 16, 2026. Retrieved October 14, 2026.
Lapidar is commission reconciliation software for independent insurance agencies, in its founding pilot. Related: commission reconciliation.