Eight carrier statement formats, translated (so your bookkeeper stops guessing)

Pull ten commission statements from ten different carriers and you'll get ten different definitions of the word "premium." I've reconciled statements for a nine-figure agency's book for six years now, and I still get surprised at least once a quarter by a format I thought I understood.

The problem isn't that carriers are hiding money from you on purpose. It's that every statement was designed by a different systems team, at a different point in that carrier's history, with zero coordination with anyone in agency operations. The result is eight recognizable formats, and if your bookkeeper doesn't know which one they're looking at, they will book the wrong number. I've seen it happen. It cost one agency I consulted for about $14,000 in unreconciled chargebacks over four months because someone assumed every statement worked like the last carrier's.

The eight shapes you'll actually see

| Format | What it calls itself | Where the chargeback hides | Column to verify before you trust it | |---|---|---|---| | Single-Line Roll-Up | "Net Commission Due" | Folded into the current month's net, no separate line | The whole thing. It's one number pretending to be simple. | | Two-Column Split | Written vs. Earned Premium | Shows as a negative in the Earned column weeks after cancellation | Earned Premium, always | | Batch-by-Effective-Date | Statement Period | Grouped by effective date, not statement date, so chargebacks lag 60 to 90 days | Effective Date column, not statement date | | Direct Bill Detail Dump | Transaction Detail | Buried under an adjustment code, usually a two-digit number nobody's defined for you | Adjustment Code column | | Agency Bill Summary | Account Summary | Netted directly against new business production so growth looks flat | Total Written vs. Total Net | | Prior-Period Adjustment (PPA) Tab | PPA Detail | Isolated on its own tab, which means it's easy to never open | The PPA tab itself, every month, not just at audit time | | Reinstatement Trap | Reinstatement Credit | A reinstated policy posts as new business credit, masking the chargeback that hit two months earlier | Policy effective date vs. transaction date | | Portal-Only, No File | (nothing, there's no downloadable statement) | Negative commission with no policy number until you click through three screens | Every line, because there's no file to reconcile against |

Where the chargebacks actually hide

Three of these eight formats are designed, whether the carrier admits it or not, to make chargebacks harder to spot than new business. The Agency Bill Summary is the worst offender. If a carrier nets chargebacks against your new business production in the same summary line, your month can look flat when you actually wrote $40,000 in new premium and ate $38,000 in chargebacks from three lapsed accounts. You will not know that unless you pull the detail.

The Reinstatement Trap is sneakier because it's not hiding anything, technically. It's just presenting a correction as if it were fresh production. I watched a producer get a bonus calculation wrong for two consecutive quarters because reinstatement credits were counted as new business in his comp report. Nobody caught it because the number looked good.

And the Portal-Only carriers deserve their own circle of frustration. If your carrier doesn't give you a downloadable file, you are reconciling by hand every month, or you're not reconciling at all. I'd guess a third of small agencies fall into the second camp. I don't know the real number, and neither do most agency owners I've asked, which is itself the problem.

The one column you never trust

Here's my opinion, and I'll stand behind it: never trust "Net Commission Due" as a standalone number, on any carrier, in any format, ever. Not because carriers are dishonest. Because that column is a sum, and sums hide the two things you actually need to see, which are what changed and why.

The fix isn't complicated, it's just tedious. Tie every statement's net figure back to policy-level detail before it goes in your books. If a carrier gives you 40 line items, look at 40 line items. If they give you one number, call and ask for the detail, and keep asking until they send it. Some carriers will tell you the detail "isn't available in that format." That's not a systems limitation, that's a carrier deciding your reconciliation isn't their problem.

Agencies under $5M in premium usually skip this because nobody has the hours. Agencies over $15M usually have a person whose entire job is this reconciliation, and that person will tell you the same thing I'm telling you: the summary number is a starting point, never an ending point.

What to do about it

Build a one-page cheat sheet for every carrier you write, noting their format type and exactly which column hides chargebacks, and hand it to whoever touches your books before the next statement lands.