2 min read
Building a Stage-Weighted Pipeline
The template assigns a probability percentage to each pipeline stage based on historical win rates, not optimistic estimates. A prospect at the proposal stage might carry a 40% probability; a contract under legal review might carry 80%. Applying these probabilities to opportunity values produces a weighted pipeline — the expected revenue contribution of each deal adjusted for likelihood of closing.
The five default stages are: Identified, Qualified, Proposal Sent, Negotiating, and Contract Under Review. Directors should calibrate the probability for each stage to their own closing history before using the template for financial planning.
Converting Pipeline to Monthly Revenue
Each opportunity in the pipeline carries an estimated close date and a contract start date. These may differ: a deal closing in September may not begin generating revenue until November if there is an implementation period. The template maps cash receipt dates — not contract signature dates — to the monthly revenue columns, which keeps the output aligned with cash flow rather than just P&L.
The total weighted revenue per month is the primary output. A secondary output is the unweighted total — the number the sales team believes it will hit — which provides a ceiling for optimistic planning and a useful sense check on the weighting.
Tracking Forecast Accuracy Over Time
The template includes an actuals column populated at month end. The variance between weighted forecast and actual revenue, tracked over six months, allows directors to recalibrate stage probabilities. If the weighted forecast consistently overstates actual revenue by 15%, the probabilities are too high and need adjusting down before the forecast is used to support a borrowing decision.
Forecast accuracy is also a data point a commercial lender will consider when assessing the reliability of projected debt service coverage. A track record of accurate forecasting — even a modest one — strengthens a funding application materially.
Linking the Sales Forecast to Financial Models
The monthly weighted revenue row exports directly to the revenue line of the P&L model and the receipts section of the 13-week cash flow (adjusted for debtor days). This linkage prevents the common problem of a sales forecast that is disconnected from the financial plan — where the board discusses revenue optimistically while the finance function works from a more conservative number.
Revenue figures in this template are planning estimates. Confirm assumptions with your finance director or accountant before presenting to investors, lenders, or your board as a committed outlook.
Frequently asked questions
How should we handle recurring contract renewals in the pipeline?
Include renewals as separate pipeline entries with a high probability (typically 70–90% depending on your retention history) and their own close and start dates. Do not assume renewals are certain until the contract is signed — a renewal at 85% probability materially affects planning if the contract value is significant.
What is the right level of detail for individual pipeline opportunities?
For opportunities above a materiality threshold — perhaps 5% of monthly forecast revenue — track each opportunity individually. Smaller opportunities can be pooled by stage and weighted as a group. This keeps the model manageable without losing accuracy on the deals that matter most.
Can this template support an invoice finance facility assessment?
Indirectly. An invoice finance provider will focus on your debtor book rather than your pipeline. However, a credible sales forecast demonstrates future invoice generation capacity, which supports the lender's view of your facility utilisation trajectory.
Funding for UK limited companies
Credicorp lends to your company, not to you personally — short-term working capital with no personal guarantee. See what your business could access.