Monthly pipeline cash conversionCollection timing is kept separate from the closing month
Business
Sales Pipeline Cash Flow Calculator
Convert the pipeline already in motion into a twelve-month cash calendar. Stage-weighted opening opportunities, monthly new opportunities, conversion velocity, contract value, collection lag, delivery cost, acquisition cost, and fixed selling expense determine bookings, cash receipts, monthly net cash, the lowest cumulative cash point, and the month cash turns positive.
12-month pipeline collections-
Bookings created-
Wins modeled-
Gross contribution collected-
Selling and delivery cash-
Ending pipeline cash-
Lowest cumulative cash-
First positive month-
Booking-to-cash current
Follow qualified opportunities through wins, collections, and the liquidity shoreline
BookingsCollectionsCumulative cash
| Month | New qualified | Proposals | Wins | Bookings | Collections | Cash costs | Net cash | Cumulative cash |
|---|
Cash conversion workflow
Move each deal through a closing clock and a separate collection clock
- Record qualified opportunities and proposals already inside the funnel.
- Forecast new qualified opportunities with the entered monthly growth rate.
- Apply proposal and win rates after the sales-cycle delay.
- Recognize bookings when wins occur, then shift collections by the payment lag.
- Deduct acquisition, delivery, and fixed selling cash in the month each cost occurs.
Pipeline cash anatomy
Four clocks determine when a strong pipeline becomes usable cash
Detailed calculation process
Calculate bookings, collections, and liquidity on separate lines
Proposals(m) = Qualified opportunities(m - c/2) × pWins(m) = Proposals(m - c/2) × wBookings(m) = Wins(m) × VCollections(m) = Bookings(m - l)Cash costs(m) = Fixed sales cash + Wins(m) × acquisition cost + Collections(m) × (1 - g)Cumulative cash(m) = Opening reserve + Σ[Collections - Cash costs]The implementation splits the whole sales cycle into proposal and closing delays so the opening proposal stock closes earlier than newly qualified opportunities. Fractional deal counts are expected values, not promises that part of a contract closes.
Default-input substitution
How the opening pipeline enters the calendar
With 48 qualified opportunities, 19 proposals, a 46% proposal rate, and a 31% win rate, the schedule first converts the existing 19 proposals into expected wins. New monthly opportunities begin producing proposals after half of the three-month cycle, while collections arrive two months after each win. The reconciliation checks that ending cash equals the $180,000 opening reserve plus all collections less every acquisition, delivery, and fixed selling cash line.
Treasury evidence
Inputs to reconcile before relying on the trough
- CRM stage-entry and close-date history
- Executed contract values and discount terms
- Invoice aging and customer payment behavior
- Sales payroll, program, and implementation cash
Planning limitation
The schedule isolates pipeline economics
It excludes taxes, renewals, milestone billing, partial collections, bad debt, commissions paid on bookings, financing, non-sales overhead, and contract-specific delivery timing.
Sales pipeline cash flow FAQ
Questions about bookings and liquidity
Can bookings grow while cash falls?
Yes. Fixed selling cost and delivery cash can occur before the collection lag releases customer cash.
Why are expected wins fractional?
They represent a portfolio probability. Operational staffing should also test whole-deal boundary cases.
What does “no positive month” mean?
The modeled reserve never clears zero during the twelve-month window; it does not prove the pipeline has no long-term value.
Practical examples
Sales Pipeline Cash Flow Calculator in real planning situations
- Estimate the cash trough created by a two-month collection lag.
- Compare bookings growth with the month cash is actually received.
- Test whether the existing pipeline can finance the next selling cycle.
Important note
Before relying on this result
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Additional Sales Pipeline Cash Flow Calculator questions
Why are bookings different from collections?
Bookings are created when deals close; cash is shifted by the entered collection lag.
How is the opening pipeline handled?
Each opening stage is weighted by its remaining conversion probability and spread through the expected sales cycle.
Does this replace a full cash forecast?
No. It isolates pipeline-related receipts and selling/delivery cash; taxes, financing, and unrelated overhead are excluded.