Sales Quota Attainment Calculator

Quota attainment is the percentage of a sales target achieved over a defined period. It divides the booked sales credited to a representative, team or territory by the target set for that same scope and period. Sales managers use it in pipeline reviews, compensation discussions and capacity planning; representatives use it to know how far they are from their objective. It only means something when the sales figure and the target follow the same revenue definition and crediting rules.

Divide the actual booked sales credited for the period by the sales target for the same period, then multiply by 100. The denominator is the target, so the result tells you how much of the target has been covered. A result of 100 % means the target was met exactly; above 100 % means it was exceeded, which is perfectly valid.

The calculator also shows two amounts in currency: the remaining to target (target minus actual, never below zero) and the amount above target (actual minus target, never below zero). Only one of them can be positive at a time. The target must be greater than zero; with a zero target the percentage has no meaning.

What each term means

Actual booked sales

Eligible won/booked revenue credited to the target.

Where to find it: Sum of won deals credited to this person, team or territory whose booking date falls inside the period, taken from a CRM closed-won report. Use the same revenue definition as the target (for example booked contract value, excluding taxes) and apply your split-credit rules.

Sales target

Amount the business or representative aimed to sell.

Where to find it: The target assigned for exactly the same scope and period, in the same currency. If the target changed during the period, use the version your compensation or review rules say applies. Must be greater than zero.

Quota attainment

Actual booked sales ÷ sales target × 100. Above 100 % is valid.

Hypothetical example: a representative has a quarterly target of 100,000 and has 125,000 of booked sales credited for the quarter.

1. Quota attainment125,000 ÷ 100,000 × 100 = 125%

Quota attainment = 125%

125,000 ÷ 100,000 × 100 = 125 % attainment, which is 25,000 above target and nothing remaining. If credited sales had been 90,000 instead, attainment would be 90 %, with 10,000 remaining to target. Moving the target has the same kind of effect: with a target of 125,000, the same 125,000 of sales would be exactly 100 %.

Hypothetical numbers, used to show the calculation. Not real company data.

Use quota attainment at the end of a period to check results against what was planned, and during the period to see how much remains to be booked. It answers a simple question — how much of the agreed number has been delivered — which makes it the common language of sales reviews.

It is also useful across a team. Looking at how attainment is spread between representatives often says more than the team total: one very large deal can carry a team above 100 % while most people are far below, which points to a coverage or territory problem rather than a team-wide success.

Attainment is a backward-looking measure of credited sales. To estimate where the period will end, combine it with the revenue forecast calculator; to know how much open pipeline the remaining amount needs, use the required pipeline calculator.

The division is trivial; the inputs are not. Two people can report different attainment for the same representative simply because they used different rules. Before comparing figures, write down which accounts and regions belong to the territory, which date counts (booking date, signature date or contract start) and which deal types are included (new business, renewals, expansions).

Split credit is a frequent source of confusion. When two representatives share a deal, decide whether each receives a fraction of the value or both receive full credit. Full credit for both is a legitimate compensation choice, but then the sum of individual attainments no longer adds up to the team’s booked sales, and team attainment must be calculated from the team’s own figures.

Timing and mid-period changes matter as well. A deal signed on the last day of the quarter but entered in the CRM a week later can land in the wrong period. A target that is raised or lowered halfway through, or a territory that is reassigned, changes the denominator. Keep a record of which target version and which territory map applied, and calculate attainment with the same rules every period so the trend stays meaningful.

Below 100 %, the remaining amount is the booked value still needed this period. Read it next to the open deals that can realistically close before the period ends, not next to the whole pipeline.

Above 100 %, the amount above target shows how far results went beyond the plan. It does not prove that the target was well set: very high attainment across a whole team may signal a target that was too low, just as widespread low attainment may signal one that was too high or a territory with too little potential.

Attainment says nothing about margin, discounting, cash collected or customer quality. A team can reach 100 % with heavy discounts or customers who will soon leave, so review it alongside those indicators.

Practical levers

• Agree and document crediting rules (territory, dates, deal types, split credit) before the period starts.
• Track the remaining amount weekly against the open deals that can close in time, not against the total pipeline.
• Review the spread of attainment across representatives to find coverage gaps or territories with too little potential.
• When a target changes mid-period, record the date and the reason, and state which version is used for reviews.

Common mistakes

• Mixing bookings, invoiced amounts and recognized revenue between the actual figure and the target.
• Counting deals booked outside the period, or entered late in the CRM, in the wrong period.
• Summing individual attainments when split deals are fully credited to several people.
• Treating attainment above 100 % as an error or capping it at 100 %.
• Comparing representatives whose territories or targets were set on very different bases.

Scenario comparison

The scenarios move actual booked sales by ±10 % and the target by ±10 % in the unfavourable and favourable direction (a higher target is the conservative case). They are illustrative and show how sensitive attainment is to a few deals or to a target revision.

Use the comparison to see how much margin you really have around 100 %: if a 10 % swing in booked sales moves you from above to below target, the result depends on a small number of deals and should be reported with that caveat.

The calculator assumes both inputs use the same revenue definition, scope, currency and period. It cannot check crediting rules; it only divides the numbers you enter.

Attainment is a point-in-time measure of credited sales. Deals that are later cancelled, reduced or not paid may change it after the fact, depending on your rules.

It does not judge whether the target was realistic. Use your own history of attainment, territory potential and pipeline to discuss target setting.