Learn proven revenue forecasting methods that work, including pipeline-based forecasting and historical close rates.
It's the last Friday of the month. The CEO asks: "Are we hitting our number this month?"
The sales manager checks a spreadsheet. Makes some assumptions. Throws out a number: "Yeah, we should be fine. Probably $320K."
Actual revenue: $210K.
This happens in most companies. Forecasts are guesses. Numbers are missed. Teams miss targets, misses compound, business struggles.
What if your forecast was actually accurate?
Why Revenue Forecasts Matter
Cash planning — Do you have enough cash to pay payroll? You need to know.
Hiring — Should we hire another rep? Only if we're confident in revenue.
Investor reporting — VCs want to know: Are you on track?
Personal stress — If you know you're hitting target on the 15th of the month, you can relax. If you're always uncertain, it's exhausting.
An accurate forecast gives you confidence. You know where you stand. You can plan.
Why Most Forecasts Are Wrong
Sales manager thinks: "We had 5 demos last week, so we'll probably close 2. That's $100K. We'll hit it."
Problem: No data. A demo doesn't mean close. Some close in 5 days. Some take 60 days.
Sales reps are optimists. They think every deal will close. So they forecast high. Reality underperforms.
Lack of historical data
"How long is our average sales cycle?" No idea. "What's our win rate from proposal stage?" No idea. Forecasts are uninformed.
Deals don't move predictably
A deal you thought would close "any day" stalls for months. A deal you wrote off as lost closes suddenly. Surprises happen.
What should a healthy close rate be? 20%? 40%? Nobody knows. So everyone claims different numbers.
The Right Way to Forecast
Method 1: Pipeline-based forecasting
Pipeline Value (at each stage) × Historical Close Rate (from that stage) = Expected Revenue
Your pipeline looks like this:
Your forecast: $305K
You're not guessing. You're using actual historical data (your win rates from each stage). You're looking at real deals in your pipeline (not wishes).
If your average deal size is $20K and you have $200K in proposal stage (10 deals), and your historical win rate from proposal is 50%, then you'll close roughly 5 of those deals = $100K. That's math, not magic.
1. Track historical close rates by stage for the last 12 months
2. Count current pipeline value at each stage
3. Multiply: pipeline × close rate
4. Add up expected revenue across all stages
5. That's your forecast
Method 2: Sales cycle-based forecasting
The approach: Look at when deals typically close based on how long they've been in the pipeline.
You know that deals spend:
- 5 days in prospecting
- 7 days in qualification
- 10 days in demo
- 14 days in proposal
- 7 days in negotiation
- Total: 43-day average sales cycle
So a deal that entered your pipeline 43 days ago should close this month. A deal that entered 20 days ago should close next month.
Forecast for this month: All deals entering prospecting 43+ days ago.
Why this works: If you know your average sales cycle, you can predict when deals will close based on age.
Caveat: Sales cycles are not perfect. Some deals close faster, some take longer. But knowing the average helps.
Method 3: Activity-based forecasting
The approach: Forecast based on leading indicators (activities that lead to sales), not lagging indicators (actual deals).
- 1 demo scheduled = 15% chance of closing (on average)
- 1 proposal sent = 40% chance of closing
- 1 negotiation = 70% chance of closing
- 20 demos scheduled this month (20 × 15% = 3 closes = $60K)
- 8 proposals sent (8 × 40% = 3.2 closes = $64K)
- 2 in negotiation (2 × 70% = 1.4 closes = $28K)
- Forecast: $152K
Why this works: You're using leading indicators. Demos and proposals are more predictive of revenue than hoping deals will magically close.
Caveat: The percentages need to be based on your actual historical data, not guesses.
The Best Forecasting Method: Combine Them
- Pipeline method says $305K
- Sales cycle method says $310K
- Activity method says $300K
- Your forecast: ~$305K (average of the three)
If all three point in the same direction, you have high confidence. If they diverge (one says $200K, one says $400K), you have an outlier to investigate.
Forecasting by Rep
Every rep's forecast is different. A top rep might have a 50% close rate and 30-day sales cycle. A junior rep might have a 20% close rate and 60-day sales cycle.
Forecast individually by rep, then add up:
Now you see which reps need coaching (Tom is underperforming) and which are crushing it (Sarah).
Forecasting in Practice: Weekly Reviews
Every Monday morning, review the forecast:
1. Look at deals expected to close this week
2. Check in with reps: "Are these still on track?"
3. Identify at-risk deals: "This looked good, but they haven't responded in 5 days. Call them today."
4. Update forecast based on new information
5. Report: "We're tracking to $280K. Originally forecast $305K. That's -8%."
This weekly rhythm keeps you honest. By mid-month, you know if you're tracking to target. By the 20th, if you're behind, you have 10 days to do something about it.
Building Forecast Accuracy
Your forecast will never be 100% accurate. But you can improve.
Track forecast vs. actual:
Every month, write down your forecast on the 1st. Write down actual revenue on the 30th. Compare.
Calculate forecast accuracy:
Accuracy: 97% (very good)
Track this over 12 months. Where are you typically wrong? Are you too optimistic or too pessimistic? Adjust.
If you forecast $305K and close $195K, something went wrong. Investigate:
- Did deals slip to next month?
- Did we lose deals we thought were won?
- Did we stop prospecting (pipeline dried up)?
- Did the rep go on vacation?
Key Takeaways
- Accurate forecasting requires data: historical close rates, pipeline, sales cycles
- Use pipeline method: Pipeline Value × Win Rate = Expected Revenue
- Combine multiple methods (pipeline, sales cycle, activity) for confidence
- Forecast by rep; identify underperformers and stars
- Review weekly; update as you learn
- Track accuracy over time; adjust your model