Skip to content
← All articles

Notes for owners · Sales management

Sales forecasting for SMEs: a simple, practical method

Forecasting an SME's sales needs no model, just stages defined by buyer behaviour, a weekly review, and a recorded expected close date.

The GullySales team · Updated 15 Sept 2026 · 7 min read

Editorial illustration for Sales forecasting for SMEs: a simple, practical method
On this page
  1. Why most SME forecasts are useless
  2. Define the stages by buyer behaviour
  3. The weekly review that makes it work
  4. A worked example, with illustrative figures
  5. Separate the big deals from the rest
  6. What to check at the end of each quarter
  7. What to do next

A workable forecast for a small business needs three things and no mathematics beyond multiplication. Stages defined by what the buyer has done, rather than how the salesperson feels. A probability fixed for each stage, and an expected close date on every live deal, reviewed weekly. Multiply the value of each deal by its stage probability, add them up, and check the total against what actually closed. Do that for two quarters and you will have a forecast good enough to plan cash, hiring and production around, which is all a forecast is for.

Why most SME forecasts are useless

Because the stage is set by optimism. A deal sits at "90 per cent, closing this month" for five consecutive months because nobody has asked what the buyer has actually done. The sales meeting becomes a discussion about how confident everybody feels, and the number produced is a mood reading.

The second reason is that there is no close date, or the date is always the end of the current month. A forecast with no dates cannot be checked, and a forecast nobody checks never improves.

The third is that lost deals are not recorded. If a deal simply disappears from the sheet, you cannot calculate a conversion rate, and without a conversion rate you cannot forecast anything except by guessing.

Define the stages by buyer behaviour

This is the whole trick. Each stage is a verifiable thing the buyer has done, so two people looking at the same deal put it in the same place.

StageWhat the buyer has doneProbability
EnquiryMade contact with a requirement5 per cent
QualifiedConfirmed budget range, timeline and who decides15 per cent
Requirement understoodGiven you the specification, drawing, site access or brief30 per cent
Quotation submittedReceived your written quotation45 per cent
NegotiationDiscussed commercial terms or asked for revisions65 per cent
Verbal confirmationSaid yes and named the paperwork that remains85 per cent
WonPurchase order or signed agreement received100 per cent

Set the percentages from your own history once you have two quarters of data. Until then these are a reasonable starting point for Indian B2B with a six to twelve week cycle. Adjust them, but adjust them for everybody at once, not deal by deal.

The weekly review that makes it work

Thirty minutes, same day every week, same four questions per deal. Nothing more elaborate survives in a small business.

What has the buyer done since last week? If the answer is nothing, the stage does not move, whatever the salesperson feels. What is the next step, with a date and an owner? What is the expected close date, and has it moved? If a date has slipped twice, the deal goes back a stage or comes off the forecast. And is the decision maker identified by name?

Then one habit that costs nothing and improves accuracy more than anything else: record every loss with the buyer's actual words. Three months of that gives you a real conversion rate per stage and per source.

A worked example, with illustrative figures

Take a packaging manufacturer in Peenya, Bengaluru selling corrugated boxes to food and pharmaceutical companies. Illustrative pipeline for the quarter:

StageDealsTotal valueWeighted
Qualified12₹36 lakh₹5.4 lakh
Requirement understood8₹32 lakh₹9.6 lakh
Quotation submitted9₹41 lakh₹18.4 lakh
Negotiation4₹22 lakh₹14.3 lakh
Verbal confirmation2₹9 lakh₹7.6 lakh
Forecast for the quarter₹1.4 crore in pipeline₹55.3 lakh

Two things come out of this table that a revenue figure alone would hide. The weighted forecast is about 40 per cent of the pipeline, which is normal and tells the owner not to plan on the headline number. And the top two stages hold only six deals, so almost everything closing next quarter has to come from the twenty deals below them. If the owner needs ₹70 lakh, the gap is visible now, in April, rather than in June.

Separate the big deals from the rest

Any deal large enough to change the quarter on its own should be forecast by name, not by formula. List them separately with the decision maker, the date, the remaining step and what could stop it. Three lines each.

Everything else goes in the weighted pool. This split prevents the most common forecasting accident in an SME: one large order slipping by six weeks turns a good quarter into a bad one. Nobody sees it coming, because it was averaged into a total.

What to check at the end of each quarter

  • Forecast at the start of the quarter against actual revenue, as a percentage.
  • Which stage the misses were sitting in when the quarter began.
  • Average days spent in each stage, and where deals are getting stuck.
  • Conversion rate from quotation to order, which is the number most worth improving.
  • Losses by reason, in the buyer's words rather than in a dropdown.

Five checks, one page, thirty minutes. Do it four times and your stage probabilities become yours rather than borrowed.

What to do next

List every live deal with a value, a stage based on what the buyer has done, and an expected close date. That sheet, honestly filled, is a forecast, and most SMEs do not have one. Then compare its weighted total with what you need this quarter, because the gap is easier to close in week two than in week eleven. We report on enquiries and orders rather than activity, and setting up stages your team will actually use is part of the work that follows.

Questions

Questions owners ask.

How accurate should an SME forecast be?
Within about 15 per cent of the quarter's actual revenue is a reasonable standard for a small business, and most start much worse than that. What matters more than the percentage is that the error is consistent, because a forecast that is always 20 per cent optimistic is still useful once you know it.
Do we need a CRM to forecast?
A spreadsheet works up to perhaps fifty live opportunities if one person maintains it weekly. Past that it breaks down, because nobody can keep the close dates current by hand and the forecast quietly becomes fiction.
Should the salesperson set the probability on a deal?
No. Set the probability by stage, and let the stage be decided by what the buyer has done. A salesperson's confidence is the least reliable input in forecasting, and asking for it turns the review into a negotiation.
How do we forecast when order values vary enormously?
Forecast the large deals individually by name, with a date and a named decision maker, and forecast the rest as a pool using your historical conversion rate. Mixing a two-crore project into an average with fifty small orders produces a number that is wrong in both directions.

From the blog

More notes for owners.

Your next practical step

Tell us what you are trying to grow, and we will read it before we call.

Eight short steps, mostly taps. Skip anything you would rather answer on the call.