Preparing Fundraising Pipeline Reports

Workflow

1. Validate data completeness — Confirm each prospect has a current pipeline stage, commitment amount (or estimated range), and a last-contact date. Flag any prospect with no activity in 60+ days as "stale" and mark for follow-up. Mark missing data points with [VERIFY].

2. Build the prospect pipeline summary table

   • Columns: LP Name | Type | Region | Pipeline Stage | Estimated/Committed Amount | Relationship Owner | Next Step | Expected Decision Date
   • Sort by pipeline stage (most advanced first), then by commitment size descending
   • Include row counts and subtotals per stage

3. Calculate pipeline metrics

   • Total commitments closed (absolute $ and % of target)
   • Soft-circle total and weighted pipeline value (apply confidence factors: soft circle 60–70%, DD stage 30–40%, meeting stage 10–20%) [VERIFY confidence weights with GP/placement agent]
   • Number of prospects at each stage and conversion rates between stages
   • Average time-in-stage for current prospects
   • Gap-to-target: remaining capital needed to reach target size and hard cap

4. Prepare closing projections

   • Map committed and high-probability prospects against planned close dates
   • Project first-close amount and assess whether it meets any minimum-close threshold in the LPA [VERIFY minimum first-close requirements]
   • Identify risks to timeline (e.g., prospects in extended DD, pending IC approvals, regulatory clearances)
   • Provide best-case, base-case, and downside scenarios for final fund size

5. Draft narrative commentary

   • Summarize momentum: new prospects added, prospects advanced, prospects lost/declined since last report
   • Highlight top 5 prospects by commitment size and their current status
   • Note strategic observations (sector concentration, geographic mix, LP-type diversification relative to targets)
   • Flag any ERISA or benefit-plan investor threshold concerns if applicable [VERIFY ERISA 25% threshold and plan-asset regulation applicability]

6. Compile the report — Assemble pipeline table, metrics dashboard, closing-projection timeline, and narrative into a single document structured for the intended audience (internal IC vs. placement agent vs. advisory board).

Output

The final report should contain:

• Pipeline Summary Table with all prospects, stages, and amounts
• Metrics Dashboard: commitments closed, weighted pipeline value, conversion rates, gap-to-target
• Closing Projection Timeline: expected amounts per close, scenario analysis
• Narrative Update: momentum summary, key prospect highlights, strategic observations, risk flags
• Appendix (if needed): detailed prospect notes, activity log since last report, LP-type and geographic breakdowns

Format amounts consistently (e.g., $25.0M) and express percentages to one decimal place. Date formats should be consistent throughout (e.g., DD-MMM-YYYY).

Quality Checks

• Every prospect in the pipeline has a defined stage — no "TBD" or blank entries without a [VERIFY] flag
• Commitment totals reconcile: sum of individual commitments equals reported aggregate figures
• Weighted pipeline value calculation is transparent and assumptions are stated
• Closing projections align with LPA close-schedule provisions and any side-letter commitments [VERIFY]
• No prospect-identifying information is included in versions shared outside the GP unless authorized (LP confidentiality)
• ERISA/benefit-plan investor tracking is current if the fund is subject to plan-asset regulations [VERIFY]
• Report date and reporting-period boundaries are clearly stated
• Prior-period comparisons (if included) use consistent methodology