A forecast you can walk through line by line.

What do I take into the board meeting?

The breakdown. You shouldn’t have to defend a number you cannot see inside — and yet most forecasts fail the moment someone asks how it was built and the only honest answer is a tool name. The room hears that as “I don’t know”, the number gets cut on the spot, and the quarter you are then held to is one you never agreed with.

Worse is the version where nobody asks. You carry a number you privately suspect, the quarter comes in under it, and the conversation that follows is not about the pipeline. This page exists so the answer to “how did you get there” is a structure: which buckets, which weights, which deals move it, and which records were too thin to count.

• Every number breaks down

  Each bucket shows its deal count, its raw value and its weighted value. When the CFO asks which part of this is real, you point at a row instead of reaching for a recollection.

• The deals that swing it are named

  The handful whose movement changes the quarter come with their low, mid and high contribution and the size of the swing. That is the shortlist your pipeline review should be spending its hour on.

• The gaps are counted out loud

  How many deals are missing a value, a close date, a weight. You find out how much of your quarter rests on incomplete records before the board does.

• The same number comes back later

  Pull the quarter up again after the meeting and it says what it said in the meeting. So does the person who pulls it up to check you.

What is in the quarter number?

Three cases over five buckets, with nothing hidden between them. Booked is fact. Commit and best case are kept apart, so optimism never launders itself into the committed number. And deals nobody could weight sit on their own line instead of quietly receiving a default that makes the total look healthier than the pipeline is.

What does the low-to-high range mean?

It means your own pipeline run through the same arithmetic twice — once conservatively, once optimistically. You or your CFO can redo it by hand, which is the entire point: a range that narrows because a model feels more confident is a range you cannot defend when somebody pushes on it, and boards push.

So the range does not move because of anything you cannot see. It moves when your deals move, and you can show which ones.

Where does each deal weight come from?

From one of four places, and you are always told which. This is how sandbagging and happy ears become visible without anyone being accused of either: a quarter carried by stage defaults is a completely different quarter from one carried by categories a human sat down and set, even when the totals match to the pound.

A category someone set

A human looked at the deal and made a call. Used first, because a considered judgement beats a default.

The probability field

The number on the record, used when nobody set a category.

The stage default

What the stage assumes, used when nobody chose anything deal-specific. Labelled as a default, so it is never mistaken for a judgement.

Nothing usable

No weight exists. The deal goes on the unweighted line rather than being handed an invented one.

What is the forecast not counting?

Whatever it could not stand behind, listed by count. Most tools improve their coverage by filling in missing fields, which gives you a fuller-looking number built on material nobody checked — and it is exactly that material that fails you in week eleven. Here the gaps stay visible, because the size of the gap is itself something worth taking to the board.

• Deals missing a value, a close date, or a weight are each counted separately.
• Deals with no usable weight sit on their own line rather than receiving an invented one.
• The quarter you present is the quarter that comes back when someone pulls it up afterwards.

How do I get to a forecast I can defend?

In three steps, and you can do the first one on last quarter before committing to anything.

1. 1

   Rebuild a quarter you already know the answer to

   Upload an export of a closed quarter. See it broken into buckets, swing deals and missing inputs, and compare that with what you actually said at the time.

2. 2

   Connect the live pipeline

   HubSpot, read-only, in a few minutes. The current quarter comes back in the same shape, so your forecast call has one artefact instead of four spreadsheets.

3. 3

   Take the breakdown into the room

   Present the mid case with the buckets behind it and the swing deals named. When the follow-up question comes, you answer it in the room rather than in an email on Thursday.

Two quarters of this and the board meeting changes character. You are no longer defending a number; you are walking a room through a structure they can check, which means the argument moves on to what to do about it — which is the conversation you wanted in the first place.