A forecast built from three data-backed methods beats one built from optimism.
It is the last Friday of the month and the CEO asks whether you are hitting the number. The sales manager checks a spreadsheet, makes some assumptions, and says $320K. Actual revenue comes in at $210K.
That happens in most companies, and it compounds. Every plan built on the forecast misses along with it.
Why the forecast matters
- Cash planning: you need to know you can cover payroll
- Hiring: you hire the next rep once you are confident in the revenue
- Investor reporting: they want to know whether you are on track
- Your own head: knowing on the 15th that you will hit target lets you sleep
Why most forecasts are wrong
The manager reasons that 5 demos last week means 2 closes, so $100K, so it is fine. There is no data behind any step in that. Some of those deals close in 5 days and some take 60.
Reps are optimists, so they forecast high. Nobody knows the average sales cycle or the win rate from proposal stage, so nobody can challenge a number. Ask what a healthy close rate is and one person says 20% and another says 40%.
Deals also misbehave. One you were certain of stalls for months. One you wrote off signs on a Tuesday.
Method one: pipeline and win rates
Take the pipeline value at each stage, multiply by your historical close rate from that stage, and add them up.
If your average deal is $20K, you have $200K sitting in proposal across 10 deals, and you historically win 50% from proposal, you will close roughly 5 of them. That is $100K, and it is arithmetic rather than hope.
- Track close rates by stage over the last 12 months
- Count the current pipeline value at each stage
- Multiply pipeline by close rate
- Add up the expected revenue across every stage
On a typical pipeline that lands somewhere around $305K.
Method two: sales cycle age
If you know how long deals spend in each stage, you know roughly when one will land.
- 5 days in prospecting
- 7 days in qualification
- 10 days in demo
- 14 days in proposal
- 7 days in negotiation
- A 43-day average cycle
A deal that entered 43 days ago should close this month. One that entered 20 days ago belongs to next month. Forecast this month from everything that entered prospecting 43 or more days ago.
Cycles vary, so treat this as a second opinion rather than a rule. On the same pipeline it might say $310K.
Method three: activity
Forecast from the leading indicators instead of the deals themselves, using your own conversion history.
- 1 demo scheduled: 15% chance of closing
- 1 proposal sent: 40%
- 1 negotiation: 70%
So 20 demos this month gives 20 × 15%, which is 3 closes worth $60K. 8 proposals gives 3.2 closes at $64K. 2 negotiations gives 1.4 closes at $28K. Total $152K.
Those percentages have to come from your own data. Borrowed benchmarks make this method worthless.
Use all three
Pipeline says $305K, sales cycle says $310K, activity says $300K. Call it $305K and carry real confidence into the meeting.
When they diverge, that is the useful part. One method saying $200K while another says $400K means something in the pipeline deserves a closer look.
Forecast by rep
Each rep has their own numbers. A strong one might close 50% on a 30-day cycle. A newer one might close 20% on a 60-day cycle. Forecast them separately and add up.
That also shows who needs coaching, without it becoming a matter of opinion.
Review it every week
Every Monday, walk the deals expected to close this week. Ask each rep whether it is still on track. Flag anything that has gone quiet: no reply in 5 days means a call today. Then update the number.
By mid-month you know whether you are tracking. At $280K against an original $305K you are 8% behind, and on the 20th you still have 10 days to do something about it.
Getting more accurate over time
No forecast reaches 100%. Write the forecast down on the 1st and the actual on the 30th, every month, and compare. A forecast of $305K against $300K actual is 97% accurate, which is good.
Track that across 12 months and the pattern appears: consistently optimistic, or consistently cautious. Adjust the model to match.
When it misses badly, say $305K forecast against $195K actual, work out which of these happened: deals slipped into next month, deals you counted as won were lost, prospecting stopped and the pipeline dried up, or a rep was away.
Written by the team at Ambivo, a business platform that keeps CRM, accounting and ERP on one customer record. This article is general guidance on the topic rather than a description of Ambivo features.