Sales forecasting for small teams

For a small business, a sales forecast isn’t a board-meeting exercise. It’s how you decide whether to hire another crew, order materials early, spend more on ads or keep cash in reserve for a slow month.

This guide shows how to build a forecast from your pipeline using the weighted method (with a worked example), how to sanity-check it against historical win rates, how to present it as a range and which mistakes throw forecasts off.

Why forecasting matters for small teams

Large companies forecast to satisfy investors. Small businesses forecast to survive cash crunches. A 2016 JPMorgan Chase Institute study of 597,000 small businesses with Chase business accounts (transactions from February to October 2015) found that the median small business held just 27 “cash buffer days”: the number of days it could keep paying its usual outflows from its cash balance if money stopped coming in. When your buffer is under a month, knowing roughly what will close in the next 30 to 60 days is not optional.

A forecast also turns a vague feeling (“things seem slow”) into something you can act on early, like adding pipeline, chasing stalled quotes or delaying a purchase.

What you need before you forecast

A forecast is built from your pipeline, so the pipeline has to be in decent shape. Before you calculate anything, check that every open deal has:

• A current value. Updated when the quote changes.
• The right stage. Based on what the buyer has actually done (see sales pipeline management).
• A realistic expected close date. Not “end of the month” by default.
• Stage probabilities for your pipeline, ideally from your own history.

Bad inputs are the most common reason forecasts miss. In Salesforce’s 2024 State of Sales survey of 5,500 sales professionals (vendor research), only 35% said they completely trust the accuracy of their organization’s data. Ten minutes cleaning up close dates before you forecast is time well spent.

The weighted pipeline method

The weighted method is the simplest reliable approach for small teams:

1. For each open deal expected to close in the period, multiply its value by its stage probability.
2. Add up those weighted values.
3. Add revenue already won in the period.

Worked example

Say you run a remodeling company and it’s early November. Your stage probabilities are: new opportunity 10%, site visit booked 20%, site visit done 40%, quote sent 50%, negotiation 70%. You’ve already won $15,000 this month. Here are your open deals (a hypothetical example):

Deal	Value	Stage	Probability	Weighted value	Expected close
Kitchen remodel, Hernandez	$42,000	Quote sent	50%	$21,000	November
Deck build, Patel	$18,000	Negotiation	70%	$12,600	November
Bathroom refresh, Okafor	$16,000	Site visit done	40%	$6,400	November
Siding replacement, Chen	$24,000	Quote sent	50%	$12,000	November
Basement finish, Larsen	$55,000	Site visit booked	20%	$11,000	December
Window replacement, Brooks	$9,000	New opportunity	10%	$900	December

For November, only the first four deals count:

• Weighted open deals: $21,000 + $12,600 + $6,400 + $12,000 = $52,000
• Already won: $15,000
• Weighted forecast for November: $67,000

December’s weighted pipeline so far is $11,900, which mostly tells you December needs more deals.

Notice that the weighted number isn’t what any single deal will produce. The kitchen remodel will close for $42,000 or for nothing, never for $21,000. Weighting works because, across many deals, the wins and losses roughly average out. That’s also its weakness for very small pipelines (more on that below).

Check it against your historical win rate

A second method is a useful cross-check. Look at the last 6 to 12 months:

• Win rate from a stage: of all deals that reached “Quote sent,” what share were won?
• Average won deal size.
• Average time from quote to close.

Say your history shows you win 35% of quoted deals at an average of $22,000, and you have five quotes out that should decide this month. That suggests about 5 × 35% × $22,000 = $38,500 from quoted deals, plus whatever is already won. If that number is far from your weighted forecast, find out why. Usually either your stage probabilities are out of date or this month’s deals are unusually large or small.

Forecast a range, not a number

A single number hides uncertainty. A range shows it. Using the November example:

Scenario	What it includes	November
Worst case	Only revenue already won	$15,000
Commit	Won + deals in negotiation with a firm decision date	$33,000
Weighted (likely)	Won + weighted value of open November deals	$67,000
Best case	Won + every open November deal closes	$115,000

Plan your costs around commit, hope for weighted and know what you’d do with best case. If the gap between commit and weighted is huge, your month depends on a few deals; give them extra attention.

Share the range, not just the headline number, with whoever needs it: your bookkeeper, a business partner or the crew lead planning next month’s schedule. “We’re confident in $33,000, likely around $67,000, and anything above that is upside” is far more useful for planning than “about $67,000,” and it sets honest expectations if two big quotes slip into December.

Measure your forecast accuracy

At the end of each month, compare what you forecast at the start of the month with what actually closed:

Forecast error = (actual − forecast) ÷ forecast

One month’s miss tells you little. A pattern tells you a lot. If you’re 20% high three months in a row, your stage probabilities are too generous or deals are slipping past their close dates. Lower the probabilities for the stages where deals stall, or tighten your exit criteria so deals don’t advance too early.

Forecasting beyond this month

The weighted method is strongest for the current month and the next one, because those deals are in your pipeline with real dates. Further out, your pipeline thins and history becomes a better guide.

For months two and three, combine what’s already in the pipeline with what you’d normally expect to create and close in that time. A simple approach:

1. Take the weighted value of deals already expected to close in that month.
2. Estimate deals not yet in the pipeline: average new leads per month × lead-to-won rate × average deal size, adjusted for your typical sales cycle.
3. Adjust for seasonality using the same month last year.

A lawn care company forecasting April in January will have almost nothing in the pipeline yet, but its history of spring sign-ups is a far better guide than an empty board. A realtor forecasting a quarter ahead can use average closings per month plus what’s already under contract.

A monthly forecasting routine

Keep the process light so it actually happens:

• First working day of the month: clean up close dates and stages, then record the worst, commit, weighted and best-case numbers.
• Every week: in your pipeline review, update deals that moved, slipped or died.
• Mid-month: check whether you’re on track for commit; if not, decide what to push.
• Month end: compare forecast with actual and note why they differed.

Common forecasting mistakes

• Stale close dates. Deals with close dates in the past still counting toward this month.
• Happy ears. Reps moving deals forward on enthusiasm rather than buyer actions.
• Probabilities nobody has checked. Default percentages from a template instead of your own history.
• Ignoring seasonality. A lawn care business’s March and a roofer’s December look nothing like their averages.
• Forecasting few big deals with weights. With three large deals, forecast each one as a realistic yes or no and use scenarios.
• Never closing lost deals. Dead deals inflate both pipeline and forecast.

If you use an AI assistant, prompts like “Which deals expected to close this month have had no activity in two weeks?” are a quick way to find the risky ones. Our list of AI prompts for sales has more.

How Exa helps

Exa’s pipelines store a value, stage probability, owner and expected close date on every deal and show weighted totals. Analytics include a monthly revenue forecast showing won, weighted and best-case revenue, alongside pipeline value, weighted pipeline and win rate, for any date range. “Rotting” alerts flag deals that have sat in a stage too long, which is where stale forecasts usually come from.

The AI assistant answers natural-language questions about your pipeline, with charts, and summarizes deals with highlights, risks and next steps, which makes it faster to decide which “likely” deals are really likely. For a complete reporting routine around the forecast, see sales reporting.

Final thoughts

Good forecasting for a small team doesn’t need a data scientist. Keep deal data current, use the weighted method, cross-check it with your history, present a range and compare forecast to actual every month. Within a few months, you’ll have a forecast you can plan around and a pipeline that tells you the truth.