On This Page
- How to use this calculator
- Sales commission formula
- Tiered (graduated) commission structures
- Adding a base salary: on-target earnings (OTE)
- Splitting sales commission
- Sales commission by role and industry
- Is sales commission taxed differently?
- Sales commission in Excel and Google Sheets
- Worked examples
- Frequently asked questions
- References
How to Use This Calculator
Pick a calculation mode, fill in your numbers, and the result updates instantly. Two modes cover the two directions people actually search for: working out commission from a sales figure, or working backward from a target income to find the sales required.
Mode 1: From sales amount
Enter the sales amount, choose flat rate or tiered as your commission structure, and add an optional base salary and commission split. Flat rate applies one percentage to the whole sale. Tiered applies a different rate to each slice of sales, the same way income tax brackets work, so a rep who blows past quota earns a higher rate on the extra sales, not just more of the same rate.
Mode 2: Sales needed for target
Already know what you want to earn? Choose whether the target is commission only or total pay (base plus commission), enter the target amount, base salary if relevant, and a flat commission rate. The calculator works the formula backward to show exactly how much you need to sell.
Read the results
The main result card shows the primary answer for your chosen mode: commission earned in Mode 1, or sales needed in Mode 2. The grid below adds total pay, your share after any split, the split going to a house or broker, and the effective commission rate, the single percentage the whole deal actually worked out to once every tier is blended together.
Sales Commission Formula
The basic formula for calculating sales commission is: Commission = Sales Amount × Commission Rate. A rep who closes a $50,000 deal at a flat 6% rate earns $3,000 in commission, full stop. This is how most retail, call center, and straightforward B2B commission plans work, and it is the calculation most people mean when they search for how to calculate sales commission.
Example: $50,000 in sales at a 6% commission rate gives $50,000 × 0.06 = $3,000 in commission. Add a $3,000 base salary and the total pay for that period comes to $6,000.
Tiered (Graduated) Commission Structures
A tiered, or graduated, commission structure pays a higher rate as a rep sells more, but only on the sales inside each tier, not on the whole amount. This is the same logic as a progressive income tax bracket: crossing into a higher tier does not retroactively raise the rate on everything sold below it.
Take a structure with three tiers: 3% on the first $50,000 in sales, 5% on the next $50,000 (from $50,000 to $100,000), and 8% on anything above $100,000. A rep who closes $150,000 in sales earns 3% on the first $50,000 ($1,500), 5% on the next $50,000 ($2,500), and 8% on the final $50,000 ($4,000), for a total of $8,000. Dividing total commission by total sales gives an effective rate of 5.33%, the single blended percentage that summarizes the whole deal even though three different rates were involved.
Tiered structures reward reps for exceeding quota without requiring separate accelerator paperwork, and they show up often in software sales, enterprise B2B, and any commission plan built around quarterly or annual targets. A common mistake when calculating tiered commission by hand is applying the top rate to the entire sales amount instead of just the slice inside that tier, which overstates the commission significantly on larger deals.
Adding a Base Salary: On-Target Earnings (OTE)
Many sales roles pay a base salary plus commission rather than commission alone. The combined figure, base salary plus expected commission at quota, is what recruiters and job postings usually mean by on-target earnings (OTE). A rep with a $40,000 base and a commission plan expected to add $30,000 at full quota attainment has an OTE of $70,000, even though neither number alone tells the full story.
Entering a base salary in Mode 1 adds it directly to the calculated commission to show total pay for that period. This matters when comparing job offers: a lower base with a richer commission plan can out-earn a higher base with a thin commission rate, but only if quota is realistically achievable. Before accepting an offer built mostly around variable pay, the Break-Even Point Calculator can help estimate how many sales or units are needed just to cover personal fixed costs.
Splitting Sales Commission
Commission is not always paid in full to the person who closed the sale. Real estate is the clearest example: a typical 5% to 6% total commission on a home sale is usually split first between the listing brokerage and the buyer's brokerage, then split again between each brokerage and its agent. Sales teams also split commission between a rep and a sales development rep who sourced the lead, or between a house account and the closing rep.
The split % field in this calculator represents your final take-home share of the calculated commission, however many steps it took to get there. For a real estate deal with a 50/50 split between brokerages and a 70/30 split between an agent and their broker, multiply the two percentages together: 50% × 70% = 35%, and enter 35 as the split. This single number collapses any multi-step split chain into one field.
Sales Commission by Role and Industry
The formula stays identical across industries. What changes is the typical rate, whether a base salary is involved, and how often splits apply.
Retail and call center sales commission
Retail commission rates commonly run from 2% to 10%, frequently layered on top of an hourly wage rather than a salary. Call center and inside sales roles often use tiered structures tied to monthly quota, since call volume and close rates are easy to track and reward incrementally.
Real estate sales commission
Total real estate commission is usually 5% to 6% of the sale price, split between the listing and buyer's side, then split again between each agent and their brokerage. A $420,000 home sale at 5% generates $21,000 in total commission before any splits are applied. Use the split field above to find an individual agent's actual take-home share.
B2B, SaaS, and technology sales commission
Technology and software sales frequently use tiered or accelerator structures tied to quarterly or annual quota, often paired with a base salary that makes up 40% to 60% of total on-target earnings. Accelerators, higher rates that kick in above 100% of quota, are a form of tiered commission and can be modeled with the tiered structure above by setting the final tier's threshold at the quota amount. A rep weighing a commission-based role against going independent can compare the equivalent pay using the Freelance Rate Calculator, since consulting income has to cover business expenses and tax that a commission plan's base salary would otherwise absorb.
Insurance and financial services commission
Insurance sales commonly pays a first-year commission rate on new policies and a smaller renewal or "trail" commission in following years, which functions like two separate flat-rate calculations run side by side rather than one blended rate.
Is Sales Commission Taxed Differently?
In the United States, the IRS classifies commission as supplemental wages, which can be withheld at a different flat rate than regular salary depending on how an employer processes payroll, even though it is taxed the same way as ordinary income once a full tax return is filed. This calculator shows commission and total pay before tax. To estimate actual take-home pay after federal, state, and payroll tax withholding, run the total pay figure through the Gross to Net Pay Calculator.
Sales Commission in Excel and Google Sheets
Both Excel and Google Sheets use identical syntax for these formulas. Assume sales amount is in B2 and commission rate (as a percentage) is in C2.
- Flat-rate commission:
=B2*(C2/100) - Total pay with a base salary in D2:
=D2+B2*(C2/100) - Tiered commission (tier 1 max in E2, tier 1 rate in F2, tier 2 max in G2, tier 2 rate in H2, tier 3 rate in I2):
=MIN(B2,E2)*(F2/100) + MAX(0,MIN(B2,G2)-E2)*(H2/100) + MAX(0,B2-G2)*(I2/100) - Effective rate:
=Total_Commission/B2*100 - Required sales for a target commission (target in J2, rate in C2):
=J2/(C2/100)
The tiered formula uses MIN and MAX to cap each tier's contribution at its own range, which is exactly what stops a large sale from being taxed at the top rate on every dollar rather than just the dollars inside that tier.
Worked Examples
Example 1: Retail Sales Associate with Flat Commission
A retail sales associate closes $45,000 in sales this month, earns a flat 4% commission, and has a $2,200 monthly base salary.
Commission = $45,000 × 0.04 = $1,800. Total pay = $2,200 + $1,800 = $4,000 for the month.
Example 2: B2B Sales Rep with a Tiered Structure
A software sales rep closes $150,000 in sales this quarter under a tiered plan: 3% on the first $50,000, 5% on the next $50,000, and 8% on anything above $100,000. No base salary; this is a pure commission role.
Tier 1: $50,000 × 3% = $1,500. Tier 2: $50,000 × 5% = $2,500. Tier 3: $50,000 × 8% = $4,000. Total commission = $1,500 + $2,500 + $4,000 = $8,000. Effective rate = $8,000 ÷ $150,000 = 5.33%.
Example 3: Real Estate Agent Commission Split
A home sells for $420,000 with a total commission rate of 5%. The listing and buyer's brokerages split that 50/50, and the listing agent keeps 70% of their brokerage's share after the in-house split.
Total commission = $420,000 × 5% = $21,000. Combined split = 50% × 70% = 35%. Agent's share = $21,000 × 35% = $7,350.
Example 4: Reverse Check on a Total Pay Target
A sales rep wants to earn $8,000 in total pay this month, has a $3,000 base salary, and earns a flat 10% commission rate. How much does she need to sell?
Commission needed = $8,000 − $3,000 = $5,000. Required sales = $5,000 ÷ 10% = $50,000.
Example 5: Reverse Check on a Pure Commission Target
A commission-only rep wants to earn $9,000 in commission this month at a flat 6% rate, with no base salary to account for.
Required sales = $9,000 ÷ 6% = $150,000. If quota realistically caps out lower than that, this reverse check flags the gap early instead of at the end of the month. The Savings Goal Calculator can then show how a $9,000 commission month contributes toward a longer-term savings target.
Frequently Asked Questions
How do you calculate sales commission?
Multiply the sales amount by the commission rate: Commission = Sales Amount × Commission Rate. For a $50,000 sale at a 6% rate, commission is $50,000 × 0.06 = $3,000. Use Mode 1 above to run this automatically, including an optional base salary and split.
How is sales commission calculated on a tiered structure?
Each tier applies its own rate only to the sales that fall inside that tier's range, the same way tax brackets work. Add up the commission from every tier to get the total, then divide by total sales to find the effective (blended) rate. Switch to "Tiered" under Commission Structure above to calculate this directly.
How do you calculate commission on net sales versus gross sales?
Gross sales commission uses the full invoice or contract value. Net sales commission subtracts returns, discounts, and sometimes shipping or sales tax before applying the rate. Check the compensation plan document for the exact definition of "sales" it uses, since this single detail can noticeably change a commission payout.
Is sales commission calculated before or after sales tax?
Almost always before sales tax. Sales tax is collected on behalf of the government and passed through, not revenue the business or the rep earned, so most commission plans explicitly exclude it from the base used to calculate commission.
How do you calculate a sales commission split, like a real estate split?
Multiply each split percentage together as a decimal. A 50/50 split between two brokerages followed by a 70/30 split between an agent and their broker works out to 50% × 70% = 35% for the agent. Enter that combined percentage in the "Your split %" field in Mode 1.
What is OTE (on-target earnings) and how is it calculated?
OTE is base salary plus the commission a rep would earn at full (100%) quota attainment. It represents expected total pay under normal performance, not a guaranteed amount, since actual commission still depends on actual sales. Enter a base salary and expected sales at quota in Mode 1 to see the OTE figure as "Total Pay."
Is sales commission taxed differently than a salary?
In the US, the IRS treats commission as supplemental wages, which employers can withhold at a different flat rate than regular salary, though the total tax owed at year-end depends on total annual income regardless of how it was withheld. See the Gross to Net Pay Calculator to estimate actual take-home pay from a commission total.
How do you calculate sales commission in Excel?
For a flat rate, multiply the sales cell by the rate cell: =B2*(C2/100). For a tiered structure, use nested MIN and MAX functions to cap each tier's contribution, as shown in the Excel section above.
How much do you need to sell to hit a commission target?
Divide the target commission (after subtracting any base salary, if the target is total pay) by the commission rate: Required Sales = Target ÷ Rate. Use Mode 2 above to calculate this directly for either a commission-only or total-pay target.
What is a typical sales commission rate by industry?
Retail and call center roles commonly run 2% to 10%. Real estate totals 5% to 6% before splits. B2B and technology sales often blend a lower base-adjusted rate with tiered accelerators above quota. Insurance commonly pays a higher first-year rate and a smaller renewal rate. Rates vary considerably by company and role, so treat these as starting reference points, not fixed rules.
How is real estate commission calculated and split?
Total commission is calculated as a percentage of the home's sale price, typically 5% to 6%, and is usually paid by the seller. That total is then split between the listing brokerage and the buyer's brokerage (often 50/50), and each brokerage splits its share again with the individual agent, commonly 60/40 to 80/20 in the agent's favor depending on experience and brokerage agreement.
Does a higher commission tier apply to all sales or just the amount in that tier?
Just the amount inside that tier. This is the single most common misunderstanding in a DIY tiered commission calculation. A rep who crosses into a higher tier only earns the higher rate on the sales above the tier threshold, not on the entire deal, exactly like a progressive tax bracket.
References
- IRS Publication 15 (Circular E), Employer's Tax Guide: defines commission as supplemental wages and explains federal withholding treatment.
- U.S. Department of Labor: Fair Labor Standards Act (FLSA): federal wage and hour rules that apply to commissioned sales employees, including the retail and service establishment exemption.
- National Association of Realtors (NAR): industry reference for how real estate commission structures and brokerage splits typically work.