Insurance Commission Reconciliation Checklist
A four-point checklist for catching missing, stopped-paying, and clawed-back insurance commissions before they cost your agency money.
A commission statement only tells you what a carrier actually paid. It never tells you what it forgot. A reconciliation checklist closes that gap: it is a repeatable way to compare what you expected to be paid against what showed up, so a stopped payment, a never-started one, or a quiet clawback doesn't sit unnoticed in a spreadsheet for three months.
Most agencies find their first missing commission by accident — a client mentions the policy is still active, or a renewal report looks thin. By the time someone notices, the carrier's window to correct the error without a fight has often narrowed. A short, monthly reconciliation routine catches the same problem in weeks instead of quarters.
What Commission Reconciliation Actually Checks
Reconciliation is the process of matching two lists: the policies and clients you expect to be paid on, and the payments that actually landed. Anything on one list and not the other is worth a look. In practice, almost every gap an agency finds falls into one of four categories, and checking for all four — not just skimming the statement total — is what separates a real reconciliation process from a quick glance.
Before You Start: Build Your Own Expected List
You cannot catch a missing payment against a list you don't have. Before opening a single carrier statement, pull together what you expect to be paid on:
- Every active policy, with its carrier, commission rate, and premium.
- The month each policy is due to pay — first-year, renewal, or as-earned, depending on the carrier's own schedule (see how carriers actually pay commissions for the difference between advance and as-earned timing).
- Anything already flagged as a chargeback risk from a lapse, free-look cancellation, or non-payment in the last 90 days.
This list is your baseline. Without it, a statement with a missing line item just looks like a statement — there's nothing to compare it against.
The Four-Point Reconciliation Checklist
1. Chargebacks and clawbacks
Scan every negative line on the statement first. A chargeback usually means a policy lapsed, was cancelled in a free-look period, or the client stopped paying premium — and it's often the one line item agents skip because it's easy to read a statement only for what it paid, not what it took back. Match each chargeback to a specific policy and confirm the reason matches your own records. If the reason doesn't match — the carrier's system shows a lapse but the client insists they're still paying — that's worth a call before the recovery period closes. For how to keep chargebacks from happening in the first place, see preventing chargebacks in the first 90 days.
2. Never-paid policies
Cross-reference every active policy against the statement. A policy that issued and is still active but has never once appeared on a commission statement is a never-paid case — not a delay, a gap. Give a policy one grace period past its expected first-pay month before flagging it (carriers occasionally run a cycle behind on genuinely new business), but if a second cycle passes with the same policy still absent, it needs a call to the carrier's commission department, not another wait-and-see month.
3. Stopped-paying (lapsed-in-place) policies
This is the one manual reconciliation misses most often, because the policy already showed up correctly in past months — there's nothing new to notice. Pull last month's paid list and this month's paid list side by side. Any policy that was on the first and not the second, with no chargeback explaining why, is a stopped-paying policy: still active on your side, invisible on the carrier's. This can mean a processing error on the carrier's end, a billing lapse the client hasn't mentioned yet, or a policy that moved to a different servicing agent without your knowledge.
4. Clients paid on but missing from your CRM
Run the reconciliation the other direction too. If a name on the commission statement doesn't match anyone in your CRM, you're either being paid on a client you haven't entered yet, or the statement has a data-entry error worth flagging to the carrier. Either way, an unmatched name sitting on a statement is money your agency can't currently attribute to a book of business, a household, or a renewal date — which means it can't be planned around.
What To Do When You Find a Gap
- Document it immediately. Note the policy number, client, carrier, expected amount, and the statement date where it should have appeared. A gap without a paper trail is much harder to argue six months later.
- Check your own house first. Confirm the policy is actually in force, the commission rate on file is current, and the effective date matches what you have. A surprising number of "missing" commissions turn out to be a rate or date that changed on your end and was never updated.
- Contact the carrier's commission or licensing department, not general support. General support routes commission questions slowly. Ask specifically for the commission or accounting team and reference the policy number and statement date.
- Set a follow-up reminder. Carrier commission departments are slow by default, not maliciously — but a ticket without a follow-up date tends to sit. Two weeks is a reasonable first check-back.
- Re-run the reconciliation the following month to confirm the correction actually landed, rather than assuming a promised fix appeared.
How Often to Reconcile
Match your reconciliation cadence to your statement cadence — most carriers pay monthly, so a monthly reconciliation catches a gap within one cycle of it appearing. Waiting for a quarterly or annual review to reconcile means a stopped-paying policy can run three to twelve months before anyone notices, by which point the resolution conversation with the carrier is much harder.
Where This Breaks Down Without a System
The checklist above works with nothing more than a spreadsheet and a carrier statement PDF. It also gets slower and less reliable every month a growing book adds more policies to check by hand. The reconciliation is only as good as how consistently someone actually runs it, and consistency is exactly what falls apart first when AEP or OEP hits and the same staff are pulled onto enrollments.
AgencyView's commission tracking runs this same four-point check automatically. Every night, it mirrors your commission records through its ComTrack partnership and matches each payment to a client in your CRM — then raises an alert the moment a client stops being paid on, a policy has never been paid on, a chargeback lands, or a paid client can't be matched to anyone in your CRM. Instead of running the checklist by hand once a month, the alert is already sitting on the client's record before you open the CRM. For agencies who want the P&L view across the whole book on top of that — retention, receivables, carrier concentration, chargeback exposure — the CFO Center builds more than twenty reports from the same matched data. See the full picture at AgencyView's insurance commission tracking software.
FAQ
How long should I keep records if I find a missing commission?
Keep the documentation — policy number, expected amount, statement dates, and every carrier communication — for as long as your agency's own record retention policy requires, and at minimum until the correction is confirmed on a later statement. A resolved gap with no paper trail is difficult to reopen if the same policy has a problem again later.
Is a missing commission the same thing as a chargeback?
No. A chargeback is a carrier actively reversing a payment it already made, usually because a policy lapsed or was cancelled in a free-look period. A missing commission is a payment that should have started or continued and simply never showed up on a statement. Both need to be caught, but they're found by checking different things: chargebacks show up as negative lines, missing commissions show up as absences.
How much of a book typically has a reconciliation gap in a given month?
This varies too widely by carrier, product mix, and agency size to state a reliable number, which is exactly why a monthly check matters more than a benchmark — the point isn't comparing your gap rate to anyone else's, it's making sure your own gaps get caught every cycle instead of accumulating.
Do I need special software to reconcile commissions?
No. The four-point checklist above works with a spreadsheet, your CRM's policy list, and the carrier's own statement. Software mainly buys back the time a growing book takes to check by hand and catches gaps the same day a statement lands instead of whenever someone gets to it.
Who should reconcile commissions — the agent or the agency?
Independent agents with their own book should reconcile their own statements; agencies with multiple producers typically centralize it with one person or system so the same four checks run consistently across every agent's book, rather than depending on each agent remembering to do it.
Where AgencyView fits
Keep reading
- What a Commission Tracker Needs to Connect To
- CRM for Life Insurance Agents: A Buyer's Checklist
- Google Business Profile for Insurance Agencies: Checklist