The Sales Forecast Playbook Most forecasts are optimism with decimal places. Build one you can steer by.
You add up the deals that feel likely, round towards the number you need, and call it a forecast. Then two big deals slip. This guide shows how to build a forecast that is wrong in a direction you know, by an amount you can measure.
A forecast that is sometimes right is not an instrument. It is weather.
Every forecast is wrong. The trouble is not knowing how wrong, in which direction, or which deals carried the error. And a forecast is not a sales document. It is the input to every expensive decision you make: the contractor, the acquisition budget, the hours you move out of delivery, whether the cash lasts. When you sell alone, you wrote the number, so nobody tells you it is soft.
None of them is "better visibility".
The question is not how sales is going. It is what you can afford to commit to. A forecast is judged on whether the decisions you made from it held up.
The person closest to a deal is the person most invested in it, and when you sell alone that is always you. Stage history, calibrated from your own deals, takes the mood out of the arithmetic.
Weighted pipeline judges whether you have enough for next quarter. Commit, named deal by deal, answers this month. Blur them and you panic about a healthy pipeline or spend against an unhealthy one.
Slippage, not loss, is the most common reason a forecast misses. A forecast that ignores close dates and deal age predicts whether, when you need to know when.
Each loss comes with a reason you paid for in evenings and attention. Collected consistently, the reasons tell you whether to fix the offer, the message or the qualification.
It is the discipline by which a deal earns its way out of hoped and into probable. Without it, your cash plan either ignores the pipeline or quietly includes all of it.
A number wrong in a direction you know.
Not a prediction. A way to know how far to trust your own read of the future, so the contractor you take on, the hours you move and the money you spend on leads all rest on revenue that is actually coming.
Five parts, in order.
Six mechanisms, each something you cannot do without it, and the honest limit: with a dozen open deals, a weighted pipeline is a polite fiction.
Stages defined by what the buyer did, probabilities from your own history, three numbers that never merge, what earns a place in commit, and a coverage target from your win rate.
A fixed slot, what changed first, the commit walked deal by deal, a mechanical slip rule, age as well as stage, and honesty with yourself.
Quarterly calibration, three independent estimates, lost reasons as a map, coverage as an early warning, and feeding the cash plan in cash terms.
Set up the forecast, the weekly review, and quarterly calibration with the hand-off to cash. Each line is a box you either can or cannot tick.
Nine ways a forecast becomes untrustworthy and gets quietly replaced by gut feel. Every one is a choice, and the pattern underneath is the same.
Discovery call held. Decision maker engaged. Proposal reviewed with the buyer. A stage you can enter because you are hopeful will carry a probability that means nothing.
Weighted pipeline, commit and best case, every time. The gap between them stops being uncomfortable and becomes information.
A close date from the buyer's own process is a date. "I need it by month end" is a wish. A deal with no date is unknown, so treat it that way.
- You already sell, with a pipeline of real stages and enough deals that predicting them is worth the effort.
- You want a forecast to decide what you can afford to commit to, not to feel good.
- You are willing to compare the forecast with what happened, even when it is unflattering.
- You want rules you set while calm, because nobody else will check your pipeline.
- You are still finding your first customers. A pipeline that small is not worth forecasting yet.
- You want a template of default percentages. The guide says they describe nobody's business.
- You expect one clever spreadsheet to fix a forecast that is never compared with outcomes.
- You want the number to be right. The aim is a number you know how to be wrong about.
Nobody checks your pipeline but you.
That is exactly why the forecast drifts towards what you hope, and why it needs rules. Write the three numbers down every week. Compare them with what happened every quarter. Then make your next commitment with the one that can bear it.
Luis Gonçalves
Twenty years in digital product development. Led the agile transformation at Nokia. Teaches at Porto Business School. Has spent the last decade working with founders across Saudi Arabia, Portugal, Brazil, and the broader emerging-market startup ecosystem.
He calls himself the Dark Entrepreneur because he believes the founder world is allergic to honesty. No success theater. No highlight reels. Just the real work that has to happen.