Turn a sales pipeline into a cash forecast without counting every deal

A proposal, a verbal agreement, a signed contract, and a paid invoice represent different levels of certainty. Preserve those stages in the cash model. Do not place the full value of every opportunity into next month's receipts because the sales dashboard labels the pipeline healthy.

Define the amount being forecast. Total contract value may include several years of service, while the first cash receipt may be a small deposit. Use the actual billing terms for signed work and explicit assumptions for opportunities that have not yet reached agreement.

Map expected contract date, service or delivery milestone, invoice issue, payment terms, and likely collection date. Include customer procurement or purchase-order requirements where known. A signed deal can still take time to become an invoice the customer is able to pay.

For an illustrative $30,000 project with a 40% deposit and the remainder after delivery, the first planned receipt is $12,000. The other $18,000 belongs on the expected final collection date. Counting $30,000 at signing overstates near-term cash even if the deal closes exactly as forecast.

A weighted pipeline can help summarize a group of opportunities when the probabilities are supported by experience. It is less reliable as a promise that a specific large payment will arrive. A 50% chance of a $100,000 receipt does not create a guaranteed $50,000 available for payroll.

Show a contracted case, a reasonable sales case, and a downside case for the decisions that depend on uncertain deals. Review large opportunities individually and document the evidence behind stage changes. Avoid assigning higher probabilities simply because the company needs the cash.

Track whether misses came from deal loss, delayed signing, delayed delivery, invoice errors, or slow payment. Each cause belongs to a different owner. Updating only the expected receipt date every week can conceal a problem that needs commercial action.

Keep the original forecast version and reconcile actual receipts to the opportunities and invoices that produced them. Use the results to improve stage assumptions and collection timing. A useful cash forecast makes uncertainty visible enough to plan around it.