# Sales forecasting: review the deals behind next month’s number

Build a reviewable sales forecast from deal evidence. Separate open pipeline, forecast judgment and confirmed wins; track changes without invented probabilities.

Canonical page: https://cpcinsider.com/insights/sales-forecast-review-worksheet/
Author: Vladlens Kecko
Published: 2026-11-20
Updated: 2026-11-20


**The forecast looks healthy, but the expected deals keep moving into next month.** Open the opportunities included in the next reporting period. Before changing the target, check which deals have buyer-supported timing and a dated next step.

This worksheet reviews a period-specific forecast. It complements our [sales pipeline stages guide](https://cpcinsider.com/insights/sales-pipeline-stages/), which defines the evidence needed to move a deal through the process.

## Define what you are forecasting

Write the period, cut-off date, currency and amount basis above the worksheet. First-contract value, recurring revenue and cash collection answer different questions. Do not combine them in one total. A signed contract does not by itself establish when its cash will arrive.

Keep the revenue goal, open opportunity value and forecast judgment separately labelled. [HubSpot's forecast documentation](https://knowledge.hubspot.com/forecast/use-the-forecast-tool) distinguishes open pipeline, weighted or total pipeline and submitted forecasts. Check your own CRM's settings before interpreting a label. This worksheet does not require purchasing a forecasting feature.

## Inspect the deals, not just the sum

Use an authorised CRM view and deal IDs rather than copying personal contact information into a shared spreadsheet. Start with the records included in the period. For each, check the amount basis, expected decision date, latest meaningful buyer evidence and owner of the next action.

| Field | What to record | If it is missing |
| --- | --- | --- |
| Deal ID and amount basis | One distinct buying decision and a consistent value | Resolve duplicates or incompatible amounts |
| Expected decision date | Date supported by the buying process | Ask what remains before a decision |
| Buyer evidence | Confirmation of the next commercial step | Separate the seller's assumption |
| Next action and owner | A specific task and date | Assign it before the review closes |
| Main uncertainty | Approval, scope, budget, timing or another known issue | Keep uncertainty visible |

An overdue close date is a review flag, not proof that the deal is lost. Ask what changed before moving or removing it. Never manufacture urgency to improve a dashboard.

## Separate stage from forecast judgment

A proposal stage records process progress. It does not guarantee a decision this period. Your team can classify which deals belong in its expected forecast and which are additional possibilities, but each label needs a written definition and supporting evidence.

CRM implementations vary. [HubSpot's setup guide](https://knowledge.hubspot.com/forecast/set-up-the-forecast-tool) describes configurable forecast categories and stage mappings. Do not assume a category name has the same meaning in every account. Preserve the business's approved definitions rather than silently remapping production stages.

If a weighted calculation is used, record where the weights came from. Arbitrary stage percentages create apparent precision. With insufficient relevant history, report unweighted pipeline and documented judgment separately instead of inventing calibrated probabilities.

## Save a snapshot and explain the movement

At the agreed cut-off, retain the permitted deal-level snapshot and forecast total. At the next review, identify additions, removals, amount changes and timing changes. Keep the original forecast: replacing it with the latest CRM state destroys the comparison.

When the period ends, compare the original forecast with actual results using the same commercial basis. Record forecast minus actual: a positive result means the original forecast was higher than the actual outcome. Keep the absolute difference separately if comparing error size, and record the reasons behind the movement. Do not call a percentage error meaningful when its actual-value denominator is zero. Review repeated timing or qualification errors over several periods before changing the model.

Freeze the original snapshot before updating the live CRM. Keep revisions beside it with dates, so a changed forecast cannot silently replace the number you later evaluate.

## End with an operational decision

Agree the next action, owner and review date for every material uncertainty. Repeated scope confusion may need a clearer offer; missing follow-up may need a handoff repair. Neither follows from the forecast total alone. Use the [lead-nurturing plan](https://cpcinsider.com/insights/lead-nurturing-plan/) and [CRM measurement guide](https://cpcinsider.com/insights/crm-conversion-tracking/) for the connected workflows.

Our [business growth service](https://cpcinsider.com/services/business-growth/) connects marketing and sales execution. [Book a free 30-minute founder-led growth review](https://cpcinsider.com/?audit_from=%2Finsights%2Fsales-forecast-review-worksheet%2F#audit) for a short written three-priority plan, with no obligation to hire CPCInsider.
