15 November 2026 · 7 min read
How to Forecast Your Sales Pipeline (Simple Method + Example)
A step-by-step method to forecast revenue from your pipeline using weighted probabilities and coverage ratios. Includes a worked example you can copy.

Overview
If you are a founder or run a small sales team, you need to answer one question every week: how much revenue is likely to close this month?
You don't need a data team to answer it. You need clean pipeline data and a simple method. Here is how to do it.
Step 1: Make sure every deal has the basics
A forecast is only as good as the data behind it. For each open deal, you need:
• A deal value
• A pipeline stage
• An expected close date
• A next action
If any of these are missing, fix them before forecasting. Deals without a close date should not count toward this month's number.
Step 2: Assign a probability to each stage
Give each stage a win probability. If you don't have history yet, start with the defaults in our pipeline stages guide, then adjust them as you close more deals.
To calibrate from your own data, use this formula for each stage:
Stage probability = deals that eventually won from that stage / all deals that reached that stage
Step 3: Calculate the weighted pipeline
Multiply each deal’s value by its stage probability, then add them up.
Weighted pipeline = sum of (deal value × stage probability)
Worked example (illustrative numbers, not customer results):
Qualified — €20,000 × 20% = €4,000
Proposal sent — €30,000 × 50% = €15,000
Negotiation — €15,000 × 75% = €11,250
Total — €65,000 open pipeline; €30,250 weighted pipeline.
Your open pipeline is €65,000, but the weighted estimate is €30,250. These are example assumptions, not a guaranteed outcome.
Step 4: Filter by close date
For a monthly forecast, include only deals with an expected close date in that month. Deals scheduled for later months belong in next month's forecast.
Be strict here. A deal "closing this month" with no recent activity is probably not closing this month.
Step 5: Check your pipeline coverage
Coverage tells you whether you have enough pipeline to hit your target.
Pipeline coverage = open pipeline value / revenue target
A common rule of thumb is to aim for about 3x coverage, but the right number depends on your win rate. If you win one in four qualified deals, you need roughly 4x. Use your own win rate to calculate it:
Required pipeline = revenue target / win rate
Example: with a €30,000 target and a 25% win rate, you need about €120,000 in qualified pipeline.
Step 6: Build three scenarios
Instead of one number, give yourself a range:
• Commit: deals in Negotiation with a confirmed close date.
• Likely: the weighted forecast from Step 3.
• Best case: everything in Proposal sent and later, at full value.
Plan spending and hiring around the commit and likely numbers, not the best case.
Common forecasting mistakes
• Using the same probability for every deal. A deal that went quiet is not the same as one with a signed order form.
• Never cleaning the pipeline. Stale deals inflate your forecast.
• Counting by the seller's mood. Use buyer actions: a meeting booked, a contract opened, a legal review started.
• Ignoring deal age. Deals much older than your average sales cycle rarely close.
• Forecasting once a quarter. Review weekly. It takes ten minutes.
Make it a weekly habit
Every Friday, do this:
1. Update stages and close dates.
2. Remove or move stalled deals.
3. Recalculate the weighted pipeline.
4. Compare it to your target.
5. Pick the three deals that most affect the number and plan their next step.
You can run this in a spreadsheet, or let a CRM do it. RevenueRobotics shows weighted forecast, win rate and money at risk, with deal-health flags and AI scoring to help prioritise follow-up. For a month-specific forecast, verify each close date; the worked example’s probabilities are not necessarily the app’s defaults. You can also try our free pipeline calculator to test the numbers.
FAQ
What is a weighted sales forecast?
It multiplies each deal's value by the probability of winning it at its current stage, then adds the results. It is more realistic than counting the full value of every open deal.
How accurate is a pipeline forecast?
It depends on data quality and how long you have been tracking. Accuracy usually improves as you gather more closed deals and refine your probabilities.
How often should I update my forecast?
Weekly is a good default. Update it immediately after major changes, like a big deal moving or being lost.
What is a good pipeline coverage ratio?
Many teams aim for around 3x their target, but your own win rate is the better guide. Divide your target by your win rate to find the pipeline you need.
Related product page
Sales forecasting for startups →Try RevenueRobotics
Companies, deals, automations and AI note summaries in one calm CRM.
Start free trial