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…
Where AgencyView fits
Keep reading
Share: Facebook · LinkedIn · X · Email
All articles · AgencyView