
Sales Velocity Calculator: From Pipeline to Quota
Free sales velocity calculator: enter opportunities, deal size, win rate and sales cycle to get revenue per day, per rep and your gap to quota.
Four definitions keep the inputs consistent. A qualified opportunity is an open deal that has passed your qualification stage. Average deal size means the first-year contract value (ACV) of deals won recently. Win rate is won deals divided by won plus lost deals, with open deals left out. Sales cycle length counts the days from opportunity creation to closed-won, averaged across won deals.
The output is revenue per day. Multiplied by 30, 90 or 365 days, it gives projected revenue for the month, the quarter or the year. Quota coverage divides that projection by team quota, while the chart and the two tables show the day the team crosses quota and what would bring that day forward.
The sales velocity formula, worked through in pounds
Behind every figure sits a single equation: sales velocity equals qualified opportunities multiplied by average deal size and win rate, divided by the length of the sales cycle in days.
Our guide to the sales velocity formula covers each factor, its variants and its traps in more depth.
A mid-market team over one quarter
Picture a UK software team with 200 qualified opportunities, deals worth £12,000 on average, a 30% win rate and a 60-day cycle. Velocity is (200 × £12,000 × 0.30) ÷ 60, or £12,000 a day. Over a 90-day quarter, that pipeline produces £1,080,000. Ten reps each holding a £120,000 quarterly quota add up to £1,200,000, so the pipeline covers 90% of target and leaves £120,000 to find.
A smaller inbound team
An SMB inbound team runs on different numbers. With 150 opportunities at £4,000, a 25% win rate and a 30-day cycle, velocity is £5,000 a day, or £450,000 over a quarter. Against eight reps on a £60,000 quarterly quota each (£480,000 in total), the pipeline covers just under 94% of target.
Sales velocity in Excel or Google Sheets
Type opportunities in cell B1, deal size in B2, win rate as a percentage in B3 and cycle length in B4, and the formula =(B1*B2*B3)/B4 returns velocity. Scenarios, quota coverage and the reverse calculation are where a spreadsheet becomes fiddly, and the calculator handles all three.
What does a good sales velocity look like?
No single figure counts as good, because velocity grows with deal size and headcount. A healthy number improves on your own baseline and is high enough to cover quota.
The most useful comparisons are internal: this quarter against the same quarter last year, inbound against outbound, SMB against mid-market, and each rep against the team. There are no official UK statistics on sales cycles, win rates or velocity, so treat any outside benchmark as background rather than as a target for a British team.
Which lever lifts sales velocity fastest?
Opportunities, deal size and win rate sit on top of the fraction, and the sales cycle sits underneath. Raise any of the top three by 10% and velocity grows by exactly 10%. Cut the cycle by 10% and it grows by 11.1%, since 1 ÷ 0.9 = 1.111. Move all four by 10% at once and the gain compounds to 47.9%. The lever simulator runs the same arithmetic on your own pipeline.
More qualified opportunities
Extra volume only helps while qualification standards hold. A shared framework such as MEDDPICC stops weak deals from padding the count.
Bigger deals
Bundled products, upsell at the point of signature and a firm discounting policy all lift average deal size. Heavy discounting tends to buy a quicker signature at the cost of contract value.
Higher win rate
Win rate rises when reps qualify sooner, drop poor-fit deals faster and bring the economic buyer in earlier.
Shorter sales cycle
Mutual action plans, early involvement of the customer's legal and procurement teams, and a dated next step on every deal all take days off the cycle. Our guide on how to shorten the sales cycle covers further tactics. Ebsta's 2023 B2B Sales Benchmark report, built on 3.2 million opportunities and not specific to the UK, found that deals left open for more than twice the average cycle had only a 3% chance of closing.
From sales velocity to quota: targets your reps can reach
Capacity is velocity per rep multiplied by the days in the period. In the SMB inbound example, £5,000 a day across eight reps is £625 per rep per day, or £56,250 over a 90-day quarter, which is 6.25% below a £60,000 quarterly quota.
The path-to-quota table turns that shortfall into one target per lever: 10 more qualified opportunities, about £267 more per deal, 1.7 extra points of win rate or 1.9 fewer days of cycle. Choose the lever your team can genuinely move, then test it against your sales quota attainment history.
Most UK employee jobs are paid monthly (77.6% in the ONS's April 2021 survey), so commission usually reaches reps through a monthly payroll even when quotas are quarterly. A monthly velocity reading shows early whether the quarter, and the commission that will appear on payslips, is on track.
To build quotas from capacity and ramp time, use our sales quota calculator.
How your commission scheme shapes sales velocity
Reps pull the levers their commission scheme rewards, so each of the four inputs needs a matching element in the plan.
- Deal size: an ACV-based rate with accelerators above target favours larger first-year contracts over long, heavily discounted terms.
- Sales cycle: a short SPIF, limited to deals closed within the month or the quarter, brings customer decisions forward.
- Win rate: when reps can see what each deal will pay, they spend their time on the deals they can actually win.
- Opportunities: paying SDRs on qualified meetings rather than raw leads protects both pipeline volume and quality.
A faster pipeline also means a bigger variable pay bill. Switch on the commission projection to price each scenario, then model tiers and accelerators with the commission calculator.
The projection shows gross commission. HMRC guidance treats commission as earnings that go through payroll with PAYE and National Insurance, so the employer's cost is higher than the amount shown. Our OTE calculator works through that payroll side.
Sales velocity vs pipeline velocity vs deal velocity
The three terms overlap, so agree a single definition and use it across the organisation.
- Sales velocity: the revenue the pipeline generates each day, calculated with the four-factor equation on this page.
- Pipeline velocity: frequently used as a synonym, although some teams reserve it for how quickly deals progress from one stage to the next.
- Deal velocity: how long a single deal takes to close. It feeds the sales cycle input but says nothing about deal size or win rate.
Velocity describes the pace of the whole pipeline rather than the outcome of specific deals. For a view of which open deals should close this period, build a weighted pipeline in our sales forecast calculator.
Choosing the period for a UK sales team
Pick the period your sales plan is measured on. A month suits a team paid commission every month, and a quarter suits quarterly quotas. A year is the better choice when the cycle runs longer than a quarter: with the enterprise preset's 120-day cycle, the calculator warns that most of today's pipeline will close after a 90-day quarter has ended.
Keep the plan year and the tax year apart. The UK tax year runs from 6 April to 5 April, with the current one ending on 5 April 2027, and it frames payroll records such as each rep's P60. A company sets its own financial year, which need not match the tax year, so velocity periods should follow the plan year on which quotas are set.
Five mistakes that distort sales velocity
- Mismatched time windows: last year's win rate, last quarter's cycle and this week's pipeline do not describe any real period.
- Unqualified opportunities in the count: early-stage leads inflate volume and hide a weaker win rate.
- Lifetime value in place of ACV: renewals fall outside the sales cycle, so using lifetime value overstates velocity.
- One average for every segment: SMB and enterprise deals differ in both size and cycle, so run each segment separately.
- Slipped deals left out: deals pushed into the next quarter lengthen the real cycle, which is why the inputs should be refreshed every month.



