CPCInsider

Growth Strategy

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.

Vladlens Kecko · · 4 min read

Editorial illustration: Review the deals. Keep the snapshot.

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, 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 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.

FieldWhat to recordIf it is missing
Deal ID and amount basisOne distinct buying decision and a consistent valueResolve duplicates or incompatible amounts
Expected decision dateDate supported by the buying processAsk what remains before a decision
Buyer evidenceConfirmation of the next commercial stepSeparate the seller's assumption
Next action and ownerA specific task and dateAssign it before the review closes
Main uncertaintyApproval, scope, budget, timing or another known issueKeep 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 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 and CRM measurement guide for the connected workflows.

Our business growth service connects marketing and sales execution. Book a free 30-minute founder-led growth review for a short written three-priority plan, with no obligation to hire CPCInsider.

About the author

Vladlens Kecko

Free founder-led growth review

Know where to focus your next marketing investment.

In a focused 30-minute conversation, we review your advertising, website and sales follow-up together. Afterwards, you receive a short written action plan you can use with your own team or with ours.

Get my free growth review
01

Your biggest growth gaps

See where your ads, website or follow-up may be losing potential customers.

02

Your next 3 priorities

Get a ranked action list with the reason for each recommendation and what to check next.

03

A practical starting plan

Leave with clear next steps for your team, plus our recommendation if you want help implementing them.

Continue reading

Related services and proof

Business Growth4,002 Meta leads and €818,984 in CRM won deals