Insurance commission reconciliation: a step-by-step process

What commission reconciliation means

Insurance commission reconciliation is the process of matching what you expected to earn against what a carrier reported and paid. It is broader than checking whether the bank deposit looks right. The work happens at the policy-line level, where a missing payment, wrong rate, duplicate, or unexplained chargeback can be identified and documented.

A one-time audit can uncover old problems. Reconciliation turns that check into a repeatable control for every statement period, so new issues are found while the supporting contract and policy records are still easy to retrieve.

Step 1: build the expected-payment record

Start with your own book of business rather than the carrier statement. For each policy, keep the carrier, product, premium or other commission basis, effective date, writing number, and the rate you were promised. Add the carrier's payment schedule and a reasonable lag based on the contract or your established experience.

Rates can differ by contract, product, issue date, renewal year, production level, and hierarchy. Use your executed agreement or current schedule as the authority. Published averages are not a substitute for your contract.

Step 2: preserve and normalize each carrier statement

Save the original file before changing it. Identify the statement period and the columns that represent policy number, insured name, product, premium, paid commission, transaction type, and writing number. When one carrier uses different labels, map those labels to the same internal fields rather than rebuilding your review from scratch.

Normalization should not erase the carrier's original values. Keep both the original statement and the normalized record so every flagged item can be traced back to its source.

Step 3: match, calculate, and classify exceptions

Match statement rows to policies using stable identifiers first. Calculate expected commission from the contract-specific basis and rate, then compare it with the paid amount. Use a documented tolerance for rounding and small carrier adjustments so the exception list stays focused.

• Missing payment: an eligible policy is absent after its expected payment window
• Short payment: the paid amount is below the calculated expectation
• Rate mismatch: the effective paid percentage differs from the saved rate
• Unexpected chargeback: a negative line lacks a known lapse, cancellation, or rewrite
• Duplicate or reversal: repeated entries may overstate or undo a prior payment
• Unmatched line: a payment appears for a policy not yet in your book

Step 4: investigate before you dispute

Not every variance is an underpayment. Check the contract effective date, renewal year, commissionable premium definition, split arrangement, payment lag, and any later adjustment. Document the reason when an exception is valid; that history prevents the same item from being researched again next month.

When the variance remains unexplained, prepare one clear record containing the policy, statement period, premium basis, expected rate, expected amount, paid amount, difference, and the contract evidence supporting your calculation.

Step 5: close the loop and measure recoveries

A reconciliation process is incomplete when it stops at finding errors. Assign each discrepancy a status such as open, sent, carrier reviewing, recovered, or dismissed. Record the carrier's response and connect any adjustment on a later statement to the original issue.

Review this process on a consistent schedule. The useful measures are statements completed, unresolved exceptions, dollars at risk, dollars recovered, and aging by carrier—not a vague claim that the books look close enough.