Rep commission model

Monthly commission earned totals back to the 30 cases

The monthly grid did not drop, duplicate or misfile a case.

Every case's commission re-derived from revenue, rate, accelerator and split

The earned column is rebuilt from its four ingredients in one pass. A number typed over any case's commission — the most common way a commission file goes wrong — shows up here.

Every case carries the plan rate for its product line

Rates re-counted straight off the Inputs table, line by line. A rate edited on the Commission sheet instead of on Inputs is caught.

Liability roll-forward agrees with the case detail, every month

Opening plus earned less paid equals closing — and closing also equals the same number rebuilt from the 30 cases by a different route. One of those alone proves nothing.

The invoice basis eventually captures every case

The invoice-date bucketing is a timing difference and nothing else. If these disagree, the model has lost a case rather than merely booked it late.

Cash collected plus still outstanding equals everything invoiced

Nothing collected twice and nothing lost. The collections grid closes against the case log.

The blended rate collects the same money, just in different months

The blended book closes against the case log too: what it has collected plus what it still expects is every dollar invoiced. The two methods differ only in WHICH month the money lands — which is the whole argument against a blended rate.

The running totals behind the headline step by exactly each month's figure

The two cumulative rows that produce the March liability figure are re-walked month by month: each step must equal that month's earned (or booked) commission. A typed-over running total is caught in the month it was typed.

Every case matched a plan rate and a hospital DSO

A product line or a hospital name typed differently from the Inputs table would look up to nothing and quietly earn zero commission. This counts those.

Credited cases reverse at the clawback rate

A credited case gives the commission back at whatever rate the plan says — and follows the input if that rate is changed, rather than assuming 100%.

The accelerator is on for every case past the threshold, and off for every case before it

Every case is re-tested against the threshold. Catches the classic off-by-one (an accelerator wired to the row above, paying the bonus a case early) and the quieter one: a multiplier typed back to 1 on a case that had earned it.