River
Y CombinatorBacked by Y Combinator

Free template

Sales Compensation Plan Explainer Template

Four documents and six sheets that explain a sales comp plan to reps, run last year's deals through it and answer the hard questions.

Free download · No account needed

What you get

Pack of 10 files: 4 documents, 6 spreadsheets

Sales Compensation Plan Explainer Template
  • A Plan Is What It Pays ForDocument
  • Plan ParametersSpreadsheet
  • Deal Shape EconomicsSpreadsheet
  • Attainment and CliffsSpreadsheet
  • Quota Feasibility by MixSpreadsheet
  • Earnings Scenarios by Deal MixSpreadsheet
  • Plan Change ComparisonSpreadsheet
  • Plan ExplainerDocument
  • Worked ExamplesDocument
  • Plan FAQDocument
RiverSales Compensation Plan Explainer Template

Deal Shape Economics · Ardsley Analytics, FY plan

The plan ranks these two shapes backwards from the company.

ShapePays the rep/hrReturns the company/hrPlan rankCompany rank
Mid-market new logo$93$5723rd6th
Enterprise, ramped 3-year$26$9416th3rd

Mispriced by 5.9x, the same ratio as the two shapes' cost of sale. The plan pays 3.6 times more for a shape that returns 0.61 times as much.

Why: quota retires on year-one value only

A 3-year ramp worth $654,000 contracted retires just its first $118,000 against quota. A rep reading the rate alone never finds this. Reading the hours does.

Page 1 of 1104 words

How to communicate a sales compensation plan

To communicate a sales compensation plan, send each rep the plan and a short explainer before the kickoff, then go through their own numbers with them one-on-one. The explainer says what changed, shows how every payment is calculated, and works through examples built from deals your team actually closed. A good one leads with the change reps will like least and answers hard questions with numbers.

Assume every rep will run last year's deals through the new plan within days. Your explainer should get there first.

Two men in business clothes talk at a café table beside a laptop showing pie charts and a clipboard holding a printed chart
Walk each rep through what their own deals would earn. Photo: Vitaly Gariev on Unsplash

Turn the plan into numbers

From the plan document, list on-target earnings (OTE), the split between base salary and variable pay, and the quota, including what counts toward it. Add any threshold, the accelerator above quota and every bonus. Then work out the base commission rate, even if the plan never states it: variable pay at target divided by quota.

If the plan is changing, put last year's figures in a second column. On-target earnings can rise while the rate falls, if quota grows faster than variable pay. Base salary can fall too when the split shifts toward variable pay, so check the new base against your salary bands.

One plan change, read into numbers

Plan detailLast yearThis year
On-target earnings$225,000$240,000
Base salary$123,750 (55%)$120,000 (50%)
Variable pay at target$101,250 (45%)$120,000 (50%)
Quota (first-year contract value)$900,000$1,200,000
Base commission rate11.25%10%
ThresholdNone60% of quota ($720,000)
Accelerator above quota1.4x (15.75%)1.6x (16%)
New-logo bonus$5,000$3,000

Illustrative figures from this template's made-up company. OTE rose $15,000, yet base salary and the base rate both fell.

Find out what the plan pays for

A plan doesn't only set how much reps earn. It tells them which deals are worth their time. To see what yours says, group last year's closed deals, won and lost, into the six or so kinds your team sells. For a software company, they might be seat expansions, new mid-market customers and multi-year enterprise contracts.

For each kind, work out two numbers per selling hour. The rep's number is win rate times the commission the deal pays, divided by the hours a pursuit takes. The company's number is win rate times total contract value times gross margin, divided by the same hours. Rank both columns and look for the places they disagree.

In the template's example, an hour spent on a new mid-market customer pays the rep $93 and earns the company $572 in gross profit. A three-year enterprise deal that ramps up in price pays $26 and earns $941, because quota counts only its first year. A rep who notices will reasonably favor the mid-market deal. That isn't gaming; it's doing what the plan pays for.

No hours data?

Estimate hours from each deal type's sales cycle, label them as estimates, and have reps check them. Include lost pursuits: 150 hours a pursuit at a one-in-three win rate is 450 hours per win.

Price the cliffs where reps really sit

A threshold paid from the first dollar is a cliff. Below it, bookings earn no commission, and the deal that crosses it unlocks commission on everything booked so far. Modeled at 100% of quota, a cliff looks harmless. Price it instead where a real rep stood last December, with the deals they still had open.

ExampleA December cliff, pricedAn illustrative example written for this guide

On December 19, a rep has $576,000 booked against a $1.2 million quota. The plan pays 10%, but nothing below the $720,000 threshold.

Closing a $38,000 expansion and a $92,000 new customer takes the rep to $706,000. Commission so far: $0.

A third deal, worth $41,000, takes them to $747,000 and pays $74,700, or 182% of that deal's value.

  • All or nothing. Miss any one of the three and the rep stays under $720,000. Whichever signs last unlocks $74,700, 62% of their variable pay at target.
  • If the $41,000 deal slips. The other $130,000 of December bookings earns no commission this year.

Economist Paul Oyer notes that salespeople's pay typically doesn't rise in a straight line with revenue. That gives them reason to manipulate prices, influence the timing of customer purchases and vary effort1 over the fiscal year. His 1998 study found a pattern consistent with that: manufacturers' sales ran higher at the end of the fiscal year, and lower at the start, than in the middle.

Run last year's deals through both plans

Pay each rep's actual closed deals from last year under the old plan and the new one, unchanged. Do it rep by rep, not as a team average, because an average hides the person the change hurts most. Give each row a one-line reason, such as the higher quota or the smaller bonus.

Expect an awkward total. In the example, OTE rose $15,000 a head, yet four reps' unchanged deals pay 31% less: $347,960 instead of $505,915. One rep's deals land under the new threshold, and their pay falls from $91,050 to $9,000.

Then compare two reps on either side of the threshold. In the example, one booked $76,000 more than the other and earned $84,200 more, or 111% of the difference, on a plan that pays 10%. Leave out reps who were still ramping, and set their targets with a 30-60-90 ramp plan.

Settle every ambiguity in writing

Find every sentence that could be read two ways, and decide it before the kickoff. One to check: does the threshold apply to bonuses as well as commission? In the template's example, the answer is worth $9,000 to one rep. Also pin down when a commission is earned (at signing, invoicing or payment), how split deals are credited, and what is paid if a rep leaves.

Some states require a written plan. California's Labor Commissioner explains that Labor Code section 2751 requires commission plans to be in writing2 and to set out how commissions are computed and paid. Each rep must get a signed copy, and the employer must get a signed receipt. The same manual notes that unresolved ambiguities are read against the party who caused them, usually the employer who wrote the plan.

New York's Labor Law requires a commission salesperson's terms to be in writing and signed by both the employer and the salesperson3. The writing must explain how commissions are calculated and what is paid when employment ends, and the employer must keep it for at least three years.

Have a lawyer review the plan

Commission rules differ by state, and a signed plan is a contract. Ask an employment lawyer to review the plan document before rollout. Neither this guide nor the template is legal advice.

Communicate the plan before the kickoff

Brief front-line managers first, so every rep hears the same answers. Send the plan, explainer and FAQ a few days before the kickoff, so the meeting is for questions, not a first read. Afterward, go over each rep's row in the comparison with them, one-on-one.

Build worked examples from real mixes of deals, not attainment percentages, and the FAQ from the questions your analysis raised. Answer each with a number, not reassurance. Name any known flaw in the plan and say what you will do about it.

Cover the paycheck too. In the US, the IRS treats commissions as supplemental wages4. When commissions are paid or listed separately from salary, employers may withhold federal income tax on them at a flat 22%. Tell reps whether your payroll uses that flat rate.

Before the plan goes out

  • The base commission rate is stated for this year and last
  • Each rep's deals from last year are paid under both plans
  • Every threshold is priced at a real December position
  • Each ambiguous sentence has a written answer
  • Each rep has a signed copy, and you hold a signed receipt

Once the plan is live, use a sales commission calculation template to pay each deal by the rules you explained. For a faster start, open this template in River with Edit with AI and send your plan and last year's closed deals.

How to use this template

Use the files as they are, or open them in River with Edit with AI. River asks for this year's plan, last year's if it changed, and a year of closed deals, won and lost, with amounts, terms and close dates. It reads the plan into numbers first. For a new plan, it then prices each kind of deal per selling hour, finds the cliffs and runs last year's deals through both plans.

If the plan isn't changing, River goes straight to worked examples and an FAQ built from the deals your team sells. Either way, it estimates selling hours from sales cycles if you don't track them, and says so. It also lists every sentence that can be read two ways for you to decide, and checks whether the plan is documented the way your state requires.

  1. Download it or open it in River

    Get the four Word documents and six CSV sheets free, or open the template in River with Edit with AI.

  2. Read the plan into numbers

    Fill in Plan Parameters for this year and last, or let River read them from your plan documents.

  3. Price the deals and the cliffs

    Rank each kind of deal per selling hour, and price each threshold where reps really stood last December.

  4. Compare both plans, then explain

    Pay last year's deals under both plans, settle every ambiguous sentence, then send the explainer and FAQ before kickoff.

What's in the template

What the plan pays for, and what happens to last year's bookDeal Shape Economics with both rankings, Quota Feasibility against the hour budget, and Plan Change Comparison run rep by rep.
Sales Compensation Plan Explainer Template
RiverDeal Shape Economics

Deal Shape Economics

Ardsley Analytics, eight account executives, one uniform quota. Gross margin 82%.

ShapeYr-1 ACVHrsWinPays/hrReturns/hrCost of saleVerdict
Seat true-up, existing$24,000988%$235$1,92412.2%Agrees
Inbound expansion$38,0001672%$171$1,40212.2%Agrees
Mid-market new logo$92,0005844%$93$57216.2%Disagrees
Competitive displacement$146,00015238%$44$8984.9%Agrees
Enterprise, flat 3-year$235,00020526%$34$7334.6%Agrees
Enterprise, ramped 3-year$118,00018833%$26$9412.8%Disagrees

The inversion pair. Plan rank 3 against company rank 6, and plan rank 6 against company rank 3. A 5.9x mispricing, which is exactly the ratio of the two cost-of-sale figures, because it is the same arithmetic read from the other side.

Strip the $3,000 new-logo bonus and mid-market pays $70 an hour rather than $93. The bonus is a quarter of what makes that shape attractive, not the rate.

RiverQuota Feasibility

Quota Feasibility by Mix

1,300 selling hours a year. Hours to a full quota, one shape alone, then blended.

ShapeHrs/winHrs/$1,000 retiredHours for a full quotaVerdict
Seat true-up, existing10h0.43h511hFits alone
Inbound expansion22h0.58h702hFits alone
Mid-market new logo132h1.43h1,719hImpossible alone
Enterprise, ramped 3-year570h4.83h5,794hImpossible alone

Blended with seat true-ups as fill: 1 ramped enterprise win costs 570 pursuit hours plus 461 fill hours, 1,031h total, fits. 2 wins cost 1,139 plus 411, 1,550h, over budget.

The quota rations the company's best per-hour shape to exactly one pursuit a rep a year, and it does that through the quota rather than the rate, which is why reading the rate alone never finds it.

RiverPlan Change Comparison

Plan Change Comparison

Last year's real books, unchanged, run through both plans.

RepYr-1 ACVLast yearThis yearChangeWhy
Rivas$986,000$134,795$110,600-17.9%Quota up 33%, rate down, bonus down
Okonkwo$1,276,000$165,470$135,160-18.3%Cleared last year's quota
Brandt$752,000$114,600$93,200-18.7%Six logos at $3,000 not $5,000
Iyer$676,000$91,050$9,000-90.1%Unchanged book lands under the new gate

Four reps, same books: $505,915 becomes $347,960, down 31.2%, while on-target earnings rose $15,000 a head. Both are true. Iyer's book never changed and now lands under a $720,000 gate that did not exist last year.

Brandt against Iyer: $76,000 more ACV is worth $84,200, a marginal rate of 111% against the plan's stated 10%.

  • A Plan Is What It Pays ForHow to price a plan against real deals, worked through on one plan, with four one-line fixes.
  • Plan Parameters sheetBoth years' plans as numbers, including OTE, quota, the base commission rate and what each change does.
  • Deal Shape Economics sheetEach kind of deal ranked by what it pays the rep and earns the company per selling hour.
  • Attainment and Cliffs sheetThe threshold priced one deal at a time from a December position, plus accelerator and bonus checks.
  • Quota Feasibility by Mix sheetHow many selling hours a full quota takes in each kind of deal, alone and blended.
  • Earnings Scenarios by Deal Mix sheetFour reps' deal mixes from last year paid under the new plan, with earnings per selling hour.
  • Plan Change Comparison sheetLast year's deals paid under both plans, rep by rep, with the reason for each change.
  • Plan ExplainerThe note reps read first: what changed, what it does to the rate, and known flaws.
  • Worked ExamplesFour reps' years explained in the kinds of deals they sold, plus the one-slide comparison.
  • Plan FAQThe hard questions answered with numbers, and the open decisions to settle before kickoff.

Common questions

What should a sales compensation plan include?

A sales compensation plan should state on-target earnings and the split between base and variable pay, the quota and what counts toward it, and how commission is calculated. Include any threshold, accelerator and bonus, when commission is earned and paid, how split deals are credited, and what happens if a rep leaves. Put it in writing and get it signed.

How do you communicate a sales compensation plan change to reps?

Lead with the change reps will like least, and show the numbers behind it. Compare last year's base commission rate with this year's, run every rep's actual deals through both plans, and send the explainer and FAQ before the kickoff. If the plan has a flaw you intend to fix, say so before a rep finds it.

What is a base commission rate?

It's the percentage of each dollar booked that a rep earns as commission up to quota, found by dividing variable pay at target by quota. A rep with $120,000 of variable pay and a $1.2 million quota has a 10% base rate. If quota grows faster than variable pay, the rate falls, even when on-target earnings rise.

Do commission plans have to be in writing?

In some US states, yes. California requires a written commission agreement that explains how commissions are computed and paid, with a signed copy for the employee and a signed receipt kept by the employer. New York requires terms signed by both sides, kept for at least three years. Elsewhere it is still wise, and an employment lawyer should review the plan.

Is this sales compensation plan explainer template free?

Yes. Download the four Word documents and six CSV sheets with no signup. They come filled in for a made-up analytics software company with eight account executives, so you can see how each file works before you swap in your own plan. Edit with AI opens the same files in a free River workspace.

What does Edit with AI do?

It opens the template in a free River workspace and asks for your plan, last year's plan if it changed, and a year of closed deals. River reads the plan into numbers, prices each kind of deal per selling hour, runs last year's deals through both plans, then helps draft the explainer and FAQ. Nothing reaches reps until you send it.

Sources

  1. The Quarterly Journal of Economics. “Fiscal Year Ends and Nonlinear Incentive Contracts: The Effect on Business Seasonality.” doi.org (opens in a new tab)

  2. California Labor Commissioner's Office. “The 2002 Update Of The DLSE Enforcement Policies and Interpretations Manual (Revised).” dir.ca.gov (opens in a new tab)

  3. New York State Senate. “Section 191: Frequency of payments.” nysenate.gov (opens in a new tab)

  4. IRS. “Publication 15 (2026), (Circular E), Employer’s Tax Guide.” irs.gov (opens in a new tab)

Written by

Chandler Supple

Co-founder & CEO, River

Chandler has spent the last six years working in AI, building tools for millions of users and Fortune 100 companies. In 2025, he co-founded River to build a new kind of operating system for AI agents.

Reviewed by

Brian Joseff, Co-founder, River