Map Extract
Free tool

Quota attainment: where you are, and where you will finish

Halfway through a month or quarter, the useful questions are how far through the quota you are, whether you are ahead of or behind the pace you need, where you will land at the current rate and how much you must close each remaining day. Enter the quota, what is closed, selling days, pipeline and your commission rates, and every answer appears together.

Runs in your browser. Nothing you enter is uploaded.

Checking progress against quota

  1. Enter the quota and what is closed

    Quota for the period and Closed so far, in pounds.

  2. Enter the selling days

    Selling days in the period (about 63 in a typical quarter of working days) and Selling days gone. These set the pace you should be at and the days left to close the gap.

  3. Add pipeline and win rate

    Open pipeline and the Win rate on pipeline you usually achieve. The calculator weights the pipeline and shows how much of the gap it covers.

  4. Add commission rates (optional)

    A commission rate, the attainment where an accelerator starts and the accelerated rate for sales above that point. Commission so far and at forecast are then shown.

  5. Read the results

    Attainment, forecast at the current pace, sales needed per remaining day and pace against plan, with a sentence giving the run rate, gap, pipeline cover and commission.

Example: a rep 35 days into a 63-day quarter

A sales rep at a small software firm has a £36,000 quarterly quota and has closed £14,500 after 35 of 63 selling days. She has £40,000 of open pipeline and usually wins 30% of it. Her plan pays 10% commission, rising to 15% on sales above quota.

She is at 40.3% of quota while 56% of the quarter has gone, so her pace is 72.5% of plan. At the current run rate she finishes on £26,100. She needs £767.86 a day for the remaining 28 days, and the weighted pipeline of £12,000 covers only 56% of the £21,500 gap, which says she must add new opportunities, not just work the existing ones.

Input
Quota: £36,000   Closed: £14,500   Selling days: 63   Days gone: 35
Open pipeline: £40,000   Win rate: 30%   Commission: 10%   Accelerator from 100% at 15%
Result
Attainment: 40.3%   Forecast at current pace: £26,100.00 (73%)   Needed per remaining day: £767.86   Pace against plan: 73%

Run rate £414.29 a day over 35 days. Gap £21,500.00; weighted pipeline £12,000.00 covers 56% of it. Commission earned so far £1,450.00, £2,610.00 at forecast.

The calculations

ResultFormula
AttainmentClosed ÷ quota
Run rateClosed ÷ selling days gone
ForecastClosed + run rate × selling days left
Pace against planClosed ÷ (quota × days gone ÷ total days)
Needed per remaining day(Quota − closed) ÷ days left
Weighted pipelineOpen pipeline × win rate
CommissionRate on sales up to the accelerator point, plus the accelerated rate on sales above it

Questions people ask

How do you calculate quota attainment?

Divide what you have closed by your quota and multiply by 100. £14,500 closed against a £36,000 quota is 40.3% attainment. To judge whether that is good, compare it with how much of the period has passed: 40% with half the quarter gone is behind, the same figure a third of the way through is ahead.

How do I know if I will hit quota?

Look at the forecast at your current pace and at the pipeline cover. If the run rate projects a finish below quota and the weighted pipeline covers less than the gap, you need new opportunities, a better win rate or bigger deals. The daily figure tells you how much must close each remaining day.

How many selling days are in a quarter?

Around 63 to 65 working days in most UK quarters, depending on bank holidays. Use the days you actually sell, leaving out holidays, training and events, so the run rate and daily target reflect your real time.

How is commission with an accelerator worked out here?

Sales up to the accelerator point (by default 100% of quota) earn the normal rate, and only sales above it earn the higher rate. With a £36,000 quota, 10% normally and 15% above quota, £43,200 of sales earns £3,600 plus £1,080, or £4,680. Your actual plan may calculate differently; check its wording.

Where your data goes

Your quota, sales and commission figures are calculated in your browser. Nothing is uploaded or stored.

Checked against the tool on

Top