How to Calculate Quota Attainment for Reps Teams and Ramping Sellers

What is the quota attainment formula?

Divide closed bookings by assigned quota for the same period and express the result as a percentage.

``` Quota attainment = Closed bookings in period / Assigned quota for period ```

A rep who closed $420,000 against a $500,000 quota attained 84%. The arithmetic is simple. The errors come from the definitions on either side of the division.

The numerator has to match the basis the quota was written in. If the quota was set on new ARR, count new ARR. If it was set on total contract value, count total contract value. Renewals belong in the numerator only if they were in the quota. The denominator has to reflect the quota the rep actually carried during the period, including any mid-period adjustment for a territory change or a leave of absence.

How do you calculate team attainment correctly?

Sum the closed bookings across the team and divide by the sum of assigned quotas, rather than averaging the individual attainment percentages.

The two methods give different answers whenever reps carry different quota sizes, which is almost always. Averaging percentages weights a rep carrying a $250,000 quota the same as one carrying $1,200,000. Summing the dollars first gives you the number that actually matters, which is how much of the team's committed revenue arrived.

``` Team attainment = Sum of closed bookings / Sum of assigned quotas ```

Report both if you want, but treat the dollar-weighted figure as the one that describes the business. The average of percentages describes how the roster felt.

How do you handle ramping reps?

Prorate the quota by the ramp schedule, then measure attainment against the prorated number.

A rep in month three of a six-month ramp is not carrying a full quota, and holding them to one produces an attainment figure that says nothing about performance. Publish the ramp factors before the period starts and apply them consistently.

Against full quota, Rep C would show 28% attainment and look like a problem. Against the ramp-adjusted number, they are ahead of schedule. Rep D is the one who needs attention, and the unadjusted view would have buried that.

For capacity planning, the same ramp factors feed the coverage model. Total ramp-adjusted quota is the number your pipeline has to cover, not the sum of full quotas across the roster.

Why does the attainment distribution matter more than the average?

Because two teams with identical average attainment can carry completely different levels of risk.

Take a 10-rep team averaging 92%. In one version, eight reps land between 80% and 105% and two land near 70%. The number is broadly distributed and the next quarter is predictable. In the other version, two reps attain 200% and the remaining eight sit at 65%. Same average, and the second team is one departure away from a severe miss.

Plot attainment as a distribution every quarter. Track the share of reps above 100%, the share between 70% and 100%, and the share below 70%. Movement between those bands is a leading indicator for the following quarter, and it shows up before any pipeline metric reacts.

How does attainment history improve the forecast?

Rep-level attainment patterns are stable enough to use as a check on what reps are committing.

If a rep has attained between 70% and 85% in each of the last six quarters, a commit implying 135% attainment is a claim that requires evidence. It may be true, since a single large deal can change a rep's quarter. It is still worth testing against the deal-level detail before it goes into a roll-up.

The same logic runs in reverse. A rep who consistently attains above 100% while committing conservatively is sandbagging, and their commit needs an upward adjustment rather than a challenge. Both patterns are visible in attainment history and invisible in a single quarter's numbers. This is one of the inputs that separates a defensible forecast from a stack of rep opinions, covered further in how to forecast revenue.

What distorts quota attainment numbers?

Mid-period quota changes, split credit, and timing rules that let deals count twice or not at all.

Mid-period quota changes are the most common distortion. When territories move in week six of a quarter, both the old and new owner have partial claims on the pipeline, and if quotas are not restated the attainment math breaks for both. Restate the quota at the point of change and document it.

Split credit needs a written rule. If two reps each receive full credit for a $300,000 deal, team attainment counts $600,000 of bookings that produced $300,000 of revenue. Decide whether credit splits or duplicates, then apply it the same way every period.

Timing is the third. A deal signed on the last day of the quarter but booked in the following period will either inflate or deflate attainment depending on the rule you use. Pick close date or booking date and never mix them inside one report.

How often should quota attainment be measured?

Monthly for the trend, quarterly for compensation, and continuously for the reps who are furthest from plan.

Waiting until the quarter closes to look at attainment means the only available response is a post-mortem. Track pace against a monthly expectation instead. Quarters are not linear, and in most B2B SaaS businesses the third month of the quarter is stronger than the first two, so a rep at 40% attainment entering month three may be on a normal path while a rep at 40% entering the final two weeks is not.

Seasonality applies at the year level as well. Q2 and Q4 tend to run stronger than Q1 and Q3, so comparing a Q1 attainment figure against a Q4 figure without adjusting for that pattern will lead you to the wrong conclusion about a rep. Compare the same quarter year over year, and read the distribution alongside the average. Attainment history also belongs next to your win rate analysis, since the two together explain whether a shortfall came from volume or from conversion.