Forecasting in the CRM: how to build reliable sales predictions

Mon Projet CRM - 4 octobre 2024

Forecasting, or sales forecasting, involves estimating expected revenue over a given period (month, quarter, year) based on the opportunities currently in the sales pipeline. A well-maintained CRM makes this process faster, more consistent, and more objective: it relies on shared data rather than individual intuition. For a sales leadership team, effective forecasting enables resource planning, helps detect deviations from the plan, and allows for earlier decision-making. This article explains what makes a forecast reliable, the most common methodologies, and the requirements for making it a valuable tool.

What is forecasting in a CRM?

Forecasting involves projecting probable revenue over a given period based on current opportunities. It relies on data recorded in the CRM: opportunity value, sales cycle stage, estimated closing date, and win probability.

The goal is not to achieve a perfectly exact figure, but an estimate reliable enough to steer the business: deciding whether to hire, launch a campaign, or adjust an action plan.

Most common forecasting methods

Several approaches coexist, often used in combination:

  • Stage-based forecasting: applying a win probability to each pipeline stage (e.g. 20% at qualification, 60% at proposal, 90% at negotiation).
  • Weighted forecasting: multiplying each opportunity by its specific probability to obtain a more granular view.
  • Commit forecasting: the sales representative indicates for each opportunity whether they commit to it, or consider it likely or just possible.
  • Historical forecasting: using conversion rates observed over previous quarters to calibrate forecasts.

Indicators to track

Useful indicators for managing forecasting:

  • Pipeline coverage: the ratio between pipeline value and the period's target.
  • Conversion rate by stage, to identify where deals are being lost.
  • Forecast accuracy (variance between forecast and actuals) over past periods.
  • Opportunity ageing, to spot stalled deals.

How to make forecasts more reliable

Reliable forecasting first requires a shared definition of sales cycle stages: everyone must know what distinguishes a deal 'in negotiation' from one 'in proposal'.

Simple rules for updating opportunities are also necessary, such as a weekly review where each sales rep updates their records. Without this discipline, the pipeline reflects age rather than reality.

Common pitfalls to avoid

Several classic traps:

  • Confusing pipeline with forecast: a large pipeline does not guarantee high revenue.
  • Allowing each sales rep to define their own probability rules.
  • Pushing to artificially inflate opportunities at the end of the quarter.
  • Never comparing forecast vs. actuals, which prevents learning.
  • Seeking absolute precision when the goal is primarily to inform decision-making.

Questions to ask yourself

Key questions to frame the process:

  • Are our pipeline stages defined and shared by all sales reps?
  • How frequently do we update opportunities in the CRM?
  • Do we compare our forecasts to results to learn?
  • What concrete decisions do we make based on the forecast?
  • Does management use the CRM as the single source of truth for forecasting?

Going further

Forecasting is closely linked to the sales cycle and CRM performance KPIs. You can explore further with our articles on the sales cycle, KPIs to track, and opportunity management.

Key takeaways

  • Forecasting in a CRM involves projecting probable revenue based on current opportunities.
  • Several methods coexist (by stage, weighted, commit, historical) and can be combined.
  • Reliability depends primarily on shared definitions of stages and data entry discipline.
  • Regularly comparing forecasts against actuals is essential for improvement.
  • The goal of a good forecast is not perfection, but the ability to make better decisions, sooner.

Want to go further?

Discover our tools, checklists and templates to apply these recommendations immediately.

Access the tools Talk to an expert

In the same category