Sales Forecasting Methods: Four Simple Ways for a Small Business to Estimate Next Month's Sales

Should you hire another salesperson next quarter? Can you afford a bigger ad budget in December? Will you make this month's number? Each of those decisions rests on a guess about future sales, and in many small businesses the guess lives in the founder's head. It doesn't have to. A handful of simple calculations, run from records you already keep, turn that guess into an estimate you can defend.

This guide walks through four sales forecasting methods that suit small and mid-sized teams, with the formula for each, a worked example in rupees, when to use it and the trap to watch for. It ends with a monthly routine that makes your estimates a little more accurate every month.

What a sales forecast is, and what it isn't

A sales forecast is an estimate of the revenue your business will close in a specific period, such as next month or next quarter. It draws on past results, the deals currently in your sales pipeline and your team's judgement. It is used to plan hiring, spending, stock and cash flow.

It is not a target. A target is the number you want. A forecast is the number you expect, based on evidence. The gap between them is useful: it tells you how much extra pipeline, how many extra leads or how much extra effort you need, and whether the target was realistic in the first place.

Method 1: Historical forecasting

How it works: take the revenue from a comparable past period and adjust it for growth or known changes. Formula: last comparable period's revenue × (1 + expected growth rate).

Example with invented figures: a Jaipur furniture maker closed ₹20,00,000 last November. The business has grown by about 15% over the year. The historical estimate for this November is ₹20,00,000 × 1.15 = ₹23,00,000.

• Best for: steady businesses with clear seasons and at least a year of reliable sales records.
• Watch out for: it assumes the future looks like the past. A new competitor, a big campaign or two reps leaving won't show up in it.

Method 2: Weighted pipeline forecasting

How it works: give each pipeline stage a probability of closing, multiply each open deal's value by its stage probability and add the results. Formula: sum of (deal value × stage probability).

Example with invented figures for a B2B services firm, with probabilities taken from its own history:

The raw pipeline says ₹29,00,000. The weighted estimate says a more realistic ₹12,10,000. The probabilities are where this method lives or dies. Work them out from your own records: of the deals that reached Proposal sent in the last two quarters, how many were won? If you can't answer that yet, start with cautious figures and correct them every quarter. Clear deal stage definitions, with rules for what must be true before a deal moves, make those figures meaningful.

• Best for: B2B and high-value sales with a defined pipeline and several weeks between first contact and close.
• Watch out for: probabilities copied from a blog post rather than your own history, and deals sitting in late stages for months, inflating the total.

Method 3: Rep commit forecasting

How it works: each salesperson sorts their open deals for the period into three groups:

• Commit: I am confident this closes this period.
• Best case: this could close if things go well.
• Pipeline: possible, but unlikely this period.

The estimate is the total of the commit deals, with best case showing the upside. Example with invented figures: across a team of five, committed deals total ₹14,00,000 and best-case deals ₹6,00,000. The estimate is ₹14,00,000, with an upside of ₹20,00,000.

• Best for: experienced teams where reps know their buyers well.
• Watch out for: temperament. Some reps are always optimistic, others sandbag. Track each person's commit against what they actually closed and weigh their calls accordingly.

Method 4: Lead-based forecasting

How it works: estimate from the leads you expect, the share that become customers and the average deal size. Formula: expected leads × lead-to-customer conversion rate × average deal size.

Example with invented figures: a coaching institute expects 300 enquiries next month. Historically, 4% enrol, and the average fee is ₹50,000. Estimate: 300 × 0.04 × ₹50,000 = ₹6,00,000. A lead conversion rate calculator gives you the conversion figure for each step from enquiry to sale.

• Best for: high-volume, short-cycle sales such as coaching, D2C and many local services.
• Watch out for: source mix. Conversion rates differ by channel, so if next month's leads come mostly from a lower-converting source, an overall average will overshoot. Calculate it per major source where you can.

Comparing the four methods

Combine two methods

Each method has blind spots, so run two. Calculate the weighted pipeline figure, collect rep commits, and compare. If they are close, plan with confidence. If they are far apart, the gap is the agenda for your next sales meeting: go through the specific deals behind the difference. Sense-check both against the historical figure for the same period.

A monthly forecasting routine

1. 1First working day: clean the pipeline. Every deal with no activity for several weeks either gets a real next step or is marked lost with a reason.
2. 2Update close dates. A deal that has been closing next week for two months is not part of this month's number.
3. 3Calculate the weighted pipeline for the month and the quarter.
4. 4Collect rep commits and best-case lists.
5. 5Compare and discuss where the two figures differ.
6. 6Write down the number you are planning with, and the date.
7. 7Last working day: compare the estimate with what closed. Which deals slipped, and why?
8. 8Adjust. If deals at one stage keep closing less often than assumed, lower that stage's probability.

After three or four months, your stage probabilities reflect your real business rather than a guess, and the gap between estimate and actual narrows. Our guide to sales pipeline stages helps if your stages are too vague to support this yet.

Where DigiPix Flow fits

DigiPix Flow keeps the records these methods depend on in order. Its sales pipeline has your own stages, fields a deal must have before it moves, close-date rules and won and lost reasons, so stuck and dead deals are easy to find. The pipeline by stage report gives the count and value of open deals in each stage, the home screen shows a 30-day win rate, and deals export as CSV or Excel files.

The product does not calculate a forecast or weight deals for you. The arithmetic in this guide is yours to run in a spreadsheet, from numbers your team has kept honest.

Plan with numbers, not hope

A good forecast doesn't need to be perfect. It needs to be honest and a little more accurate each month. Start with a weighted pipeline, check it against one other method, keep your pipeline clean with a regular sales pipeline review and compare every estimate with what actually happened.

Want pipeline records clean enough to plan from? Talk to an expert and we'll set up stages, required fields and lost reasons around how your team sells.