Checking progress against quota
Enter the quota and what is closed
Quota for the period and Closed so far, in pounds.
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.
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.
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.
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.
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%
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
| Result | Formula |
|---|---|
| Attainment | Closed ÷ quota |
| Run rate | Closed ÷ selling days gone |
| Forecast | Closed + run rate × selling days left |
| Pace against plan | Closed ÷ (quota × days gone ÷ total days) |
| Needed per remaining day | (Quota − closed) ÷ days left |
| Weighted pipeline | Open pipeline × win rate |
| Commission | Rate 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