casemark/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