Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Our Sales Forecast Is Whatever the Reps Say It Is. How Do We Get a Number the Board Can Trust?
Problems We Solve

Our Sales Forecast Is Whatever the Reps Say It Is. How Do We Get a Number the Board Can Trust?

A sales forecast built from reps' gut feel misses every quarter. We build machine learning forecasts from your CRM history showing what the pipeline will close.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

When the quarterly forecast is the sum of what each rep expects, it carries every rep's optimism or caution. A model trained on how deals in your CRM actually progressed, looking at stage, age, activity, deal size and history, estimates what the current pipeline is likely to close, giving a forecast range you can compare against the reps' call.

The forecast call

Every month the sales leaders go round the table. Each rep says what they expect to close. Some are always optimistic, some sandbag, and the sales director applies a mental discount based on who is talking. The total goes to finance and the board. At the end of the quarter it is wrong again, sometimes over, sometimes under, and the explanations are always about individual deals.

Finance has stopped trusting the number and builds its own. Hiring, cash planning and production decisions are made on a figure everyone knows is unreliable.

Why rep-based forecasts miss

A rep's view of a deal is shaped by the last conversation, the buyer's enthusiasm and their own targets. They see their deals up close but not the pattern across hundreds of past deals: how often deals of this size, at this stage, with this little recent activity, actually closed.

CRM stage probabilities were meant to solve this, but they are usually the fixed defaults that came with the CRM, a set percentage per stage that nobody has checked against your history. And deals sit in stages long after they have gone quiet, because nobody likes marking a deal as lost.

Close dates make it worse. A deal expected this month slips to next month, then the month after, and each time it is counted again in the current forecast. Looking at any one deal, the slip seems reasonable. Looking across the pipeline, the same deals have been "closing next month" for a long time.

What an unreliable forecast costs

PatternConsequence
Optimistic forecastHiring and spending ahead of revenue that does not arrive
Cautious forecastMissed chances to invest or stock up
Stale deals in pipelineA pipeline that looks healthy but is not
Parallel forecastsFinance and sales argue about numbers instead of acting
Board confidenceLeadership credibility suffers with every miss

The time cost is real too. Forecast calls that spend an hour debating individual deals could be spent on the few deals where attention would change the outcome.

How we forecast from how your deals actually behave

  1. We pull opportunity history from your CRM, such as Salesforce, HubSpot, Pipedrive or Dynamics, including every stage change, amount change, close date change and activity.
  2. We reconstruct what the pipeline looked like at past points in time, so the model learns from the information available then rather than hindsight.
  3. We train a model that estimates, for each open deal, the chance it closes this period and the likely amount, using stage, age in stage, activity, deal size, product, source and the owner's historical accuracy.
  4. We roll deal-level predictions into a forecast range for the period, by team and product, and backtest it against past quarters.
  5. We show the model's forecast next to the reps' call in a dashboard, with the deals where they differ most listed first, because those are the ones worth discussing.
  6. We flag stale deals, such as those with no activity or repeatedly pushed close dates, and refresh the forecast as the CRM updates.

The model does not replace the reps' judgement. Sometimes a rep knows something the data does not. The value is in seeing where the two disagree and asking why.

What leadership gets

A forecast range based on how deals really progress in your business, available whenever the CRM updates. A clear list of the deals where the reps and the data disagree. A pipeline that is cleaned of stale deals because they are flagged automatically.

Finance and sales look at the same number, and forecast meetings move from debating every deal to discussing the handful that matter.

It also gives sales managers a coaching tool that does not feel like an accusation. Showing a rep that deals like theirs, at this stage and with this little activity, rarely close this quarter is a conversation about the pipeline, not about their honesty.

Is this your situation?

  • The sales forecast is the sum of what reps say they will close.
  • Forecasts miss most quarters, in either direction.
  • Finance keeps its own version of the forecast.
  • The CRM holds many deals that have gone quiet but are still open.
  • You have a couple of years of opportunity history in the CRM.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

How much CRM history is needed?

Enough closed deals to see patterns by stage and deal type. If deals are few and large, the model is less useful and simpler checks on stale deals may be the better start.

Our reps do not update the CRM well. Does that stop this?

It reduces accuracy. Missing activity and stale stages are common, and part of the work is flagging where data is missing so it improves.

Will the model replace the forecast call?

No. It changes the call, focusing discussion on deals where the model and the rep disagree.

What drives the cost?

The CRM platform and how much history it keeps, the number of products and teams, and where the forecast needs to be shown.

What do you need from us?

CRM access with opportunity history, past forecasts if you kept them, and time with a sales leader and someone from finance.

Keep reading

More on Problems We Solve

Start here

Tell us what your data should be telling you

Describe the decision you want to improve and the data you already keep. We will give you a straight answer on whether machine learning fits, and if a report or a simple rule would do the job, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →