Revenue Forecasting from Open Deals

Revenue Forecasting from Open Deals

A pipeline total is not a forecast.

If a service business has EUR 40,000 in open deals, that does not mean EUR 40,000 is arriving next month. Some deals will close. Some will slip. Some will go quiet. Planning around the full number turns optimism into a budget.

Revenue forecasting from open deals is the discipline of making that pipeline more honest.

The Three Inputs

A practical forecast needs three fields on each open deal:

Field	Why It Matters
Value	How much the deal is worth
Probability	How likely it is to close
Expected close date	When it may become revenue

Without value, there is nothing to forecast. Without probability, every deal looks equally real. Without close date, the business cannot see whether revenue is likely this month, next month, or later.

For stage design, see deal stages for service businesses.

Why Probability Estimates Drift Without Discipline

Probability is the input most likely to become fiction over time, because unlike deal value (usually a fixed quote) or close date (a real calendar date), probability is a judgment call that nobody is forced to revisit.

A common failure mode: a deal enters the pipeline at 50% probability based on a genuine early read, and then simply stays at 50% for weeks or months while the actual situation changes, because updating it requires someone to stop and think rather than being prompted by an event. A deal that has gone quiet for three weeks should probably have its probability lowered, and a deal where the client just asked detailed contract questions should probably have it raised, but neither adjustment happens automatically.

A practical discipline is to tie probability to observable stage or behavior rather than pure gut feel: "estimate sent" might default to 25%, "client asked follow-up questions" to 40%, "verbal yes pending paperwork" to 75%. Anchoring probability to something concrete makes it easier to catch when a number is stale, and easier for a second person reviewing the pipeline to sanity-check it without having to read the salesperson's mind.

Weighted Forecasting

The simplest useful forecast is weighted value:

deal value x probability = weighted forecast value

Examples:

Deal	Value	Probability	Weighted Value
Website redesign	EUR 4,000	25%	EUR 1,000
Clinic fit-out quote	EUR 8,000	50%	EUR 4,000
Maintenance contract	EUR 2,000	80%	EUR 1,600

The raw total is EUR 14,000. The weighted forecast is EUR 6,600.

That second number is usually the better planning number. It still will not be perfect, but it is less misleading than assuming every open deal closes.

Large Deals Can Distort A Small Pipeline

In a small service business, a single large deal can dominate the entire forecast, which creates a specific risk worth watching for deliberately: if one EUR 15,000 contract makes up most of a EUR 20,000 weighted forecast, the accuracy of the whole month's plan hinges on that one deal's probability estimate being right. A smaller, more diversified pipeline spreads that risk across several deals, so no single misjudged probability throws off the whole picture. When reviewing a forecast, it is worth explicitly checking whether one or two deals make up a disproportionate share of the weighted total, and treating that concentration as a reason for extra scrutiny rather than comfort.

Time-Phased Forecasting

Expected close date turns one forecast number into a planning view.

Two businesses can both have EUR 20,000 of weighted pipeline. One expects most of it this month. The other expects it over the next quarter. Those are very different operating situations.

This is why a forecast grouped by expected close month is useful. It can show whether next month looks thin while there is still time to add pipeline or follow up stale deals.

What Tregovia's Sales Pipeline Supports

Tregovia's Sales Pipeline add-on stores:

• Deal value
• Deal probability
• Expected close date
• Stage
• Status
• Source channel and source detail
• Activity history

The module also includes forecast analytics. The service groups open deals by expected close month and returns total value and weighted value, calculated from deal value and probability.

That means Tregovia can support a real weighted pipeline forecast without exporting every deal to a spreadsheet first.

For stale-pipeline cleanup, read how to recover stale deals in your sales pipeline.

Forecasting Is A Habit, Not A One-Time Setup

Entering value, probability, and expected close date once when a deal is created is the easy part. The harder, ongoing part is revisiting those fields as circumstances change, and skipping that maintenance is the most common reason forecasts stop being trusted after a few months.

A forecast that was accurate on day one but never gets updated as deals evolve slowly turns into fiction the team quietly learns to ignore, which defeats the purpose of building it in the first place. Treating a weekly pipeline review as a standing habit, rather than a one-time setup task, is what keeps the numbers connected to reality long enough to be worth checking before making a real staffing or spending decision.

What The Forecast Does Not Do

Tregovia does not inspect every conversation and assign close probability on its own.

The team still has to keep deal values, probabilities, stages, and expected close dates accurate. That is not a weakness. In a small service business, a maintained forecast based on clear stage discipline is usually more useful than a black-box prediction nobody trusts.

A Practical Forecast Review

Once a week, review:

1. Deals with no expected close date.
2. Deals with no recent activity.
3. Deals with probability that no longer matches reality.
4. Deals expected to close this month.
5. Weighted value by month.
6. Large deals that distort the forecast.

The goal is not to predict the future perfectly. It is to make bad planning assumptions visible early.

Pricing Snapshot

The base Tregovia CRM plan is EUR 47/month. Sales Pipeline is an EUR 10/month add-on, so a CRM-plus-pipeline setup is EUR 57/month before any other add-ons.

For the broader sales pipeline context behind stages, stale deals, and forecasts, see the sales pipeline FAQ.

The Bottom Line

Open-deal revenue forecasting works when the pipeline has value, probability, and timing.

Tregovia's Sales Pipeline module stores those inputs and includes weighted forecast analytics grouped by expected close month. Use it as an operating forecast, not a promise. The number gets better when the team keeps deal stages, probabilities, close dates, and activity history current.

Frequently Asked Questions

What is revenue forecasting from open deals?

It is estimating likely future revenue from deals that are still open, using deal value, probability, and expected close date instead of simply adding every open deal at full value.

How do weighted forecasts work?

A weighted forecast multiplies deal value by probability. A EUR 2,000 deal at 40% probability contributes EUR 800 to the weighted forecast.

Does Tregovia support revenue forecasting?

Yes. The Sales Pipeline module stores deal value, probability, and expected close date, and includes forecast analytics grouped by expected close month with total and weighted value.

Does Tregovia set deal probabilities for you?

No. Tregovia provides the pipeline data and forecast analytics. The team still maintains deal probability, stage, value, and expected close date.

What does Sales Pipeline cost?

Sales Pipeline is an EUR 10/month add-on on top of the EUR 47/month base CRM plan.