Build it in four layers: a pipeline that reflects reality, a coverage ratio worked out from your own win rate, a forecasting method matched to your sales cycle, and reporting that comes straight from the CRM rather than a spreadsheet. Forecast accuracy isn't a talent, it's a system property. Fix the system underneath and the number starts meaning something. Here's each layer in turn.
The tell that yours has failed: the number goes up in the board meeting and everyone quietly applies their own private discount to it.
Layer 1: does your pipeline reflect reality?
No method survives a fictional pipeline, so start with three pieces of hygiene. Deal ageing: sort by last activity and force a decision on anything silent for 60+ days, revive it or close it. Close-date discipline: a slipped date needs a logged reason, and a deal that slips twice gets reviewed. Stage definitions: write one sentence of exit criteria per stage and enforce it in the CRM, not a document nobody reads.
Skip this and everything above it is arithmetic performed on vibes.
Layer 2: what is a pipeline coverage ratio, and what should it be?
Coverage is total open pipeline divided by target for the period. Need £500k this quarter with £1.5m open, and coverage is 3x. But the "3x rule" is folklore. Your ratio is personal: it's the inverse of your win rate. Close a third of what you pursue and 3x is right; close a fifth and you need 5x.
Two refinements make it far more useful. Measure it by stage, because £1m of early-stage and £1m at contract stage are different animals. And measure it at the start of the period, then watch it erode, coverage that looks fine in week one and evaporates by week six means your problem is progression, not generation.
Layer 3: which forecasting method should you use?
Match the method to your sales motion. Stage-weighted (deal value times stage probability) suits high-volume, short-cycle sales where the law of large numbers works; with 15 long-cycle deals, one big deal moving swings the whole number. Commit-based (reps tag deals commit, best case or pipeline) adds judgement but inherits every rep's optimism, so the categories need teeth.
Flow-based methods suit long-cycle B2B best, borrowed from agile delivery. A cumulative flow diagram shows how many deals sit at each stage over time, exposing where they stall, how long each stage really takes, and whether the pipeline is moving or just churning. I built exactly this for an eight-figure, long-cycle pipeline, and it replaced an evening of monthly spreadsheet work with a report leadership actually opened.
Layer 4: does the forecast come from the system or a spreadsheet?
It should come straight from the CRM, live and drillable. If the board pack means exporting to Excel and "adjusting", two bad things happen: someone senior loses an evening a month, and the numbers detach from the system of record, so nobody can drill from the summary to the deals behind it.
The standard to aim for: leadership can click from "we'll do £480k" down to the actual deals making up the number. When they can, trust follows. It's genuinely achievable for a 10 to 100 person company, and it's much of what I do for clients.
Where should I start?
At the bottom of the chain, because a weak link anywhere shows up as a number nobody believes. Run a free commercial systems health check: a few minutes, a score across your data, pipeline and reporting, and the three fixes worth doing first. Better to find the weak link now than at the quarter's end.
Frequently asked questions
What is a good pipeline coverage ratio?
Roughly the inverse of your win rate. Close a third of deals and 3x coverage is about right; close a fifth and you need nearer 5x. Work it out from your own last few quarters, not a rule of thumb.
Why is my sales forecast always wrong?
Usually a broken link upstream: dead deals inflating the pipeline, close dates that slip unchallenged, stages that mean different things to different reps, or a method that doesn't suit your cycle. Fix the pipeline before blaming the formula.
What's the best forecasting method for long sales cycles?
Flow-based forecasting. A cumulative flow view shows where deals accumulate and how the pipeline moves over time, which point-in-time stage-weighting hides when you only have a handful of large, slow deals.