Key takeaways
- Gross pipeline value overstates income; weight each sale by the probability its stage has historically reached completion.
- The government says around 1 in 3 transactions fail[1], while in Scotland only 9% fall through[2], so stage and system matter enormously.
- Date each sale from your own median time from that stage to completion; the national average from offer to completion is 120 days[3].
- Check accuracy monthly: compare forecast with actual completions, and track both bias and error.
- Recalibrate probabilities each quarter from the latest 12 months of outcomes.
Gross pipeline versus weighted pipeline
Most agency software shows a pipeline value: the total fees on every sale agreed but not yet completed. It is a useful headline and a poor forecast. Some of those sales will fail, many will complete later than expected, and a few will renegotiate. An owner who plans staffing or spending on the gross figure will be disappointed most months.
The size of the gap is significant. The government says around 1 in 3 property transactions fail[1]. In Scotland, where contracts become binding earlier, only 9% of transactions fall through[2]. A weighted pipeline applies a probability to each sale based on how far it has progressed, so the forecast reflects how sales at each stage have really behaved in your branch.
Source: Ministry of Housing, Communities and Local Government (GOV.UK), 2025[1]
Show the data
| Item | Value |
|---|---|
| Government estimate (around 1 in 3) | 33% |
| Scotland | 9% |
Define stages by evidence, not by feeling
Probabilities only work if every sale is placed in a stage using the same objective test. Define each stage by an event you can see on the file, not by a negotiator's sense of how things are going.
| Stage | Enters when | Typical risks at this stage |
|---|---|---|
| A. Offer accepted | Memorandum of sale sent to both conveyancers | Buyer finance, survey, chain not yet confirmed |
| B. Chain and finance confirmed | Mortgage in principle verified and every link in the chain identified | Survey and valuation outcomes |
| C. Survey and mortgage offer | Lender valuation done and mortgage offer issued | Search results, enquiries, a chain link failing |
| D. Ready to exchange | Enquiries answered and a target exchange date agreed by all parties | Late renegotiation, a chain delay |
| E. Exchanged | Contracts exchanged with a fixed completion date | Very low; occasional delays to completion |
Calibrate probabilities from your own history
Export 12 to 24 months of sales
Include every sale agreed in the period, with the dates it entered each stage and whether it completed, fell through or is still live.
Count outcomes from each stage
For every sale that reached stage A, record whether it completed. Repeat for stages B, C and D. Ignore sales still live, or count them only once they resolve.
Calculate the completion rate per stage
Completed divided by resolved, for each stage. These are your stage probabilities.
Measure time to completion from each stage
Take the median days from entering each stage to completion, for sales that completed.
Repeat each quarter
Market conditions change; recalculate using the latest 12 months so the probabilities stay current.
Example: over the last 18 months a branch had 260 resolved sales that reached stage A, of which 177 completed, a stage A probability of 68%. Of 210 that reached stage C, 189 completed, a probability of 90%. Median time from stage A to completion was 131 days and from stage C was 52 days. These figures, not industry averages, go into the branch forecast.
Putting dates on the forecast
A probability without a date is only half a forecast. For each live sale, add the median days for its current stage to the date it entered that stage, giving an expected completion date. HMRC says completed transactions happen on average two to four months after an initial offer[4], and the government puts the average from accepted offer to completion at 120 days[3], with transaction times up 60% since 2007. Use these as a sense check against your own medians.
- Move a sale's expected date only when it changes stage or a firm date is agreed, not because someone feels it will be quick.
- For sales well past their stage median, apply a slippage rule, such as moving them into the following month and reducing their probability.
- Report the forecast by month for the next three months and as a total for months four to six.
- Keep a separate line for exchanged sales with fixed completion dates; they are close to certain.
Watch for ageing. In August 2026, an average of 31.8% of Propertymark member agents said most of their agreed sales took more than 17 weeks from acceptance[5]. If your stage A median is much shorter than that, check whether your history is up to date.
Worked forecast
Example: a branch has 34 live sales. Using its own probabilities: 14 at stage A with fees of £50,400 at 68% gives £34,300; 8 at stage B with £29,600 at 78% gives £23,100; 7 at stage C with £27,300 at 90% gives £24,600; 3 at stage D with £11,700 at 95% gives £11,100; and 2 exchanged with £7,800 at 99% gives £7,700. Gross pipeline is £126,800; weighted pipeline is about £100,800. Dated by stage medians, about £41,000 falls in the next calendar month.
Show both gross and weighted figures to owners, and explain the difference once. The weighted figure is the one to plan against; the gross figure shows the size of the opportunity if progression improves. Feed the dated weighted forecast into the cash flow forecast each week.
Checking forecast accuracy
A forecast earns trust when it is checked. At each month end, compare the forecast you made at the start of the month with the fees that actually completed. Track two measures: bias, which shows whether you consistently forecast too high or too low, and error, which shows how far off you are on average regardless of direction.
- Save each month's opening forecast; never overwrite it.
- At month end, record actual completed fees for the month.
- Bias: actual minus forecast, as a percentage of forecast. A run of negative figures means the forecast is optimistic.
- Error: the size of the difference, ignoring sign, averaged over the last six months.
- Investigate the sales that made the biggest difference: completed early, slipped or failed.
Example: over six months the branch forecast £252,000 and completed £231,000, a bias of about -8%. Most of the shortfall came from stage A sales that slipped a month rather than failed, so the fix was a longer stage A median in the model, not a lower probability.
Forecasting with small numbers
A single branch may not have enough history for stable probabilities at every stage, especially in a slow year. A probability calculated from 15 sales can swing wildly when two of them fail. There are practical ways to handle this without abandoning the method.
- Pool data across branches with similar markets and stock, then check each branch against the pooled figure once it has more history.
- Use a longer period, such as 24 months, for stages with few sales, and note that older data may reflect different market conditions.
- Round probabilities to the nearest five points; false precision suggests more certainty than the data supports.
- Separate unusual segments, such as new-build plots or probate sales, which often behave differently from ordinary resales.
- Treat the first quarter of using the method as a test, and compare its forecasts with the gross pipeline to see which was closer.
The aim is a forecast that is roughly right and consistently made, not one that is perfectly calibrated. Even simple stage weighting is usually far closer to actual completions than the gross pipeline figure most agencies plan against.
Improving the pipeline itself
Better forecasting shows you where sales fail. Use it to improve conversion, not just prediction. Government trials found earlier binding agreements can cut fall-through rates by up to 30% and help transactions complete up to 33% faster[6]. Even without formal reservation agreements, the actions that move sales quickly from stage A to stage B have the largest effect: verifying finance at offer, confirming every chain link and getting memoranda out the same day.
Record the reason for every fall-through against the stage it reached. Over a year, the pattern shows which stage loses the most fee value in your branch and which causes dominate there, whether buyer finance, survey results or chain breaks. That tells you where extra progression time will pay back fastest, and it improves the probabilities in the next quarterly recalibration.
Review the weighted pipeline at the Monday agency dashboard review, with the list of sales past their stage median. Combine it with stock levels for the months beyond the current pipeline, and with ancillary income where referral fees depend on completions. For homes in Wales affected by local tax changes, see council tax premiums on second homes in Wales.
Frequently asked questions
How do estate agents forecast completions?
Place each agreed sale in a stage defined by an objective event, apply the probability that sales at that stage have historically completed, and date each one using the median time from that stage to completion.
What probability should I use for a newly agreed sale?
Use your own history: completed sales divided by resolved sales that reached that stage over the last 12 to 24 months. Nationally around 1 in 3 transactions fail[1], but rates vary by stage and branch.
How do I know if my pipeline forecast is accurate?
Save each month's opening forecast and compare it with actual completed fees. Track bias and average error over six months, and adjust the stage probabilities or timings that cause the gaps.
References
Ministry of Housing, Communities and Local Government (GOV.UK) (2025). Home buying and selling reform (consultation) (opens in a new tab) ↑
Ministry of Housing, Communities and Local Government (GOV.UK) (2025). Home buying and selling reform (consultation) (opens in a new tab) ↑
Ministry of Housing, Communities and Local Government (GOV.UK) (2025). Home buying and selling reform (consultation) (opens in a new tab) ↑
HM Revenue & Customs (GOV.UK) (2026). UK monthly property transactions commentary (opens in a new tab) ↑
Propertymark (2026). Housing Insight Report, August 2026 (PDF) (opens in a new tab) ↑
Ministry of Housing, Communities and Local Government (GOV.UK) (2025). Home buying and selling reform (consultation) (opens in a new tab) ↑