Turn Your Sales Pipeline Into a Cash Forecast: The Coverage-Ratio Method for Service Firms

A sales pipeline is not a cash forecast.

The CRM shows potential contract value. Cash planning needs the amount likely to close, when delivery can begin, when the business can invoice, and when the customer will actually pay. Between opportunity and cash sit four separate risks.

That gap matters because uneven cash flow remains a widespread small-business challenge. The Federal Reserve's 2025 Small Business Credit Survey report on employer firms found 51% cited uneven cash flows as a financial challenge. A service business can have strong demand and still miss payroll if the forecast treats proposals as deposits.

The fix is a pipeline-to-cash model that discounts uncertainty and moves every deal to the month cash is expected to arrive.

Start with four probabilities, not one stage percentage

Most CRM forecasts multiply deal value by a stage probability:

Weighted revenue = deal value × close probability

That is useful for sales management but incomplete for cash.

Use:

Expected cash = deal value × close probability × billable percentage × collection probability

Then place expected cash on the projected collection date, not the projected close date.

The billable percentage handles deposits, milestones, retainers, and revenue that starts later. Collection probability handles customer quality, disputed work, and historical payment behavior.

A $100,000 proposal at 70% close probability is not automatically $70,000 of next-month cash. If only 30% is billed at signing and 95% of billed amounts collect on time:

$100,000 × 70% × 30% × 95% = $19,950

The CRM says $70,000 weighted revenue. Treasury should plan on about $19,950 of near-term expected cash.

Replace opinion with historical stage conversion

Stage probabilities should come from your data. Review the last 12 to 24 months and calculate how often opportunities in each stage became signed business.

For example:

Stage	Historical close rate
Qualified opportunity	20%
Discovery complete	35%
Proposal delivered	50%
Verbal approval	75%
Contract sent	90%

Do not use a higher probability because a seller feels good about one deal. Add deal-specific evidence instead: confirmed budget, identified decision-maker, agreed scope, procurement steps, and a verified decision date.

Recalculate by service line, deal size, and lead source when volume permits. A referral-led $25,000 engagement may convert differently from a cold outbound $250,000 project.

The model improves when sales owns stage hygiene and finance owns calibration. Sales explains the deal. Finance checks what similar deals historically did.

Add the three clocks between close and cash

Every opportunity has three dates:

1. Close date: when the customer signs.
2. Billing date: when the contract permits an invoice.
3. Collection date: when the customer is expected to pay.

These dates are rarely the same.

A contract signed August 28 may start September 15, invoice at the end of September, and pay on net-30 terms in late October. A CRM forecast that puts the full value in August makes September payroll look safer than it is.

Build standard timing rules for each offer:

• Retainer: deposit or first month billed at signing.
• Project: deposit plus milestone invoices.
• Usage or performance fee: billed after the measurement period.
• Annual contract: upfront, quarterly, or monthly billing.

Then adjust for the customer's actual payment history. If a large client consistently pays 18 days after terms, use the observed lag.

Calculate pipeline cash coverage

Compare risk-weighted expected cash with the cash commitments the pipeline is meant to fund.

Pipeline cash coverage = risk-weighted expected collections ÷ uncovered cash commitments

Uncovered commitments are payroll, contractors, taxes, debt service, and operating costs that existing cash and contracted collections do not already cover.

As a Bennett Financials operating guardrail, 1.5x or more provides useful room for slippage, 1.25x–1.5x deserves close monitoring, and below 1.25x calls for a corrective plan. These are planning guardrails, not accounting standards. Volatile or concentrated businesses may need more.

Coverage answers a better question than "How big is the pipeline?" It asks whether the quality and timing of the pipeline are sufficient for the cash obligations ahead.

Calculate coverage by week for the next 13 weeks and by month for the following nine to 12 months.

Work a real pipeline through the model

Assume a marketing firm has four opportunities:

Opportunity	Value	Close probability	Near-term billable %	On-time collection probability	Expected near-term cash
Annual retainer	$240,000	75%	8.3% monthly	95%	$14,197
Website project	$120,000	50%	40% deposit	90%	$21,600
Strategy sprint	$40,000	90%	100% upfront	98%	$35,280
Rebrand project	$200,000	25%	25% deposit	90%	$11,250

The raw pipeline is $600,000. Expected near-term cash is $82,327.

If the firm has a $70,000 uncovered cash requirement in the period, coverage is 1.18x. The pipeline looks impressive, but the cash plan is below the 1.25x guardrail.

Leadership now has specific options: collect a larger deposit, accelerate the strategy sprint, delay a discretionary cost, improve the annual-retainer billing schedule, or secure working capital before the gap becomes urgent.

Build base, downside, and upside cases

One forecast hides risk. Use three:

• Base case: historical probabilities and standard collection timing.
• Downside case: key deals slip one period, win rates decline, and collections slow.
• Upside case: named late-stage deals close on time.

Payroll and other fixed commitments should work in the base case. Do not hire or spend against the upside case.

The downside case should trigger actions in advance:

• Which cost pauses first?
• Which invoice or deposit can be accelerated?
• Which owner distribution changes?
• When does the company draw a credit line?
• Which hiring start date moves?

A scenario is useful only when it changes a decision.

Connect the CRM to the 13-week forecast

Keep one operating table with:

• Opportunity owner.
• Customer.
• Service line.
• Deal value.
• Stage and calibrated probability.
• Expected signature date.
• Billing schedule.
• Collection lag.
• Expected cash by week.
• Confidence notes and next action.

Update it weekly with sales and finance in the same meeting. Reconcile won deals to signed contracts, invoices, and the 13-week cash-flow forecast. Remove lost or stale deals immediately.

The handoff matters. When a deal closes, the forecast should switch from pipeline assumptions to contract terms. When an invoice is issued, it should switch from contract terms to A/R. When cash arrives, it should reconcile to the bank.

That chain prevents one deal from appearing in pipeline, backlog, and receivables at the same time.

Use forecast error to improve the model

At month end, compare expected cash with actual cash by opportunity.

Measure:

• Close-date variance.
• Win-rate variance.
• Billing-date variance.
• Collection-date variance.
• Forecasted versus actual deposit.
• Seller and service-line bias.

If verbal approvals close at 55% rather than the assumed 75%, change the probability. If one service line always starts a month late because delivery is full, change the billing clock. The model should learn from error.

Do not punish honest forecast reductions. A culture that rewards inflated pipeline will produce an inflated cash plan. Reward accuracy, next-step discipline, and early risk identification.

Turn pipeline into a financial decision system

Pipeline-to-cash forecasting connects sales, delivery, collections, and hiring. It shows whether growth is funded before the company commits to the cost.

That is part of the ongoing fractional CFO cadence: close the books, update the forecast, compare budget to actuals, identify the next constraint, and assign the action.

If the CRM looks healthy but cash remains unpredictable, the missing link is probably timing and probability. Book a Scale-Ready Assessment to turn your actual pipeline, margins, and payment terms into a cash decision model.

This article is educational and does not replace accounting, tax, legal, or financing advice based on your specific facts.