Home › Case Studies › Sales Commission Plan & Calculator

Sales Commission Plan & Calculator

A compensation plan that drives the behavior leadership says it wants — and a working Excel calculator so reps can self-verify their commission instead of opening tickets with Finance every two weeks. Built for an 8-rep B2B SaaS team.

The problem

A comp plan that read clean on a PDF but unraveled the moment a deal carried a partial-year discount, a multi-year ramp, or a mid-quarter amendment. Reps were spending hours every month reconstructing their own commission. Finance was spending more hours arguing with reps. Sales leadership couldn't answer "is this plan still driving the right deals" because nobody had a clear payout history by deal type.

The approach

Design the plan and the calculator in parallel — if a clause cannot be modeled cleanly, it does not belong in the plan. Tier the accelerators against historical attainment so 70th-percentile reps see a real upside without breaking the comp ratio. Layer in MEDDPICC compliance kickers on Enterprise deals — small payout, big behavioral lever. SPIFs as time-boxed campaigns with explicit start/end and a deal-type filter, not standing programs. The calculator outputs a deal-by-deal payout trace so any rep can see exactly how their number was built.

The outcome

• Time spent reconciling commissions cut from hours per rep per month to minutes.
• A working calculator the team uses as a forecasting tool — reps now model their own quarter against pipeline before commit calls.
• Comp-ratio compliance maintained while introducing accelerators that meaningfully reward overperformance.
• MEDDPICC qualification adoption lifted because the comp plan made it visible — small kicker, large signal.

What I would do differently

Run the calculator against the prior two quarters of closed-won data BEFORE rolling out the plan, with reps in the room. The first version surfaced two edge cases that the model handled correctly but felt unfair to the reps when they saw their own historical numbers re-computed. A retro pass would have caught them before the all-hands.