Agency finance
Commission reconciliation, without the month-end scramble
Why statements eat days, the error classes that cost real money, and what a checked pipeline looks like instead.
Every carrier speaks its own dialect of the same month. Somebody has to translate.
Every month, between the fifth and the fifteenth, a familiar scene plays out in agency finance: dozens of carrier statements arrive, each in its own format, each sure of its own correctness, and one or two people reconcile all of them against the agency management system by hand. When it goes well, nobody notices. When it goes badly, commissions are underpaid, producers are mispaid, and nobody finds out until a producer asks a question nobody can answer.
This guide covers what reconciliation actually involves, where the errors hide, and what a pipeline that checks itself looks like.
What commission reconciliation actually is
Reconciliation is four matches, not one:
- Policy to statement: every transaction on the carrier statement exists in the AMS, with the same policy, the same effective dates, and the same premium.
- Rate to plan: the commission percentage paid matches the schedule for that carrier, line, and producer. The 10 percent that arrived as 8 percent is found here.
- Producer to policy: the split lands on the right producers per the arrangement, round after round, including the overrides.
- Statement to bank: the deposit matches the statement net of returns, and the timing differences are explained rather than plugged.
Why it eats days instead of hours
The work is not conceptually hard. It drowns in format:
- Every carrier issues statements in its own layout: PDFs, CSVs, portals, occasionally paper. There is no standard.
- Rounding, cancellations mid-term, endorsements backdated, and profit-sharing adjustments all arrive unlabeled in the same column.
- The AMS export and the statement almost never group things the same way, so the comparison is manual even when both numbers are right.
- It lands monthly, in a window, on top of the day job. The scramble is structural, not personal.
The error classes that cost real money
- Underpaid commission: wrong rate applied, a tier misread, an endorsement's premium never commissioned. Individually small, collectively a real revenue leak, and invisible unless someone recomputes.
- Dead policies still paying: cancelled mid-term with the return premium never clawed back. The statement looks generous; the books are wrong.
- Producer misattribution: the split paid on the wrong producer code. Small agency, big resentment.
- Unapplied cash: the deposit that never tied to anything, sitting in suspense until someone writes it off or finds it years later.
The consistent finding in agency books: the errors are rarely dramatic. They are small, repeated, and unmeasured, which is exactly why they survive. A checked pipeline does not just save the days. It finds the money.
What a checked pipeline looks like
- Ingest: statements land in one place regardless of format, and the data is read off them, not retyped.
- Normalize: every transaction mapped to policy, producer, and plan in your terms.
- Match: the four matches run automatically, and only the exceptions surface for a human.
- Report: discrepancies ranked by dollars, so the hour goes to the 4,000 dollar gap and not the 4 dollar one.
- Audit trail: every statement, every match, every adjustment, queryable when a producer or carrier asks.
How we fit into this
This is one of the systems we build and run on retainer: the statement pipeline that reconciles itself and escalates only the exceptions. It starts with measurement: what the current process costs in hours and found dollars, before anything is built.
Frequently asked questions
What is commission reconciliation in insurance? +
Matching what carriers say they paid against what your system says they owed, transaction by transaction. It verifies four things: every statement line exists in your AMS, the commission rate matches your schedule, producer splits landed correctly, and the bank deposit ties out. Done well it is monthly and quiet. Done badly it is a quarter-end archaeology project.
Why do carrier commission statements not match my AMS? +
Usually one of four reasons: timing differences on cancellations and endorsements, statements netting out returns your AMS still shows as active, genuinely different commission rates from the plan you assumed, or data-entry drift in the AMS itself. The first two are noise. The last two are money, and you cannot tell which is which without matching the transactions.
How often should commissions be reconciled? +
Monthly, at minimum for agencies with meaningful commercial books. Carrier statements arrive monthly, and unmatched months compound: a January error discovered in April is a negotiation, not a correction. Larger agencies and MGAs with volume concentration often run continuous reconciliation as statements land.
What is commission accounting software for agencies? +
Tools purpose-built for the statement problem: they ingest carrier statements in any format, normalize the transactions, match them against your AMS or general ledger, and surface only the exceptions. The established names cover the enterprise end. The question that decides value is not features but coverage: how many of your carriers are actually supported, because the unsupported ones fall back to manual anyway.
Can reconciliation find money we are owed? +
Yes, and that is the business case. Underpaid commissions, missed tiers, endorsements never commissioned, and return premiums never recovered are recurring findings in unmanaged books. The amounts are individually small and collectively material. A pipeline that recomputes every statement against the plan finds them as a byproduct of the matching it already does.