Sales Compensation Software Benchmark
Download
Diagonal gradient streaks in soft orange, purple, and blue fading into white at the bottom.
Sales Ops
Reading time
9
min

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.

By
·
October 2, 2026

Using this sales quota calculator in three steps

The sales quota calculator covers both halves of the job: following attainment while a period is running, and setting next year's number with three methods you can test against each other. Start from the worked example or enter your own figures; everything recalculates instantly and no data leaves your browser.

01

Follow attainment and pace

Type in the quota, revenue closed so far, selling days already used and the open pipeline. The tool returns attainment, the shortfall, how far ahead of or behind an even pace the rep sits, a projected finish and the daily run rate still required.

02

Build next year's quota

On the second tab, an annual quota is worked out from OTE, from the team target and from what a rep can realistically close, shown together with the share of quota that capacity covers and a pro rata first-year figure for anyone still ramping.

03

Check the whole team

Switch on the team view to enter up to 10 reps and set mean attainment against the share of the team that actually hit 100%.

What the calculator models

Both sides of quota management sit on one screen, from in-period pace to a new starter's ramp.

01

Attainment and pace

See where a rep stands against quota, how much is still missing and whether the period is running ahead of or behind an even pace, with a projected finish at today's run rate.

02

Routes to 80%, 100% and 120%

For each milestone, the tool shows the revenue still needed, the run rate that implies per selling day and per week, and the pipeline required to get there.

03

Weighted pipeline coverage

A win rate applied to open opportunities shows what share of the shortfall the pipeline already covers and how much more needs generating.

04

Three quota methods

OTE × ratio, top-down and capacity quotas sit next to each other, with the proportion capacity can fund and a ramp-adjusted figure for year one.

05

Team attainment

Load up to 10 reps to set mean attainment against the number of people who genuinely made their number.

Sales Quota Calculator

Track quota attainment and pace, or set a quota three ways and compare the results.

Quota measured in
Quota and results
Period
Pipeline
Quota attainment
—
—
Gap to quota
—
—
Pace vs straight line
—
—
Projected attainment
—
—
Cumulative progress over the period
What it takes to reach 80%, 100% and 120%
TargetAmountStill to closePer selling dayPer weekPipeline needed
Compare your team

Average attainment vs share of reps at quota.

RepQuotaClosedAtt.
1 · From OTE
2 · Top-down
3 · Bottom-up capacity
Ramp and proration
Quota to retain
Annual quota
—
—
Funded by capacity
—
—
Quota : OTE
—
—
Year-1 prorated quota
—
—
Three methods side by side
Method comparison
MethodAnnualQuarterlyMonthlyQuota : OTEvs capacity

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.

From calculator to automation

From a one-off calculation to live quota attainment

A calculator captures a single moment. Once a plan is live, attainment shifts every time a deal closes, a split is applied or a territory is redrawn, and it has to follow exactly the crediting rules used for commission.

Qobra connects to Salesforce or HubSpot and works out quota attainment and commission from one set of rules, in real time, in GBP alongside USD or EUR when a plan spans several countries. Reps follow their attainment, their pace and what their next deal will pay, accelerators included. UK RevOps and Finance teams stop rebuilding attainment reports in spreadsheets and hand payroll a clean export instead. Qobra opened its London office in June 2024 and supports UK customers during UK hours.

Book a demo: follow quota attainment live →
Attainment updated deal by dealEvery deal closed in the CRM updates quota attainment straight away, using the same rules as commission.
Pace and pay side by sideReps can see where they stand, whether they are on pace and what their next deal pays, accelerators included.
Spreadsheets retiredRevOps and Finance work from a single rulebook instead of rebuilding attainment reports by hand each month.

Sales quota calculator FAQ

How is a sales quota calculated?

Work it out with at least two methods and compare the results. A pay-based quota is OTE × your target quota-to-OTE ratio. A top-down quota is the team target × (1 + over-assignment) ÷ the number of ramped reps. Rep capacity is average deal size × win rate × qualified opportunities a month × 12. If capacity cannot fund the quota, revisit the inputs, then apply a pro rata figure to anyone joining or ramping during the year.

How do I work out quota attainment?

Take closed revenue, divide it by quota and multiply by 100. £140,000 closed against a £250,000 quota is 56% attainment. Count revenue as your plan credits it, splits included, and use the quota for the same period. Comparing that figure with the share of selling days already used tells you whether the rep is on pace.

Is 120% quota attainment a good result?

Yes. At 120%, a rep has closed a fifth more than quota, which stands out when Bridge Group's US data shows only 48% of reps hitting their annual quota in 2026. Attainment can run above 100%, and most plans reward it with accelerators, a higher commission rate on revenue beyond quota. Check that the quota was realistic, then see what that attainment earns with our commission calculator.

What is a good quota-to-OTE ratio?

Bridge Group's 2026 figures for US account executives put the median at 4.6×, against 4.2× in 2024, which works out at roughly a $960K quota for a $200K OTE. No official UK equivalent is published, so base your own ratio on what reps can produce and test the OTE method against the capacity method before committing.

What does a typical sales quota look like?

No single figure applies to every team, because role, segment and deal size all change the answer. As a US reference, Bridge Group reports a median annual AE quota of $960K in 2026, rising by about 2.4% a year. SDR, account management and enterprise roles carry very different numbers, which is why the calculator builds a quota from your own deal size, win rate and deal flow.

Does a UK rep's quota need to be put in writing?

The Employment Rights Act 1996 (section 1(4)) requires the written statement of employment particulars to set out the rate of pay or the method of calculating it, and gov.uk guidance says the principal statement is due on the first day of employment. When commission depends on the quota, putting the calculation method in writing from the start is the prudent course. How much detail the statement itself needs, and whether a quota change must be notified within one month, are questions for an employment lawyer.

Should quota attainment be tracked monthly, quarterly or annually?

Track it over the same period as the quota, and follow pace within that period. Annual quotas are normally broken into quarterly or monthly targets so managers can step in before the year slips away. Short sales cycles suit monthly tracking and long ones quarterly. The presets load 22, 65 or 260 selling days, which you can reduce for bank holidays.

How much pipeline is needed to hit quota?

Divide the revenue still to close by your win rate. With £110,000 outstanding and a 25% win rate, you need £440,000 of pipeline capable of closing in the period. Your own win rate is a sounder guide than a fixed coverage multiple, and the calculator shows how much of the shortfall your weighted pipeline already covers.

By
·
October 2, 2026