Quarterly Sales Forecast Template: Building the Quarter on Day One

What does a quarterly forecast template have to answer?

Not "do we have enough pipeline," but "how is this quarter going to happen." Those are different questions and only the second one produces a plan you can act on.

Most quarterly templates are a coverage calculation dressed up as a forecast. Target at the top, open pipeline underneath, a ratio in between, and a conclusion drawn from the ratio. That structure can be directionally right in stable conditions and dangerously wrong the rest of the time, because it hides the composition of the quarter. A company can carry 4x coverage and miss badly if the pipeline is low quality, aged, concentrated in a few large deals, or built on close dates that keep moving.

The template below decomposes the quarter into where the revenue actually comes from, which makes the risks visible in week one instead of week eleven.

What are the three sources of revenue in a quarter?

Carry-over, in-quarter, and pull-forward. Each has a different failure mode, so each gets its own block. Most teams over-trust carry-over because it is visible in the CRM, and under-model the in-quarter line because it is not. They also understate what pull-forward costs. Revenue pulled from Q4 into Q3 is a gap moved rather than a gap closed, and the template should hold that number in its own row so the tradeoff is on the page when someone approves it.

What does the sheet look like?

One block per source, split by month, with the assumption stated next to each figure. The gap line at the bottom is the point of the exercise. Finding a 600K gap on day one leaves eleven weeks to generate pipeline against it. Finding the same gap in week ten leaves you with discounting as the only lever.

How should the three months be weighted?

Weight month three heaviest, and derive the split from your own history rather than from a straight line. The third month of a quarter typically closes more than the first two. Quarterly seasonality runs on top of that, with Q2 and Q4 usually stronger than Q1 and Q3.

A straight-line split across the three months creates a false alarm every month one and a false sense of safety every month three. Pull two years of monthly closed-won, calculate each month's share of its quarter, and use those percentages as the default weights. Adjust for known events such as a fiscal year end concentrated in one customer segment.

The weighting matters most for cash planning and for deciding when to intervene. A soft month one can be entirely normal in a business whose third month typically carries the quarter, and reacting to it as a shortfall wastes a month of selling on a manufactured fire drill.

What coverage number belongs at the top of the sheet?

Coverage by segment, shown as an input to inspect, with the absolute gap next to it. Three to five times the target is the standard range. Across ORM's customer base most companies sit around three and a half, with customers as low as 1.4x and as high as 5x.

Two adjustments make the number honest. First, strip out stale pipeline before calculating. Across ORM's customer base, 10 percent or more of open pipeline has had no meaningful change in twelve months, where meaningful means a change in stage, close date, or amount. Second, remember what day-one pipeline is actually worth: roughly 20 percent of the pipeline carrying close dates in the quarter on day one closes in that quarter. Eighty percent of the value sitting in the period on the first day does not land in the period.

Feed that realization rate into the carry-over block rather than assuming a healthy ratio protects you. The full argument against using coverage as a conclusion is in why the 3x pipeline coverage rule is wrong, and the calculation itself is covered in the pipeline coverage definition.

How do you update the template mid-quarter?

Update each block on its own rhythm and never let one block quietly absorb another's miss.

Carry-over gets updated weekly as deals move, with close date changes tracked as a running count per deal. In-quarter gets updated against the creation plan, since a creation shortfall in month one is the earliest reliable warning that the quarter is short. Pull-forward gets reviewed by an executive, because the decision to spend next quarter's revenue to save this one is a business decision rather than a forecasting adjustment.

The failure pattern to watch for is a carry-over shortfall being covered by an increase in the in-quarter assumption with no corresponding increase in pipeline creation. That is not a forecast update. That is arithmetic applied to make a total match a target.

How do you check the template after the quarter closes?

Score each block separately against what actually happened, then fix the block that was wrong. A single accuracy number for the quarter tells you that you missed. Block-level scoring tells you why.

If carry-over came in low, your realization rate is too generous or slippage is running higher than assumed. If in-quarter came in low, creation missed or the cycle assumption was too short. If pull-forward carried the quarter, next quarter starts with a hole you already know about.

Manual quarterly forecasting done carefully lands around 90 percent accuracy on new and expansion business, and it costs a large amount of manager time while going stale as soon as conditions change. ORM targets 95 percent without manual adjustment, holding from day one through day ninety and updating as the quarter progresses. Whichever method you use, track the result the same way every quarter using forecast accuracy, and keep the build sequence consistent with how to forecast revenue.