Free calculator
Commission calculator
Model sales commission as percent of deal amount: commission = sale × (rate ÷ 100). Use forward mode for the dollar amount, find rate when you know sale and commission, or find sale when you know commission and rate. Add an optional flat per-deal line on top of the percent slice, or switch to base + commission for a simple salary + variable illustration. This is not tiered quotas, not real-estate co-broker splits, and not forex pip math—see methodology for scope.
When to use this calculator
Quick deal economics and comp checks before you paste rows into Google Sheets or Excel.
- Turn a quoted rate % and a ticket size into a commission dollar line for a memo or proposal.
- Back-solve the effective rate after a pilot payout, or the implied sale that matches a target commission and rate.
- Add a flat spiff on top of percent to mirror a simple two-part plan in a spreadsheet row.
- Sketch base + variable as base + sale × rate—then move to a full model for tiers, caps, and true OTE math.
We use one percent-of-sale definition: commission = sale × (rate ÷ 100) with sale ≥ 0 and rate ≥ 0. Currency is yours to keep consistent—we never convert FX.
Forward payout
Percent slice = sale × (rate ÷ 100). Optional flat is added for a total line in forward mode—use your own sheet if you need deductions, taxes, or net-of-fees stories.
Reverse solves
Implied rate = commission ÷ sale × 100 when sale > 0. Implied sale = commission ÷ (rate ÷ 100) when rate > 0. When sale = 0 and commission = 0, the rate is not determined by these formulas alone.
What this is not
Not progressive tiers, not listing-side vs buyer-side real-estate splits, not broker per-share ticket fees, and not payroll withholding—build those tables in a model when your policy needs them.
Name sale the same way your plan defines eligible revenue, then treat results as illustration only. For generic percent of drills, use the percentage calculator. To compare commission % of sale with margin % of revenue on a unit, see margin and markup.
Google Sheets & Excel
Let A2 = sale amount, B2 = commission rate % (as a number, e.g. 5 for five percent). English function names; switch to your workbook language pack when you need localized names.
=A2*B2/100Treat B2 as percent points (5 = 5%), not a decimal (0.05).
=C2/A2*100With A2 = sale and C2 = commission; requires A2 > 0.
=C2/(B2/100)With C2 = commission and B2 = rate %; requires B2 > 0.
More tools in Unit economics
Browse all toolsSlide 1 of 28
Frequently asked questions
What does this commission calculator do?
It computes percent-of-sale commission, optional flat add-on, implied rate or implied sale, and a base + variable illustration—not a full HR or tax engine.
What is the formula for sales commission?
Commission = sale × (rate ÷ 100) when rate is entered as percent points (6 means 6%). Total with flat = that commission + flat when you use the optional field.
How do I find the commission rate from the sale and commission?
Rate % = commission ÷ sale × 100 when sale > 0. Use the Implied rate % tab on this page.
How do I find the sale amount from commission and rate?
Sale = commission ÷ (rate ÷ 100) when rate > 0. Use the Implied sale amount tab.
What is the optional flat add-on?
A fixed currency amount added to the percent commission so you can mirror simple fee + percent or spiff lines. It is not a generic deductions or payroll tax model.
What does “Base + commission” mean here?
Total = base + sale × (rate ÷ 100) with non-negative inputs—an illustration only. Real plans can include draws, caps, accelerators, and clawbacks that you model separately.
Is commission the same as margin?
No. Commission here is % of sale paid to a rep. Gross margin on the margin and markup tool is % of selling price kept as profit after unit cost—a different definition and audience.
Does this split buyer and seller agent commission?
No. Co-broker and MLS splits need your local contract math. This page stays a single percent-of-one-total story with transparent formulas.
Can I use this for forex or CFD commission per lot?
No. Lot/pip and leverage calculators use different inputs. Use your platform fee tables or a sheet built for contracts and tick size.
Can I model tiered or accelerating commission?
Not in v1. Build brackets in Sheets or Excel (one row per tier or SUMPRODUCT on slabs) when your plan is progressive—this tool keeps the default path simple.
Where is trading commission per buy and sell?
Use the stock calculator for round-trip share trades with optional flat buy and sell commissions on each side.
How do I do this in Google Sheets or Excel?
See the copy cards: =A2*B2/100 for commission, =C2/A2*100 for implied rate with C2 commission, =C2/(B2/100) for implied sale. Match your language pack for localized names.
Is this compensation or legal advice?
No. It is a free educational calculator for arithmetic on the numbers you enter.