Revenue forecasting for agencies: the weighted pipeline

Ask an agency owner what revenue looks like in three months and you usually get a round number said with confidence and no basis. The error is not indiscipline: it is treating the pipeline as a wish list instead of a probability distribution.

The problem with adding up proposals

If you have $120,000 in open proposals, your forecast is not $120,000. It is also not zero. An agency that historically closes one in four has an expectation of $30,000, but even that number is unusable, because the proposals do not share the same probability and do not land in the same month.

A weighted pipeline solves both: probability by stage, and value placed in the month the money arrives, not the month the proposal went out.

Stages and probabilities

Use few stages, each with a fixed probability based on your history rather than intuition:

• Qualified contact: 10%
• Discovery call completed: 25%
• Proposal sent: 40%
• Negotiating scope or price: 65%
• Verbally approved, contract pending: 85%
• Signed: 100%

Treat those as a starting point. After 30 or 40 logged opportunities, replace them with your own: count how many sent proposals closed in the last 12 months and use the real rate. If your proposal-stage rate is 22% rather than 40%, you were forecasting nearly double the revenue you will see.

Recurring and one-off do not enter the same way

A $6,000 monthly retainer on a 12-month term is worth $72,000 in total contract value, but in a quarterly forecast it enters as $18,000, spread across three months. A one-off $30,000 project paid in three instalments enters as three amounts in three different months.

Mixing total contract value with monthly cash is the most common error and the one that inflates forecasts most. Always work with the amount that hits the account that month.

A complete forecast has three blocks

• Contracted revenue: active retainers and instalments on signed work. High confidence.
• Weighted pipeline: value times probability, allocated to the month of payment.
• Expected losses: contracts ending in the period and clients with known churn risk. This block is negative, and almost nobody fills it in.

Skipping the third block is why so many agencies are blindsided by a revenue drop that was written in the calendar the day the contract was signed.

What to do with the result

Compare the forecast with monthly fixed cost. If contracted revenue alone covers fixed cost, you are in a comfortable position and can be selective about clients. If it covers 60% and the rest depends on the weighted pipeline, every quiet sales week becomes risk.

Check concentration too: if one client is more than 25% of contracted revenue, the forecast is fragile regardless of the total. Losing that client is not a scenario, it is a probability.

Review weekly, not monthly

Pipeline stages change every week. A monthly review lets an opportunity sit in "proposal sent" for six weeks counting as 40% when it has effectively died. Set a decay rule: any opportunity with no interaction for 30 days drops back to 10% or leaves the pipeline.

Spreadsheets handle this up to about 20 simultaneous deals. Past that, the cost of updating exceeds the benefit and the forecast rots. Eluvie connects pipeline, contract and payment in one flow, so the forecast updates as sales moves. To see where your forecast is fragile today, start with the free diagnostic.