lev-os Managing Portfolio Company Reporting
Structures portfolio company monitoring frameworks with KPI tracking, budget-to-actual variance analysis, and management team assessment for PE, VC, and growth equity investors.
When To Use
- Building or refining a quarterly/monthly portfolio company reporting package
- Preparing for an LP advisory committee meeting or annual meeting with portfolio performance data
- Flagging underperformance, covenant breaches, or management concerns across a fund's portfolio
- Onboarding a new portfolio company into the fund's monitoring framework
- Consolidating cross-portfolio data for fund-level reporting or valuations
Inputs To Gather
- Company financials: Income statement, balance sheet, cash flow statement (current period + prior period + budget/plan)
- Operating KPIs: Revenue run-rate, MRR/ARR, customer count, churn, pipeline, headcount, burn rate — as relevant to sector
- Budget/plan: Board-approved annual operating plan with monthly or quarterly breakdowns
- Debt schedule: Outstanding balances, covenant levels, interest rates, maturity dates, compliance certificate data
- Cap table snapshot: Fully diluted ownership, option pool remaining, any recent issuances
- Management commentary: CEO/CFO narrative on performance drivers, risks, and outlook
- Prior period report: Last reporting cycle's package for trend comparison
- Investment thesis benchmarks: Original underwriting assumptions (entry revenue, EBITDA targets, growth rate, exit timeline)
Workflow
Validate data completeness — Confirm all financial statements tie (net income flows to retained earnings, cash flow reconciles to balance sheet). Flag any missing line items or periods with [VERIFY].
Build the KPI dashboard
- Select 8-12 KPIs relevant to the company's sector and stage (e.g., SaaS: ARR, net dollar retention, CAC payback, Rule of 40; industrial: EBITDA margin, backlog, capacity utilization, working capital days)
- Present current period, prior period, budget, and variance (both absolute and percentage)
- Include a trailing 4- or 6-quarter trend chart or sparkline where possible
Perform budget variance analysis
- Revenue variance: decompose into volume, price/mix, and timing components
- EBITDA/margin variance: separate gross margin impact from SG&A/opex deviations
- Cash flow variance: highlight capex timing, working capital swings, and one-time items
- Mark any line item deviating >10% from plan for narrative explanation
Assess debt and liquidity position
- Calculate covenant compliance ratios (leverage, coverage, minimum liquidity) against thresholds
- Project runway in months at current burn rate (for growth-stage companies)
- Note upcoming maturities, required amortization, or revolver availability
- [VERIFY] covenant definitions — these vary by credit agreement
Evaluate management performance
- Compare actuals to the commitments management made in the prior reporting period
- Track key initiative milestones (product launches, hiring targets, geographic expansion)
- Note any leadership changes, organizational issues, or talent gaps
- Rate overall execution as On Track / Watch / Action Required
Compile portfolio-level summary
- Rank companies by performance against plan (green/yellow/red or quartile)
- Aggregate fund-level revenue, EBITDA, and net debt across portfolio
- Highlight the 2-3 companies requiring IC attention or follow-up
Draft the reporting package
- One-page executive summary per company (KPI snapshot + management assessment + key risks)
- Detailed financials as appendix
- Fund-level dashboard as lead section for LP or IC consumption
Output
A structured portfolio company report containing:
- Executive summary: One-page per company with traffic-light status, key KPIs vs. plan, and critical issues
- KPI dashboard: Standardized metrics table with trend, budget comparison, and variance flags
- Budget variance narrative: Explanation of material deviations with management's remediation plan
- Covenant/liquidity tracker: Compliance status and headroom for each facility
- Management scorecard: Execution rating with supporting evidence from milestone tracking
- Portfolio roll-up: Fund-level aggregation with ranking and concentration analysis
- Action items: Specific follow-ups for deal teams, with owners and deadlines
Quality Checks
- All financial data ties across statements; any discrepancy is flagged with [VERIFY]
- Variance calculations are directionally correct (favorable vs. unfavorable labeled accurately)
- KPIs match the sector-appropriate metrics — do not apply SaaS metrics to an industrial company
- Covenant ratios are calculated using the credit agreement's specific definitions, not generic formulas [VERIFY]
- Management assessment is evidence-based, not subjective; tied to specific commitments and outcomes
- Prior period comparisons use consistent accounting treatment (watch for restatements or methodology changes)
- Sensitive compensation or personnel data is excluded unless explicitly requested
- [VERIFY] any valuation-related data points (marks, multiples) against the fund's most recent fair value process