
Sales Quota Calculator: Set Quotas & Track Attainment
Free sales quota calculator: set a realistic quota from OTE, capacity and pipeline, then track quota attainment, pace and the gap to 100%. No sign-up.
Out of the box, the first tab acts as a quota attainment calculator. Month, Quarter and Year presets load 22, 65 and 260 selling days, which you can trim for UK bank holidays, and a units mode handles quotas counted in deals rather than pounds.
Sales quota formulas, worked in pounds
Each figure in the tool comes from a short formula. The worked example uses the default inputs: a £250,000 quota for the quarter, £140,000 booked after 40 of 65 selling days, £300,000 of open opportunities and a 25% win rate.
Quota attainment (percent to quota)
Attainment is revenue closed divided by quota, multiplied by 100; some teams call it percent to goal or sales quota percentage. Here, £140,000 ÷ £250,000 gives 56%, which leaves £110,000 to find before the quarter closes.
Attainment adjusted for pace
Pace compares attainment with the share of the period already used. With 40 of 65 selling days gone, 61.5% of the quarter has elapsed, so the rep sits 5.5 points under an even run, which is £13,846 below where a straight line would put them.
Carrying on at £3,500 a selling day would end the quarter on £227,500, or 91% of quota. Recovering the shortfall in the 25 remaining days takes £4,400 a day, or £22,000 a week. Teams whose quarters tend to land late should read the pace figure with that habit in mind.
Pipeline required to reach quota
Required pipeline is the outstanding shortfall divided by the win rate. At 25%, the £110,000 still missing calls for £440,000 of pipeline able to close inside the period. The £300,000 currently open is worth £75,000 once weighted, covering 68% of the shortfall, so roughly another £140,000 of pipeline has to be generated.
For a full-quarter projection that blends weighted pipeline with run rate, switch to the sales forecast calculator.
Setting a sales quota a UK team can defend
A sales quota is the revenue a rep is expected to bring in over a set period. The safest number is one that holds up under more than one method, as the default Mid-Market AE example shows:
- OTE × ratio: £180,000 of OTE at 4.5× produces an £810,000 annual quota, which means an 11.1% commission rate on £90,000 of variable pay.
- Top-down: an £8,000,000 team target with 10% over-assignment, shared between 10 fully ramped reps, comes to £880,000 each.
- Bottom-up capacity: £40,000 average deals × a 22% win rate × 9 qualified opportunities a month × 12 months comes to £950,400.
Base the number on capacity, not last year plus a percentage
Uplifting last year's figure by a flat percentage says nothing about what a rep can actually close. Capacity is the sense check: in this example it covers 117% of the £810,000 quota, so current deal flow can carry the target. Where capacity falls short, the levers are opportunity volume, win rate or the quota itself.
To find out which input moves revenue most, put the same figures into the sales velocity calculator.
Pro rata quotas for ramping reps and mid-year joiners
A new account executive rarely carries a full number from day one, and Bridge Group's research on US sales teams puts AE ramp time at 6.2 months. The calculator counts the first half of the ramp at 50% of quota, the second half at 75% and full quota after that. Someone joining in April on a six-month ramp therefore carries 56.25% of the annual figure in year one, which is £455,625 rather than £810,000.
An April start also lines up with the UK tax year, which runs from 6 April to 5 April (6 April 2026 to 5 April 2027 for the current one). A quota year does not have to follow it, and many organisations set quotas on their own financial year instead.
Putting the quota in writing: what UK employment law expects
A quota is rarely just a sales target for a UK rep. When commission is calculated against it, the quota becomes part of how pay is worked out, and that brings the written statement of employment particulars into play.
Gov.uk guidance says employers must give a principal written statement on an employee's first day, covering at least how much and how often the person will be paid. The Employment Rights Act 1996 (section 1(4)) adds that the statement sets out the scale or rate of remuneration, or the method of calculating it, and the intervals at which it is paid.
For a commission scheme, a sensible reading is that the calculation method belongs in writing from the start: the quota or the way it is set, the commission rate, any accelerators above 100% and the pro rata rule for new starters. Under the same gov.uk guidance, the wider written statement follows within two months of the start date.
Changes matter too. Gov.uk guidance says employers must tell employees or workers about any change to the written statement within one month of making it. Whether a new quota or a revised rate counts as such a change, and how much detail the statement must hold rather than a separate plan document, are legal questions, so take advice from an employment lawyer before issuing or amending a plan.
When a scheme does change mid-year, our guide on how to communicate a new commission plan covers the conversation with the sales team.
Two pay rules that sit alongside the quota
Gov.uk guidance says sales commission counts towards minimum wage pay, and the National Living Wage for workers aged 21 and over has been £12.71 an hour since April 2026. Since 1 January 2024, commission linked to the tasks a rep is contractually required to do also feeds into normal holiday pay, while an annual quota bonus counts or not depending on its nature. Check edge cases, such as a low basic salary in a month without deals, with an employment lawyer.
Quota-to-OTE ratio: what does good look like?
Divide the annual quota by on-target earnings and you get the quota-to-OTE ratio, which expresses the revenue each pound of OTE is expected to generate.
No official UK benchmark exists for this ratio, so the usual reference is American. According to Bridge Group's 2026 AE report, which draws on US data, the median US account executive carries a $960K quota against a $200K OTE, a 4.6× ratio that has risen from 4.2× in 2024. Over that time, US quotas grew by roughly 2.4% a year and OTE by roughly 4.9%.
Use that median as a point of comparison rather than a target for a UK team, because average deal size, cycle length and win rate decide what a rep can realistically carry. To work out the pay side of the ratio in pounds, use the ote calculator.
What counts as good quota attainment?
For one rep, 100% is the threshold that matters. For a sales leader, the more useful question is how many of the team clear it, and Bridge Group's US figures show 48% of reps reaching their annual quota in 2026, compared with 51% in 2024.
Reps themselves are not especially confident either. Salesforce's State of Sales report found that only 18% of reps surveyed expected to finish exactly on 100% of quota this year, while 17% expected to go past it.
Spendesk, whose commission plans cover teams in France, Germany, Spain, Italy and the United Kingdom, reached an average individual performance of 123% in 2022, as its customer story explains. For benchmarks and practical ways to lift attainment, see our guide to sales quota attainment.
Why a team average can hide misses
An average blends the strongest performers with reps well short of target. In the calculator's team example, six reps average 101%, yet only three of them made quota, because results of 150% and 121% lift the mean. Look at the share of reps at quota alongside the average before resetting quotas across the board.



