How to build a week-by-week sales forecast

The monthly forecast has a structural problem: it's produced when it's already too late to act. If you find out on the 25th that the pipeline won't close enough to hit the target, there's no time to fix it.

The solution isn't a more sophisticated forecast. It's a more frequent forecast cadence — with a weekly review that catches deviations while there's still time to adjust.

Why a weekly forecast changes the game

A forecast isn't a magic prediction. It's a continuous process of comparing the current state of the pipeline with what's needed to hit the target — and deciding what to do about the difference.

When that comparison happens weekly, the manager has three or four chances to act before the month closes. When it happens monthly, they have zero.

That changes the nature of management: from reactive to preventive.

Structure of the weekly forecast

Pipeline categories

The first step is to split the pipeline into categories with a clear operational meaning:

• Commit: deals the rep is willing to guarantee will close in the period. High confidence, defined next steps, engaged decision-maker.
• Best case: deals that should close but carry some risk. The rep believes in the close but acknowledges one or two uncertainties.
• Pipeline: deals in the funnel that may or may not close in the period. Included in the overall view, but not in the short-term forecast.
• Upside: opportunities that weren't planned for the period but may be a positive surprise.

This separation creates transparency. The manager sees what's certain, what's likely and what's speculative — and makes different decisions for each category.

The number of the week

Each weekly review should produce three numbers:

1. Commit forecast: the sum of deals in the commit category expected to close this month
2. Best-case forecast: commit + best case
3. Gap to target: the difference between the best-case forecast and the month's target

The gap is the most important number. It sets the urgency of the week's actions.

The pipeline review

Beyond the forecast, the weekly review should include an analysis of the state of the pipeline:

• Which deals moved to a new stage in the last seven days?
• Which deals have been stalled for more than X days with no activity?
• What is the current pipeline coverage vs. what's needed?
• How many new opportunities entered the funnel?

A stalled deal is the forecast's worst enemy. An opportunity that doesn't move for weeks rarely closes on the expected date — and keeping it in the forecast distorts the prediction.

The weekly review ritual

A weekly forecast doesn't work without a structured ritual. It's not a status meeting — it's a decision meeting.

Suggested format (45 to 60 minutes):

Part 1 — Numbers (10 minutes) The manager presents the current forecast, the gap to target and the comparison with the previous week. Everyone starts from the same baseline.

Part 2 — Deal review (25 to 35 minutes) Each rep presents their commit and best-case deals. For each deal, the manager asks objective questions:

• What is the concrete next step?
• Who is the decision-maker, and are they engaged?
• What could prevent the close?
• Is the timeline still realistic?

This conversation exposes at-risk deals before the close is lost.

Part 3 — Actions for the week (10 to 15 minutes) Based on the gap and the risks identified, the team defines what needs to happen next week: which deals need to be accelerated, which new leads need to be prospected, which proposal needs revising.

Want to structure a weekly forecasting process in your operation? Nexo implements and runs this model. Talk to the team.
Take the free assessment

How to deal with reps' excess optimism

One of the biggest forecast risks is optimism bias: reps tend to believe more deals will close than actually do. That inflates the forecast and masks the problem.

Some practices to calibrate it:

Use historical conversion rates, not individual estimates If history shows that only a fraction of opportunities at a given stage close within the month, apply that factor to the current pipeline — regardless of what the rep thinks.

Question the evidence, not the intention In the review, ask about what the buyer did — not what the rep believes will happen. "Did the buyer confirm the timeline internally?" is a different question from "do you think it'll close by the 30th?"

Track each rep's historical accuracy Some reps are systematically optimistic; others are conservative. Knowing that pattern helps calibrate the weight of each individual prediction.

Connecting the weekly forecast to revenue predictability

The weekly forecast is the backbone of revenue predictability. Without it, predictability is an intention — with it, it's a process.

Understand the full model in revenue predictability: how to stop guessing and build a reliable forecast and how to monitor the indicators that feed this process in essential sales KPIs for predictability.

Nexo structures this process end to end — from defining the categories to the review ritual — for B2B companies that need real predictability. Learn about the approach in how to achieve revenue predictability and see how we connect it to individual performance in how to track sales rep performance.

See how Nexo runs weekly sales forecasting for B2B companies.
See how Nexo does it

To understand how to structure the pipeline review that supports this process, see how to build an effective pipeline review cadence.

The weekly forecast tends to get lost in the third month, once the novelty wears off. Nexo's sales advisory exists so the ritual doesn't die there.