How to Build a Sales Forecast in One Morning, Solo
How to build a sales forecast you can steer by: seven decisions, made once and written down. Stages, probabilities, three numbers, dates, coverage and losses.
To build a sales forecast, spend one morning setting it up. Define every stage by something the buyer did, put a probability on each from your own history, record weighted pipeline, commit and best case separately, give every deal the buyer's close date, and derive your coverage target from your win rate.
How to build a sales forecast in one morning
Forget the template. Forget the software's default setup. You don't need a model. To build a sales forecast, you need seven decisions, made once, written down.
That morning decides whether every later number means anything. Skip it and you'll spend the next year averaging things that were never comparable.
This is for you if you already sell, you have a pipeline with real stages, and there are enough deals in it that predicting them is worth the effort. If you're still finding your first customers, stop here and go sell. A forecast built on three deals is decoration.
Here's the order. Don't rearrange it. Each step depends on the one before.
Step one: define every stage by something the buyer did
This is the step people rush, and it's the one that ruins everything downstream.
A stage now carries a probability. And a probability attached to a feeling is worthless. So a stage can't be "warm" or "interested" or "going well". It has to be a thing that happened and can be checked.
- Discovery call held.
- Decision maker engaged.
- Proposal reviewed with the buyer.
- Verbal agreement.
- Paperwork in procurement.
If a stage can be entered because you're hopeful, the probability on it will drift upwards until it means nothing. Hope is the enemy here, and you're its only host.
Then add two stages people forget: a clearly defined won stage and a clearly defined lost stage. A deal is lost when someone says no, or when it has gone silent past a limit you set in advance. Not when you finally give up months later.
Free guide · 20 pagesForecast the number you steer by.The Sales Forecast Playbook: stop adding up deals that feel likely.Get the free guide →Step two: put a probability on each stage, from your own history
Software ships with tidy defaults. They describe nobody's business.
Your numbers come from one question per stage: of the deals that reached this stage, how many eventually closed as won? If you have the history, use it. If you don't, set conservative guesses, write down that they are guesses, put a date on when you'll replace them, and move on.
A probability you calibrated badly is still better than one you borrowed. Yours can be corrected. The full method is in how to set deal stage probabilities.
Step three: keep three numbers and never merge them
Every time you build a sales forecast or update one, write down three figures side by side.
| Number | What goes in it | What it is good for |
|---|---|---|
| Weighted pipeline | All open deals multiplied by their stage probabilities | Long-range: do I have enough pipeline? |
| Commit | Deals you'd stake your own plans on, listed by name | This period: what can I count on? |
| Best case | Commit, plus deals that could close if things go well | Upside only. Never money you spend |
The failure isn't having three numbers. It's reading one as another. Best case treated as commit. Weighted pipeline used to predict a single month. Put them side by side every time and the gap between them turns from uncomfortable into informative. More on that in weighted vs committed pipeline.
Also: name your large deals individually. Don't let one big deal hide inside a weighted total. It'll distort every average around it.
Step four: write down what earns a place in commit
Commit can't be a feeling either.
Write the criteria now, while you're calm. A deal belongs in commit when, for example, the person who signs has been in the conversation, the close date comes from the buyer's own process rather than your month end, the paperwork path is known, and no unresolved objection is outstanding.
Your criteria may differ. What matters is that they exist in writing before the review. Then a deal enters commit because it qualifies, not because the number is short and you want it to be.
Step five: fix what a date means
Three dates get confused: the day the buyer signs, the day the work starts and the day the cash arrives.
Pick one for the forecast. Usually it's the signature. The cash plan derives the other two from it, using your real payment terms and your real collection behaviour.
Then the rule that saves you most: a close date is the buyer's date, not yours. "They said they decide at the board meeting on the fourteenth" counts. "I need it by month end" doesn't. Every open deal gets a date, and any deal without one is unknown.
Step six: derive your coverage target
Coverage is open pipeline divided by the target for the period. The right ratio isn't a number someone mentioned in a thread. It's arithmetic on your own conversion.
If roughly one qualified deal in three closes, you need about three times your target in qualified pipeline at the start of the period, plus margin for slippage. If one in five closes, you need about five. Work it out once. Write it down. Re-derive it whenever your win rate moves. The detail is in how to calculate pipeline coverage.
While you're at it, note your typical sales cycle length, roughly. You'll need it to spot a deal that's stuck.
Free assessmentHow trapped are you, really?Take the Corporate Suffocation Index, the free solopreneur readiness assessment.Take the assessment →Step seven: set a short list of lost reasons
Five to seven, at most. Price, timing, chose a competitor, no decision, poor fit, lost the champion. Add a free-text line for detail.
Make "no decision" its own category. It's usually the largest and the most revealing. The buyer wasn't persuaded that changing was worth the effort. That's a different problem from losing to someone else, and it has a different fix.
Three shortcuts that wreck how you build a sales forecast
Most solo forecasts die in the setup, not in the maths. Watch for these.
Borrowing the defaults. They feel authoritative. They drift further from your reality every quarter they go unchecked.
Letting your mood set a stage. You're the person closest to every deal, and the most optimistic about it. Stage history is duller and much more accurate. Let it do the guessing, and keep yourself for the selling.
Skipping the lost stage. A pipeline that only grows isn't healthy. It's unweeded. Old hopeful deals inflate every number you build on top of them.
None of these needs skill to avoid. They need you to decide before the pressure arrives. When a big deal is wobbling and the month looks thin, you won't set a good rule. You'll set a convenient one.
The checklist you can tick
When the morning is over, you should be able to say yes to each of these.
- Every stage is defined by something the buyer did.
- Every stage has a probability, and I know where it came from.
- Guesses are labelled as guesses, with a date to replace them.
- I record weighted pipeline, commit and best case separately.
- The criteria for entering commit are written down.
- Every open deal has the buyer's close date.
- I have a short list of lost reasons and a silence limit.
- I know my win rate roughly, and my coverage target comes from it.
Any box you can't tick is your next task. Not tomorrow's. Next.
Free guide · 20 pagesForecast the number you steer by.The Sales Forecast Playbook: stop adding up deals that feel likely.Get the free guide →What happens after the morning
You can build a sales forecast in a morning. Keeping it honest is the job.
The forecast is only as good as its last update, which is why a short, fixed weekly session matters more than a clever model. That's covered in how to run a weekly pipeline review. And at the end of each quarter you compare what you forecast with what happened and correct the probabilities, even when reality is unflattering.
Expect the first few quarters to be calibration, not prediction. With thin history your numbers will be wrong. That's fine. A forecast that's never compared with outcomes never improves. It just accumulates confidence.
Free assessmentHow trapped are you, really?Take the Corporate Suffocation Index, the free solopreneur readiness assessment.Take the assessment →Frequently asked questions
How long does it take to build a sales forecast?
The setup is a morning's work. You define stages, set probabilities, decide your three numbers, fix what a close date means and derive coverage. After that it's a short weekly update and an honest afternoon each quarter.
Do I need special software?
No. What matters is the definitions, not the tool. A spreadsheet with stage, value, close date and next step on every deal will do. Software helps most when it prompts you for a lost reason the moment you mark a deal lost.
What if I don't have enough history for the probabilities?
Set conservative guesses, write down that they are guesses, and replace them once a quarter of real outcomes exists. A probability you calibrated badly is still better than a borrowed one, because yours can be corrected.
Should I build the forecast around the weighted pipeline?
Not on its own. Keep weighted pipeline, commit and best case as three separate numbers. Use weighted pipeline for the long range and commit for this period. Treat best case as upside only.
The full method, with the checklists, is in The Sales Forecast Playbook, a free 20-page playbook.
How trapped are you, really?
Take the Corporate Suffocation Index, the free solopreneur readiness assessment.