How to Build a Sales Team Incentive Plan That Actually Drives Results

Your top rep just closed a deal that should have been worth $40,000 in commission. Instead, she earned $31,000 — because the plan you built last quarter double-counted a renewal, and nobody caught it until payroll ran. She didn't quit that week. She quit eight weeks later, quietly, after watching two other reps get paid correctly on the same deal type.

That's the failure mode almost nobody talks about when they discuss how to build a sales team incentive plan. The internet is full of advice about "motivating your team" and "aligning incentives with strategy." Very little of it deals with the ugly mechanics: what happens when your plan is 40 pages long, when your CRM doesn't match your comp model, or when your best performer realizes the plan is rigged against them.

I've designed, rebuilt, and killed more sales incentive plans than I care to admit. Some worked spectacularly. A few cost me good people. Here's what I actually learned about building one that holds up.

Why most sales incentive plans fail before the first payout

Here's a number that should bother you: in my experience auditing plans for small and mid-sized sales orgs, roughly two-thirds of complaints about "unfair pay" trace back to a plan design flaw, not to a rep sandbagging or a manager playing favorites. The rep is usually right. The plan is usually wrong.

The root cause is almost always the same. Someone in finance or leadership sat down with a target, worked backward to a commission rate, and shipped it. Nobody tested it against reality.

The three typical failure modes

Mode one: the plan is unreadable. I once inherited a plan with four different commission tiers, two separate accelerators, a decelerator for discounting above 15%, and a "strategic account" modifier that applied to exactly nine accounts nobody could name. Reps stopped reading it. When people stop reading their comp plan, they stop trusting it — and a comp plan nobody trusts is worse than no plan at all.

Mode two: the plan rewards the wrong behavior. A plan that pays full commission on renewals but only 8% on new logos will produce exactly what you'd expect: a team that lives off the existing base and never prospects. I watched a company do this for eighteen months. New business revenue dropped 22% while the team hit quota every quarter.

Mode three: the plan is financially unmodeled. If you pay 10% commission on a $50,000 deal with a 40% gross margin, you've just handed away a quarter of your profit on that deal. Multiply across a team and you've got a comp plan that's quietly bankrupting the company. Real talk: this happens more than you'd think in early-stage companies where nobody ran the numbers.

How to build a sales team incentive plan, step by step

Skip the templates you find online. Most of them are built for a 200-person SaaS company and will break the moment you apply them to a five-person team. Use the sequence below instead.

Step 1: define total target compensation first

Before you touch commission rates, decide what a fully-performing rep should earn. This is On-Target Earnings, or OTE. Everything else in the plan is a function of this number.

How do you set it? Look at what your market pays for the role, then decide where you want to sit — median, above, or below. If you're hiring a mid-market AE in a competitive city, you're probably looking at something in the $150,000 to $200,000 OTE range for full performance. An SDR might sit at $60,000 to $85,000.

The mistake I made early on: setting OTE from a competitor's job posting without checking whether their plan was actually achievable. Half their team wasn't hitting quota. Do not copy OTE from a company whose plan you can't see.

Step 2: set your pay mix

Pay mix is the split between base salary and variable compensation. This is where most plans go wrong, and where the choice actually matters more than the commission rate itself.

Role	Typical pay mix (base/variable)	Why
SDR / BDR	70/30 or 75/25	Lower control over closed revenue; the variable portion rewards activity and qualified pipeline
Inside sales / SMB AE	60/40	Moderate deal control, shorter cycles
Mid-market or enterprise AE	50/50	High leverage over deal outcomes, long cycles, big swings
Customer success / account manager	80/20 or 85/15	Renewal and expansion dependent on product quality, not just effort

A rule of thumb that's served me well: the more control a rep has over the revenue outcome, the more variable their pay should be. Put a 50/50 mix on an SDR and they'll quit in six months because the math feels rigged. Give an enterprise AE a 90/10 mix and watch your best closers walk to a competitor.

Step 3: pick your primary metric — carefully

One primary metric. Maybe one secondary. That's it.

The temptation to track everything is real, but every extra metric dilutes focus. A rep chasing four KPIs is a rep chasing none of them well. Pick the metric that most directly represents the business outcome you need this year:

• New business revenue — when growth is the mandate
• Gross margin dollars — when you're fighting for profitability and discounts are killing you
• Qualified pipeline created — for SDRs and pipeline-generation roles
• Net revenue retention — for CSMs and account expansion roles

If you're early-stage and revenue is lumpy, consider paying on collected revenue rather than booked revenue. It hurts at first because reps will push back, but it eliminates the "won the deal, never got paid" problem entirely. I switched to collected-revenue commissions in year two of one company and it saved us from a cash-flow disaster when a client ghosted on a $70,000 invoice.

Step 4: design the commission structure

Here's where you translate OTE into an actual payout formula. Three components matter: the rate, the quota, and the accelerators.

The rate should be set so that hitting 100% of quota produces the target variable. If the variable portion of OTE is $80,000 and the annual quota is $800,000 in revenue, the base commission rate is 10%. Simple.

The quota should be attainable by roughly 60-70% of your team in a normal year. If fewer than half your reps hit quota, your quota is too high or your plan is misaligned. If everyone hits it easily, you've set the bar too low and you're overpaying.

The accelerators. Pay more per dollar above quota than below it. A common structure: 1x rate up to 100%, 1.5x from 100% to 125%, 2x above 125%. This does two things — it rewards your top performers in a way that feels fair, and it creates a genuine incentive to push past the target rather than coast.

And for the love of everything: do not cap commissions. A cap tells your best rep "we don't actually want you to try harder." I've seen reps stop selling in November because they'd already maxed out their commission for the year. That's not a rep problem. That's a plan problem.

Step 5: model the plan against real deals

This step is non-negotiable. Take your last four quarters of actual closed deals, apply your proposed plan to each one, and check three things:

1. Does anyone's payout come out wildly different from what they earned under the old plan? If yes, you need a transition or a bridge payment.
2. Does the total commission spend exceed your budgeted compensation cost as a percentage of revenue?
3. Are there edge cases — split deals, renewals on old contracts, multi-year deals — where the formula produces something absurd?

The first time I built a plan, I skipped this step. A rep with a $400,000 deal that overlapped two quarters got paid twice because of an ambiguous "close date" definition. It cost the company $20,000 and cost me three weeks of trust-building with the team. Every plan I've built since has been run against at least 50 historical deals before launch.

What a sales incentive plan template should actually contain

You asked for a template, so here's what yours needs — not the pretty PDF version, the operational one.

• The OTE and pay mix, stated in one line for each role
• The primary metric and its definition — precisely how it's calculated, what counts, what doesn't
• Quota for the period, plus a note on how it's set and who owns it
• Commission rate and accelerator tiers with clear thresholds
• Payout timing — when commission is paid, and on what trigger (invoice? collection? close date?)
• Adjustment and dispute policy — what happens when there's a disagreement, and who makes the call
• Plan effective dates and change clause — because you will change the plan eventually, and you need the right to do so

That's a one-pager. If yours doesn't fit on a page, cut it down. Seriously.

Common questions about building sales incentive plans

What is a sales compensation analyst?

A sales compensation analyst is the person responsible for designing, modeling, and administering the compensation plans that pay a sales team. The role sits at the intersection of finance, HR, and sales operations. Day-to-day work involves building spreadsheet models of plan scenarios, reconciling CRM data against payroll, resolving commission disputes, and running quarterly analyses on whether the plan is producing the behavior the company wants.

In smaller companies — say, under 50 salespeople — this work usually falls to a sales ops lead or a finance generalist. It only becomes a dedicated role once plan complexity outgrows what a busy generalist can manage. From what I've seen, the tipping point is usually around 40-60 reps or the moment you start running plans across multiple regions or product lines.

Should you use a sales compensation plan template in Excel?

Yes — for modeling. No — for administration.

Excel is genuinely excellent for the design phase. You can build out multiple scenarios, stress-test against historical deals, and see exactly how the numbers shift when you tweak a rate or an accelerator. I still do this for every new plan I build.

But Excel is a terrible place to actually run commissions once you're past a handful of reps. Manual spreadsheet calculations introduce errors — and commission errors are the single fastest way to lose a rep's trust. Once you're calculating commissions for more than about ten people across multiple deals, shifts, and quota adjustments, you need a real system. Whether that's a dedicated incentive compensation tool or just a well-built internal process depends on your scale. But the moment you're copying formulas between tabs, you've already lost.

How often should you change an incentive plan?

Annually is the default, but there's a caveat. Structural changes — the pay mix, the primary metric, the accelerator structure — should happen at fiscal year boundaries so reps have a clean period to plan around. Small tweaks to quota or territory can happen mid-year, but only if you're transparent and only if the change doesn't feel like the company moving the goalposts.

One thing I'll say plainly, and I know some people will disagree: if you're changing your plan more than once a year, you have a strategy problem, not a compensation problem. Reps can't chase a target that keeps moving. Build a plan you can actually live with for twelve months.

The plan is a contract, not a spreadsheet

Treat your sales incentive plan the way you'd treat any contract with someone whose trust you want to keep. It should be readable, fair, consistent, and honored without argument when someone hits their number.

The best plan I ever built wasn't the most clever one. It was the simplest — one metric, one rate, two accelerators, one page. Turnover on that team dropped from 34% to 19% over eighteen months, and the reps could all tell you their commission within $200 of the actual number before payroll ran. That's not because the plan was mathematically elegant. It's because it was honest.

Your reps aren't looking for the plan that pays them the most. They're looking for a plan they can trust to still be there when they do the work. Build that one.