Five Sales Forecasting Mistakes That Cost Indian SMBs

Most Indian B2B companies between ₹5 crore and ₹200 crore in revenue forecast sales roughly the same way: someone opens the CRM, eyeballs the pipeline, and writes a number in a spreadsheet. It holds up until the quarter a large deal slips — and you have already committed to hiring, inventory or a bank facility against money that never arrived. You don't need a data team to fix this. You need to stop making five specific mistakes.

• Counting total pipeline value instead of probability-weighted value
• Blending enterprise and SMB, new business and renewals, into one number
• Chasing a single precise figure instead of a range
• Running the forecast in a spreadsheet nobody owns
• Confusing revenue booked with cash collected

Here is what each one costs you, and the fix that does not require hiring anyone.

Mistake 1: Pipeline value is not a forecast

A ₹9 crore pipeline does not mean ₹9 crore is coming. It means you have ₹9 crore of hope sitting at different stages of maturity.

Take a Gurgaon B2B services firm with three open buckets: ₹6 crore in stage 2 (demo done), ₹2 crore at stage 3 (proposal sent), ₹1 crore at stage 4 (verbal yes, negotiating terms). The sales head's gut number is ₹4.5 crore. Pull the last eight quarters of closed deals and you find stage 2 converts at 28%, stage 3 at 45%, stage 4 at 70%. The weighted forecast is (6 × 0.28) + (2 × 0.45) + (1 × 0.70) = ₹3.28 crore. Then add one more filter: stage 2 deals sitting untouched for more than 45 days typically close at closer to 11%, and half that ₹6 crore is stale. The realistic number falls to around ₹2.8 crore.

The gap between ₹4.5 crore and ₹2.8 crore is the cost of this mistake. You do not need a data team to compute it. You need one person, one afternoon, and your last 40 to 60 closed deals in a spreadsheet. Even crude conversion rates beat confident guessing, because the guessing has no memory and your closed deals do.

Fix: weight every open deal by stage, not by rep optimism. Force-close or downgrade anything that has not moved in 30 days.

Mistake 2: Blending everything into one number

An enterprise deal that takes 120 days to close and renews annually has almost nothing in common with a ₹40,000 SMB deal that closes in nine days. Averaging them produces a number that describes neither.

Segment your forecast into three or four buckets — new business, renewals or upsell, inbound versus outbound — and give each its own conversion rate and cycle length. If you sell across regions, split by region too; a Mumbai enterprise cycle and a Dubai one rarely move at the same speed.

Seasonality matters more than most founders admit. In India, the fiscal year shapes buying behaviour: January to March is when budgets get spent, April to June starts slow, October and November slow down around the festive period, and December is largely a write-off for new deals. A flat forecast spread evenly across twelve months will be wrong eight months out of twelve.

Mistake 3: Chasing one precise number

When your sales head tells the board "we will do ₹4.2 crore", that number gets treated as fact. It isn't. It is the midpoint of a wide distribution, and the person planning headcount against it usually knows that.

Give three numbers instead: committed (signed or verbally confirmed, with a date), likely (weighted, as above), and upside (everything that could close if it moves). Board and finance conversations get easier immediately, because the question changes from "will you hit it?" to "what happens if we land at the low end?"

Then track your own accuracy. If your "likely" number has come in 25% high for the last four quarters, apply that haircut before you send it. Most companies are optimistic in the same direction every quarter, and a bias you can see is a bias you can correct with one formula.

Mistake 4: A spreadsheet nobody owns, and no cash view

Two failures live here, and they usually travel together.

The first is version sprawl. Six copies of Forecast_Final_v3.xlsx float between sales, finance and the founder, each slightly different, and nobody can say which one is real. Fix it with one sheet, one named owner, one update time — Friday 5pm, say — and a rule that nobody forecasts off a copy. A simple Looker Studio dashboard reading straight from your CRM removes most of the copying.

The second is treating a closed deal as money. Between "signed" and "in the bank" sit a GST invoice, the client's internal approval, TDS deducted at source, and a payment cycle that in Indian B2B typically runs 45 to 60 days and often longer with large buyers. If your buyers are bigger than you and you are registered as an MSME, they have a tax reason to pay you within 45 days, and it is fair to remind them politely on day 30.

So run two views, not one: the sales forecast (what will we book?) and a 13-week rolling cash view (what will actually land, and when?). A deal closing on 28 March that pays in June still has to be funded in April.

Where to start

Pick your last two quarters of closed deals, list them with stage at entry, deal size, segment and days to close, and compute four conversion rates. That single exercise will change the number you take to your next board meeting. If you would rather not build it yourself — or you want pipeline data pulled cleanly out of your CRM into a live dashboard instead of a Friday-night spreadsheet — that is the kind of thing Maysan Labs builds for growing B2B teams.