Field guide
Insurance commission reconciliation, explained.
A plain-English guide for independent P&C agency owners and ops managers: what reconciliation is, why agencies quietly lose commission without it, how to do it step by step, and how to stop doing it by hand.
Every cycle, your carriers pay you commission — across dozens of carriers, in dozens of statement formats. Commission reconciliation is simply the act of checking that what they paid matches what your book of business actually earned.
It sounds clerical. It isn’t. When a carrier underpays, it never looks obviously wrong on any single line — a rate that’s a few points low, a renewal that quietly never paid, a chargeback that never reversed. Caught by eye, these are invisible. Checked against your AMS, they add up to real money you earned and never received.
There are seven recurring ways this happens. The good news: every one of them is catchable with a disciplined process. Here it is.
The 5-step process
- 1
Gather both sides
Pull the carrier's commission statement (PDF or CSV) and your agency management system's commission/production export for the same period. You're going to compare what the carrier paid against what your book says it owes.
- 2
Normalize the data
Carrier statements arrive in dozens of layouts. Get every statement to line-level data — one row per policy, with premium, rate, and commission — so it can be compared to your AMS records at all.
- 3
Match policy by policy
Line up each commission payment with the policy in your AMS that earned it. Unmatched AMS policies (earning but unpaid) and unmatched statement lines (paid but unknown) are both red flags.
- 4
Check the math on every match
For each matched policy, confirm the rate paid equals your contracted schedule and the commission equals rate × premium of record. Flag short-pays, wrong rates, and mid-term changes that weren't trued up.
- 5
Resolve the variances
Group the flagged items into a demand the carrier can act on: the policy, the statement line, your record, and the dollar delta. Send it, track it, and confirm the correction lands on a future statement.
Common questions
What is commission reconciliation?+
It's the process of checking that the commissions a carrier paid you actually match what your book of business earned — catching short-pays, missing renewals, wrong rates, and unreversed chargebacks before they're lost for good.
Why can't I just trust the carrier statement?+
Carrier statements are generated by systems with no view of your AMS. Errors aren't usually fraud — they're rate tables out of sync, renewals dropped, mid-term changes not trued up. Small, scattered, and invisible unless you check every line against your own records.
How often should an agency reconcile?+
Every commission cycle — typically monthly. Reconciling late means short-pays compound across cycles and the window to dispute them with the carrier narrows.
Can my AMS do this for me?+
AMS platforms post commissions; they don't grade your carriers or fight a short-pay on your behalf — the major vendors partner with the same carriers that pay you. Reconciliation that holds the carrier accountable is a separate job.
How long does it take?+
By hand, hours per carrier per cycle — the reason most agencies skip it. Automated, the comparison runs in minutes and you only spend time on the flagged variances.
Skip the by-hand part.
Run the whole 5-step process automatically on your own book. Free first audit, no card to start — your real numbers in about 90 seconds.