How to Calculate Commission: A Practitioner’s Cheat Sheet for Exact Rates, Tiers, and Splits

Quick Answers: 6% Commission on $300,000 and How to Calculate 7%

If you landed here for two specific math problems, here they are. A 6% commission on $300,000 equals $18,000—calculated as $300,000 × 0.06. That’s the number a real estate seller or buyer’s agent would owe or earn on a typical U.S. home sale at that price point.

For a 7% commission, the method is identical: multiply the commissionable base by 0.07. For example, 7% of $250,000 is $17,500 ($250,000 × 0.07). The formula works for any amount; just convert the percentage to a decimal and multiply.

Those two queries—’What is 6% commission on $300,000?’ and ‘How to calculate 7% commission?’—show up constantly in search because people need instant numbers, not a lecture. Below, I’ll give you the universal formula, a cheat-sheet table, and a reusable spreadsheet so you never recalculate by hand again.

But first, a practitioner’s note: the math is trivial; the contract defining what counts as the base is where real money is won or lost. We’ll cover that next, because missing this caused me a five-figure headache in my first year running sales ops.

The Universal Commission Formula (and Why the Base Matters)

Every commission calculation reduces to one expression: commission = commissionable base × rate. The rate is a percentage (e.g., 6% = 0.06). The base is the number you multiply against, and it is rarely as simple as ‘the sale price.’

When I built my first commission plan for a 12-person SaaS sales team in 2019, I assumed our CRM’s ‘deal value’ field equaled the commissionable base. It didn’t—it included annual maintenance fees we had explicitly excluded from rep comp. That oversight cost us $4,200 in overpaid commissions in Q1 alone, and rebuilding trust with the finance team took longer than fixing the spreadsheet.

The thing nobody tells you about commission bases: gross versus net is a battleground. In real estate, a 6% rate might be charged on the gross sale price, but some broker agreements calculate the agent’s split only after deducting franchise fees or marketing costs (net proceeds). If your contract says ‘net,’ your effective take-home rate drops.

For example, on a $300,000 home with $15,000 in seller-paid closing costs deducted before commission, a 6% gross commission is $18,000, but a 6% net commission is only $17,100. That $900 gap is real money that disappears if you blindly use the gross figure.

Another edge case: recurring revenue commissions. If you pay 10% on a $1,200/month subscription, do you pay $120 every month or only on the first year? I’ve seen both; the formula is the same but the base definition changes the lifetime payout by thousands over a 36-month contract.

Most online calculators ignore this nuance. If you want precision, open our interactive Commission Calculator and manually adjust the base field—don’t let a tool assume gross when your contract says net.

Caps and floors are another hidden layer. A commission cap limits total payout above a threshold to protect margins. Suppose you cap at $50,000; a 10% rate on $1M would mathematically be $100,000, but the plan pays $50,000. Conversely, a floor guarantees minimum commission even if the rate times base falls lower.

Draws against commission are advances, not free money. In 2022, a new rep took an $8,000 recoverable draw and quit after 60 days. We learned to use non-recoverable draws for new hires and document recovery terms in writing, or you’ll eat the cost.

Clawbacks are the ugly cousin of commissions. If a customer cancels within 90 days, many contracts require reversing the commission. Your formula must handle negative entries, or your accrual reports drift.

Quick-Reference Commission Rate Table

Because search snippets for specific numbers are often empty, here is a cheat sheet I keep pinned in my own sales ops dashboard. It covers the rates people ask about most: 1%, 5%, 6%, 7%, 10%, and 20% across common transaction sizes.

Base Amount 1% 5% 6% 7% 10% 20%
$50,000 $500 $2,500 $3,000 $3,500 $5,000 $10,000
$100,000 $1,000 $5,000 $6,000 $7,000 $10,000 $20,000
$200,000 $2,000 $10,000 $12,000 $14,000 $20,000 $40,000
$300,000 $3,000 $15,000 $18,000 $21,000 $30,000 $60,000
$500,000 $5,000 $25,000 $30,000 $35,000 $50,000 $100,000
$1,000,000 $10,000 $50,000 $60,000 $70,000 $100,000 $200,000

Notice that 6% on $300,000 (the top PAA query) sits at $18,000, and 7% on the same base is $21,000. If you’re negotiating a rate, these anchors help you visualize the dollar delta quickly.

I recommend screenshotting this table or pasting it into your CRM notes. It’s faster than launching a calculator for back-of-napkin negotiations in a car dealership or open house.

One limitation: this table assumes a straight percentage on a gross base. Tiered structures (next section) will bend these numbers downward or upward depending on thresholds. Also, if you know the commission dollar amount and need the rate, divide commission by base: $18,000 ÷ $300,000 = 0.06 = 6%. That reverse math is handy when reviewing a pay stub.

For micro-transactions, scale down: 6% of $1,000 is $60. The same decimal shift applies. I’ve used this table to train new agents who froze when asked ‘what’s 7% of $475,000?’ They now answer $33,250 without blinking.

How to Calculate Tiered and Split Commissions

Straight percentages are easy; real-world plans rarely stay flat. Below are the two structures that trip up most beginners, plus the errors I’ve audited in real books.

Tiered Commission Step-by-Step

A tiered plan pays different rates above certain performance thresholds. Example: 5% on the first $200,000 of sales, then 8% on everything above that. If a rep sells $350,000, you don’t multiply $350,000 by 8%.

Instead: $200,000 × 0.05 = $10,000. The remaining $150,000 × 0.08 = $12,000. Total commission = $22,000. The effective blended rate is 6.29%, not 8%.

I once audited a plan where the controller applied the top tier to the entire base because the formula referenced the wrong cell. The rep was overpaid $3,400 before month-end close. Always isolate each tier in its own row.

Multi-tier example: 0–$100k at 5%, $100k–$300k at 7%, above $300k at 10%. On $450,000: first $100k = $5,000; next $200k = $14,000; remaining $150k = $15,000. Total = $34,000 (blended 7.56%). This incremental method is called a ‘marginal’ tier, distinct from a ‘cliff’ tier where the higher rate applies to the whole base once threshold is crossed—rare but toxic if undocumented.

Chargebacks must layer on top. If $50k of that $450k sale cancels, you reverse the commission on that portion using the same marginal logic: $50k falls in the 7% band, so claw back $3,500. Your accrual ledger should show negative line items, not a vague adjustment.

Split Commissions and Brokerage Cuts

Splits happen when multiple parties share a deal—common in real estate, insurance, and agency sales. A 6% gross commission on $300,000 ($18,000) might split 50/50 between listing and buyer agent, leaving each $9,000 before broker fees.

Then the brokerage might take 20% of the agent’s $9,000, netting the agent $7,200. The math is sequential: gross → side split → broker split. Most people calculate only the first step and wonder why their check is small.

For multi-agent teams, use a waterfall: define order of deductions explicitly. Ambiguity here is the top cause of commission disputes I’ve mediated. In one case, two agents argued over a $1,200 delta because the contract omitted whether the broker fee came off the top or after the side split.

Rule of thumb: never calculate a split on a split. Document the exact sequence of deductions in the contract, or you’ll spend more on legal fees than the disputed amount.

Cross-border deals add currency conversion. If the base is in EUR and you pay in USD, lock the exchange rate in the contract. I’ve seen a 3% rate swing wipe out the entire commission due to a volatile week.

Build Your Own Google Sheets Commission Calculator

You don’t need fancy software. A copy-paste Google Sheets template handles 90% of small-business needs. Here’s the exact structure I give to clients after a two-hour onboarding.

Column A: Deal Amount (base). Column B: Rate (as decimal, e.g., 0.06). Column C: Commission = =A2*B2. For tiered, add columns D (Tier1 Limit), E (Tier1 Rate), F (Tier2 Rate) and use =IF(A2<=D2, A2*E2, D2*E2+(A2-D2)*F2).

To handle splits, add Column G: Split % (e.g., 0.5) and Column H: Net to Agent = =C2*G2. This mirrors the waterfall we discussed. For multi-tier, nest another IF or use SUMIFS against a rate table.

I also add data validation to force rates between 0 and 1, and conditional formatting to flag commissions above $50,000 for manual review. These tiny guards would have caught my 2019 $4,200 error automatically.

If you’d rather not maintain formulas, our Commission Calculator already encodes these layers online. But a Sheets file is portable for field negotiations where Wi-Fi fails—something I learned during a rural real estate closing in 2021 when the cloud tool was unreachable.

For a downloadable version, copy the table above into a new Sheet, label rows, and protect the formula cells. Share it with 'view only' to agents so they can’t accidentally overwrite the logic. That’s your reusable cheat sheet, no license fee required.

One advanced tip: use =ARRAYFORMULA to apply the tiered logic to an entire column of deals at once. It saves dragging formulas and reduces human error during month-end runs of 500+ rows.

Taxes, Compliance, and the Fine Print Nobody Tells You

Commission is taxable income, but the withholding mechanics surprise new earners. According to the IRS, commissions paid to employees are supplemental wages and may be subject to a flat 22% federal withholding rate if paid separately from regular wages (under $1 million).

That doesn’t mean your tax bracket is 22%—it’s just withholding. At year-end, the total is reconciled against your actual bracket. I’ve seen reps panic when their $18,000 commission check nets $14,040, assuming they were 'taxed 22% forever.' They weren’t.

Independent contractors (1099) receive gross commissions with no withholding; they must file quarterly estimated taxes. Miss those deadlines and you’ll owe penalties—another thing nobody tells you until April. The same IRS guidance notes self-employment tax of 15.3% applies to net earnings, so a 1099 agent keeping $7,200 pays both income and SE tax.

State rules vary. Some states cap commission clawbacks or require written agreements for recoverable draws. Check your state labor department before copying a template from another jurisdiction. California, for instance, has strict rules on wage deductions that many out-of-state brokers violate.

Also, commission splits with unrelated parties can trigger 1099 reporting if brokerages pay agents directly. Keep a paper trail of who earned what portion to avoid mismatched IRS forms. In an audit I supported, missing split documentation cost the brokerage $11k in corrected filings.

FUTA and SUTA taxes apply to employee commissions, adding to employer cost. Budget for roughly 6–8% on top of the gross commission when modeling plan affordability. This is why a 10% plan can effectively cost 10.8% all-in.

Which Commission Model Should You Use?

Choosing a structure is a trade-off, not a formula. Here are three common models and when each fits, drawn from plans I’ve designed for SaaS, real estate, and retail teams.

Straight Percentage

Best for simple, high-velocity transactions (e.g., affiliate sales). Low admin overhead, but it can encourage discounting because reps want volume regardless of margin. I used straight 20% for a clearance furniture line; reps slashed prices to boost their own math, hurting gross profit.

Base Plus Commission

A small salary plus variable pay stabilizes income and attracts experienced reps with families. The downside: you carry fixed cost in slow months. I used this for our SaaS team to reduce churn from 34% to 12% in a year, but finance needed to model the floor carefully.

Tiered or Accelerator

Paying higher rates above quota pushes top performers. But set tiers too low and you inflate cost of sale; too high and nobody reaches them. Model the blended rate (like the 6.29% example) before approving. One client set an 12% accelerator at 110% quota; only 2 of 40 reps hit it, so it was dead weight.

SPIFs and Team Pools

Short-term spiffs (e.g., $500 for selling a new product) inject momentum but can distort core metrics if overused. Team pools split a group bonus by tenure or equal share; they build culture but dilute individual incentive. I allocate no more than 10% of variable pay to spiffs to keep focus.

Most people don't realize that the best commission plan is the one finance can audit in 10 minutes. If your calculation requires a 200-cell macro, you’ll breed disputes and erode trust.

Test any plan on last year’s deals retroactively. If the payouts look unaffordable or absurd, adjust before going live. I run a 'shadow quarter' where we compute hypothetical commissions for 90 days without paying, to surface bugs.

Finally, communicate the plan in plain language with one worked example per rep. The math is only as good as the rep’s belief that it’s fair. That belief, not the formula, drives performance.

Leave a Reply

Your email address will not be published. Required fields are marked *