Sales Forecasting Guide: Producing a Number You Can Actually Defend

A forecast is not a prediction for its own sake. It exists so that other people can make decisions: whether to hire, whether to commit to a supplier, whether to spend on marketing, whether the founder needs to spend next month selling instead of building. The quality of a forecast is measured entirely by whether those decisions turn out to have been made on sound information.

That reframing matters because it changes what a good forecast looks like. A number that is usually close is far more valuable than a number that is occasionally exactly right and often badly wrong. And a number delivered with an honest range beats a confident single figure that everyone privately discounts.

Most forecasting advice fails because it assumes one revenue shape. Pick the method that fits yours.

The common answer for a small B2B business is two methods added together rather than one: a run rate or renewal model for repeat revenue, which is stable and easy, plus named-deal commit for new business, which is volatile and needs judgement. Blending them into a single weighted total loses information from both.

Why weighted pipeline misleads at small scale

Weighting multiplies each deal by a stage probability and adds them up. With hundreds of deals, the arithmetic works because individual variation averages out. With eight deals, it does not. A significant deal weighted at sixty per cent contributes a figure that will never happen, because that deal will close fully or not at all. The weighted total is a useful way to compare the size of pipeline between periods. It is a poor way to tell your accountant what next quarter looks like.

Forecast categories only work if entry is governed by tests rather than by confidence. Write them down and apply them without exception.

Commit

You would be surprised if this did not close in the period. Entry requires: the person who signs has been identified and spoken to; commercial terms are agreed at least in principle; the buyer has stated the date they are working to, rather than agreeing to yours; and any procurement, legal, or approval step is known and scheduled. Four facts, all checkable from the record.

Likely

More probable than not, with one identified thing outstanding. Entry requires a confirmed requirement, an engaged decision maker, and a specific named obstacle with a plan attached. If you cannot name the obstacle, it is not likely, it is upside.

Upside

Real opportunities that could land in the period if things go well. No commitment is implied and none should be inferred, which means upside should not be summed with commit in any number presented to anyone making decisions.

The categories do the work only if a deal that stops meeting the criteria comes back out. Downgrading a deal must be as normal and as blameless as upgrading one, or the categories ratchet upwards and the forecast becomes a ceiling that nobody believes.

Monthly for most small businesses, forty-five minutes, with the numbers circulated beforehand.

The two questions

Go through the commit list deal by deal and ask each rep exactly two things. What has to be true for this to close in the period? And what could stop it? The first question surfaces whether there is a real plan or a hope. The second question is the one that produces information, because reps will tell you the risk if you ask directly and will rarely volunteer it.

If the answer to the first question includes anything that has not been agreed with the buyer, the deal is not commit. That single test, applied consistently, does more for forecast accuracy than any model.

Then the gap

Commit against target gives you the gap. Look at likely for what could realistically be pulled in, and be honest about the arithmetic: if the gap needs three of four likely deals to land early, that is not a plan, it is a hope with a number attached. Say so at the midpoint of the period, not at the end.

Hygiene before the call

Five minutes of checks prevents most of the wasted discussion. Any deal in commit with no next step scheduled. Any deal in commit whose close date has already moved twice. Any deal in commit with only one contact at the buyer. Any deal whose close date is in the past. Each of these is a question to resolve before the meeting rather than a discovery during it.

Keep a simple record: for each period, the committed figure at the start, the committed plus likely figure, and the actual result. Per person and in total. After three or four periods, patterns appear that no individual period reveals.

Typical findings are that the aggregate commit runs consistently above actuals by a stable margin, and that the variance is concentrated in one or two individuals. Both are useful. A stable margin can be corrected for openly, in the room, with everyone seeing the same adjustment. Individual variance is a coaching conversation held with evidence rather than an impression.

Resist the temptation to apply a private haircut to one person numbers before presenting the forecast. It feels pragmatic and it means the number you present is not the number anyone agreed to. When it is discovered, and it will be, the forecast process loses whatever credibility it had.

Separate slippage from loss

At the end of each period, take every deal that was committed and did not close and put it in one of two buckets. Lost, meaning the buyer chose someone else or chose nothing. Slipped, meaning it is still live in a later period.

Heavy slippage almost always means close dates are being set by the seller. The remedy is a habit rather than a system: ask the buyer what date they are working towards, in their words, and record that. A date the buyer stated slips far less often than a date they politely agreed to.

Heavy loss from commit points somewhere else entirely, usually at qualification or at a competitor you are meeting late in the process. The recurring reasons across several periods are the thing to act on, not any individual case.

A small business runs quarterly targets. Repeat and renewal revenue is fairly stable. New business is roughly six to ten deals a quarter, with the largest two usually accounting for a substantial share.

The old approach was a weighted pipeline total, which produced a figure that came in high three quarters running. The team assumed the sales team was optimistic. The accuracy record showed something more specific: aggregate commit was around a fifth above actual, and almost all of the variance came from two large deals a quarter that were committed early and slipped.

Two changes follow. First, commit entry now requires a buyer-stated close date. When applied, one of the two large deals in the current quarter fails the test immediately, because the date in the system was proposed by the rep in a follow-up email and never confirmed. It moves to likely.

Second, forecasting splits in two. Renewal revenue is forecast from a simple model of what is due and what historically renews. New business is forecast from named deals only. The two are added, never blended.

At the midpoint of the quarter, commit plus renewals sits below target with a visible gap. Because it is visible in week six rather than week twelve, there is time to act: two upside deals get senior attention, and a small campaign goes out to a segment with a short cycle. The quarter closes slightly under target, which is a much better outcome than the previous quarter where the same shortfall appeared with four days left.

Three quarters later the accuracy record shows aggregate commit within a few per cent of actual. Nobody got better at predicting. The entry rules did the work.

Forecasting from a weighted total

Fix: name the deals. Use weighting only to compare pipeline size between periods.

Categories that only ever go up

Fix: make downgrades normal and expected. If nothing ever leaves commit, the categories are decoration.

Close dates set by the seller

Fix: ask the buyer for their date, in their words, and record it. This is the single most effective anti-slippage habit there is.

No accuracy record

Fix: three numbers per period in a simple table. Without it, every conversation about optimism is opinion against opinion.

Announcing the miss too late

Fix: a midpoint check with the same rigour as the end-of-period one. A gap found halfway through is a plan; a gap found at the end is an apology.

Ignoring cash

Fix: a second view of expected receipts by month using your real payment behaviour. A strong quarter can still produce a difficult month, and only the cash view shows it coming.

The forecast is working when the gap between committed and actual narrows across periods and stays narrow, when downgrades happen mid-period without drama, when slippage falls as a share of missed commit, and when someone outside sales makes a real decision on the number without asking what they should knock off it.

That last one is the true test. A forecast that everyone mentally discounts is not a forecast, it is a proposal. When the discount disappears, the process has done its job.

Every input above lives on deal records: category, close date and its change history, next step, contacts engaged, and the actual outcome. If those live in a spreadsheet rebuilt each month, the accuracy record cannot be kept and the hygiene checks will not be run.

HelloGrowthCRM keeps forecast category, close dates with their change history, next steps, and outcomes on the opportunity, so the forecast call runs from live lists and the accuracy record accumulates without anyone maintaining it. There is a free plan to start on, and paid access is $10/user/month billed annually.

Related reading: sales automation, lead management software, CRM versus a spreadsheet, CRM for small business, what a CRM is, product features, and pricing.