Optimized Sales Optimized Marketing Target Accounts For CROs For CFOs For CMOs Blog News Glossary Compare Tools About Schedule a Demo
Sales Forecasting

How to Diagnose a Mid-Quarter Revenue Shortfall Before It Becomes a Miss

Pete Furseth 6 min read
revenue planningforecastingpipeline coverage
How to Diagnose a Mid-Quarter Revenue Shortfall Before It Becomes a Miss
Home/ Blog/ How to Diagnose a Mid-Quarter Revenue Shortfall Before It Becomes a Miss

How do you know you are actually behind?

Measure against the normal shape of your quarter, not against a straight line. Most B2B SaaS revenue arrives late in the period. ORM sees the third month of the quarter run stronger than the first and second, and Q2 and Q4 typically run stronger than Q1 and Q3. A linear pace chart flags a shortfall in week six of nearly every quarter, including the ones that finish above plan.

Build the pace target from your own historical distribution of closed revenue by week. If you normally book 22 percent of the quarter in month one and you are at 21 percent, you are on plan. If you normally book 22 percent and you are at 11 percent, you have a real gap and eight weeks to work it.

Put this to work on your numbers
Run your own numbers with the free Forecast Accuracy Scorecard, then see how ORM builds it into a custom model.

Which three sources of revenue should you check?

Every quarter closes from carry-over pipeline, in-quarter created pipeline, and deals pulled forward, so diagnose the gap one source at a time. Carry-over is the pipeline that existed on day one with a close date inside the period. In-quarter creation is revenue that does not exist yet and will be created, qualified, and closed inside the same period. Pull forward is revenue taken from a future period, usually at a discount.

Most teams over-trust the visible pipeline and under-model the invisible part. They study deals already in the CRM, and they do not forecast how much will be created and closed inside the quarter. A gap in carry-over and a gap in creation call for completely different responses, and a single blended number hides which one you have.

Where exactly is the gap coming from?

Split the shortfall by source before you pick a lever.
Gap sourceDiagnostic questionData to pullLever that still works at week six
Carry-over closing lateAre the day one deals still open and moving?Stage, close date, and amount changes since day oneExecutive engagement on named blockers
Carry-over lostDid the planned deals close lost or go dark?Loss reasons on day one cohortRequalify remaining coverage, reset the number
Creation shortfallDid new pipeline get created at the planned rate?Opportunities created by week versus planOnly helps next quarter if cycle time exceeds weeks left
Conversion shortfallIs created pipeline advancing at the historical rate?Stage conversion by creation cohortStage gate enforcement and deal desk support
Deal size shortfallAre deals closing below their pipeline value?Closed-won amount versus amount at day oneDiscount governance and approval thresholds
Renewal or expansion shortfallDid installed base revenue land as planned?Renewal outcomes and expansion bookings by monthSave plays and executive sponsorship
Run the table by segment. Aggregate numbers hide a single segment carrying the entire gap.

Is the problem coverage or conversion?

Coverage gaps need new pipeline, conversion gaps do not, and treating one as the other wastes the rest of the quarter. If the deals you planned to close are still open and progressing, you have timing risk. If they are open and static, adding pipeline changes nothing, because the new deals will hit the same broken stage. If they are gone, you need created pipeline that in most cases cannot land in period.

This is where a fixed coverage multiple leads teams wrong. Coverage of 4x can sit entirely in the wrong segment, be owned by reps who just changed territory, be aged past the point where deals like it close, or be priced above what deals in that group actually close for. The argument against treating the ratio as an answer is laid out in why the 3x pipeline coverage rule is wrong, and the definition sits under pipeline coverage.

How much of the in-quarter pipeline will actually close?

Roughly 20 percent of the pipeline dated to close in the quarter on day one closes in that quarter, so 80 percent of the dated value is not revenue. That single ratio explains most mid-quarter surprises. A leader looks at the dated pipeline in week one, sees more than enough to cover the target, and concludes the quarter is funded. By week six the dated value has rolled forward and the gap appears fully formed. Stale pipeline makes it worse. ORM sees more than 10 percent of pipeline at many customers untouched for 12 months. That value sits in coverage calculations and never converts.

What levers still work with half a quarter left?

Rank levers by cycle time, because anything slower than the weeks remaining is next quarter's work. Deals already in late stage with named blockers respond fastest. Installed base expansion is next, since the buying relationship exists and procurement is often lighter. New pipeline creation is the slowest lever and rarely lands in period unless your average cycle from created to closed is shorter than the time left.

Pull forward sits last for a reason. It works, and it costs more than teams record. You give up price, and you remove revenue from a period that still carries a target. Price it, log it, and show the next quarter's revised starting position in the same meeting.

How do you stop diagnosing this in week six?

Build the quarter's shape on day one and update it weekly, since a number that arrives after the quarter has happened is a report, not a forecast. The value of a forecast is the time it gives you to act. Getting the number right in the last week helps nobody.

That means decomposing the plan into carry-over, in-quarter creation, and pull forward before the quarter starts, then tracking each source against its own plan every week. The method is covered in how to forecast revenue, and the measurement side sits under forecast accuracy.

Frequently Asked Questions

How do I know if I am really behind at week six?

Compare closed revenue to the shape of a normal quarter for your business, not to a straight line. Most B2B SaaS quarters are back loaded, and the third month usually outperforms the first and second. A linear pace target will tell you that you are behind in week six of almost every quarter you eventually make.

Is a mid-quarter gap a coverage problem or a conversion problem?

Check whether the deals you planned to close are still open and moving. If they are open and progressing, you have a timing problem. If they are open and static, you have a conversion problem, and adding pipeline will not fix it in period. If they closed lost, you have a coverage problem and need created pipeline you do not yet have.

What percentage of in-quarter pipeline actually closes in the quarter?

ORM sees roughly 20 percent of the pipeline that carries in-quarter close dates on day one actually close in that quarter, which means about 80 percent of the value sitting in the quarter is not realized in it. Plan the gap against that reality rather than against the raw dated value.

Should I pull deals forward from next quarter to cover the gap?

Only with the cost priced in. Pull forward usually requires discounting and it removes revenue from a future period that still has a target attached. Teams consistently understate this cost. Treat pull forward as borrowing, record what it cost, and show the next quarter's revised starting position at the same time.

When is it too late to fix the quarter?

Once you are inside the average time it takes a new deal to go from created to closed, new pipeline cannot land in period. At that point the only levers left are the deals already open, the expansion motion in the installed base, and pull forward. Knowing this in week two rather than week ten is the entire value of an early forecast.

PF
Pete Furseth
ORM Technologies
Pete has built custom revenue forecast models for B2B SaaS companies for over a decade.

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