Split the right thing
Credit split changes attainment. Commission split changes the check. Doing both by accident double-applies the share. Write which one the plan means before the deal is entered.
Edge case
Splits, overlays, and clawbacks.
A split is easy to type as 60/40. It is harder to say whether you split credit, commission, or both, and what happens when the customer refunds after payroll has paid the original total.
Overlay is not another share
An overlay manager is paid on someone else’s credit. That amount is not also one of the rep shares. If the shares plus the overlay exceed the deal, the sheet has counted the deal twice.
Clawback after payroll
A refund does not edit last month’s statement. It is a new negative line that names the original payout, the rep, and the period payroll already closed. A draw works the same way: recovery is its own line, not a quiet change to the old total.
Three rows worth testing.
- One opportunity, two owners, shares that sum to 100% of credit.
- The same opportunity plus an overlay. The overlay uses the credit base you intended, not a share that was already reduced.
- A refund the following month. The clawback names the original row. It does not depend on someone remembering which tab was final.
The complexity checker builds a synthetic matrix for these options. The dollars are a $10,000 example, not a payout.