Sales Forecasting in CRM: 3 Criteria for a Reliable Forecast
Jacek Szafader September 7, 2026 You're reading:
- How to build a reliable sales forecast based on CRM data
- Why CRM sales forecasts miss the mark
- A clogged sales funnel, or where dead opportunities in the pipeline come from
- Step 1. Qualifying a sales opportunity, or the entry criterion for the funnel
- Step 2. Assessing the maturity of a sales opportunity: BANT and MEDDIC in practice
- Step 3. A sales forecast built exclusively from mature opportunities
- How long it takes to implement pipeline management
- Sales forecasting in CRM — frequently asked questions
How to build a reliable sales forecast based on CRM data
Almost every company with more than ten employees has some kind of CRM today — a proper system, a spreadsheet, or something bolted onto the mailbox. And yet two out of five sales forecasts turn out to be wrong, and roughly half of all implementations fail to deliver the goals set at the outset.
That pairing is uncomfortable, because it shows the problem isn’t a missing tool. The tool is there. The problem is what we put into it, and by what rules we calculate what comes out of it.
Why CRM sales forecasts miss the mark
A few years ago, the owner of a CRM project was the sales director, and the system mainly answered the question “what is my salesperson doing?”. Over the last two years that has clearly shifted. The sponsor of an implementation is increasingly the CFO, controlling, or the board directly — and not at all because they want to control the sales force.
The reason is simpler. A well-run sales funnel doesn’t primarily tell you how much you’ll earn. It tells you how to prepare the company’s resources: when to fire up another production cell, when to order machines, how many engineers to hire for the projects that will actually land next quarter. This is steering the capacity of the business, not a report for the sales department.
So if the CRM shows something other than reality, the consequences reach far beyond sales. You’re planning hiring and production on the basis of fiction — just nicely formatted in tables.
A clogged sales funnel, or where dead opportunities in the pipeline come from
A typical conversation at a first meeting goes like this: the client shows a sales pipeline worth PLN 550,000 and it looks pretty good. Only once you go one level down does it turn out that one opportunity has been sitting in negotiations for 142 days, another for 210, and a third dates back two years. Close dates get pushed from quarter to quarter, amounts are entered by gut feel.
Formally, all of it is in the funnel. In practice the funnel has become a waiting room and a repository of curiosities with microscopic chances of success — and in the report every one of those entries looks exactly like a real, mature project.
This happens for one reason: there is no classification criterion in that set. Nobody has established the binary line that says “you are a sales opportunity, and you are not”. Without such a line, everything a salesperson has ever identified as a topic falls into the funnel.
Below are three steps that draw that line. None of them is technically difficult. What’s difficult is the decision to introduce them and stick to them.
Step 1. Qualifying a sales opportunity, or the entry criterion for the funnel
The answer is not an elaborate form with dozens of fields. One or two criteria are enough — but hard ones, the kind that can’t be interpreted to suit yourself.
- The client has named the problem and knows what that problem is costing them. Not "the client is interested", but: the client has stated themselves that something is running sub-optimally, and that this sub-optimality costs them a specific amount per year.
- The client has assigned resources to solving that problem. The board or another authorised unit has designated a person or a team to look for a solution.
If both elements are in place, something really is taking shape at the client — we are still a long way ahead of a budget, but the project exists. If either is missing, the topic is not a sales opportunity. It is a marketing activity or client education and it should live somewhere else: in a campaign, in a contact database, in the waiting room. Not in the pipeline, next to projects the client is genuinely already working on.
Note that this kind of opportunity qualification doesn’t require an essay from the salesperson. It requires two check marks and two pieces of information: who is on the team and how much the unsolved problem costs. The difference is fundamental — the salesperson knows this anyway from the conversation, but until they tick it off, only they know it, not the organisation.
Step 2. Assessing the maturity of a sales opportunity: BANT and MEDDIC in practice
Let’s assume the funnel now contains only genuine sales opportunities. Another problem appears: they’re all at one of three stages — proposal, negotiation, closing — and that tells a decision-maker absolutely nothing.
Why? Because such stages are the bookkeeping of our own sales process. They show how much work the salesperson has put in, but the client disappears from that view. Two opportunities may formally be stuck in “negotiations” while one is a week away from signature and the other is only just starting a serious conversation.
The solution is to reflect the client’s buying process — and that’s what ready-made maturity assessment methodologies are for.
How BANT differs from MEDDIC
These are not synonyms, and it’s worth telling them apart:- BANT — four criteria: confirmed budget (Budget), identified decision-makers (Authority), a defined need (Need), time pressure on the client's side (Timeline). The simplest grid, good to start with.
- MEDDIC — six criteria, with much finer granularity: measurable benefits (Metrics), the budget holder (Economic buyer), decision criteria (Decision criteria), the decision process (Decision process), identified pain (Identify pain), an advocate on the client's side (Champion).
Maturity signals in B2B sales and engineering projects
In engineering sales — whether it’s new technology or a general contractor building a hall — a few signals speak remarkably well to how advanced a deal is:- a completed technical dialogue,
- the client asking for a substantive revision of the proposal (not a price cut) and the issuing of an updated version,
- the involvement of the client's legal department, which usually sits very close to the board.
How to check whether a status in the CRM is true
The objection will come that statuses are easy to fake: the salesperson clicks everything green for a quiet life. That’s true, and that’s why every light must be backed by a fact, not a declaration.
The simplest test concerns decision-makers. Salespeople naturally get attached to one person on the client’s side — usually the one who is most willing to pick up the phone, replies fastest and shows no impatience. Except that in B2B the decision is almost always made by a group: future users, technical experts, the budget holder, legal, and finally the board.
So if the “Authority” field is showing green, and there isn’t a single name in the system besides that one person, they’re not in the emails or the meetings, and the salesperson can’t say what those people think about our solution — the status is untrue. This is, incidentally, one of the better moments for coaching the team: not general sales training, but a specific conversation about the fact that the decision-maker area is being neglected.
Step 3. A sales forecast built exclusively from mature opportunities
The CFO comes along and asks about the forecast. There are two popular schools of answer. The first: show everything in the funnel, enjoy thirteen minutes of glory, and wait for the “let me check that”. The second: show less and then surprise on the upside. Neither has much professionalism in it.
The solution is mechanical: only opportunities with a full set of green lights go into the forecast. Full BANT or full MEDDIC. Everything else stays in the CRM but doesn’t count towards the number the board sees.
That cuts off debates and subjective judgements along the lines of “I feel this client is more of a sure thing than that one”. The sales forecast stops being built on a salesperson’s intuition and starts being built on facts — because every light has to be backed by a fact.
A time rule that clears dead opportunities out of the forecast
It’s worth adding a second filter, a purely arithmetical one. Check in your data from the last two years how long, from an unambiguously measurable point — submitting the final proposal, completing a PoC, anything that can be measured without interpretation — it took you to close sales. If it turns out that 90 percent of deals closed within 120 days, then anything older than 120 days has a negligible chance of a positive ending and automatically drops out of the forecast, even if it’s formally still hanging in the system.
A side effect of both rules is that the commit forecast is never higher than the entire pipeline. It sounds obvious — until you see a CRM where it’s the other way round.
How long it takes to implement pipeline management
The board gets two numbers that don’t lie: a high-probability forecast based on mature opportunities, and a preliminary forecast on the whole. With long or phased deliveries, the funnel can additionally be arranged to account for the phasing of revenue over time — and then it simply becomes the revenue part of the financial forecast.
Contrary to appearances, this is not a multi-month IT project. For a company with a reasonably homogeneous market and products, putting pipeline management in order is about two months’ effort. For a diversified business — several product lines, different customer groups — four to five months.
Far more important than the time is who initiates the project. If it comes from the very top, from the board or the CFO, then they later become the readers of the pipeline report and ask for it every month. The implementation doesn’t fizzle out after three quarters, because someone at the top is asking questions.
There is one cultural condition, without which everything else falls apart: if someone enters the truth into the system, they cannot be punished for it. Salespeople would rather enter anything than enter nothing, because the absence of new information is sometimes read as an absence of work. As long as that’s the case, no criterion will ever be filled in honestly.
Sales forecasting in CRM — frequently asked questions
Why is a CRM sales forecast sometimes higher than the entire pipeline? Because the funnel has no objective criteria for assessing an opportunity, and salespeople enter close dates and amounts by gut feel, usually towards the end of the quarter. Once entry and maturity criteria are introduced, that situation stops being possible.
Which sales opportunities should go into the forecast? Only those with a full set of confirmed maturity criteria — full BANT or full MEDDIC — and falling within your company’s historical deal closing time.
Is it better to use BANT or MEDDIC to assess sales opportunities? BANT is simpler and gets adopted faster; MEDDIC gives finer granularity in long buying processes. In practice, a hybrid tailored to the company’s business model works well.
How many CRM fields do you need to qualify a sales opportunity? One or two. Elaborate forms don’t improve data quality, they only increase the number of entries filled in just so the system lets you move on.
If you’d like to check how your organisation measures up against these three steps — we’ve prepared a short funnel health check: Pipeline Management Health Check
On that basis, our consultant prepares a report with a list of gaps and recommendations on where to start.