How to Use Your Sales Pipeline to Forecast Revenue and Cash Timing

Most businesses have a sales pipeline sitting in a CRM or a spreadsheet. Most of those pipelines are used for one thing: tracking who to follow up with next. That's useful, but it's only half the value. Your pipeline is also a revenue and cash forecast waiting to be built.

If you're not using pipeline data to look forward at your cash position, you're flying without instruments.

What a Pipeline Already Tells You

A typical CRM opportunity has a deal name, a dollar value, an expected close date, and a stage. That's the raw material for a revenue forecast. You know the amount, you know roughly when it might close, and the stage gives you a signal about probability.

The gap most businesses have is that they don't connect those fields to their financial plan. The pipeline lives in one place. The budget lives in another. Nobody builds the bridge.

What Owners Get Wrong

The first mistake is using the pipeline as a list, not a number. Knowing that five deals are "in progress" tells you almost nothing about when cash will arrive. Knowing that those five deals total $180,000 with expected close dates in August and September tells you a lot.

The second mistake is taking pipeline value at face value. A deal in early-stage discussions is not the same as a deal that's had a proposal signed. If you forecast every opportunity at 100% probability, your revenue forecast will be consistently wrong in one direction: too optimistic.

The third mistake is ignoring the lag between a closed deal and cash in the bank. Even when a deal closes, cash timing depends on your payment terms, the invoicing schedule, and when the customer actually pays. A deal that closes August 15 on Net 30 terms doesn't produce cash until mid-September at the earliest. More often it's later.

The CFO Perspective

A pipeline-based forecast has two layers. The first is expected revenue: what deals are likely to close and when. The second is expected cash timing: when will that revenue actually convert to cash in your account.

For expected revenue, stage-based probability weighting is the standard approach. Deals in an early discovery stage might be weighted at 20% to 30%. Deals with a proposal sent might be 50% to 60%. Deals with verbal agreement might be 80% to 90%. The weighted total across all open deals gives you a realistic revenue estimate, not the full pipeline value.

Consider a business with four open deals: a $50,000 deal at proposal stage (60%), a $30,000 deal in early discussions (25%), a $20,000 deal with verbal agreement (85%), and a $15,000 deal just entered (15%). Weighted, that's $30,000 plus $7,500 plus $17,000 plus $2,250, or roughly $57,000 in probability-adjusted expected revenue. The raw pipeline value is $115,000. The difference between those two numbers is the gap between wishful thinking and a forecast.

Then layer in cash timing. If those deals all close in August but your standard terms are Net 45, most of the cash lands in October. Your August and September income statement may look solid while your cash balance stays flat. That timing gap is where businesses get caught.

What to Do About It

1. Pull your pipeline into a simple spreadsheet with four columns: deal name, expected close month, deal value, and stage probability. You don't need complex software. A spreadsheet updated monthly is enough to change how you plan.
2. Assign probability weights to each stage in your pipeline. Whatever stages you use, assign a percentage to each. Early conversations might be 20%. Proposal sent might be 60%. Verbal yes might be 85%. Apply these consistently so your forecast reflects realistic odds, not hope.
3. Calculate a weighted pipeline total by month. Multiply each deal value by its probability and group by expected close month. That gives you a probability-adjusted revenue estimate for each month in your horizon.
4. Add a payment timing lag. If your typical terms are Net 30, shift the cash arrival date one month after the close date. If customers typically pay in 45 days, use that. Apply your actual collection pattern, not the theoretical one.
5. Compare the pipeline forecast to your expense commitments. The point of the exercise is to see whether your expected cash inflows cover your planned cash outflows. If a payroll date falls in a month where the pipeline is thin, that's a signal to either accelerate collections on existing receivables or slow down discretionary spending.
6. Update the forecast monthly. A pipeline forecast is only useful if it reflects current reality. Deals move, close dates shift, and new opportunities enter. A monthly update takes 20 minutes and keeps the picture accurate.

When the Pipeline Isn't Enough

Recurring revenue businesses have it easier here because a large portion of next month's revenue is already contracted. For project-based or transactional businesses, the pipeline is the primary forward-looking tool. If your pipeline is consistently thin for the next 90 days, that's not a forecasting problem. That's a sales problem, and the forecast is what surfaces it early enough to act.

The goal isn't a perfect forecast. The goal is knowing where the risk is before it becomes a crisis.

If you want to build a pipeline-to-cash forecast for your business, book a free call at peterxiacpa.com/book.

Next step: see it in your free Instant CFO Snapshot.