A sales forecast should explain why revenue might arrive and what could prevent it. A spreadsheet full of probabilities is not enough if the probabilities have no relationship to buyer behavior.
For an early startup, I would make the evidence visible before trying to make the forecast sophisticated. Sparse history makes precise-looking estimates especially easy to overtrust.
Use an evidence-based opportunity record
Record the proposed scope, commercial value, expected decision date, buyer’s next action, remaining approvals, and implementation dependencies. Add the last meaningful change and the source of the timing estimate.
A seller’s desired close date and a customer’s confirmed decision process are different inputs. Keep them distinguishable.
Build scenarios
| Scenario | What belongs in it |
|---|---|
| Conservative | Outcomes supported by strong evidence, with unresolved risks reflected |
| Working | The most plausible view given current information |
| Upside | Additional outcomes that require specific favorable events |
Define the rules consistently. Do not move deals between scenarios simply to make the total match a target.
Inspect the next decision
For every material opportunity, ask what has to happen next and who owns it. If the answer is unclear, the forecast should reflect that uncertainty. Large contract value does not make an unresolved buying process more predictable.
A fictional deal might require a successful pilot, a budget approval, and a contract review. Forecasting it as nearly certain because the demo went well collapses three separate dependencies into optimism.
Compare forecasts with outcomes
Keep dated snapshots. Review what slipped, what disappeared, and what closed earlier than expected. Identify whether errors came from qualification, timing assumptions, missing stakeholders, or inconsistent updates.
The purpose is calibration. A forecast that improves over time is more useful than one that is always defended after the fact.
Connect the forecast to operating decisions
Use scenarios to inform capacity, spending, and cash planning without assuming revenue is collected the moment a contract is signed. Coordinate the commercial forecast with the person maintaining the company’s financial view.
The qualification template supplies the evidence the forecast needs. If the input process is weak, adding more formulas usually makes the uncertainty harder to see rather than smaller.
Co-founder and CEO of Stackmatix, startup advisor, and former Head of Sales at MightyHive. Connect with Matt on LinkedIn ↗ · More about Matt →