How to Turn a Sales Forecast Into a Cash Plan Step by Step
How to turn a sales forecast into a cash plan: move committed deals to the month cash lands, file them as probable and show the weighted pipeline as upside.
To turn a sales forecast into a cash plan, move each committed deal to the month its cash will actually arrive, which is the signature date plus your real payment terms plus your real collection lag, and file it in the probable bucket. The weighted pipeline goes in as a labelled upside line that funds nothing, and best case stays out entirely.
A signed deal is not money in the bank, and the months between signature and payment are where cash plans quietly break.
How to turn a sales forecast into a cash plan in cash terms
A sales forecast and a cash plan look similar and answer different questions. The forecast says what you expect to win. The cash plan says when money will be in the account and whether it will last. The connection between them is the point at which most runway numbers go wrong, because the forecast is written in deals and the cash plan has to be written in months.
The bridge is a translation, deal by deal, from a signature into a receipt. Do it carefully and the cash plan inherits the discipline of the forecast. Skip it and a good pipeline produces a bad plan.
Three buckets for revenue
The method for cash planning divides expected revenue into three honest buckets and builds the runway only on the first two. The forecast is the upstream half of that: the discipline by which a deal earns its way out of hoped and into probable.
| Bucket | What belongs in it | May it support spending decisions? |
|---|---|---|
| Contracted | Revenue already agreed | Yes |
| Probable | Committed deals, converted into cash terms | Yes |
| Hoped | The weighted pipeline, shown as a labelled upside line | No, it never funds a decision |
Best case does not appear in the plan at all. Without this routing, the cash plan makes one of two errors. It ignores the pipeline entirely, which is too pessimistic, or it quietly includes all of it, which is how runway numbers lie.
Step one: use one date for the forecast
Three dates are easily confused: the date the buyer signs, the date the work starts and the date the cash arrives. The forecast should use only one, usually the signature. The cash plan then derives the other two from it, using your real payment terms and real collection behaviour.
Keeping the roles apart prevents a common mistake, which is to put the signature date into a cash line. Signature is a milestone in the sales process. Payment is an event in the bank. They are separated by exactly the delays that the plan is supposed to capture.
Step two: shift each committed deal to the month cash arrives
For every deal in commit, work out the month the cash will land:
- Start with the signature date, taken from the buyer's own process.
- Add your payment terms, the period you have agreed for paying.
- Add your real collection lag, which is how long customers actually take.
The last step is the one that gets skipped. The lag is usually longer than the invoice says. Treat it as a fact about your customers, not as a wish about how they will behave. The reasons for the gap and how to shorten it are a topic of their own in the Getting Paid Playbook, and for planning purposes the rule is to apply the real figure and not the printed one.
| Date | What it marks | Where it belongs |
|---|---|---|
| Signature | The buyer agrees | The forecast |
| Start of the work | Delivery begins | Derived from signature |
| Cash arriving | Money lands in the account | The cash plan, derived from signature plus terms plus lag |
Step three: file it in the right bucket
Commit, once converted this way, belongs in the probable bucket. That placement is earned: the deals in commit have met written criteria, with a buyer's date and a known paperwork path. Deals that have not met them are in the weighted pipeline, not in probable, however good they feel.
The weighted pipeline goes to the hoped line. Show it, label it as upside, and let it inform your sense of what might happen. It must never fund a decision. The reason it is unsafe as a funding source is that it is an average, and averages do not behave in a short run with few deals, as discussed in weighted pipeline versus commit.
The hand-off is a decision, not a formula
The guide notes that the pipeline does not flow into the cash plan automatically. The committed number is carried across by a person, in cash terms, once it has survived the review. This is deliberate. The act of carrying it across forces the question: do I still believe this deal, and is the cash date realistic?
An automatic feed would skip that question. A person asked to move a number from one plan to the other has to look at it.
Decide which figure each decision may use
The cash plan is where forecast figures become spending, so write down, while calm, which one each decision may rest on.
| Decision | Should rest on |
|---|---|
| A hire, which is hard to undo | Contracted revenue plus the converted commit |
| A short marketing experiment | The weighted pipeline, as upside |
| A timeline that depends on closing deals | Commit, trimmed for the slips you have measured |
These rules prevent a strong pipeline week from producing an offer letter the cash cannot support. They are most valuable written down before the strong week arrives.
What to check before you carry a number across
Because the hand-off is a decision, it deserves a short test. For each committed deal, before it enters the cash plan, confirm the following.
| Question | Why it matters |
|---|---|
| Does it still meet the commit criteria? | A deal that no longer qualifies belongs in the weighted pipeline, not in probable |
| Is the signature date the buyer's? | Every later date is derived from it, so an error here spreads |
| Have I applied real payment terms? | The agreed terms set the earliest sensible cash date |
| Have I applied the real collection lag? | Customers usually take longer than the invoice says |
| Has the deal slipped before? | A repeated slip suggests the cash will arrive later still |
A deal that answers all five well can be moved into the probable bucket with confidence. A deal that stumbles on any of them should be treated more cautiously, or left where it was.
When the forecast says yes and the cash plan says no
Sometimes a healthy forecast produces an uncomfortable cash plan. Deals are being won, and the money arrives too late to support the spending you had in mind. This is not a contradiction. It is exactly the situation the translation exists to reveal: the company can be winning and still be short of cash in a given month.
The response is to look at the real inputs rather than to adjust the plan until it looks fine. Are the payment terms what you assumed? Is the collection lag longer than the invoice says? Is there a decision, such as a hire, resting on a figure that cannot bear it? A hire should be justified by contracted revenue plus commit, never by best case, and the cash plan is where that rule is tested against real months.
Keeping the two plans honest together
The forecast and the cash plan should be reviewed with each other in view. The weekly pipeline review keeps the forecast current, and the quarterly check keeps both honest. When the quarterly comparison shows commit running over or under, the cash plan should be adjusted in the same sitting, since it inherited the bias.
It also helps to remember what the forecast is for in the first place. It is the input to almost every expensive decision a growing company makes, from hiring to acquisition spend to whether the cash will last. The cash plan is where that last question is answered, which is why the translation deserves care. For the bigger picture of what a forecast is and is not, see what a sales forecast is.
Slippage and the cash plan
A deal that slips by one period pushes its cash back by at least that long. Since slippage, not loss, is the most common reason forecasts miss, your measured slip rate is a direct input to the cash plan. How to measure it is in how to calibrate a sales forecast, and the rule for managing it is in how to handle slipping deals.
Common errors at the hand-off
- Treating signed as paid. Signature is not payment. The months between are where models break.
- Using the invoice date as the cash date. Real collection takes longer than the invoice says.
- Funding spending from the hoped line. It exists for information, not for commitments.
- Letting best case in. It is the upside to the commit and has no place in the plan.
- Automating the hand-off. The review is the filter; remove it and unreviewed numbers flow through.
Frequently asked questions
Can I put the whole weighted pipeline into the cash plan?
Only as a labelled upside line in the hoped bucket. It should never fund a decision.
Which date should the forecast use?
One date, usually the signature. The cash plan derives the start date and the cash date from it.
Where does best case go?
Nowhere in the cash plan. It is the upside above the commit, not a source of funding.
Why is the hand-off not automatic?
Because a person carrying the number across has to confirm it survived the review. The guide treats the hand-off as a decision, not a formula.
The full method, with the checklists, is in The Sales Forecast Playbook, a free 33-page playbook.