Carrier statement commission reconciliation

What is carrier statement reconciliation?

Every month each insurer sends a statement showing the policies it billed or paid commission on and the amounts involved. Carrier statement reconciliation is comparing that statement against what your broker management system expected on the same policies, then investigating and clearing every difference.

It is the control that keeps commission income, commission receivable, and premiums payable honest. It is also, in most brokerages, the single largest task in month-end close, because the line volume is high and the dollars per line are low. That combination is why it slips: no individual line is ever worth chasing, and the aggregate is worth a great deal.

What the reconciliation proves depends on the billing type:

• Direct bill. The insurer collected the premium and pays you commission by statement. Reconciliation confirms the carrier paid the commission you earned, and clears the commission receivable.
• Agency bill. You invoiced and collected the premium and owe the insurer the net. Reconciliation confirms the premium payable you owe and ties it back to your trust position.

If the difference between those two flows is not yet second nature, start with agency bill vs direct bill accounting and come back.

Direct-bill reconciliation: did the carrier pay what we earned?

Direct-bill reconciliation answers one question, and it is a collections question dressed up as an accounting one.

• Match each statement line to the policy in your system by policy number, not by client name.
• Compare the commission paid to the commission expected at the booked rate.
• Flag missing policies, rate mismatches, cancellations, and endorsements.
• Clear the commission receivable for what was paid. Carry forward and age what was not.

The per-policy amounts are small and the volume is high, so underpayments are close to invisible without a systematic match. Unreconciled direct bill is how brokerages quietly lose commission they actually earned, and the loss is permanent once the carrier’s own query window closes.

Worked example: one direct-bill statement

The figures below are illustrative only. They show the shape of a month’s differences on a mid-sized personal lines statement.

Policy	Premium	Rate booked	Commission expected	Commission paid	Difference	Cause
HO-448120	$1,860	15%	$279.00	$279.00	$0.00	Agrees
AU-771905	$2,240	12%	$268.80	$224.00	$(44.80)	Paid at 10%, rate error
HO-449002	$1,420	15%	$213.00	$0.00	$(213.00)	Not on statement
AU-770118	$3,105	12%	$372.60	$372.60	$0.00	Agrees
HO-441776	$980	15%	$147.00	$(147.00)	$(294.00)	Cancelled flat, clawback
Totals			$1,280.40	$728.60	$(551.80)

Three differences, three different actions:

• The rate error on AU-771905 is a carrier query. Send it with the policy number, the booked rate, and the paid amount. Rate errors repeat, so check whether the same rate was applied to every auto policy on the statement.
• The missing policy HO-449002 is a timing item or a carrier omission. If it bound on the 29th it will appear next month, so age it and re-test. If it does not appear next month, query it.
• The flat cancellation on HO-441776 is a brokerage correction. The clawback is legitimate. The problem is that the system still expected $147, which means the cancellation was never processed on your side. Fix the policy record so next month’s expectation is right.

Only the first of those three is money the carrier owes you. The discipline is deciding which bucket each difference belongs in before you touch a number.

Agency-bill reconciliation: is what we owe correct?

On agency bill you already have the client’s money. Reconciliation confirms what leaves.

• Match the insurer’s statement to the agency-bill items in your system.
• Confirm the premium payable for each policy, net of your commission.
• Resolve differences from endorsements, cancellations, instalments, and timing.
• Tie the resulting payable back to the trust position so cash covers the liability.

The failure mode here is the mirror image of direct bill. On direct bill you lose money you were owed. On agency bill you remit money you did not owe, or fail to remit money you did, and either one shows up in the trust position rather than in income.

A short illustrative version of an agency-bill line: gross premium $8,400, commission at 12.5% is $1,050, so the payable is $7,350. If the client took a mid-term endorsement adding $600 of premium and the endorsement posted in your system but not on the carrier’s statement, the statement shows $7,350 and your system shows $7,875. That is a timing difference, not an error, and it must be documented as one rather than forced to agree.

The premiums payable schedule and aged balances

Agency-bill reconciliation should produce an aged premiums payable schedule: what you owe each carrier, by age. It is both a control and a cash-flow tool. Old items on that schedule almost always signal a specific problem:

• A policy that cancelled but was never reversed.
• A remittance applied to the wrong carrier, which shows as two carriers off by equal and opposite amounts.
• A statement difference that was queried once and then forgotten.
• A carrier account set up twice under slightly different names.

The same discipline applies to the commission receivable on the direct-bill side, where aged balances point to unpaid or short-paid statements. Age both schedules in the same buckets, current, 31 to 60, 61 to 90, and over 90, so a principal can read the two side by side. Anything over 90 days on either schedule should have a name, a date, and a next action beside it.

Contingent and profit-sharing commissions sit outside this monthly cycle and follow their own timing. See contingent commission accounting for how to treat those.

Handling disputes with carriers

Not every difference is your error. Carriers misstate rates, omit policies, double-count cancellations, and re-issue corrected statements after you have closed the month. A workable process:

1. Log the difference with the policy number, the expected amount, the statement amount, the variance, and the suspected cause.
2. Classify it as a brokerage correction or a carrier query. Do not send a query until you have confirmed your own record is right, or you will lose credibility with the carrier’s accounting team.
3. Raise carrier queries promptly, within the close cycle, before the trail goes cold and before the carrier’s own correction window closes.
4. Track the query to resolution. Date raised, contact, response, date cleared. A query with no owner is a write-off waiting to happen.
5. Do not write off receivables or release payables until the item is resolved or aged out under a documented policy with an approval threshold.

Batch queries by carrier rather than sending them one at a time. One monthly email with ten lines gets worked. Ten emails get filtered.

Commission recognition and producer splits

Reconciliation feeds revenue recognition. Commission is generally recognized when it is earned, meaning the policy is bound and effective and the brokerage has substantially performed, rather than when cash lands. The exact timing depends on your accounting framework, so confirm it with your CPA, particularly for instalment business, premium-financed business, and direct bill where the carrier reports on its own cycle.

Reconciliation also drives producer compensation. The brokerage recognizes the full commission as income and records each producer’s share as commission expense or payable in the same period as the underlying commission, based on the agreed split.

The rule that saves the most money: calculate splits from reconciled amounts, not expected ones. Paying a producer 40% of expected commission on a policy the carrier never paid means chasing the producer for a clawback months later, which is unpleasant and often unsuccessful. If your split run happens before the reconciliation is finished, you have the order backwards. See producer commission split accounting for the mechanics.

Reconciling in Applied Epic

Applied Epic includes direct-bill reconciliation and carrier statement matching that compare statement amounts to the expected amounts on the policies. Used consistently, it keeps commission receivable, premiums payable, and commission income tied to source. The system surfaces the differences. A person still has to resolve them.

What makes it work in practice:

• Booked commission rates must be right on the policy. Epic’s expectation is only as good as the rate stored on the line. A stale rate produces a difference every month, forever, on the same policy.
• Match on policy number. Client-name matching breaks on renewals, name changes, and multi-policy accounts.
• Process cancellations and endorsements before you reconcile, not after. Reconciling against a stale policy record generates differences that are your own doing.
• Use the reconciliation to post, rather than posting a journal entry for the net cash and reconciling separately. If the cash posts outside the reconciliation, the receivable never clears cleanly.
• Close the reconciliation each month. An open reconciliation carried across periods stops being a control.

Step-by-step Epic detail lives in reconcile direct bill in Applied Epic, and the surrounding close sequence in Applied Epic month-end close.

Common failure modes and how to fix them

Failure mode	What you see	Fix
Reconciliation deferred when the month is busy	Two or three carriers unreconciled, then six	Fix the close calendar and reconcile the largest carriers first, always
Posting the net cash and skipping the match	Commission receivable grows every month	Post through the reconciliation so the receivable clears line by line
Stale commission rates on policies	The same policies differ every single month	Correct the rate on the policy, not on the reconciliation
Differences written off to a suspense account	A suspense balance nobody can explain	Ban suspense for carrier differences; age the item instead
Splits paid on expected commission	Producer clawbacks and disputes	Run splits after reconciliation closes
No aging on premiums payable	You cannot say what is owed to each carrier today	Produce the aged schedule as an output of the reconciliation
Carrier set up twice	Payables split across two accounts, neither one right	Merge the carrier records and re-point open items

Monthly reconciliation checklist

• Close calendar published, with a date each carrier statement is due to be worked
• Cancellations and endorsements processed before matching starts
• Every carrier statement matched line by line, largest carriers first
• Differences logged with policy, expected amount, statement amount, and cause
• Differences classified as brokerage correction or carrier query
• Carrier queries batched and sent within the close cycle
• Commission receivable aged, with over-90-day items named and owned
• Premiums payable aged by carrier and tied to the general ledger
• Premiums payable agreed to the trust liability schedule
• Commission income posted from reconciled amounts
• Producer splits run only after the reconciliation closes
• Reconciliation reviewed by someone other than the preparer

What BrokerLedger does with carrier statements

We run carrier statement reconciliation and commission income accounting inside Applied Epic every month: matching statements line by line, classifying and chasing carrier differences, aging premiums payable and commission receivable, and posting commission income and producer splits from reconciled figures. Where a brokerage is several months behind, we work the largest carriers backwards first, because that is where the unrecovered commission concentrates. The whole cycle sits inside our month-end close service.