What Is Commission Reconciliation (and Why It Costs You Money to Skip)?
Commission reconciliation is the process of checking every dollar of commission your carrier paid you against what they actually owe. Most agencies skip it. Most agencies leave 2–5% of their commission revenue on the table as a result.
In this guide:
- The short definition
- Why carriers pay wrong amounts
- The 3 common reconciliation errors
- How to actually do it
- How much money is at stake
Time to read: 7 minutes
What is commission reconciliation?
Matching every line on your carrier commission statement against what your agency actually wrote — and catching the mismatches.
Each month, every carrier you work with sends you a statement. Every line is a policy they say they owe you commission on. Reconciliation means:
- Is every policy I wrote actually on the statement?
- Is each commission rate correct?
- Is the commission amount right?
- Is the sale attributed to the right producer?
If any of those are wrong, the carrier has shorted you.
Why do carriers pay wrong amounts?
Nobody's cheating — but errors are very common.
Typical causes of reconciliation errors:
- Data entry mistakes. A carrier employee typed the wrong premium.
- Wrong rate applied. Your contract says 12%, their system applied 10%.
- Missing policy. The sale never made it into their commission run.
- Producer misattribution. They credited the wrong producer (affects your internal split).
- Timing lags. A policy bound in March shows up on May's statement instead of April's.
- Rate tier errors. You qualified for a volume tier but the carrier didn't apply it.
Individual errors are small — often $10–$50 per error. But they add up to thousands of dollars a year for most agencies.
What are the 3 common reconciliation errors?
Error 1 — Missing policies
You wrote a policy, the carrier didn't pay you for it.
Easy to catch if you reconcile monthly. Nearly impossible to catch 6 months later because the carrier's dispute window has closed.
Error 2 — Wrong commission rate
Your contract says one rate, the carrier applied a different one.
Happens especially around tier transitions ("you hit $500K in volume, now your rate goes up from 10% to 12%") that the carrier forgets to apply automatically.
Error 3 — Wrong producer credit
The sale landed on the wrong producer or got credited to "house" when it should have gone to a specific producer.
Doesn't cost the agency anything (commission amount is the same), but it wrecks your internal commission split because the wrong producer sees the sale.
How much money is on the table?
Industry studies and our own analysis point to 2–5% of gross commission being "lost" to unreconciled errors.
| Your annual gross commission | Typical leakage |
|---|---|
| $500,000 | $10,000–$25,000/yr |
| $1,000,000 | $20,000–$50,000/yr |
| $2,500,000 | $50,000–$125,000/yr |
| $5,000,000 | $100,000–$250,000/yr |
That's money sitting on carrier servers that they'd pay you — if you asked.
Reality check. If you've never reconciled, you are leaving real money on the table. Not theoretical. Actual dollars.
How do you do reconciliation (the manual way)?
The process when you do it in Excel:
Step 1 — Export your commission statement
Download the monthly statement from each carrier. CSV if available, PDF if not.
Step 2 — Pull your sales log for the same period
From your agency management system, pull every policy written that should have been paid on.
Step 3 — Match them up
Line by line. Policy number, customer name, producer, premium, commission.
Step 4 — Flag mismatches
- On the statement but not in your sales log → figure out why (could be delayed sale)
- In your sales log but not on the statement → carrier didn't pay you
- On both but different amounts → rate or math error
Step 5 — Submit disputes
For every flagged error, use the carrier's dispute process. Usually an email, a form, or a phone call.
Step 6 — Track resolution
Don't assume fixes happened. Check next month's statement for corrections.
Time cost of doing this manually. 4–8 hours per carrier per month. With 5–10 carriers, that's 20–80 hours a month — essentially a part-time employee.
How does reconciliation software help?
Software matches every line automatically.
The process shrinks from 4–8 hours per carrier to 5–10 minutes of reviewing flagged mismatches.
What good reconciliation software does:
- Parses carrier statements (including PDFs)
- Matches each line against your sales log
- Uses fuzzy matching on producer names and customer names
- Flags the mismatches for you to investigate
- Tracks disputes through resolution
- Shows you a running "recovered" total over time
AgencyIQ does basic reconciliation today. Deeper reconciliation depth is on our roadmap — for now, tools like Mivation lead in that specific lane.
Why do most agencies skip reconciliation?
Three reasons:
Reason 1 — They don't know the scale of the loss
"It's probably a few hundred dollars" — nope, it's usually tens of thousands. Agencies that start reconciling for the first time are shocked by the recovery in the first year.
Reason 2 — They think it's too hard
Doing it manually in Excel is indeed hard. Doing it with software is 10 minutes a month.
Reason 3 — They assume carriers pay correctly
They don't — not because carriers are dishonest, but because carrier systems are old and error rates compound at scale. Even 1% error rate × 12 months × multiple carriers adds up fast.
Frequently Asked Questions
How often should I reconcile?
Monthly. As soon as each carrier's statement comes in. Delaying means disputes fall outside the carrier's window (usually 60–90 days).
What if a carrier refuses to pay a dispute?
Document everything. Escalate internally. If that fails, the state's department of insurance handles carrier-agent commission disputes. Most carriers resolve before escalation.
Do captive carriers (State Farm, Allstate) need reconciliation too?
Yes. The math is different (MOD points, bonuses, etc.) but captive agents get statements that can have errors.
Can I reconcile old statements from last year?
Probably not for disputes — carrier windows have usually closed. But reconciling historical data tells you whether there's a pattern worth fixing going forward.
Is reconciliation the same as commission "audit"?
Similar terms. Reconciliation is ongoing, monthly. Audit usually means a deeper retrospective review — often done once a year or when you switch carriers.
Stop leaving commission dollars on carriers' servers
AgencyIQ is free during beta for Founding Members. Match carrier statements against your sales log and catch the errors that have been costing you for years.
Founding Members get grandfathered pricing when we launch paid tiers later this year.
Last updated: 2026-04-18