Commission is three numbers, and they have to agree

Commission

Expected is what the carrier should pay, worked out from the policy and the commission agreement the moment the business is written. Received is what the carrier actually paid, read off its own statement. Payable is what you owe the producer who wrote it. All three are rows in one ledger from one calculation engine, so a variance is a row somebody can work — not a difference between two reports.

Three ledgers, one table

323 expected, 135 received and 380 payable entries, each naming its policy, its carrier and the period it belongs to.

Expected against received

The agreed rate, what it should have produced and what came in — every expected entry, with the shortfall as its own column.

Commission receivable, aged by carrier

Current, 31 to 60, 61 to 90 and over 90 days, carrier by carrier — so "who is slow" is a measurement, not an impression.

What you owe your producers

Each payable names the expected entry it came out of, its production credit and its pay rate, and whether it is recognised on accrual or when the money is in.