Funnel IQ Pipeline
forensics

Quality of Forward Revenue (QoFR)

Forward revenue: the last unaudited number in M&A.

Quality of Earnings tests the earnings already reported. QoFR tests the forecast that shapes your multiple –
against how the target’s past forecasts actually turned out.

So price, debt and any earn-out rest on what the evidence supports –
and you negotiate from the target’s own record, not the seller’s narrative.

Independent of managementNo confidential names or system access neededQoFR report typically in 5–10 working days

Three things Quality of Earnings isn’t built to show

Management’s forecast is the sum of many judgements on individual leads. How far each kind can be relied on lies buried in the company’s own pipeline history – invisible in any snapshot. Pipeline forensics recovers it.

How much of the forecast
is real?

Where probabilities, values and close dates are systematically overstated – by segment, stage and rep, with confidence intervals.

Why it matters

The multiple is shaped by the forecast – including the parts that won’t land.

Where is revenue
at risk?

Deals going nowhere, still carried at live-deal odds; dependence on key people; and close dates that habitually slip.

Why it matters

That is where to seek a price adjustment, warranties or earn-out protection – targeted, not boilerplate.

Where is the
real upside?

The segments and reps that consistently beat their forecast, and what redirecting effort towards them would earn.

Why it matters

The value-creation case for the hold period – grounded in the company’s own record.

Case study

What one target’s history revealed

A venture-backed digital healthcare services company

28%of pipeline value in leads that the company’s own history showed would never close – value a buyer would otherwise have priced in
35%of live leads matching the pattern of past leads that never closed – yet still carried at live-deal odds
99%of live leads detected as going nowhere that duly never closed over the following 20 months – so the price could rest on evidence, not narrative

None of this was visible in the company’s CRM, management reporting or business intelligence.

Built on evidence, not opinion

We apply pipeline forensics: we trace how every past lead, won and lost, was forecast throughout its life, and compare that with how it turned out. Our analytics then isolate the signals that predict which forecasts will fall short, and which will do better than expected.

We reconstruct the history

Every past lead traced month by month through the company’s own records: how its forecast evolved, and how it turned out.

We detect forecast biases

Where forecast values, win probabilities and close dates diverge from outcomes, and which signals predict it – for different lead types, deal stages and reps, and with confidence intervals.

We recalibrate the forecast

Today’s pipeline, adjusted line by line for the biases its history reveals. Every adjustment is traceable to evidence, never assumed – by anyone, us included.

Delivered as a Quality of Forward Revenue (QoFR) report, structured to sit alongside QoE in your diligence pack: every finding charted, with its confidence interval and an exportable audit trail your advisers can check line by line.

Where pipeline forensics fits

PE & VC investors

Before you commit capital

  • A defensible view of forward revenue, with a value waterfall and confidence intervals
  • Negotiation levers ranked by value and statistical confidence
  • Dependence on key reps or segments pinpointed – for targeted warranties or earn-outs
Portfolio teams

Protect value through the hold

  • Early warning of revenue deterioration, while there is time to act
  • Systemic underperformance separated from random variance
  • Reallocation opportunities sized, with an EV bridge at the exit multiple
QoE and diligence advisers

Set your diligence apart

  • Empirical test of the forecast your clients price on – a differentiator competitors cannot match
  • Optional, separately scoped module that dovetails with your QoE
  • Delivery under your brand, co-branded or jointly – our analysis, your client relationship

See how it fits your service

Built for the deal timetable

Independent of management, and complementary to QoE and commercial due diligence. We work from a single history export of the target’s CRM: no system access, and the analysis itself needs no confidential names.

  1. No-commitment feasibility checkConfirms the target’s data trail is strong enough to read.
  2. Headline findingsWithin days, where the deal timetable demands.
  3. Full QoFR reportTypically 5–10 working days from receiving the data.

Questions deal teams ask

Doesn’t financial due diligence already cover this?

Financial due diligence, with Quality of Earnings at its core, validates the historical numbers: what was booked, and whether it was real. The forward forecast that shapes your entry multiple may be reviewed for reasonableness, but is rarely tested against the company’s own track record. QoFR adds that test, and is designed to sit alongside QoE.

How does this relate to commercial due diligence?

CDD tests the market – how much revenue it can support, and the target’s competitive position within it. It can’t show whether the company will actually win that revenue: where its projections are realistic, and where the fat is. The two are complementary: CDD validates the opportunity; pipeline forensics validates whether the company can actually capture it.

Why can’t management see this themselves?

No-one can correct for forecasting biases without evidence of where they lie, and how far they distort today’s forecast. That evidence can be recovered from the records past leads left as they developed and were won or lost. But no snapshot shows it, and no-one inside the business is in a position to read it objectively.

What if the target’s CRM records are patchy?

The question isn’t whether recorded data is perfect – it’s whether there’s enough of it to detect the biases with statistical confidence. Irregular recording itself often contains patterns that turn out to have predictive value. Our initial feasibility check answers the question before anyone commits.

How do you know the findings are reliable?

They’re not our opinion, or anyone else’s – they’re what the company’s own data history proves. We back-test every pattern against leads that have already closed or been lost, and keep only those that prove dependable. We then apply them to the leads in the forecast you’ve been given, each with its statistical confidence – and show you the evidence behind every adjustment, structured, ranked and charted, so you can decide.

Can we test it on a deal we’ve already closed?

Yes – and it’s a good way to judge the method. Run it on a completed deal, and compare what pipeline forensics would have shown you against what actually happened.

What about confidential information?

We work under NDA as standard. Our analysis needs no confidential customer, deal or rep names: it runs on amounts, stages, dates, probabilities and reference codes that only the company can match back to real deals and people. Where a system can only export the figures together with names, we anonymise them on receipt.

Which CRM systems do you work with?

We can draw from any of the major CRMs, or from management’s spreadsheet-based pipelines. We give the company step-by-step instructions to get a history export from its system, and help where necessary. No logins, no integration, nothing to install.

Tell us what you’re facing

Call, email or choose a time to talk. We respond within one working day.

No live deal just now? Test the method on one you’ve already closed, and compare what it shows against what actually happened. Tell us about it, and we’ll shape the test to fit.

Christopher Barker, founder of Funnel IQ
Christopher Barker Founder & Managing Director

Christopher built pipeline forensics on 25 years in management consulting, predictive analytics and M&A execution – at PwC, leading an analytics firm for two decades, and as an operating partner. He leads every engagement himself, end to end.