A small pipeline can swing sharply when one deal moves. A scenario forecast shows that uncertainty more clearly than a single precise-looking number. This is a planning worksheet, not financial advice or a guarantee of future revenue.
Define the period and amount consistently
Choose whether the forecast represents bookings, invoicing, or cash collection, and keep that definition visible. These are not interchangeable. Use a consistent currency policy and exclude duplicate opportunities. Decide how multi-period contracts are represented before adding totals, otherwise one salesperson may enter an annual amount while another enters a monthly figure.
Use scenarios with explicit inclusion rules
A committed scenario can include only opportunities meeting your strongest evidence criteria; a base scenario can include the working expectation; an upside scenario can show plausible additional outcomes. Define those rules locally. Do not assign probabilities simply because a stage name sounds advanced. Where historical data is sparse, disclose that judgment rather than presenting percentages as calibrated predictions.
Explain changes between reviews
Keep a snapshot and a short bridge: new opportunities, value changes, wins, losses, and timing shifts. A total that stays constant can still conceal major deterioration if a strong deal slips and an uncertain one replaces it. Review dependencies such as procurement, implementation readiness, and customer decision dates alongside the amounts.
Working record
| Item | Record or check | Decision rule |
|---|---|---|
| Committed | Strongest agreed evidence threshold | Explain remaining dependencies |
| Base | Working planning expectation | State inclusion assumptions |
| Upside | Plausible additional outcomes | Do not budget as certain cash |
| Change log | Why this version differs | Separate timing from value changes |
Worked example — illustrative, not measured
Illustrative amounts: $10,000 meets the committed rule, another $5,000 enters the base case, and $8,000 is upside only. Show scenario totals of $10,000, $15,000, and $23,000, not their sum. The scenarios overlap; adding them would count the same opportunities several times.
Put this into practice
- Define the period and what the money represents.
- Write inclusion rules before selecting deals.
- Calculate each scenario from a clear deal list.
- Save a snapshot and explain movements next review.
A mistake to avoid
Do not equate a signed booking with cash received, or use an uncalibrated weighted forecast as proof that payroll or other obligations are covered.
Basis and limitations
Methodology: this is an original editorial planning framework, not a vendor feature claim or a hands-on product test. Adapt the suggested checks to your project.