Pipeline to cash flow: How to turn your sales pipeline into a forecast you can actually plan around

Your pipeline shows $340,000 in active opportunities. Two deals are in final negotiation. Three proposals are outstanding. Early-stage conversations might turn into projects. The sales picture looks healthy.

Your cash flow forecast shows the next 60 days based on current receivables and committed expenses. It says nothing about those $340,000 in opportunities because the pipeline and the cash forecast do not talk to each other.

This disconnection means your cash planning ignores your best leading indicator of future revenue. The pipeline represents real money that will arrive at some point, but you cannot plan around it because you have not translated pipeline data into cash timing.

Pipeline data and cash flow forecasts are typically kept separate

Most service firms track pipeline and cash flow, but the two systems operate independently. Understanding why they are disconnected reveals what it takes to connect them.

1. Pipeline tracks sales probability and timing. Your CRM or pipeline spreadsheet shows opportunities with expected values and estimated close dates. A $75,000 deal might be 60% likely to close next month. A $120,000 deal might be 80% likely to close this quarter. The data describes sales outcomes and their likelihood.

This information is forward-looking and probabilistic. It answers questions about future revenue potential, not current financial position.

2. Cash flow tracks known receivables and payables. Your cash flow forecast shows outstanding invoices and the expected payment dates. It shows bills due and when cash will leave. The data describes committed transactions with relatively certain timing.

This information is grounded in existing obligations. It answers questions about near-term cash position based on what has already been invoiced or committed.

3. The gap leaves future cash unpredictable. Between these two views is a blind spot. The pipeline shows revenue is coming, but not when cash will arrive. The cash flow forecast shows committed items, but nothing about pipeline conversion. You can see current cash and potential future revenue, but the bridge between them is missing.

Decisions that depend on future cash, like hiring, investment, or expansion, become guesses because the forecast does not incorporate your best information about incoming revenue.

Connecting them requires translating opportunities into cash timing

The cash forecast conversion for the sales pipeline requires recognizing that an opportunity in your CRM is not cash. Several steps and time delays separate a pipeline opportunity from money in your account.

1. Probability weighting adjusts for close likelihood. A $100,000 opportunity at 50% probability contributes $50,000 to your weighted pipeline. This weighting acknowledges that not every deal closes. The math is simple: opportunity value multiplied by close probability equals weighted contribution.

Your probability assessments should reflect actual close rates. If deals you call "50% likely" actually close 35% of the time, your weighting is optimistic. Calibrate probabilities against historical outcomes to make the weighted pipeline realistic.

2. Close-to-invoice timing adds delivery lag. Closing a deal is not the same as invoicing for it. Depending on your engagement structure, you might invoice at signing (for retainers), at project start, at milestones, or at completion. The time between closing the deal and sending the invoice varies by engagement type.

A deal expected to close on March 15 with milestone billing might generate its first invoice in April after the kickoff is complete. The cash forecast needs to account for this delivery and billing lag, rather than assuming invoicing happens at close.

3. Invoice-to-cash timing adds collection lag. After invoicing, you wait for payment. Your terms might be Net 30, but actual collection might average 45 days. Some clients pay promptly; others stretch to 60 days. The time between invoice and cash receipt is your collection cycle.

Opportunity to cash conversion must include this final lag. The deal closes March 15, invoices in April, and collects on a 45-day average, producing cash in mid-May. That is a 60-day gap between close and cash that pipeline data alone does not reveal.

Building the pipeline-based forecast

Pipeline-based forecasting applies these timing factors to each opportunity, producing a cash arrival timeline rather than just a sales outlook.

1. Start with a weighted pipeline by expected close month, group opportunities by their expected close date and apply probability weighting. March might show $120,000 in weighted value across four opportunities. April might show $85,000. May might show $150,000.

This gives you a probability-adjusted view of when deals are likely to close. The weighting prevents the forecast from assuming every deal converts at full value.

2. Apply delivery and billing lag by engagement type. For each opportunity, estimate when invoicing will occur relative to close. A retainer deal might invoice immediately. A project deal might invoice 30 days after close when the first milestone is completed.

Shift the weighted values forward by the billing lag. The $120,000 in March closes become March, April, and May invoices depending on each deal's billing structure. The cash forecast cares about when invoices go out, not when deals close.

3. Apply collection timing to estimate cash arrival. Take the invoice timing and add your collection cycle. If your average collection is 40 days, invoices sent in April produce cash in mid-May. Invoices sent in May produce cash in late June.

The final output is a cash arrival forecast: expected cash from pipeline opportunities by week or month, accounting for close probability, billing timing, and collection timing. This forecast connects directly to your operational cash flow projections.

The forecast becomes a planning tool

A pipeline cash flow forecast is only useful if it informs decisions. That requires regular updates and scenario analysis.

1. Pipeline changes flow to cash projections. As opportunities advance or stall, the cash forecast updates. A deal moving from 50% to 80% probability increases its weighted contribution. A deal pushing from March to May shifts its cash arrival. The forecast reflects the current pipeline state, not a static snapshot.

This dynamic connection means your cash visibility improves as your sales visibility improves. Better pipeline hygiene produces better cash forecasting.

2. Scenarios model different close outcomes. The weighted forecast shows expected value, but actual outcomes will differ. Building scenarios helps you plan for variation.

A conservative scenario might assume only high-probability deals close, and collection takes longer than average. An optimistic scenario might assume that most deals close on schedule and are paid promptly. The range between scenarios shows your cash uncertainty and helps you plan appropriate buffers.

3. Decisions use forward-looking cash visibility. With a pipeline connected to cash timing, you can make decisions that were previously guesses. Can you afford to hire in June? The forecast shows the expected cash position in June, including pipeline conversion. Should you delay a major purchase? The forecast shows whether Q2 cash supports it or Q3 is safer.

The pipeline becomes a financial-planning input rather than just a sales-management tool. The $340,000 in opportunities translates to specific expected cash in specific future weeks, informing decisions that depend on that cash arriving.

Your pipeline is a cash forecast waiting to happen

The opportunities in your pipeline represent future cash. The question is whether you can see when that cash will arrive.

Without cash conversion timing, the pipeline is a sales metric disconnected from financial planning. You know revenue is coming, but cannot plan around it. With conversion, the pipeline becomes a leading indicator of cash position, extending your planning horizon from current receivables to expected future receipts.

The translation requires probability weighting, billing lag, and collection timing. These factors turn an opportunity value into an expected cash arrival date. Applied across your pipeline, they produce a forecast you can actually use for hiring, investment, and operational decisions.

Your sales team is already tracking the pipeline. Your finance function should be using it.