Journal · Analytics

Sales forecasting from CRM data

A forecast based on gut feel misses actuals every month. If your CRM holds amounts, stages and dates, you can forecast from data and check it every week.

A CRM sales forecast combines the value of open deals, the probability of each stage based on past closes, and the payment date adjusted for your average sales cycle. In MakeBiz BI the monthly and quarterly forecast is part of the Standard plan at AED 700 a month, and the first 14 days are free.

MakeBiz Technologies · 11 November 2026 · 7 min read

A forecast is built from three numbers: amount, probability and date

Every open deal in your CRM has an amount, a stage and an expected close date. Those three fields are what a forecast is made of. The amount tells you what you could earn. The probability tells you how likely it is. The date tells you which month the money lands in.

The simplest formula multiplies each deal amount by its stage probability and adds the results up by month: a weighted pipeline. A deal worth AED 40,000 at a stage with a 25% probability contributes AED 10,000 to the forecast. No single deal pays exactly that, but across many deals the errors cancel out.

The weak spot is data quality. A blank amount drops the deal out, and a close date that has said "tomorrow" for three months keeps the forecast sliding. So the data comes first, more on that below.

Stage probability comes from history, not gut feel

In many portals stage probabilities were typed in during setup: 10, 30, 50, 90%. Those are guesses. A real probability comes from closed deals over the last 6 to 12 months: of all deals that reached a stage, how many ended up paying.

StageDeals that reached itOf those, paidProbability
New lead4004812%
Qualified2004824%
Quote sent1204840%
Negotiating terms704869%
Invoice issued554887%

A hypothetical example with made-up figures to show the calculation. Your probabilities are calculated from your own deals.

Recalculate probabilities every quarter and separately for each line of business. A repeat order and a first deal with a new client behave differently at the same stage, and so may separate free zone and mainland teams.

The sales cycle moves the forecast between months

Reps set close dates optimistically, so the deal date is compared with the average cycle from each stage to payment. If deals at "Quote sent" typically close 35 days later and a rep has set a date one week out, the forecast uses the calculated date instead.

The second rule covers stalled deals. A deal that has been sitting at a stage two or three times longer than average is very unlikely to close on time. Those deals go onto a separate list for the sales manager and carry less weight in the forecast. You can hand stalled-deal control to the AI sales manager: the agent watches the pipeline, nudges the rep and alerts the manager if nothing happens.

We build a sales forecast on your CRM

Stage probabilities from history, plan, forecast and actuals on one dashboard. Forecasting in BI from AED 700 a month, 14 days free

Talk about forecasting

Run the weighted pipeline and the rep forecast side by side

Stage maths cannot know what the rep knows: the client has signed internally, but payment will clear after quarter end. That is why a rep forecast runs alongside the weighted pipeline. In Bitrix24 we add a deal field with three values:

  • Commit: the deal will close this period and the rep stands behind it
  • Upside: there is a real chance, but open questions remain
  • Not this period: the deal is alive, but the money will come later

The sales director looks at both. If the rep forecast is far above the weighted pipeline, the team is overrating its deals; far below, and deals may be stuck. The weekly meeting turns to specific deals instead of impressions.

Calls are another source of truth. What a client says about timing and budget often never makes it into the deal record. Call speech analytics, from AED 1,000 a month for 5,000 minutes, helps you see it. Read more in our news on what gets lost between the call and the deal record and on the call analysis agent page.

Clean CRM data comes before the forecast

A forecast inherits every error in your CRM. The minimum checklist before you start:

  1. Every open deal has an amount in AED and a close date
  2. Stages have exit criteria: what has to happen for a deal to move on
  3. No duplicate deals for the same client and the same need
  4. Lost deals are closed with a reason instead of lingering in the pipeline
  5. Deal amount and invoice amount are calculated the same way, with or without 5% VAT

We cover typical data problems in our guide on why CRM reports lie. If nobody has reviewed the portal in a while, start with a Bitrix24 audit. If you have no CRM yet, or the pipeline does not match how you actually sell, you need Bitrix24 setup first: the standard package starts at AED 10,000 and go-live takes from 14 days.

Plan, forecast and actuals belong on one dashboard

A working forecast lives on a dashboard that refreshes itself. One screen, three lines by month: the sales plan, the weighted pipeline forecast and actual payments. Underneath, a table by rep and a list of the deals that carry the most weight in the forecast.

Actual payments are more reliable when they come from accounting rather than from the "Won" stage. We connect Bitrix24 to Zoho Books, QuickBooks or Odoo from AED 10,000, see the integrations page. In MakeBiz BI analytics the monthly and quarterly forecast and stalled deals come with the Standard plan at AED 700 a month, sales plans come with Pro at AED 1,000, and accounting systems are connected to BI on request for an extra fee. The first 14 days are free. To connect ad spend to those payments, see our guide on end-to-end analytics.

A worked example: a distributor with 20 sales reps

A hypothetical Sharjah distributor runs sales in Bitrix24, yet the director builds the monthly outlook in a spreadsheet by calling each rep, and actuals never match it.

First the team cleans up the pipeline: dead deals get closed, amounts and dates get filled in. Then stage probabilities are recalculated from a year of history, and deals get a rep forecast field. A month later the director sees plan, weighted pipeline and actuals on one screen and only discusses deals with gaps at the weekly meeting. What a project like this costs for you is set in a quote before work starts, and rates are on our pricing page.

Questions and answers

How do I calculate the probability of a deal stage?

Take closed deals from the last 6 to 12 months and work out what share of deals that reached the stage ended up paying. That share is the probability, and it should be recalculated every quarter.

What is a weighted pipeline?

It is the total of all open deals, each multiplied by the probability of its stage. It shows expected revenue by month, allowing for the fact that some deals will not close.

How much data do I need for a forecast?

You need a history of closed deals, both won and lost, with amounts and dates. The more deals per period, the more stable the probabilities. With only a few deals, the rep forecast matters more than the maths.

Can I build the forecast inside Bitrix24?

Bitrix24 has basic pipeline reports. For plan, forecast and actual payments from accounting on one screen, a BI dashboard is more practical, and it refreshes automatically.

How much does sales forecasting cost with MakeBiz?

The monthly and quarterly forecast comes with the BI Standard plan at AED 700 a month, and sales plans with Pro at AED 1,000. If the CRM data needs cleaning first, that work is billed at AED 200 an hour against a quote agreed before we start.

We will show you how far your forecast is from actuals

Tell us where you track deals and how you build the plan today. We reply within a business day

By clicking the button you agree to the privacy policy

CallWhatsAppRequest