How to Find Missing or Underpaid Insurance Commissions

First, make sure the payment is actually due

Before calling a carrier, confirm the policy was issued, the effective date, the applicable commission schedule, and the payment cycle. Some carriers pay after premium collection, and others process corrections in a later statement. An expectation without a documented basis is a hypothesis, not a receivable. Keep the schedule version and source of the expected amount alongside the policy record. That way, when a payment looks late, you can distinguish an actual missed payment from an incorrect calendar assumption.

Build a clean expected-versus-paid comparison

Export your agency book of business or expected commission ledger and the carrier's commission statement. Preserve the originals. Compare carrier, policy number, transaction type, statement period, and amount. Avoid matching only on insured name: names change and can repeat. A rewritten policy can have a new number, while one policy can generate several transactions. Normalize formatting carefully, but never delete meaningful leading zeros or combine records without reviewing them.

Use a variance table instead of a vague total

An aggregate total can conceal individual shortages. Consider the illustrative examples below: one policy is short, another is fully paid, and a third is absent from the carrier statement. A policy-level exception queue shows what needs investigation. Keep expected amount, actual amount, variance, last carrier response, and next follow-up date together. Your future self will appreciate the context when the issue survives another month.

Look for the five common explanations

Check for delayed payment cycles, endorsements that changed premium, cancellations and chargebacks, policy-number rewrites, and incorrect commission assumptions. A carrier may also split an adjustment across statement periods. These are possible explanations, not excuses to accept every discrepancy. Confirm the transaction against the actual statement notes and applicable schedule before closing the exception.

Document the carrier inquiry

Send the carrier a concise request containing policy number, insured reference, transaction dates, expected amount, paid amount, statement period, and supporting documentation. Ask for the specific reason for the difference and when any correction will appear. Avoid sharing unnecessary personal information over insecure channels. Save the reply and assign a follow-up date. A tracked inquiry is much harder to lose than a message buried in somebody's inbox.

Do not mistake an overpayment for free money

An unexpected positive commission entry deserves the same scrutiny as a shortage. It might be a prior-period correction, a duplicate, or a valid endorsement. If you distribute it prematurely, a later reversal can create producer payout problems. Record unexpected payments as exceptions until you understand their source. Reconciliation is about accuracy, not merely finding money that appears to be missing.

Make the process repeatable

Schedule a monthly review tied to each carrier's statement cadence. Assign ownership of open exceptions, sort by age and materiality, and carry unresolved items forward. Keep an audit trail of original records, calculations, communications, and resolutions. The process should survive staff vacations and handoffs. If it only works when one person remembers which spreadsheet tab to open, the agency has a fragile system.

When software helps

A dedicated reconciliation tool can import supported files, compare expected and reported commissions, and surface unmatched or inconsistent records for review. It cannot independently prove every carrier rule or resolve a dispute. Use automation to shorten the search, then apply judgment to the exceptions. Test your own carrier files and verify the outputs before relying on any platform for financial decisions.

An escalation process that doesn't depend on memory

When an inquiry remains unresolved, assign a review date and define what happens next. Start with the carrier's commission support channel and the evidence you already collected. If the response contradicts the applicable schedule, request the calculation or adjustment detail rather than repeating the same question. For material or persistent issues, follow your agency's escalation and contractual dispute procedures. Track the date, contact, response, and promised correction period. A well-documented issue can be transferred to another staff member without restarting the investigation.

A simple monthly control checklist

At the start of each cycle, verify that every expected carrier statement arrived and that imports contain plausible transaction counts and totals. Review the highest-value unmatched items, then the oldest open exceptions. Sample a few apparently matched entries to catch incorrect matches. Compare the statement-level total to the carrier's reported remittance, and reconcile deposits separately when appropriate. Finally, archive source files and record what changed since the previous review. This sequence prevents a neat dashboard from hiding incomplete inputs.

Frequently asked questions

Related guides

Read our commission reconciliation guide and step-by-step carrier statement walkthrough.