How to Reconcile Insurance Commission Statements

Why reconciliation matters

A commission statement tells you what a carrier says it paid. It does not tell you whether that is what you were owed. Policies that should have paid but didn't, chargebacks you didn't expect, and rate or percentage changes only surface when you compare the statement against your own records. Producers also depend on the result: their payouts come from the same numbers.

Step 1: Collect every statement and every deposit

List each carrier you expect to hear from in the period, then mark off the statements that actually arrived. Statements come in many formats: PDF, spreadsheet, CSV, portal downloads and email attachments. Also collect the matching deposits from your bank. A missing statement is the first thing to chase, and an unexplained deposit is the second.

Step 2: Normalize the data

Get each statement into the same columns: carrier, policy number, insured, transaction type, premium, commission rate, commission amount and period. If you are doing this by hand, the retyping is where errors creep in. This is the step statement parsing automates, which is why commission tracking software pays for itself quickly.

Step 3: Match every line to a policy

Each commission line should land on a real policy in your system. Lines that don't match are the exceptions to investigate: a policy number that was changed at renewal, an insured name entered in a different order, or business that was never added to your system. The mismatch list is often the most valuable output of the whole process.

Step 4: Separate the transaction types

New business, renewals, endorsements, cancellations and adjustments behave differently. Group them so you can see, for example, that a negative line is a chargeback on a cancellation rather than an error. Note whether the policy is agency-billed or direct-billed, because direct-billed and agency-billed policies can pay commissions on different schedules.

Step 5: Check the rate against what you expect

For a sample of lines per carrier, compare the commission percentage on the statement with your contract or schedule. Carriers occasionally change rates or apply a different rate to a class of business. Catching this early is much easier than discovering it at year end.

Step 6: Look for what's missing

This is the step spreadsheets are worst at. Compare your in-force policies against the lines on the statement and ask which policies you expected to see but didn't. A new policy that has been in force for weeks with no commission line is a prompt to call the carrier.

Step 7: Apply producer splits

Once lines match policies, apply each producer's split according to your rules: new versus renewal, by line of business, by producer level, or by a shared house account. Write the rules down and apply them the same way every period. A producer who can see how their number was calculated is far less likely to dispute it.

Step 8: Tie out to the deposit

The sum of your reconciled lines for a carrier should equal what the carrier deposited, within a known explanation. If it doesn't, the difference is a list of reasons you can name: a chargeback, a timing item, an unmatched line, or a statement you haven't received. "Unknown" should not be a category.

Step 9: Keep an exceptions log

Record each exception, who is chasing it and when it was resolved. Over several months you will see which carriers or lines generate the most exceptions, which tells you where to focus your follow-up.

Doing it inside your agency system

Commissions live closest to the truth when they sit next to your clients and policies, because matching and splits become lookups instead of retyping. DarkHorse AMS parses carrier statements, calculates producer splits and shows what is missing; see the overview in what's inside the AMS. If you are choosing a system, put commission handling on your evaluation list from our nine questions, and if you are changing systems, carry at least one full cycle of history across, as described in our switching checklist.

How to reconcile insurance commission statements, step by step