A sales commission plan defines how sales representatives are rewarded, which results qualify for commission, and what conditions must be met before payment. A good plan should do more than encourage revenue growth: it should reward profitable, collectible sales while protecting the business’s cash flow.
In this guide, you’ll learn how to calculate a commission budget, compare three sales commission models, and establish rules for discounts, collections, subscriptions, and refunds. You’ll also find a free Excel commission calculator and PDF operating guide to help implement and review your plan.
Table of Contents
- What a Sales Commission Plan Should Achieve
- Step 1: Calculate Your Commission Pool
- Commission Pool Examples
- Step 2: Choose a Commission Model
- Step 3: Set Commission Rules
- Step 4: Implement the Plan
- KPIs and Payment Checklist
- Download Excel and PDF Guide
- Frequently Asked Questions
What Should a Good Sales Commission Plan Achieve?
An effective commission structure should encourage the sales behavior that benefits the business without making incentive payments financially unsustainable.
- Drive profitable sales: Encourage transactions that contribute to the company’s gross profit rather than revenue alone.
- Protect cash flow: Define how collections, credit sales, and unpaid invoices affect commission eligibility.
- Reward meaningful performance: Connect compensation to realistic targets and measurable results.
- Make calculations transparent: Ensure salespeople and managers understand how commissions are calculated.
- Control the total payout: Compare commission costs against a financial ceiling before authorizing payment.
Why Revenue, Margin, and Cash Flow Must Be Considered Together
A business can report strong revenue growth while earning less profit. This may happen when sales teams offer excessive discounts, sell low-margin products, or close transactions that remain unpaid.
For example, a commission based exclusively on revenue may reward a salesperson for increasing sales volume even when the transaction contributes very little profit after product and operating costs.
The solution is not necessarily to eliminate revenue-based commissions. It is to combine the selected commission model with appropriate margin, collection, and payment controls.
To monitor these results alongside broader commercial performance, see our Sales KPIs guide, which covers target attainment, sales growth, channel contribution, and sales representative performance.
Step 1: Calculate Your Commission Pool
Before setting commission rates, determine how much the business can allocate to commissions while protecting its operating costs and target profit.
The commission pool is the financial amount available for commission payments under the assumptions of your business plan.
Commission Pool Formula
Gross Profit = Net Sales − Cost of Goods Sold (COGS)
Available Commission Pool = Gross Profit − Additional Variable Costs − Allocated Fixed Costs − Target Profit
In this calculation, net sales exclude sales taxes. Additional variable costs may include payment processing fees, variable shipping charges, and packaging costs. Avoid counting the same cost twice.
The target profit is the minimum planned profit the company wants to preserve before allocating money to commissions.
Important: The available pool is a budget limit, not an automatic commission payment. It does not determine what an individual salesperson has earned under the applicable compensation agreement.
Available Pool vs. Payable Pool
When a business sells on credit or operates subscription services, it may need additional controls before releasing commission payments.
The accompanying Excel workbook uses optional period-level factors:
Payable Pool = Available Pool × Collected Percentage × Eligible Subscription Percentage
Both factors range from 0% to 100%. When an optional factor does not apply, the workbook treats a blank value as 100%.
This adjustment establishes a payment ceiling. Individual transaction eligibility and collection controls are assessed separately in the sales log.
The final control compares the total calculated commissions against this payable pool. If the total exceeds the ceiling, the plan must be reviewed before payment.
Commission Pool Examples for Different Businesses
These examples illustrate how operating costs and collection conditions can affect the amount available for commissions. Figures are hypothetical monetary units, so the same principles can be applied in different markets.
Example 1: Retail Store
A physical retail store receives immediate payment for most transactions but has substantial rent and payroll expenses.
| Item | Amount |
|---|---|
| Net sales | 100,000 |
| COGS | 65,000 |
| Additional variable costs | 3,000 |
| Allocated fixed costs | 25,000 |
| Target profit | 2,000 |
| Available commission pool | 5,000 |
The store generates 35,000 in gross profit. After covering its additional costs and target profit, it has a maximum commission pool of 5,000 under these assumptions.
Example 2: Ecommerce Business
An online store may have a higher product margin but also significant payment processing, packaging, fulfillment, and shipping costs.
| Item | Amount |
|---|---|
| Net sales | 100,000 |
| COGS | 60,000 |
| Additional variable costs | 12,000 |
| Allocated fixed costs | 20,000 |
| Target profit | 3,000 |
| Available commission pool | 5,000 |
Despite earning a higher gross profit than the retail store, the ecommerce business has the same available commission pool because its additional variable costs are greater.
Example 3: B2B Sales on Credit
Consider a B2B supplier with the following results:
| Item | Amount |
|---|---|
| Net sales | 100,000 |
| COGS | 70,000 |
| Additional variable costs | 4,000 |
| Allocated fixed costs | 18,000 |
| Target profit | 2,000 |
| Available commission pool | 6,000 |
Suppose the company has collected only 80% of the relevant sales during the payment period.
Payable Pool = 6,000 × 80% = 4,800
The business has an available pool of 6,000 but a payable ceiling of 4,800 after applying its collection control.
This reduces the risk of making commission payments before the corresponding sales have been collected. However, any deferral or adjustment must follow the applicable employment contracts, commission policy, and local law.
Example 4: SaaS and Subscription Businesses
Subscription businesses face another challenge: a customer may subscribe and then cancel before completing the minimum retention period required by the commission policy.
Suppose a subscription business generates 8,000 in gross profit from new monthly revenue, with additional variable costs of 500, allocated fixed costs of 5,000, and target profit of 1,000.
Available Commission Pool = 8,000 − 500 − 5,000 − 1,000 = 1,500
The company may define an eligibility condition such as remaining active for 30, 60, or 90 days. The selected retention period is part of the company’s policy, not a period automatically imposed by the Excel workbook.
Critical rule: For subscription transactions subject to a minimum retention requirement, the Active after X days field must be confirmed as Yes or No. If eligibility cannot be confirmed, do not mark the transaction as eligible for payment.
The workbook does not calculate subscription dates or connect to a billing platform. The business must verify eligibility against its CRM, billing system, or subscription records.
Step 2: Choose the Right Sales Commission Model
There is no single commission model that works for every company. The best approach depends on pricing flexibility, product margins, payment terms, growth targets, and the quality of your financial data.
| Model | Commission basis | Best suited for | Main control |
|---|---|---|---|
| 1. Sales-based with margin protection | Commissionable net sales | Businesses with relatively stable margins | Minimum gross-margin threshold |
| 2. Gross profit-based | Gross profit on eligible sales | Businesses with frequent discounts or variable margins | Profit calculation |
| 3. Target-based accelerators | Selected sales or margin base | Businesses rewarding target attainment | Attainment tiers and commission pool |
Model 1: Sales-Based Commission with Margin Protection
This model calculates a commission as a percentage of eligible net sales, but only when the transaction satisfies a minimum gross-margin requirement.
Commission = Commissionable Net Sales × Commission Rate
The commission is blocked when the transaction’s gross-margin percentage falls below the minimum threshold.
Example: A salesperson closes a sale for 1,000 with a cost of 820. Gross profit is 180, or 18% of sales.
If the minimum margin is 20%, the transaction does not qualify for commission.
If the cost were 780 instead, gross profit would be 220, or 22%. At a 2% commission rate, the eligible commission would be:
1,000 × 2% = 20
Best for: Retail or commercial operations that want a simple sales incentive while preventing commissions on transactions below a defined profitability threshold.
Model 2: Gross Profit-Based Commission
This model calculates commissions on gross profit rather than revenue. As a result, discounts that reduce gross profit also reduce the commission amount.
Commission = Eligible Gross Profit × Commission Rate
| Item | Sale A | Sale B |
|---|---|---|
| Net sales | 1,000 | 900 |
| COGS | 700 | 700 |
| Gross profit | 300 | 200 |
| Commission rate | 10% | 10% |
| Commission | 30 | 20 |
The salesperson can offer a discount, but doing so reduces both the company’s gross profit and the sales incentive.
Best for: Businesses that negotiate prices, sell products with different margins, or want to discourage unnecessary discounting.
The model depends on accurate and updated COGS. Incorrect cost data can produce misleading commissions even when the spreadsheet formulas work correctly.
Model 3: Target-Based Commissions with Accelerators
Target-based commissions link the incentive rate to the achievement of a sales or gross-profit goal.
The Excel calculator allows the business to select Sales or Margin as the commission base, define a period target, and establish attainment thresholds with corresponding commission rates.
Target Attainment = Actual Period Performance ÷ Period Target × 100
Commission = Eligible Commission Base × Rate for the Achieved Tier
Suppose the monthly gross-profit target is 30,000 and actual gross profit reaches 36,000.
Target Attainment = 36,000 ÷ 30,000 × 100 = 120%
| Target attainment | Commission rate |
|---|---|
| Below 80% | 0% |
| 80% to below 100% | 5% |
| 100% to below 120% | 8% |
| 120% or above | 10% |
At 120% attainment, the applicable commission rate is 10%:
36,000 × 10% = 3,600
This is an illustrative calculation and is not the same as the sample data preloaded in the workbook. The actual approved payment must also pass the commission pool and transaction controls.
How the downloadable calculator works: It selects one rate based on period-wide attainment and applies that rate to each eligible transaction’s chosen commission base. It does not calculate progressive marginal bands and does not automatically assign a separate attainment tier to each salesperson.
This distinction is important when explaining the plan to sales representatives. If your compensation policy requires individual targets or marginal accelerator bands, the supplied workbook should not be treated as implementing those rules.
Step 3: Establish Clear Commission Rules
Commission disputes often arise because the calculation formula is clear but the operating conditions are not. Document what qualifies, what reduces the commission, and who authorizes payment.
Define the Commissionable Base
Specify whether commission is based on net sales, gross profit, or an approved performance target. Define how sales taxes, discounts, credit notes, COGS, and other adjustments are handled.
The downloadable calculator records net sales excluding tax and calculates eligibility using the model selected by the business.
Credit Notes vs. Clawback Adjustments
These two adjustments serve different purposes:
- Credit Note: Reduces the transaction during the same reporting period because of a return, cancellation, or other adjustment.
- Clawback Adjustment: Reverses a commission previously paid when a later event makes that payment subject to recovery under the applicable policy.
In the workbook, clawbacks are recorded as nonpositive adjustments. They require reconciliation with prior commission payments and the corresponding transaction records.
Do not create fictitious sales or duplicate a transaction to force an adjustment. Clawbacks must be handled in accordance with contracts and applicable employment or commission laws.
Collections and Subscription Eligibility
For B2B credit sales, the workbook supports a % Collected field to adjust transaction eligibility according to the payment information entered.
For subscription transactions subject to a retention requirement, use Active after X days to confirm eligibility. A No value blocks the commission.
Blank retention fields should only be used where the retention rule does not apply. The spreadsheet cannot identify subscription transactions or verify active status against external systems automatically.
Discounts, Targets, and Policy Changes
State who can authorize discounts, the minimum margin required where applicable, and the measurement period used for targets.
Commission terms should be defined and communicated before the period begins. Avoid changing rates, thresholds, or targets retrospectively without the appropriate agreement and authorization.
Step 4: Implement the Plan in 10 Days
A structured rollout can help identify calculation problems and operational disagreements before the plan becomes part of the regular payment process.
| Period | Main activities | Expected outcome |
|---|---|---|
| Days 1–3 | Choose the model, calculate the pool, define commission rules, and test historical transactions. | Draft policy and financial simulation. |
| Days 4–7 | Run a controlled pilot, validate transaction data, review exceptions, and reconcile commissions. | Confirmed calculations and documented adjustments. |
| Days 8–10 | Explain the policy to the team, assign approval responsibilities, and establish the payment review process. | Operationally documented plan ready for management authorization. |
This timeline is a practical example, not a guarantee that every business can legally or operationally implement a compensation policy in ten days. More complex organizations may require additional review.
KPIs and Controls to Review Before Paying Commissions
Commission expense should be evaluated together with sales performance, profitability, collection quality, and payment accuracy.
| KPI | Basic calculation or review | Management question |
|---|---|---|
| Commission-to-sales ratio | Total commissions ÷ net sales × 100 | How costly is the incentive plan relative to revenue? |
| Gross-margin percentage | Gross profit ÷ net sales × 100 | Are discounts reducing profitability? |
| Target attainment | Actual results ÷ target × 100 | Are the targets realistic and meaningful? |
| Collection percentage | Collected amount ÷ eligible invoiced amount × 100 | Are commission payments supported by cash collection? |
| Commission pool utilization | Total commissions ÷ payable pool × 100 | Does the planned payout remain within the ceiling? |
| Returns and clawbacks | Review adjusted or reversed transactions | Are commissions being corrected consistently? |
Ratios involving a zero or negative denominator should be reviewed rather than presented as meaningful performance indicators.
Prepayment Checklist
- All relevant transactions are recorded with unique IDs and consistent salesperson identifiers.
- Net sales exclude taxes, and COGS and other costs are verified.
- Credit notes and later-period clawbacks are reconciled.
- B2B collection percentages match the supporting records.
- Subscription retention eligibility has been confirmed where applicable.
- The workbook contains no unresolved blocking validation alerts.
- Total commissions do not exceed the payable commission pool.
- Management has approved the calculation in accordance with company policy.
Download the Free Sales Commission Calculator and PDF Guide
InfoExperiencia provides two complementary resources to help you implement these three commission models:
- Sales Commission Calculator (Excel): A workbook with instructions, glossary, and three commission models: Sales, Margin, and Accelerators.
- Sales Commission Operating Guide (PDF): A step-by-step guide covering setup, sales entry, validation messages, collection controls, eligibility, clawbacks, and final payment review.
The Excel workbook uses the sequence Commission Pool → Plan Parameters → Sales Log → CONTROL → Management Review.
Editable inputs: The workbook identifies user-entry fields. Do not overwrite calculated cells or change formulas when recording sales.
Each model includes row-level checks in the Validation / Action column and a general Plan Status indicator. The main messages are:
| Message | What to do |
|---|---|
| OK | Row passes the defined checks; verify supporting records. |
| MISSING INFO | Complete required transaction fields. |
| CHECK INPUTS | Correct invalid values or inconsistent transaction amounts. |
| DUPLICATE ID | Resolve the repeated transaction identifier. |
| CHECK ELIGIBILITY | Verify the subscription eligibility selection. |
| INELIGIBLE | The transaction does not qualify for commission under the retention control. |
| REVIEW — DO NOT PAY | Resolve blocking issues before payment. |
| EXCEEDS POOL — DO NOT PAY | Reconcile commissions against the payable ceiling. |
| READY FOR REVIEW | Proceed to management reconciliation; payment is not automatically authorized. |
Important: The calculator supports commission calculations and validation, but it is not a payroll system or a substitute for CRM, accounting, billing, employment agreements, or management approval.
Both files are intended to be used together. Start with the PDF instructions, configure the relevant Excel model, enter transactions, and review the CONTROL section before authorizing any payments.
Frequently Asked Questions About Sales Commission Plans
What is a good sales commission percentage?
There is no universal rate. A suitable percentage depends on gross margins, the salesperson’s responsibilities, sales cycle, compensation structure, and the company’s financial capacity. Calculate your commission pool before committing to a rate.
Should commissions be based on sales or gross profit?
Sales-based commissions are simpler when margins are stable. Gross-profit-based commissions are often more appropriate when discounts or product margins vary substantially. A margin threshold can provide additional protection to a revenue-based model.
How does the accelerator model work?
The included Excel model determines one commission rate from period-wide target attainment and applies it to eligible transactions using the selected sales or margin base. It does not use marginal bands or individual salesperson attainment tiers.
How can B2B businesses protect cash flow?
Businesses may link payment eligibility or the payable commission pool to verified collections, provided this is consistent with their contractual and legal obligations. Collection percentages must be checked against actual payment records.
What happens when a customer cancels after commission payment?
A previously paid commission may require a clawback adjustment if the applicable compensation agreement allows it. Record the adjustment in the correct period and reconcile it with the original transaction and payment records.
Can the Excel calculator replace a payroll or CRM system?
No. It calculates and checks commission information entered by the user. It does not independently validate transactions against external systems, calculate subscription retention dates, or authorize payroll payments.
Conclusion: Protect Profit Before Setting Commission Rates
A sustainable sales commission plan rewards the right results without undermining business profitability or cash flow. Start by calculating the available pool, choose a model aligned with your commercial strategy, document eligibility and adjustment rules, and reconcile every payment before approval.
Use the Excel calculator and PDF operating guide to test your chosen structure and organize the review process. For ongoing sales measurement, complement your commission analysis with our Sales KPIs guide.
Discover more from
Subscribe to get the latest posts sent to your email.
