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

Sales Forecast Calculator: Weighted Pipeline & Growth

Free sales forecast calculator: project revenue from your weighted pipeline or growth rate, see your gap to quota, and estimate the commission cost.

By
·
October 2, 2026

How to use this sales forecast calculator

The sales forecast calculator works in two modes. Pipeline mode weights each open stage by its win probability to forecast the month or quarter in progress. Growth mode projects your run-rate forward with compound growth. In both modes, you see whether the target is within reach and how much commission it would trigger.

01

Pick a mode, a currency and a period

Use pipeline mode for the month or quarter you are in, and growth mode for a budget or a financial-year plan. Select pounds sterling or another currency, then choose monthly, quarterly or annual periods. Monthly periods match the pay cycle of most UK employees.

02

Load your pipeline or your revenue history

In pipeline mode, enter the open value and the win probability of each stage. The five stages loaded by default are an illustration you can rename or delete, not a UK benchmark. In growth mode, type current revenue and a growth rate, or paste between 3 and 12 past periods and let the tool derive the rate.

03

Check the gap, the coverage and the commission bill

Set commit, most likely and best case against quota, see how well the open pipeline covers the remainder, then enter an effective commission rate. Share the scenario through a link, or download it as a CSV file for your own spreadsheet.

What the calculator models

From the probability on each stage to the commission it would cost, every part of the forecast sits on one screen.

01

Stage-by-stage pipeline

Create, rename or delete stages, give each one an open value and a win probability, and record the revenue already closed-won.

02

Commit, most likely and best case

A commit threshold splits the forecast into three scenarios that you read side by side.

03

Distance to quota and coverage

Each scenario shows its shortfall or surplus against quota. The coverage ratio tells you how many times the open pipeline covers the revenue still to close.

04

Growth taken from your own history

Project a run-rate with compound growth across as many as 36 periods, or let the tool work out the growth rate from past revenue.

05

Commission bill and forecast accuracy

Apply one effective commission rate to all three scenarios, then set last period's forecast against what actually closed to measure accuracy and bias.

Sales Forecast Calculator

Forecast the period from your weighted pipeline, or project revenue from a growth rate. Then check the gap to quota and the commission cost.

Period
Open pipeline by stage
StageOpen amountWin %
Run-rate & growth
Commission cost of this forecast

Need a full budget by role, with attainment bands and accelerators? Use the sales commission budget calculator.

Forecast accuracy check
Forecast
0
Gap to quota
0
Pipeline coverage
0
Commission cost
0
Open vs weighted pipeline by stage
Forecast scenarios

Four numbers sit at the top of the results: the most likely forecast, the distance to quota, the pipeline coverage ratio and what the forecast would cost in commission. A scenario table then sets commit and best case side by side. In growth mode, a period-by-period table shows a conservative, an expected and an aggressive projection.

The formulas behind each sales forecast

Underneath the results, the calculator writes out each formula with the figures you entered.

Weighted pipeline by opportunity stage

Forecast = closed-won to date + Σ (open value in each stage × that stage's win probability). A £300,000 opportunity sitting in a 60% stage contributes £180,000. Individual deals will close or slip, but over a large enough pipeline the gains and losses even out.

The commit threshold drives the three scenarios. Commit counts only the stages at or above the threshold, at their weighted value. Most likely takes the whole weighted pipeline. Best case treats commit stages as certain, at 100%, while earlier stages stay weighted.

Run-rate with compound growth

Revenue in period n = current revenue × (1 + g)^n, with g the growth rate for one period. Because growth compounds, 3% a month for 12 months raises the monthly run-rate by roughly 42.6% rather than 36%. To derive g from your history, the tool uses (last period ÷ first period)^(1 ÷ (number of periods − 1)) − 1.

Gap to quota and coverage ratio

Gap to quota = forecast − quota. Pipeline coverage = open pipeline ÷ (quota − closed-won), in other words the number of times the open pipeline covers the revenue still needed. A comfortable ratio can still fall short when most of it sits in early stages such as discovery.

When the quota itself looks unrealistic, work backwards from team capacity with the sales quota calculator.

Worked example: a mid-market SaaS quarter in pounds

Picture a UK SaaS team with a £1,000,000 target for the quarter, of which £300,000 is already closed-won. A further £1,950,000 is open across five stages. The calculator opens with these figures, so every number below can be reproduced on screen.

  • Discovery: £600,000 × 10% gives £60,000 weighted
  • Qualification: £450,000 × 20% gives £90,000
  • Solution demo: £380,000 × 40% gives £152,000
  • Proposal: £300,000 × 60% gives £180,000
  • Negotiation: £220,000 × 80% gives £176,000

Once weighted, the open pipeline is worth £658,000. Adding the £300,000 already won gives a most likely forecast of £958,000, which is 95.8% of target and £42,000 short. The team still needs £700,000, so coverage stands at £1,950,000 ÷ £700,000 = 2.8×.

With the commit threshold at 60%, only Proposal and Negotiation count towards commit, which comes to £656,000 including closed-won. Best case climbs to £1,122,000. At an effective commission rate of 10%, the commission bill would be £65,600 on commit, £95,800 on the most likely figure and £112,200 on best case.

Growth mode applies the same reasoning to a run-rate. Starting from £250,000 a month and growing 3% each month, revenue reaches £356,440 in month 12. The twelve months total £3,654,448, which clears a £3,500,000 annual target.

Forecasting against the UK payroll calendar and tax year

A UK sales forecast has to line up with three calendars: the payroll month, the company's financial year and the tax year that HMRC works to. Aligning them is what turns a revenue forecast into a cost forecast that Finance can book.

Most UK pay runs are monthly

ONS figures from the Annual Survey of Hours and Earnings show that 77.6% of UK employee jobs had a monthly pay period in April 2021, against 11.6% weekly, 9.3% four-weekly and 1.5% fortnightly (provisional data). A sales team on monthly pay has one payroll cut-off a month for the commission earned on closed deals. Forecasting by month shows what each pay run is likely to carry.

The tax year and the financial year are separate calendars

The UK tax year runs from 6 April to 5 April, and the current one ends on 5 April 2027. A company's financial year is set by the company and does not have to match it. Quotas and forecasts follow the financial year, whereas payroll follows the tax year, with rates and thresholds that change every 6 April.

Commission earned in March, paid after 6 April

HMRC's employer guidance (CWG2) treats commission paid on a separate payday as part of total pay at the time it is paid, no matter when it was earned. A commission earned on a March deal and paid after 6 April therefore falls into the next tax year for National Insurance purposes. For 2026/27, employer Class 1 National Insurance is 15% above the secondary threshold, so the cost of a commission to the business is higher than the payout itself. Check edge cases with your payroll provider or accountant.

Which sales forecasting method suits your team?

No single method is right for every team: the choice depends on how far ahead you are looking and which data you trust. Many B2B revenue teams cross-check two methods.

Weighted pipeline

Relies on a well-kept CRM where every opportunity moves through the same stages. It is the strongest method for the month or quarter in progress, when most of the revenue you need is already visible.

Run-rate and historical growth

Requires between 3 and 12 periods of revenue history. It suits the annual budget, headcount planning and the financial-year plan, all of which look beyond the visible pipeline.

Sales cycle and velocity

Uses average deal value, win rate and cycle length to test whether the open pipeline can close before the period ends. The sales velocity calculator works through that angle.

Machine-learning and multivariable models bring in extra signals, such as deal age or buyer engagement, yet they draw on the same CRM records. Our guide to forecasting techniques compares the options in detail.

The article on effective sales forecasting covers the data and review habits that keep any of these methods reliable.

Improving forecast accuracy

Many sales organisations lack confidence in their own forecast. A 2020 Gartner survey found that only 45% of sales leaders and sellers had high confidence in their organisation's forecasting accuracy. Three practices close much of that gap.

Base stage probabilities on your own win rates

Swap the illustrative probabilities for your historical stage conversion: the opportunities that reached a stage and were won, divided by every opportunity that reached it. Review the figures each quarter, and keep separate sets for segments where deal values vary a lot.

Track forecast accuracy and bias

Forecast accuracy = 1 − |forecast − actual| ÷ actual. Forecasting £900,000 and closing £850,000 gives an accuracy of 94.1% and an over-forecast of 5.9%. Record the direction of the error as well, because optimistic forecasts and sandbagging call for different remedies.

Keep commit, best case and pipeline apart

A single forecast number conceals the risk behind it. Reading the three scenarios together shows how much of the target still relies on opportunities that have not reached a late stage.

Turning the revenue forecast into a commission and accruals forecast

Every pound of forecast revenue that closes creates variable pay, which makes a sales forecast a cost forecast too. Finance needs that figure before the payroll cut-off and before the month-end close.

Put a cost on each scenario

Multiply each scenario by your effective commission rate, which is either total commission paid divided by revenue, or variable pay at target divided by quota. The calculator applies that rate to commit, most likely and best case. To budget by role, with attainment bands and accelerators, move on to the sales commission budget calculator.

Commission accruals at month-end and year-end

Commission is usually earned in one month and paid in a later payroll. Finance records an accrued commission for the amount earned but not yet paid, and the forecast gives an early view of how large that accrual will be. The largest accrual often falls at the financial year-end, when the last quarter's deals are still waiting for payroll.

The accrual may also need to cover employer National Insurance and pension contributions, since commission counts as earnings for workplace pension auto-enrolment under the Pensions Act 2008. Check the exact treatment with your accountant.

Groups reporting under IFRS 15, or under revised FRS 102 where they choose to, may also capitalise some commissions as costs of obtaining a contract. The saas commission calculator explains that treatment, and your accountant can confirm the policy that applies.

Excel template or online calculator?

A sales forecast template in Excel or Google Sheets does the job once the model is fixed. The weighted pipeline is a SUMPRODUCT of values and probabilities, compound growth is =start*(1+rate)^n, and FORECAST.LINEAR draws a straight trend through past periods.

While the assumptions are still moving, a sales forecast calculator is quicker: change one probability or growth rate and all three scenarios recalculate at once. Export the result to CSV and paste it into the spreadsheet that Finance already uses.

From calculator to automation

Automating the step from sales forecast to commission payout

The forecast tells you what the quarter should bring in. The next question is what it will pay out: commission per rep, the accrual Finance books at month-end and the earnings each seller can expect if the pipeline closes as planned.

Qobra reads deals from your CRM and turns them into commission under your actual scheme rules, including thresholds, accelerators and splits. Revenue teams can simulate payouts scenario by scenario, give every rep a live view of forecasted earnings and hand Finance accrual reports that match the next payroll export.

With Qobra, a single scheme can pay a London rep in GBP and a New York rep in USD. Qobra has also had a UK office since June 2024.

Forecast your commissions with Qobra →
Commission cost for every scenarioSee what commit, most likely and best case would each pay out, calculated under your real scheme rules.
Live forecasted earnings for repsEvery seller can check, at any time, what they stand to earn if the pipeline closes as forecast.
Accruals that match payrollMonth-end accrual reports come from the same deals and rules as the commission that will reach the payslip.

Sales forecasting FAQ

How do I calculate a sales forecast?

Start with revenue already closed-won, then add the weighted open pipeline: multiply the open value of each stage by its win probability and add the results together. Over a longer horizon, project the run-rate instead with revenue × (1 + growth rate)^n. A sales forecast calculator runs both methods and shows the remaining gap to quota.

Which forecasting method works best for sales teams?

The answer depends on the horizon and on how reliable your data is. When CRM stages are well maintained, a weighted pipeline gives the sharpest view of the month or quarter in progress. Historical growth is better suited to annual budgets and financial-year plans. Running both is a useful check, because a large difference between them often reveals a pipeline or data quality problem.

How is a weighted pipeline forecast calculated?

Each open stage or opportunity is multiplied by its win probability, and the products are added up. £300,000 at 60% plus £220,000 at 80% gives £180,000 + £176,000 = £356,000 of weighted pipeline. Closed-won revenue is then added to reach the forecast for the period. The probabilities should come from your own stage-by-stage win history.

How do I build a sales forecast in Excel?

Place values and win probabilities in two adjacent columns, apply =SUMPRODUCT(values, probabilities) and add revenue already closed-won. For growth, enter =start*(1+rate)^n on each period row, or let FORECAST.LINEAR fit a straight trend to past figures. Another option is to model the forecast in this calculator and download it as a CSV file.

Can AI forecast sales?

AI models can take in signals that a stage probability misses, such as how long a deal has been open or how active the buyer is, and they can flag opportunities at risk. Their output is only as good as the CRM data behind them. A transparent baseline, such as a weighted pipeline or run-rate forecast, gives sales leaders something to test the model against.

What are the 7 steps of forecasting?

The usual sequence runs as follows: set the objective and horizon, collect historical and pipeline data, clean it, select a method, produce the forecast, review it with sales leadership, then compare it with actual results and adjust. That final comparison is what refines stage probabilities and growth assumptions from one period to the next.

How is sales forecast accuracy measured?

Sales forecast accuracy = 1 − |forecast − actual| ÷ actual. A forecast of £900,000 against £850,000 closed gives 94.1%. Bias, calculated as (forecast − actual) ÷ actual, shows whether the team leans towards over- or under-forecasting. Measuring both at each period end, and by segment, makes the trend visible.

How does a sales forecast affect commission costs and accruals?

Commission moves with the forecast, so multiplying the forecast by the effective commission rate gives the variable pay the period should trigger. A £958,000 forecast at a 10% effective rate implies about £95,800 of commission. In the UK, employer National Insurance is added when that commission is paid, and commission earned but unpaid at month-end is usually accrued. Accelerators and tiers push the cost up faster once reps go beyond quota, so check every scenario.

By
·
October 2, 2026