How do you calculate a sales bonus?

Multiply the target bonus by your payout percentage. Up to 100% of quota the payout usually equals attainment; above it, each extra point is multiplied by the accelerator. At 110% with a 1.5x accelerator the payout is 100 + 10 × 1.5 = 115%, so a $10,000 target pays $11,500.

How much tax is taken out of a bonus?

In the US, employers often withhold a flat 22% federal rate on bonuses up to $1 million, plus Social Security, Medicare and any state tax. Many other countries tax a bonus like normal salary. Withholding is not your final tax bill, so enter the rate that applies to you.

What if I am below 100% of quota?

This calculator pays in proportion: 80% attainment pays 80% of the target bonus. Many plans also have a threshold, such as no bonus below 50% of quota. Check your comp plan and enter 0% attainment if you are under its threshold.

Sales Bonus Calculator: Bonus After Tax from Quota Attainment

Sales Bonus Calculator (Bonus After Tax)

Bonus earned = target bonus × payout %. The payout equals quota attainment up to 100%, plus (attainment − 100) × the accelerator above it, up to the cap. Bonus after tax = bonus earned × (1 − tax rate). A $10,000 target bonus at 110% attainment with a 1.5x accelerator pays $11,500, or $8,970 after 22% tax withheld.

Bonus earned = (target bonus at 100% of quota × MIN(bonus cap, share of target,IF(quota attainment<=100,quota attainment,100+(quota attainment-100) × accelerator above 100%)) ÷ 100) = $11,500 Tax withheld = (bonus earned × tax rate on bonus ÷ 100) = $2,530 Bonus after tax = bonus earned-tax withheld = $8,970

Sales bonus formula in Excel or Google Sheets

Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.

Cell	What	Value or formula	Example
B2	Target bonus at 100% of quota ($)	10000	10000
B3	Quota attainment (%)	110	110
B4	Accelerator above 100% (x)	1.5	1.5
B5	Bonus cap, share of target (%)	200	200
B6	Tax rate on bonus (%)	22	22
B8	Bonus earned ($)	=ROUND(B2MIN(B5,IF(B3<=100,B3,100+(B3-100)B4))/100,0)	11500
B9	Tax withheld ($)	=ROUND(B8*B6/100,0)	2530
B10	Bonus after tax ($)	=B8-B9	8970

Get the ready-made spreadsheet

The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).

Frequently asked questions

How do you calculate a sales bonus?: Multiply the target bonus by your payout percentage. Up to 100% of quota the payout usually equals attainment; above it, each extra point is multiplied by the accelerator. At 110% with a 1.5x accelerator the payout is 100 + 10 × 1.5 = 115%, so a $10,000 target pays $11,500.
How much tax is taken out of a bonus?: In the US, employers often withhold a flat 22% federal rate on bonuses up to $1 million, plus Social Security, Medicare and any state tax. Many other countries tax a bonus like normal salary. Withholding is not your final tax bill, so enter the rate that applies to you.
What if I am below 100% of quota?: This calculator pays in proportion: 80% attainment pays 80% of the target bonus. Many plans also have a threshold, such as no bonus below 50% of quota. Check your comp plan and enter 0% attainment if you are under its threshold.

About the author

Abdessamad Ghanem

Customer Experience & Customer Success Consultant · Founder of Clarivoxx

Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.

Follow Clarivoxx on LinkedIn More about Clarivoxx