Forecasting pipeline for tour operators: a practical guide
How to build a revenue forecast for a tour-operator pipeline that finance will trust — without exporting to a spreadsheet.
Most tour operators forecast in a spreadsheet at month-end. The number is wrong by 15-30%, finance knows it, and nobody trusts it.
The reason isn’t the spreadsheet — it’s the inputs. Forecasts need historical close rates per stage, per source, per destination. Almost nobody has that lying around.
The minimum viable input set
To build a forecast that lands within ±10%, you need six months of:
- Stage transitions per deal (with timestamps)
- Source captured at lead creation
- Destination on the trip record
- Final close reason (won/lost/cancelled)
- Net cost vs sell price (for margin-weighted forecasts)
A trip-aware CRM captures all of this by default. A generic CRM captures the first two; the rest live in your itinerary tool or your accounting system.
Weighted vs scenario-based
Once you have the inputs, you have a choice:
- Weighted pipeline. Multiply each deal’s value by its stage’s historical win rate. Sum. Done.
- Scenario forecasts. Best/worst/most-likely cases based on which deals are credible at this point in the cycle.
Use both. Weighted answers “what’s the math say”; scenarios answer “what could realistically happen.”