A simple sales pipeline lists every open deal, the stage it has reached and its value. To forecast revenue before it happens, multiply each deal's value by the likelihood of closing from that stage, based on your own past results, then add the totals. The result is a weighted pipeline: a realistic estimate of upcoming sales.
This guide is for owners and small sales teams who sell through quotes, proposals or consultations, and who are tired of being surprised by slow months. You'll learn how to define stages with clear exit rules, calculate close rates from your own history, build a weighted forecast and run a short weekly review that keeps it honest.
What is a sales pipeline, and how is it different from a funnel?
A sales pipeline is a snapshot of specific deals in progress: this client, this proposal, this amount, this stage. A sales funnel describes the overall flow of people from first contact to purchase, usually as percentages. The funnel tells you how your process converts. The pipeline tells you what's likely to land in your bank account and when.
You need both, but the pipeline is the forecasting tool. Our guide to building a sales funnel covers the other half.
How to set up pipeline stages that mean something
Stages only help forecasting if every deal in a stage has reached the same point. Define each one by something the customer has done, not by how hopeful you feel. Four or five stages is plenty for most small businesses.
| Stage | Exit rule: the deal moves on when... | Typical owner question |
|---|---|---|
| 1. Qualified lead | You've confirmed need, budget range and decision-maker | Is this worth a full conversation? |
| 2. Discovery held | You've had a scoping call and the prospect asked for a proposal | Do we understand the problem well enough to price it? |
| 3. Proposal sent | The prospect has your written price and scope | What's stopping them from deciding? |
| 4. Negotiating or verbal yes | The prospect has said yes in principle and is working through terms | What paperwork or approval is left? |
| 5. Won or lost | Contract signed or deposit paid, or the prospect has declined | Why did we win or lose? |
The qualification step is the one most often skipped, and it's the one that keeps your pipeline from filling with deals that were never real. See our guide to qualifying leads before spending time on them.
How to calculate close rates from your own history
Generic probabilities like "proposals close 50% of the time" are guesses. Your own data is better, even if it's rough.
- Pull every deal from the last 6 to 12 months that reached a given stage, whether it was won or lost.
- Count how many of those were eventually won.
- Divide won by total. If 40 deals reached "proposal sent" and 14 signed, your proposal-stage close rate is 14 ÷ 40 = 35%.
- Repeat for each stage. Rates should rise as deals move forward. If they don't, your stage definitions are fuzzy.
- Recalculate each quarter, or after any big change in pricing, offer or market.
If you have no history yet, start with conservative estimates and replace them as soon as you have 20 or so closed deals to learn from.
Worked example: forecasting revenue for a web design studio
Suppose a hypothetical web design studio has these close rates from its own past year: 10% from discovery held, 35% from proposal sent and 70% from negotiating. Its current open pipeline looks like this:
| Stage | Deals | Total value | Close rate | Weighted value |
|---|---|---|---|---|
| Discovery held | 8 | $48,000 | 10% | $4,800 |
| Proposal sent | 5 | $41,000 | 35% | $14,350 |
| Negotiating | 3 | $27,000 | 70% | $18,900 |
| Total | 16 | $116,000 | $38,050 |
The unweighted pipeline says $116,000. The realistic forecast is $38,050. That gap is exactly why owners who count every open proposal at full value end up disappointed.
Checking the forecast against a target
The studio needs $45,000 in new signed work over the next 90 days to stay on plan, and nearly all its deals close within that window. The shortfall is $45,000 − $38,050 = $6,950.
How much new activity closes that gap? Each new discovery call is worth its average value times its close rate: $6,000 × 10% = $600 of weighted pipeline. So the studio needs $6,950 ÷ $600 = 11.6, or about 12 more discovery calls, and soon, since deals take time to close. Alternatively, lifting the proposal-stage close rate through better follow-up would raise the forecast without any new leads.
Measuring pipeline velocity
Pipeline velocity estimates how much revenue your pipeline produces per day:
(Number of open deals × average deal size × overall win rate) ÷ average sales cycle in days
With 16 open deals, an average size of $116,000 ÷ 16 = $7,250, an overall win rate of 25% across all stages (again from its own history) and a 45-day average cycle: (16 × $7,250 × 0.25) ÷ 45 = $29,000 ÷ 45 ≈ $644 a day. Each of the four inputs is a lever. More deals, bigger deals, a higher win rate or a shorter cycle all raise velocity, and tracking it monthly shows which lever is moving.
A 20-minute weekly pipeline review
A forecast is only as good as the data in it. Block 20 minutes at the same time each week and work through this list:
- Update every deal's stage based on what the customer did this week, not what you hope they'll do.
- Check the next step on each deal. Every open deal should have a dated next action. Deals without one are stalling.
- Flag stale deals. Anything sitting in one stage for more than about twice your normal time should be re-qualified or closed as lost.
- Recalculate the weighted total and compare it with your target for the period.
- Decide one action to close the gap: more prospecting, follow-ups on proposals, or a push on deals in negotiation.
Feed the weighted forecast into your cash planning too. A 13-week cash flow forecast is much more accurate when expected sales come from a weighted pipeline instead of a hopeful guess.
Common sales pipeline mistakes
- Counting deals at full value. This inflates the forecast and leads to hiring or spending too early. Always weight by stage.
- Stages based on the seller's activity. "Sent follow-up email" isn't a stage, because the customer hasn't moved. Define stages by buyer actions.
- Never closing out dead deals. A pipeline full of zombie proposals makes the forecast meaningless. Mark them lost and record the reason.
- Using one close rate for every deal type. Referrals and repeat customers often close at very different rates from cold leads. If your mix varies, track rates by source.
- Ignoring timing. A deal likely to close in five months doesn't help this quarter. Add an expected close month to each deal and forecast by period.
- Overbuilding the system. A spreadsheet with seven columns beats an elaborate setup nobody updates. Our guide to setting up a simple CRM shows how to start small.
Where AI can help
If your deals live in a spreadsheet or a customer-management tool, you can export them and ask an AI assistant to calculate stage close rates, average time in each stage and the weighted forecast by month. It can also scan deal notes and flag ones with no recent activity or no next step, which makes the weekly review faster.
A person still has to judge the deals themselves. An AI tool can't know that a prospect mentioned a budget freeze on the phone, or that a "negotiating" deal is really stuck with a skeptical partner. Use the analysis to prompt questions, then update stages based on what you actually know.
Frequently asked questions
How many stages should a small business pipeline have?
Usually four to six, including won and lost. Fewer stages make it hard to see where deals stall. More stages create busywork and blur the definitions.
Do I need special software to run a pipeline?
No. A spreadsheet with columns for customer, value, stage, expected close date, next step and source works for many small teams. Move to a dedicated tool when you have several people updating deals or too many to track comfortably.
How accurate should my forecast be?
Expect individual deals to surprise you, but the weighted total should land reasonably close over a quarter. If you're consistently far off in one direction, your close rates or stage definitions need adjusting.
What should I do with deals whose close date keeps slipping?
Each time a close date moves, ask the prospect directly what has changed and what decision is still pending. If a deal slips twice with no new information, move it back a stage or mark it lost. You can always reopen it if the prospect comes back, and your forecast stays honest in the meantime.
Key takeaways
- Define pipeline stages by what the customer has done, with clear exit rules.
- Calculate close rates per stage from your own won and lost deals, and update them quarterly.
- Weighted pipeline = deal value × stage close rate, summed across all open deals.
- Compare the weighted total with your target and work out how much new activity closes the gap.
- Review the pipeline weekly, close out stale deals and feed the forecast into cash planning.
Comments
Post a Comment