Who Reconciles the Commissions a Carrier Download Misses?

At most Seattle agencies the monthly commission reconciliation has one owner: an accounting lead or operations manager who checks that every carrier paid the right commission on the right policy. Carrier commission download can post the clean lines for you, but it does not close the file. The person still owns the exceptions — the payments that have not posted yet, the short payments, the chargebacks on cancellations, and the policies that never showed up on the statement at all. This article maps what the download handles, what it leaves, and a way to split the work so software does the matching and a person decides the judgment calls.

The reader this is written for runs a commercial lines book, places business with a dozen or more carriers on direct bill, and wants fewer hours rekeying statements without pretending the numbers reconcile themselves. Workers' compensation is handled differently in Washington, which changes what belongs on the statement in the first place; that is covered below.

What a carrier commission download actually delivers

A commission download moves a carrier's direct-bill commission statement into your agency management system as data, so you reconcile against an electronic record instead of a PDF. EMPLOYERS, for example, states that it “delivers EMPLOYERS’ commission statements directly into your agency management system via IVANS regular policy download,” calls the feed Direct Bill Commission Statements, and processes it once a month on the fourth (EMPLOYERS IVANS download FAQ). IVANS, which runs the exchange many carriers use, markets commission download as a way to reconcile direct-bill commissions rather than enter them by hand (IVANS commission download). Those are the vendors' own descriptions of what the feed is meant to do, not a tested result.

See where commission reconciliation fits in an insurance agency's back office.

Two conditions decide whether download helps a given statement. First, the carrier has to offer it and you have to be set up to receive it: EMPLOYERS notes that commission download is supported only for certified agency management systems and that you need an IVANS account and mailbox configured before anything arrives. Second, the policy has to carry a paid commission that cycle. Carriers that bill direct but do not publish a commission download, and every agency-bill account you handle, stay outside the feed.

Where the download stops and a person starts

The exceptions are the real work, and most of them are judgment calls a feed cannot make. A short list a reconciler meets every month:

• Nothing paid yet. If the insured has not paid the carrier, no commission is due that cycle. EMPLOYERS is explicit that when the current paid commission premium is zero, that earned-commission line is removed from the file, so those have to be reconciled by hand.
• Short or over payments. A line can arrive at a different rate than your agreement. The download posts the number it was sent; a person decides whether to query the carrier.
• Chargebacks. A mid-term cancellation reverses commission already paid. Someone has to confirm the cancellation and claw back the producer's share before payroll.
• Missing policies. A policy you bound can be absent from the statement — downloaded under a different agency code, or not yet processed. Absence is not zero; it is a question.
• Carriers with no download. PDF statements, carrier-portal exports, and spreadsheets still have to be read in. This is where document extraction can assist, but a person checks the result.
• Splits and producer payouts. Allocating a commission across producers, and paying it, sits in your accounting system, not the carrier's feed.

A month of one carrier's statement, reconciled

The figures below are a labeled hypothetical, not a client's book, used to show the arithmetic of a reconciliation. One direct-bill carrier, five policies, a 15% standard commission except where noted.

The statement nets $600 + $150 − $450 = $300 paid this cycle (the two absent policies contribute nothing). Download could match the first and fourth lines automatically. Everything else — a $30 rate query, a $450 chargeback to verify, a $960 payment on hold, and a $450 policy missing from the feed — is a person's queue. That queue, not the paid total, is what decides whether the month actually reconciled.

What Washington adds to the record

Two Washington facts shape this work. First, the records are not optional. Every insurance producer must keep an organized record of each insurance contract procured, including the insurers, insureds, and premium, and must record anyone they promise or pay commissions to, kept open to the Insurance Commissioner's inspection for five years after the transaction is completed, with life and disability insurance excepted (RCW 48.17.470). A reconciliation that lives only in a producer's inbox does not meet that; the audit trail — statement, expected amount, variance, and who resolved it — belongs in your system of record.

Second, workers' compensation changes what even belongs on a commission statement. Washington administers its own workers' compensation benefits through L&I's State Fund, which covers about 75% of the state's workers, and through self-insured employers, who cover about 25%; L&I's overview describes no private-carrier market for the coverage (L&I workers' compensation fundamentals). For a Seattle agency that means the workers' compensation policy itself does not appear on a carrier commission statement, because that coverage comes from L&I rather than a commissioned private policy. An agency moving from a private-market state should not expect those lines, and should not flag their absence as missing commission.

What to automate, and what to keep with a person

This split is a method we propose for sorting the monthly file, not a product and not a guaranteed saving. Decide it per carrier.

The honest first step is not software. It is counting how many of your carriers already offer download and how many statements still arrive as PDFs, because that ratio decides whether the win is a download setup or an extraction project — and whether either is worth it against the hours you spend today. If most of your premium already downloads, the reconciliation problem is the exception queue, and that stays a person's job.

If you want to see where that reconciliation connects to the rest of an agency's back office, our insurance operations overview lays out the systems involved.