How Do You Forecast Revenue Before the Quarter Starts?
You forecast revenue by decomposing the quarter into the three sources that will actually produce it, then valuing each one honestly, rather than checking whether your pipeline clears a coverage ratio. The mistake we see most often at ORM is treating the pipeline you can see as the forecast. The real question is not "do we have enough pipeline." It is "do we understand how the quarter is going to happen before the quarter begins."Those are different questions with different answers. A team can sit on 4x pipeline coverage and still miss badly if that pipeline is aged, concentrated in a few large deals, or built on close dates the reps keep pushing forward. Another team can open the quarter with thin coverage and beat the number because it creates and closes fast inside the period. Coverage is an input. It was never meant to be the conclusion, which is the whole reason the 3x pipeline coverage rule is wrong as a standalone forecast.
So we build the revenue forecast from the motion, not the snapshot. Three sources decide the quarter.
What Are the Three Sources of Revenue in a Quarter?
Every dollar you book in a quarter comes from one of three places: carry-over deals already in pipeline, in-quarter deals that do not exist yet, or pull-forward deals dragged in from a future period. Most teams model the first, ignore the second, and forget to charge themselves for the third. Split them apart and the forecast starts describing the operating mechanics of the quarter instead of a single number.| Revenue source | What it is | How to estimate it | The trap |
|---|---|---|---|
| Carry-over | Deals in pipeline on day one that are expected to close this quarter | Weight open deals by stage and by how long each one has historically taken to close, then value them at closed-won, not CRM | Only about 20% of day-one in-quarter pipeline actually closes in the quarter, so carry-over is smaller than it looks |
| In-quarter | Deals that are not visible on day one but get created, qualified, and closed inside the same quarter | Model historical create-and-close velocity by segment and by month of the quarter | Skipping it because nothing is in CRM yet, which makes the quarter look thinner than it is |
| Pull-forward | Deals from a future period that close early, usually with a discount or a future-quarter concession | Look at how often future-dated deals have been accelerated before, and price the concession you traded for it | Booking the revenue now and forgetting you borrowed it from next quarter's number |
Most teams over-trust the visible pipeline and under-model the invisible pipeline. They study the deals already in the CRM and barely forecast how much will be created and closed inside the quarter, which for many businesses is a large share of the eventual number. Leaving the in-quarter source out does not make a forecast conservative. It makes it wrong. Then they understate what it costs to pull a future deal forward to rescue the current one.
Why Should You Forecast on Closed-Won Values, Not CRM Values?
Because deals close for less than the amount sitting on them in the CRM, and forecasting on the CRM number inflates every quarter you run. Most deals close for less than the value in the CRM. In one example, a pipeline's average deal size is $80,000 while the average closed-won deal is $40,000. Forecast on the $80,000 and you have baked a 2x overstatement into the carry-over source before you have accounted for a single loss.Amounts entered early in a deal tend to reflect the best case, and best cases erode as scoping, procurement, and discounting do their work. The fix is not optimism adjustments bolted on at the end. It is valuing each open deal at what deals like it have historically closed for, by segment and by stage. You also do not need pristine data to do this. You need consistent data. Garbage in does not have to mean garbage out, as long as the garbage stays consistent. When you build a sales forecast on closed-won history instead of seller-entered amounts, the carry-over number stops flattering you and starts predicting.
How Do You Age Out Stale Pipeline?
Stale pipeline gets aged out with a hard rule: if an opportunity has had no meaningful activity in 12 months, it does not count toward the forecast. We define meaningful activity as a change in stage, close date, or amount. Anything short of that is a deal sitting still, and a deal sitting still is not a deal.It varies by customer, but in the pipelines we model typically more than 10% of opportunities are stale, untouched for a year. They pad coverage and predict nothing. At ORM each opportunity is grouped by a machine learning model, and every group gets its own close-curve running from 1 to 80 weeks, with most of the expected closing happening before week 12 and very few groups carrying expectation past 52 weeks. An opportunity whose group says it should have closed 30 weeks ago, with no stage or amount movement since, is carry-over on paper and noise in reality. Age it out and what remains is a forecast you can defend.
How Does Seasonality Change the Forecast?
Seasonality changes how much of each source you should expect to land, and most people do not weight for it at all. In the data we see across customers, Q2 and Q4 run stronger than Q1 and Q3, and inside any quarter the third month closes more than the first or the second. A forecast that spreads expected revenue evenly across three months will look behind in month one and sound the alarm right before its strongest closing weeks arrive.Month one is the trap. Even a healthy quarter can read soft in its first four weeks, and a team that answers that softness by discounting or pulling deals forward damages the number it was trying to protect. Weighting for the pattern is not the same as trusting it blindly. When something structural changes in the market, the historical shape breaks, which is how market shifts break sales forecasts. Decomposing revenue into three sources is what lets you see which one a shift is hitting, whether carry-over is stalling, in-quarter creation is drying up, or discounts are climbing as deals get pulled forward.
What Does a Three-Source Forecast Look Like in Numbers?
Here is a hypothetical company forecasting new and expansion revenue for a quarter with a $4,500,000 target.
| Source | How it is estimated | Forecast |
|---|---|---|
| Carry-over | $10,000,000 of CRM value carries an in-quarter close date on day one. About 20% realizes in the quarter | $2,000,000 |
| In-quarter | Deals created and closed inside the quarter, from the same quarter in past years | $1,800,000 |
| Pull-forward | Next-quarter deals likely to close early without heavy discounting | $300,000 |
| Total | $4,100,000 |
How Do You Forecast Renewals and Usage Revenue?
Renewals get their own track. There is less uncertainty in a renewal. The amount is usually the same as this year or carries a price lift, and the close date is the renewal date, typically within about 30 days either side. New business works differently: its timing depends on when the opportunity last moved stage. Blending the two hides the harder forecast inside the easier one. Usage revenue needs drivers. In a seat-based business you can forecast from contracts, seats, price, renewals and expansion. In a usage or consumption model, revenue follows customer behavior. Find what predicts consumption, such as historical usage, customer growth, seasonality, transaction volume or product adoption. Forecast those, then convert usage to revenue.| Revenue type | Amount comes from | Timing comes from |
|---|---|---|
| New business | Closed-won values, usually below pipeline value | When the deal last changed stage |
| Renewal | Current contract, plus any price lift | The renewal date, within about 30 days either side |
| Usage-based | Forecast drivers of consumption | Customer behavior and seasonality |
Should You Forecast a Range or a Single Number?
A range. Give leadership a low case, an on-target case and an upper bound, so they see the expected outcome and the risk around it. Keep the number consistent from slide to slide, roll it up the same way from region to total, and make every figure traceable to the deals beneath it. That is what earns a board's trust. More in how to present a forecast to the board.
How Do You Keep the Forecast Accurate All Quarter?
You keep it accurate by making it dynamic, so it re-reads the three sources as the quarter runs instead of freezing the number you set on day one. A hand-built model of new and expansion revenue can reach roughly 90% accuracy, but it takes real time and effort to produce and it does not move as conditions change. At ORM the models we build target about 95% on new and expansion, hold from day 1 to day 90 of the quarter, and update as the quarter progresses without manual re-tuning. A model trained on your own historical sales performance gets there in about 4 to 6 weeks.The reason a dynamic model earns its keep is timing. Getting the forecast right in the last week of the quarter helps no one, because by then the quarter has already happened. The value is knowing the likely shape on day one, early enough to build in-quarter pipeline, protect carry-over, or decide whether pulling a deal forward is worth the discount. That is also the honest answer to what sales forecast accuracy you should expect: high, but only if the model keeps reading the quarter instead of the snapshot you took before it began.
Frequently Asked Questions
How do you forecast renewal revenue?
Separately from new business. A renewal's amount is usually known: the same as this year, or with a price lift. Its timing follows the renewal date, typically within about 30 days either side. New business timing depends on when a deal last changed stage.
How do you forecast usage-based revenue?
Forecast what drives usage first, such as past usage, customer growth, seasonality and product adoption. Then convert forecast usage into revenue. Extrapolating last month's usage misses what drives it.
How do you forecast revenue for a quarter?
Forecast revenue by decomposing the quarter into three sources: carry-over deals already in pipeline that are expected to close this quarter, in-quarter deals that do not exist yet but get created and closed inside the period, and pull-forward deals accelerated from a future quarter. Value each one at closed-won history rather than CRM amounts, and weight them for how the quarter usually closes. The aim is to understand how the quarter will happen before it begins, not to confirm that pipeline coverage clears a ratio.
Is pipeline coverage the same as a revenue forecast?
No. Pipeline coverage is the ratio of open pipeline to your goal. It is a useful input, not a forecast. A team can hold 4x coverage and still miss if the pipeline is old, rests on a few large deals, or has close dates that keep slipping. A real forecast covers what will close from existing pipeline, what must be created and closed inside the quarter, and what could be pulled forward.
Should you forecast on CRM deal values or closed-won values?
Use closed-won values. Deals close for less than the amount entered on them in the CRM. It is common to see an $80,000 average pipeline deal size against a $40,000 average closed-won deal size, so forecasting on CRM amounts can overstate the number by roughly 2x. Value each open deal at what similar deals have historically closed for, by segment and by stage.
When should pipeline be treated as stale?
Treat an opportunity as stale when it has had no meaningful activity in 12 months, where meaningful activity means a change in stage, close date, or amount. In most pipelines more than 10% of opportunities are stale by that test. Stale deals inflate coverage and predict nothing, so age them out before you forecast.
How does seasonality affect revenue forecasting?
Seasonality changes how much revenue you should expect to land in each period. Q2 and Q4 typically run stronger than Q1 and Q3, and within a quarter the third month closes more than the first two. A forecast that spreads revenue evenly across the three months will read as behind early and overreact right before its strongest closing weeks.
How accurate can a revenue forecast be?
A hand-built model of new and expansion revenue can reach around 90% accuracy, but it is slow to produce and does not adjust as conditions change. A model trained on your historical sales performance can target about 95% on new and expansion, hold from day 1 to day 90 of the quarter, and update as the quarter runs. Training on your own history takes roughly 4 to 6 weeks.
See how ORM turns these insights into action
ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.
Schedule a Demo