Direct Bill Commission Reconciliation: Start With One Carrier and the Agency Agreement

Why commission statements drift from the agency agreement

None of the causes below require anyone to be careless. They follow from how commission is calculated and paid:

• Different rates by transaction. New business and renewal commission can differ, some lines or programs carry their own rate, and an amendment to the agency agreement may change a rate on a date the carrier’s system and the AMS do not both reflect.
• Endorsements and audits. A midterm endorsement or a premium audit changes the premium, so it changes the commission. Because they arrive one at a time, these lines are easy to leave off a statement or pay at the wrong rate.
• Payment on installments. When a carrier pays commission as each installment is collected, a single policy produces many statement lines, and a missed installment line is hard to spot by eye.
• Cancellations and chargebacks. A midterm cancellation returns unearned commission to the carrier. A chargeback with no matching cancellation, or one calculated on the wrong date, is money taken back in error.
• Renewals that never paid. A policy that renewed in the AMS but never appears on a statement is a missing line, not a wrong one, and a line-by-line review of the statement alone will never find it.
• Rewrites and new policy numbers. A policy rewritten under a new number can fall between two matching keys and pay as new business, or not pay at all.

On a public trade forum in 2009, a poster from an agency of almost $5 million in revenue described not reconciling direct-bill statements for years and then having “to write off a significant difference,” six figures by the post’s own account. After it started reconciling, the same post listed a carrier paying the wrong inland marine rate under the agency contract and another paying nothing on homeowners. One agency’s experience is not a rate; it is a picture of the mechanism.

The one-carrier method, transaction by transaction

Start with one carrier, ideally the one with the largest direct-bill commission, and its last three statements. The steps:

• Write down the commission schedule from the agency agreement and every amendment: rate by line, new versus renewal, any program or contingent terms kept separate.
• Export the AMS transactions for the same period: new business, renewals, endorsements, audits, cancellations and reinstatements, each with policy number, transaction effective date and premium.
• Compute expected commission per transaction: premium times the scheduled rate, and the pro rata return on each cancellation.
• Match each statement line to an AMS transaction by policy number, transaction type and effective date, then compare paid with expected.
• Sort everything into four buckets: matched at the right rate; paid at the wrong rate; in the AMS with no statement line; on the statement with no AMS transaction.
• Give every exception an owner, the date it was raised with the carrier, and the date and amount it was resolved.

Illustrative example: one carrier’s quarter produces 300 statement lines and 310 AMS transactions. Twelve lines are paid two points short on a line of business whose schedule changed in an amendment, and ten renewals in the AMS have no statement line at all. On a $10,000 premium, two points is $200; the ten missing renewals are each a full renewal commission. The arithmetic is plain once the expected column exists; without it, none of these show up.

Chargebacks, cancellations and unearned commission

A chargeback is the carrier recovering commission on premium it no longer earns, because the policy canceled midterm or the premium went down. The agency agreement says how unearned commission is calculated and when it is taken back. The check is narrow: every chargeback on the statement should match a cancellation or premium reduction in the AMS, with the same effective date and an amount that follows from the schedule.

Two patterns deserve a second look. A chargeback on a policy that was reinstated: the reinstatement should put the commission back, and someone should confirm that it did. And a chargeback dated earlier than the cancellation in the AMS, which returns more commission than the policy’s actual cancellation date supports.

Chargebacks also show where the agency found out about a lost policy late. A nonpay cancellation that first appears as a chargeback is a policy that sat on a pending-cancel report with nobody working it. The renewal and cancellation side of that story is in the article on why an agency’s book of business shrinks quietly.

Producer pay is the internal half. If producers are paid on commission received, decide in writing what happens to a producer’s split when a chargeback arrives months later, so the answer is the same for every producer and every policy.

Records, time limits and who owns the short pays

Two documents set the limits. The agency agreement may say how long the agency has to dispute a commission statement; read that clause before deciding how far back to reconcile. And state law sets how long agency records must be kept. Florida, as one example, treats premiums an agency receives as trust funds held “in a fiduciary capacity” and requires a licensee to keep records pertaining to a premium payment “for at least 3 years after payment” (Fla. Stat. 626.561(1)–(2)). Other states set their own rules. Confirm the agency’s retention period with its attorney and accountant; this is not legal advice.

Ownership matters more than the tool. One named person reconciles each carrier on a fixed day after the statement arrives, and keeps one log: carrier, statement date, policy, transaction type, expected, paid, difference, date raised, date resolved. The principal reads the open items monthly. A short pay with no owner and no date stays a short pay.

When matching every line is not worth it

Full reconciliation of every carrier is real work, and it is a fair choice not to do it everywhere. In the same 2009 forum thread, another agency described taking what its carriers paid, keeping an eye out for obvious problems, and moving carriers back off a reconciliation workflow because it consumed too many hours. That can be a sound decision when it is made on purpose, carrier by carrier.

A practical split: full reconciliation for the carriers that pay the largest share of direct-bill commission and for any carrier where an exception has turned up; a quarterly spot check of ten endorsement, audit and renewal transactions for the rest. A carrier that passes several spot checks in a row earns a lighter look. Where a carrier pays commission per installment, asking it to pay on the full premium, if the agency has the volume to ask, cuts the line count before any reconciliation starts.

Outside help is not worth buying if the exception log already exists, the expected column is built from the agency agreements, and the open items get closed. It earns its fee when nobody can say what the agency should have been paid last quarter, or when the AMS, the statements and the bank do not agree and no one owns the difference. The Revenue Review takes two weeks: read-only access to the AMS and the commission statements, read against the agency agreements, and a written report that prices each finding, with a 90-day plan. Lumina is not an insurance agency and is not an accounting firm; it gives no tax, licensing or E&O advice. A free 20-minute call is enough to tell whether the Review fits.