How do I calculate sales quota attainment?

Close $150,000 against a $200,000 sales quota and your attainment is 75%. You still need $50,000 to reach the target.

That percentage compares sales with a goal. Your commission plan determines what those sales pay.

The sales quota attainment calculator shows both, using a flat commission rate and an optional bonus at quota. Let’s work through its defaults.

The sales quota attainment formula

Attainment = closed revenue ÷ sales quota × 100

Salesforce’s quota attainment guide uses closed-deal revenue and quota for the same period. For a team, it divides combined closed revenue by combined quota.

Match the reporting window and the sales credit rules before dividing. A quarterly quota needs that quarter’s credited sales. If your plan measures annual recurring revenue, use that measure on both sides. Pipeline opportunities still waiting to close belong in a separate forecast.

With the calculator’s example inputs:

• Sales quota is $200,000.
• Closed revenue is $150,000.
• Commission rate is 8%.
• Bonus at quota is $2,000.

150,000 ÷ 200,000 × 100 = 75%. The revenue gap is 200,000 − 150,000 = $50,000.

A zero quota cannot produce a meaningful percentage. The tool shows “Need a quota” in that case. A positive quota with zero closed revenue gives 0% attainment.

What happens to commission at 100%?

In this model, commission is closed revenue × commission rate. The bonus switches on when closed revenue reaches quota.

At $150,000 closed, the calculation is 150,000 × 0.08 = $12,000. The bonus is zero because attainment is below 100%.

At exactly $200,000, commission is $16,000. Add the $2,000 bonus and modeled pay becomes $18,000. This is the sales-linked payout in the example; base salary and tax are outside the calculation.

At $250,000 closed, attainment reaches 125%. Commission is $20,000 and the same bonus makes modeled pay $22,000. The calculator awards that bonus once. It keeps the commission rate at 8% above quota.

These amounts come from the site’s calculator methodology and the tool’s stated formula. They are example inputs, rather than a market compensation benchmark.

Read your compensation agreement for accelerators, caps, split credit, draws, or clawbacks. The quota tool leaves those out. The sales commission calculator covers a different commission setup; choose the model that matches your plan.

How do I calculate team quota attainment?

Add revenue first. Add quotas separately. Then divide the totals.

Suppose one person closes $90,000 on a $100,000 quota. Their attainment is 90%. Another closes $150,000 on a $300,000 quota, reaching 50%.

The team closes $240,000 against $400,000 of quota. Team attainment is 60%.

A plain average of 90% and 50% gives 70%. That answers a different question: the average person’s attainment, with each person weighted equally. The team’s revenue target gives more weight to the larger quota.

The zero commission and bonus inputs keep this card focused on team attainment. Individual compensation needs each person’s plan.

Can attainment tell me how many orders I need?

Start with the remaining revenue gap and an assumed order value. A $50,000 gap at $500 per order would take 100 additional orders. At $400 per order, it takes 125.

That is scenario arithmetic. Actual deal sizes and close dates can change. Use the average order value calculator to calculate your own period’s average. The article on calculating average order value explains what goes into that number.

For visitor-driven sales, the conversion funnel revenue calculator connects visitors, conversion rate, and order value. It can help you explore the activity needed to produce the remaining revenue.

Keep the original quota beside any revised forecast. Changing the target changes the attainment percentage even when closed sales stay the same. For example, $150,000 is 75% of $200,000, but 100% of $150,000. Record which target you used when comparing periods.

These calculators provide planning estimates. They do not determine contractual compensation or provide personalized financial advice. Enter the quota and credited sales from your own reporting period to check your attainment.