Sales forecasting
Sales forecasting is estimating the revenue your team will actually close in a future period. Done well, it drives hiring, cash-flow and targets. Done badly, it's a spreadsheet nobody believes. Here's how to build one that holds up.
Weighted pipeline, in one line
Everything else — commit calls, best case, coverage ratios — is a check on this number. The formula is trivial; the accuracy comes from clean stages, honest close dates and win rates calculated from your own closed-deal history rather than an industry benchmark.
Four forecasting methods that work
Run at least two in parallel — the gap between them is where your risk lives.
Multiply each open deal by the historical win rate of the stage it sits in. Fast, objective, and the default in most CRMs — but only as accurate as your stage discipline.
Each rep commits to the deals they'll close this period. Captures context a formula can't, but drifts optimistic — always compare commit to weighted pipeline.
Project forward from the last few periods, adjusted for seasonality and headcount. Excellent as a sanity check, poor at spotting a change in the market.
Forecast on deal age relative to your average sales cycle. Removes rep optimism entirely and exposes deals that have quietly gone stale.
How to create a sales forecast in six steps
- 1. Clean the pipeline first
Close out dead deals, re-date stale close dates, and confirm every open deal has a next step. Forecasting a dirty pipeline just adds decimal places to a guess.
- 2. Calculate your real win rate per stage
Take the last 12 months of closed deals and work out what percentage of deals that reached each stage were eventually won. Use your numbers, not a benchmark.
- 3. Apply weighting to open deals
Multiply each open deal's current value by its stage win rate, then sum by close-date period. Split once-off revenue from recurring so MRR isn't overstated.
- 4. Layer in commit and best-case
Run three numbers: commit (deals reps will stake their name on), weighted pipeline, and best case. The gap between them tells you how much risk sits in the quarter.
- 5. Check coverage against quota
Open qualified pipeline divided by quota should be roughly the inverse of your win rate — a 25% win rate needs 4x coverage. Short coverage is a prospecting problem, not a forecasting one.
- 6. Review weekly and record the variance
Log the forecast each week and compare to actuals at period end. Forecast accuracy improves only when you measure how wrong you were and why.
Forecasting without the spreadsheet
Pulse calculates weighted pipeline automatically from your own historical win rates, splits once-off from monthly recurring revenue, and flags contracts approaching renewal so MRR at risk never surprises you at quarter end.
- Weighted forecast from your real win rates
- Once-off vs monthly recurring split
- Revenue trend and sales funnel dashboards
- MRR-at-risk from contract renewal dates
- Deal value change history per stage
Sales forecasting questions
What is sales forecasting?+
Sales forecasting is the process of estimating how much revenue your team will close in a future period — typically a month, quarter or year — based on the deals currently in the pipeline, historical win rates and known market factors. It drives hiring, cash-flow planning and target setting.
How do I create a sales forecast?+
Clean the pipeline, calculate your real win rate per stage from the last 12 months of closed deals, multiply each open deal by its stage win rate, group by expected close month, then compare that weighted number against rep commit and against your quota coverage ratio. Review it weekly and record the variance against actuals.
What is the most accurate sales forecasting method?+
No single method wins. The most accurate teams run at least two in parallel — usually weighted pipeline plus rep commit — and investigate the gap. Weighted pipeline is objective but assumes clean stages; rep commit adds context but skews optimistic.
What is a good sales forecast accuracy?+
Within 10% of actual revenue is considered strong for a B2B team with a defined pipeline process. Above 20% variance usually points at stage hygiene or close-date discipline rather than the forecasting formula itself.
How do recurring revenue deals change the forecast?+
Once-off and recurring revenue must be forecast separately. A contract worth a monthly amount over a 24-month term contributes very differently to cash-flow than an equivalent once-off installation fee. Forecast new MRR, expansion, and once-off amounts as distinct lines, then reconcile to total contract value.
How often should a sales forecast be updated?+
Weekly for the current quarter, monthly for the following two. Anything less frequent and the forecast is always describing a pipeline that no longer exists.
Forecast from live pipeline, not a spreadsheet
Open the sandbox and look at the forecast dashboard with fully-populated data — no sign-up needed.