Blog Post

Your Sales Forecast Is Wrong Because Your Pipeline Is Blocked

Most business owners understand the importance of forecasting revenue. In manufacturing, professional services and commercial trades, the consequences of getting it wrong extend well beyond the sales team. Expected revenue can influence recruitment, purchasing, production planning, subcontractor commitments, equipment decisions and cash flow.

The problem is that many sales forecasts are not really forecasts at all. They are lists of opportunities accompanied by an opinion about which ones might be won.

A healthy pipeline should provide management with a reasonable view of future work. Instead, many pipelines are full of opportunities that have been sitting there for months, quotes that have received little or no follow-up and prospects that were never properly qualified in the first place.

Everything looks positive until the expected orders fail to arrive.

This is particularly dangerous because an optimistic pipeline can create more management problems than an obviously weak one. If there is very little work in the pipeline, at least the problem is visible. When management believes there is $500,000 of credible work ahead but much of it has little realistic prospect of proceeding, decisions are being made on information that cannot be trusted, with dramatic and negative impacts on cash flow.

Know Your Win Rate

To be able to develop a sales forecast you must be able to calculate your win rate, the percentage of quotes that are won. It needs to be measured and not guessed. If you’re looking up right now trying to guess, stop. Only calculate with real numbers from recent and past opportunities. Do not mix win rates from warm referrals and quotes to cold leads, they are different.

When you have your calculated win rate, for example 40%, you can multiply the value of your quoted opportunities by that win rate and begin a reasonable forecast.

$500,000 (of quoted opportunities) X 0.4 (40% win rate) = $200,000 (probable revenue)

The next key to an accurate forecast is understanding both the timing of the opportunity and the likelihood.

The Age Of An Opportunity Matters

To know what revenue is likely to be this month you need to have calculated Deal Days. How many days on average does it take to close an opportunity that was quoted. Again, guessing this is simply dangerous, it needs to be calculated. The more data you use the more accurate it will be.

If it takes an average of 30 days for a quoted opportunity to become won, why do you have opportunities in your pipeline and forecast that are 60 days old? Yes, it might win this month but statistically it’s unlikely. Much better a conservative forecast that you beat than an optimistic one that causes a cash flow crisis.

What we commonly see is a quotation was submitted three months ago. The customer has not said no, so the opportunity remains open. Another customer promised to reconsider the project later in the year, so that remains open as well. An enquiry received several months ago is still classified as active because nobody has taken responsibility for closing it.

Individually these decisions can appear harmless. Collectively they create a misleading picture of future revenue.

An opportunity should remain in the pipeline because there is a factual basis for believing it is progressing, not simply because the customer has never formally rejected the proposal.

That requires meaningful follow-up that includes understanding where the customer is at.

Sending a quotation is not the end of the sales process. The customer may still have unanswered questions, unspoken objections or concerns about the return they will receive from the investment. They are likely evaluating other ways of solving the problem. They may also have changed priorities entirely.

Unless somebody is having those conversations, the business is not managing the opportunity. It is dreaming for a positive outcome.

Forecasting Requires A Documented Sales Process

Reliable forecasting becomes much easier when everyone follows the same sales process. If you know the steps that customers go through to buy from you, it is easy to see the patterns and determine the likelihood of the win.

If one salesperson regards an initial enquiry as a qualified opportunity while another waits until they have confirmed the customer’s requirements and intent, their pipeline values cannot sensibly be compared. Similarly, if one person closes an inactive quotation after a defined period while another leaves it open indefinitely, management is not looking at consistent information.

Documented sales processes provide the discipline required to make pipeline data meaningful. The business can establish what must be true before an opportunity progresses through the pipeline, what information needs to be captured and what activity should occur at each stage.

The CRM can then facilitate those processes and journey through the pipeline. It should also be able to give you the meaningful data that allows management to call out the expired quotes and the dream deal that will never close.

The CRM should support the sales processes and deliver insights from the data. Its purpose is to provide structure, visibility and accountability around a process the business has already agreed to use.

That also means resisting the temptation to track information simply because the CRM makes it possible. Complicated pipelines with excessive stages and fields do not automatically produce better forecasts, you need the right ones. The information being captured needs to help the business understand the customer, manage the opportunity or make a better decision.

Everything else is administration, and that’s where CRM adoption falls over.

Forecasting Is A Management Tool, Not A Sales Report

For many businesses, better pipeline visibility can help with decisions about labour, subcontractors, equipment, materials and cash flow. A business can be fully occupied today while having limited visibility over what will replace current projects when they finish. A boom bust cycle is what happens when a business doesn’t have any visibility of a meaningful pipeline.

Manufacturers considering capacity and purchasing decisions, or professional service businesses making decisions about recruitment and utilisation, need accurate data to forecast and gain the insight they need. The purpose of forecasting is not to produce an impressive sales dashboard. It is to give management better information about what is likely to happen next.

That is why the quality of the pipeline matters more than its headline value. Remove old and hairy opportunities from your forecast.

A smaller pipeline containing properly qualified and actively managed opportunities is far more useful than a large pipeline full of hopeful quotations. One gives management information it can use. The other provides reassurance until reality catches up with it.

Salespeople also need to feel comfortable removing opportunities that are unlikely to proceed. Closing a poor opportunity is not failure. Keeping it open for another six months does not make it more valuable.

In fact, acknowledging that an opportunity has been lost can be extremely useful. It allows the business to understand why, learn from the outcome and focus effort elsewhere.

Start With The Four Questions That Matter

A useful sales forecast does not need to become an exercise in mathematical modelling. It does, however, require discipline.

For every significant opportunity, management should be able to answer four questions. Is this genuinely a qualified opportunity? Where is the customer in their decision-making process? What needs to happen next? Is there evidence that the opportunity is moving forward?

If those questions cannot be answered, applying a percentage to the opportunity in a CRM will not make the forecast more accurate.

The percentage creates an appearance of precision, but the quality of the forecast still depends on the quality of the information underneath it.

That is the real purpose of a sales system. It creates enough consistency for management to understand what is happening without relying entirely on the judgement and memory of individual people.

A good forecast will never predict revenue perfectly, and it does not need to. What it should do is give the business a credible view of future work early enough to make better decisions.

If your forecast regularly says that next month will be strong and next month regularly proves otherwise, changing the spreadsheet is unlikely to solve the problem.

Start with the pipeline.

Remove the opportunities that should no longer be there, qualify the remaining opportunities properly and make sure every genuine opportunity has a clear next step.

The value of your pipeline may fall considerably. Get busy filling it.

The value of the information it gives you will improve.

Sales system that works for your business.