Tracking Cancelled-and-Rewritten Policies Without Losing the Commission

Of all the transactions that pass through an agency's books, the cancel and rewrite is the one that causes the most trouble for its size.

It looks simple from the client's side. Their policy got replaced with a better one, maybe a new program, maybe a different company within the same carrier group, maybe just a fix to something that couldn't be endorsed. One policy ends, another starts, coverage continues.

From the accounting side, though, it's two separate events that happen to be related. One policy is cancelled, which triggers a return of unearned commission. A new policy is written, which triggers new commission. They often land on different statements, sometimes in different months, and they almost always carry different policy numbers.

If nobody connects them, three bad things can happen: the agency eats a chargeback it should have offset, the producer gets clawed back and never repaid, or the producer gets paid twice.

Walk through one

Let's use a hypothetical commercial package policy.

The original policy has an annual premium of $5,000 and pays 15% commission, so $750, which the carrier paid up front.

Ninety days into the term, it's cancelled and rewritten. That leaves 275 days of unearned premium on the original:

$5,000 × 275 ÷ 365 = $3,767.12 returned to the insured (or applied to the new policy).

The carrier takes back 15% of that:

$3,767.12 × 0.15 = $565.07 in return commission.

The rewrite is a fresh 12-month policy at $4,600, also at 15%:

$4,600 × 0.15 = $690 in new commission.

Now add a producer who's paid 40% of agency commission:

• On the original, they were paid 40% of $750, which is $300.
• On the cancellation, the agency recovers 40% of $565.07, which is $226.03.
• On the rewrite, they're owed 40% of $690, which is $276.

Each of those numbers is easy. The hard part is making sure all three get recorded, against the right people, and that nobody can look at only one of them and draw the wrong conclusion.

Why it goes wrong

The cancel and rewrite usually arrive separately. The cancellation might hit the statement this month, the rewrite next month. In between, the person reconciling sees a $565.07 negative line on a policy that's now cancelled, and a producer whose pay is about to drop.

If they process the cancellation by itself, the producer sees a $226.03 deduction with no explanation. If the rewrite then gets recorded under a different producer code (because someone else in the office processed it, or because the new policy number didn't inherit the original's producer), the original producer never sees the $276.

Or it goes the other direction. The rewrite is recorded with the right producer, but the cancellation never gets processed against producer pay, and the producer is effectively paid on $750 plus $690 for one account.

Neither is anyone being dishonest. It's just that two related transactions got handled as unrelated ones.

Chain them together

The fix is to treat cancel-rewrite as a single event with two halves, and to make the link explicit in your records.

1. When the rewrite is issued, record the relationship immediately. On the new policy, store the prior policy number. On the old policy, store the replacement policy number and a cancellation reason of "rewritten" rather than a generic cancel.

2. Carry the producer over. The rewrite should inherit the original producer (and any split) by default. If the producer should change, that should be an explicit decision, not an accident of who keyed the new policy.

3. Hold the cancellation's producer adjustment until both halves are in. When the return commission line arrives, check for a linked rewrite. If there is one and its commission hasn't arrived yet, park the producer adjustment instead of deducting it right away. When both are in, process them together and show the producer the net.

4. Reconcile the pair, not just the lines. Each line still reconciles against its own policy. But also check the pair: return commission plus new commission should make sense given the premiums and dates. If the return looks too large, or the new commission never shows up, that's a carrier inquiry.

5. Give the pair a shared reference. A note, a tag, a shared ID field, whatever your system supports. When someone searches for either policy, they should find the other.

The audit trail you'll want later

Clawback disputes tend to come up at bad moments: when a producer leaves, or when a large account cancels and a producer insists the account was rewritten elsewhere in the agency.

The records that settle those disputes quickly are the boring ones:

• The cancellation date, the cancellation reason, and who recorded it.
• The rewrite's policy number, effective date and producer.
• The return commission and the new commission, each tied to the statement they came from.
• The producer adjustments that resulted, dated, with the calculation visible.

If you can pull that up in a couple of minutes, the conversation stays short. If you're reconstructing it from statements and memory, it doesn't.

Producer agreements matter here too. Whether a rewrite offsets a clawback, whether it counts as new business or renewal for comp purposes, whether a small clawback is waived: those are policy decisions for your agency, and they should be written into the agreement. Treatment of these items can also have accounting or tax consequences, so if you're unsure how to book them, ask your CPA.

A monthly habit

Once a month, pull every policy cancelled with a reason of "rewritten" and confirm each one has a linked replacement policy with commission recorded. Then pull every new policy with a prior policy number and confirm the prior policy's cancellation is recorded.

Anything that fails either check is a loose end. Better to find it in October than when a producer asks about it in March.