Reconciling $4.8M in Phantom Pipeline: A PE Portfolio Revenue Audit

This case study describes a PE-backed $31M ARR SaaS company that reconciled $4.8M in phantom pipeline, reduced forecast variance from 31% to 11%, and passed add-on acquisition diligence without material adjustments. Details are anonymized. Financial figures are rounded.

The Situation

Fourteen months after acquisition, the PE operating partner flagged the portfolio company's pipeline data as unreliable in the quarterly operating review. The CRM showed $8.3M in active pipeline. Finance could not reconcile two consecutive quarters of CRM-to-collections gaps exceeding 25%. An add-on acquisition was approaching diligence in 90 days and the pipeline data could not be used as presented.

The company had grown from $18M to $31M ARR in the 14 months post-close, primarily through a mid-market expansion. The CRM had not scaled with the team. Stage management was informal, activity logging was inconsistent, and no reconciliation process had been run since the acquisition.

What the Audit Found

A full pipeline audit preceded the controls installation. Three failure categories accounted for most of the gap between the CRM number and the credible pipeline figure.

Zombie pipeline

62% of deals classified as Stage 3 or higher had no logged activity in the prior 60 days. These deals were neither closed nor lost. They had simply stopped moving, but no one had reviewed them, downstaged them, or marked them lost in the CRM. They continued appearing in the pipeline and the forecast without any active buyer engagement behind them.

Stage-jumping without evidence

31% of Stage 4 deals had no verifiable documentation of Stage 2 or Stage 3 completion. Deals had been advanced directly to Stage 4 based on rep judgment. In several cases, deals in the final pipeline stage had no record of a legal contact or a mutual action plan. They carried the highest commit weight in the forecast with none of the evidence that stage was designed to require.

Discount bleed without controls

The company had a published discount policy capping field discounts at 8%. The average discount at close was 19%. No exception log existed. Discounts above 8% nominally required VP approval, but the requirement had no CRM enforcement. Reps were closing deals at 15% to 22% discount and marking them as standard closes. Finance billed the discounted amount with no visibility into the variance from list price.

The Intervention

A four-component engagement ran over eight weeks.

Pipeline classification audit

Every open opportunity was reviewed against three categories: Active (buyer engaged in the last 30 days with a documented next step), Stale (no activity in 30 to 90 days, requiring immediate re-engagement), or Dead (no activity in 90 or more days, or explicit buyer disengagement). Dead deals were archived rather than deleted to preserve the audit trail. Active pipeline fell from $8.3M to $3.5M qualified.

Stage-exit controls installed

Each stage received binary validation rules built into the CRM stage-change workflow. Stage 2 required a named economic buyer and a documented pain statement. Stage 3 required a mutual action plan and a legal contact. Stage 4 required written buyer acknowledgment of deal terms and a finance introduction. Deals could not advance without the artifacts. Retroactive stage-jumping became structurally impossible.

Discount approval workflow enforced

The 8% discount ceiling was built into the CRM as a hard block. Discounts above 8% required VP approval through a CRM approval workflow before the deal could advance to Stage 4. An exception log captured every request with the reason, approver, and outcome. The informal practice of closing above policy without documentation was closed off at the system level.

Monthly pipeline health report to PE operating partner

A standard report was delivered to the PE operating partner on the first business day of each month. It included active pipeline by stage, deals moved in the prior month with evidence status, the discount exception log, and a comparison of the current forecast to the prior month's close. The operating partner could monitor pipeline quality without waiting for quarterly reviews.

Results

The add-on acquisition diligence ran 11 weeks after the pipeline audit completed. The portfolio company's pipeline was submitted as part of the data room. The diligence team accepted the pipeline without material adjustment and without requesting a reconciliation session. The deal closed on the original timeline.

Why PE Portfolios Face This Problem

The pattern in this case is common in post-acquisition SaaS portfolios. A company grows through the acquisition period, headcount scales, deal volume increases, and the informal stage management that worked at $10M ARR is overwhelmed at $30M. No single point of failure causes the problem. Accumulated operating friction across dozens of reps and hundreds of deals produces a CRM that reflects optimism more than operating state.

The fix is structural, not behavioral. Reps in this case were not gaming the system. They were using the system they had. The system did not require evidence to advance deals, so they advanced without evidence. Installing the evidence requirement changed the behavior without requiring anyone to be individually corrected.