Why carrier commission statements stop matching after an acquisition

Abe Harbid, 25 October 2026

On direct-bill business the carrier bills the client and pays the agency its commission on a statement, one layout per carrier. Commission reconciliation is matching each line on those statements to the commission the policy should have paid. Inside one agency, that works because the staff know the book. After the agency is acquired, the same statements arrive, and they stop lining up with the platform’s records.

The five usual causes

1. Policy numbers no longer match

The carrier prints the policy number its own way. The acquired agency’s export may store it with a prefix, without one, or with a line-of-business suffix. Once the book is mapped into the platform’s format, a statement line has to be matched to a policy that now looks different.

Check: normalize policy numbers the same way on both sides before matching, and list every statement line that still finds no policy.

2. Carrier codes differ

Each agency has its own code for each carrier. The platform has another. Until the two are mapped, a statement cannot even be assigned to the right carrier in the platform’s numbers.

Check: map every carrier code in the agency’s export to the platform’s list, and flag codes with no match along with the premium they cover.

3. The rate on the statement is not the rate in the book

The commission rate in the agency’s book may be out of date, or the carrier may be paying a different rate than agreed. The statement then pays an amount nobody expected.

Check: compute expected commission as the book’s premium times the book’s rate, compare it with what was paid, and show both rates when they differ.

4. The premium changed

Endorsements and audits change premium mid-term. The carrier pays on the new premium; the book may still hold the old one.

Check: when paid and expected differ but the rates agree, compare the statement’s premium with the book’s and say which one moved.

5. The policy is not in the book at all

A line arrives for a policy number the agency’s export does not contain: business written after the export was taken, or a record that never made it across.

Check: keep these lines on their own list. Each is money arriving for business the platform’s book does not show.

Producers make it worse

Commission matched to the wrong policy is also credited to the wrong producer. Producer codes from the old agency often have no match on the platform’s roster, and some policies carry no producer at all. Fixing the match before producer pay is calculated avoids paying, and then unwinding, the wrong person.

What a working process looks like

1. Convert the agency’s client, policy and producer exports into the platform’s format, with carrier and producer codes mapped.
2. Read each carrier’s statement in its own layout.
3. Match every line to a policy, compute expected commission, and flag every line outside a small rounding tolerance with the reason.
4. Total each statement: lines, paid, expected, net variance and lines needing a person.
5. Re-run on the next month’s statements and on corrected exports, keeping every decision already made.

That is what the acquisition-onboarding engine does. The demo runs it on a fictional platform with three fictional acquired agencies, including a carrier paying a lower rate than the agency’s book: the engine shows both numbers. Commission reconciliation · Watch the demo