preparing-fundraising-pipeline-reports

# Preparing Fundraising Pipeline Reports

## When To Use

- Generating a fundraising status report for the GP or investment committee during an active fund raise
- Tracking LP prospect movement through pipeline stages (initial contact → meeting → DD → soft circle → hard commit → closed)
- Projecting interim and final close timelines based on current commitment velocity
- Preparing materials for placement agent check-ins or fundraising strategy sessions
- Monitoring progress toward target fund size and hard-cap thresholds

## Inputs To Gather

- **Fund parameters**: target fund size, hard cap, GP commitment amount, minimum LP commitment, management fee/carry terms summary
- **Prospect list**: LP name, type (pension, endowment, family office, fund-of-funds, sovereign wealth, insurance, etc.), contact/relationship owner, geographic region
- **Pipeline stage for each prospect**: categorize as Identified → Contacted → Meeting Held → Due Diligence → Soft Circle → Hard Commit → Docs Out → Closed/Funded
- **Commitment amounts**: soft-circled amounts (with confidence weighting if available), hard commitments, signed subscription amounts, funded capital
- **Timeline data**: date of first contact, most recent touchpoint, expected decision date, any known committee meeting dates
- **Close schedule**: planned first close date, subsequent close dates, final close deadline per LPA terms
- **Prior reporting period data** (if producing an update rather than initial report)

## 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