Next Quarter's Sales Forecast: How to Build a Number Your CFO Will Actually Believe

The number a CFO believes isn't one number — it's three: committed, likely, and the gap you still have to build. Each one backed by deal names and payment dates, not a blanket percentage. Present your forecast alongside a "when does the cash land" schedule, and you'll walk out of the quarterly review with a figure approved as-is, instead of one quietly discounted by 20% "for safety."

The Number Finance Believes: Three Figures, Not One

A single number invites argument. Three numbers invite a decision. When you say, "Committed is 1.2 million, likely is 1.9, and there's a 600K gap to target that I'm working on," you've moved the conversation from do I believe you? to what do we do about the gap?

What Your CFO Is Really Asking — And We Never Answer: When Does the Cash Arrive?

A deal closed in March on 60-day terms is cash in May. Add two columns to every deal in the forecast: expected close date and payment terms. Then redistribute the amounts across the months they'll actually be collected. That one table cuts the meeting in half.

Split the Forecast Into Three Layers: Committed, Likely, Still to Be Built

• Committed: proposal submitted, the approving authority is identified, and the customer themselves has confirmed a decision date.
• Likely: the need is confirmed and budget exists, but the decision hasn't been scheduled.
• Still to be built: deals that don't exist yet — covered by activity, not by hope.

The test for the first layer isn't how the rep feels. It's external evidence from the customer.

Closing the Gap Between Target and Committed With Deals That Don't Exist Yet

Do the math: gap ÷ average deal value = number of deals required. Divide that by your opportunity-to-close conversion rate to get the number of new opportunities needed. Divide by the number of weeks in the quarter, and you have a weekly quota you can actually track — instead of the phrase "we need to push harder."

Pipeline Hygiene Before You Calculate: Five Checks You Can Run in an Hour

1. Deals with no logged activity in the past 21 days.
2. Deals whose expected close date is already in the past.
3. Deals with zero value or no owner.
4. Duplicate deals for the same customer covering the same scope.
5. Late-stage deals with no decision-maker contact attached.

Any deal that fails two or more of these checks comes out of the committed layer until it's corrected.

In Effistar, these checks are built as saved filters you open right before the forecast meeting, so broken deals surface by name instead of being hunted down manually in a spreadsheet.

Quarterly Scenarios: Conservative, Base, Optimistic — And What Drives Each

Every scenario needs one explicit driver. Conservative assumes your two largest deals slip. Base assumes last quarter's conversion rate holds. Optimistic assumes a stalled customer gets their budget approved. Write the driver next to the number — that's what makes it auditable.

A Weekly Review That Updates the Number Instead of Defending It

Thirty minutes a week: What moved between layers? What dropped out? What's new? A forecast updated weekly reads as a management tool. A forecast presented once a quarter reads as self-defence.

Mistakes That Cost Your Forecast Its Credibility for Two Quarters

• Inflating the number to please the room, then explaining the variance later.
• Pushing a deal to the next quarter without updating its written reason.
• Mixing bookings, revenue, and collections in the same table.
• Hiding the gap instead of presenting it with a plan to close it.

Start tomorrow with one step: sort this quarter's deals into the three layers and add a payment-terms column. Everything else builds on top of that.