Commission Calculator
Commission plans can look simple on a compensation sheet and still be hard to audit once tiers, base pay, and draws enter the conversation. This calculator keeps the question narrow: given a sales amount and one selected payout structure, how much commission is earned, what are total earnings after base salary, and what effective rate did the plan actually pay? It is designed for a salesperson checking a pay stub, a founder testing a proposed incentive plan, or a finance manager explaining why two commission structures with the same headline rate can produce different payouts.
This tool is intentionally different from the sales commission calculator. That sibling page models a quota plan with COGS, selling expenses, gross profit, operating profit, and OTE-style labor cost. This commission calculator is the payout engine: flat rate, marginal tiers, graduated tiers, or draw against commission. If you need to forecast the revenue being paid on before calculating a payout, start with the sales calculator. If you are translating the result into a personal budget or compensation comparison, use the salary calculator and budget calculator after the commission amount is known.
How to use the commission calculator
Choose the commission structure first. Flat multiplies all sales by one commission rate. Tiered uses the built-in marginal tier table shown below. Graduated chooses the highest tier reached and applies that tier’s rate to all sales. Draw uses the flat commission rate, then compares earned commission with a draw amount spread evenly across the number of periods. Next, select the period label and enter sales amount and base salary for that same period. The period label is informational in the result; it does not annualize or monthly-scale the math, so the sales and base salary inputs must already be in the same time unit.
For flat and draw structures, enter the commission rate. For draw, also enter the draw amount and number of periods. The form rejects nonpositive sales and invalid numbers. The output includes total commission, base salary, total earnings, effective commission rate, and a structure-specific breakdown when the chosen plan needs one.
Formula used by the calculator
For a flat commission, the calculation is direct:
Total earnings add base salary to the calculated commission:
The tiered option uses this built-in marginal schedule:
| Tier | Sales slice | Rate |
|---|---|---|
| 1 | From $0 to $5,000 | 2% |
| 2 | Over $5,000 to $10,000 | 4% |
| 3 | Over $10,000 to $25,000 | 6% |
| 4 | Over $25,000 to $50,000 | 8% |
| 5 | Over $50,000 | 10% |
For tiered commission, each slice receives only its own rate:
For graduated commission, the calculator finds the highest threshold reached and applies that one rate to all sales:
For a draw, the calculator divides both sales and the draw amount evenly across the period count, accumulates earned commission period by period, and reports total earnings as:
Finally, every structure reports the effective rate:
Worked example matching the default flat inputs
With the default flat setup, sales amount is $10,000, commission rate is 5%, and base salary is $1,000 for the selected period. The commission is:
Total earnings are:
The effective commission rate is:
That result is simple because every dollar of sales receives the same rate. A tiered result at the same sales amount is different because the calculator’s first $5,000 earns 2% and the next $5,000 earns 4%, for $100 plus $200, or $300 total commission. A graduated result at $10,000 reaches the 4% threshold and applies 4% to the full $10,000, for $400. The three structures can share a sales amount and still return three different payouts because the rate is applied to different bases.
When to use each structure
A flat plan is easiest to explain and audit. It works well when each sale has a similar margin profile and the business mainly wants to reward volume. A tiered plan is better when the company wants accelerators without repricing earlier sales; it rewards the extra dollars above each threshold. A graduated plan is more aggressive because crossing a threshold can raise the rate on the full sales amount. That can motivate stretch performance, but it also creates cliffs that should be checked before payroll is finalized.
A draw is different from the other structures because it deals with timing. The salesperson receives an advance or guaranteed draw while commissions are earned. This calculator shows the draw balance by period and total earnings based on the larger of total earned commission or the draw amount. It does not decide whether a draw is recoverable after the period; that depends on the written compensation agreement and local employment rules.
Practical tips for accurate commission math
Keep the sales amount, period, and base salary aligned. Do not put annual sales next to a monthly base salary unless that is the exact comparison you intend. Use recognized sales rather than booked pipeline when the compensation plan pays on closed revenue. Document whether refunds, cancellations, tax, shipping, and discounts are included in the commissionable base. For revenue cleanup before the payout step, the sales calculator separates gross sales from returns, allowances, and discounts. For percentage checks, the percentage calculator is useful when reviewing rate changes or clawback adjustments.
Small businesses should also test affordability. A commission that is motivating for reps can still be too expensive if it consumes margin, creates cash-flow strain, or pays on sales that later reverse. The SBA’s finance guidance stresses cash-flow management and recordkeeping, and the IRS business expense guidance is useful when separating compensation costs from other operating expenses. Treat the calculator as an arithmetic model, then confirm timing, eligibility, recoverable draw language, and payroll compliance with the actual plan document.
Sources
- U.S. Small Business Administration, Manage your finances — cash-flow and financial recordkeeping context for small businesses.
- IRS, Publication 535: Business Expenses — business expense categories and recordkeeping context for compensation-related costs.
- U.S. Bureau of Labor Statistics, Public Data API — official BLS data access endpoint for labor-market time series.