Analysis & Reporting Commands
FundAdmin AI provides analytical commands that validate fund economics, prepare audit-ready documentation, and generate professional reports. These commands bridge the gap between raw fund data and presentation-ready deliverables.
/fund audit-support
Description: Generates a comprehensive audit support package including auditor confirmation letters, supporting schedules, and workpaper templates. Designed to streamline the annual audit process by organizing fund data into formats auditors expect.
Usage
/fund audit-support <file>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
file | File path | Yes | Fund data, financial statements, or prior audit package (PDF, DOCX, JSON, XLSX) |
Output
Generates AUDIT-SUPPORT-[fund-name]-[date].md containing:
- Confirmation Letter Drafts -- bank confirmations, custodian confirmations, counterparty confirmations, legal counsel confirmations
- Capital Account Schedules -- per-LP capital account roll-forward (beginning balance, contributions, distributions, income allocation, ending balance)
- Investment Schedule -- portfolio company detail (cost basis, fair value, valuation methodology, unrealized gain/loss)
- Fee Calculation Workpapers -- management fee calculation with rate, basis, period, amount; carry calculation with waterfall tier detail
- Expense Analysis -- fund expenses by category, organizational expense amortization, broken deal costs, GP reimbursement
- Valuation Support -- fair value hierarchy classification (Level 1/2/3), valuation methodology documentation, comparable company data
- Trial Balance Mapping -- chart of accounts with balances, reconciliation to financial statements
- Subsequent Events -- post-period transactions, capital activity, material events requiring disclosure
Example
/fund audit-support fund-iv-year-end-data.xlsxRelated Commands
/fund waterfall-review-- validate waterfall calculations before audit/fund fee-audit-- detailed fee verification/fund performance-calc-- calculate performance metrics for audit support
/fund waterfall-review
Description: Validates a distribution waterfall calculation by independently recomputing each tier. Checks hurdle rates, preferred return accruals, GP catch-up mechanics, carried interest splits, clawback obligations, and fee offsets. Flags discrepancies between the stated waterfall and the LPA terms.
Usage
/fund waterfall-review <file>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
file | File path | Yes | Waterfall data, distribution schedule, or LPA with financials (PDF, DOCX, JSON, XLSX) |
Output
Generates WATERFALL-REVIEW-[fund-name]-[date].md containing:
- Waterfall Structure -- identified waterfall type (American/European), number of tiers, key parameters
- Tier 1: Return of Capital -- contributed capital returned, remaining amount to distribute
- Tier 2: Preferred Return -- preferred return rate, accrual method (simple/compound), amount due, amount distributed, shortfall
- Tier 3: GP Catch-Up -- catch-up percentage (typically 100% to GP until 20/80 split achieved), amount, completion status
- Tier 4: Carried Interest Split -- carry percentage, LP/GP split, amounts to each party
- Clawback Analysis -- GP clawback obligation, escrow adequacy, true-up calculation, interim clawback triggers
- Fee Offset Verification -- management fees, transaction fees, monitoring fees, offset percentage applied, net impact
- Discrepancy Report -- differences between provided calculations and independent recomputation, with magnitude and cause
- Sensitivity Analysis -- waterfall results under alternative NAV assumptions (+/- 10%, 20%)
Example
/fund waterfall-review fund-iv-distribution-model.xlsxRelated Commands
/fund draft-distribution-- generate distribution notices based on validated waterfall/fund scenario-model-- model waterfall under different scenarios/fund smart-contract-sim-- simulate waterfall as programmable logic
/fund report-pdf
Description: Generates a professional PDF report using ReportLab with a cover page, score gauge, risk dashboard, and formatted tables. It finds the most recent supported FundAdmin AI analysis output in the working directory, normalizes the review data for rendering, and produces a presentation-ready document suitable for LP meetings, board presentations, or regulatory submissions.
Usage
/fund report-pdfInputs
| Parameter | Type | Required | Description |
|---|---|---|---|
| (none -- uses prior analysis) | -- | -- | Finds the most recent supported analysis file in the working directory (for example LPA-REVIEW-*.md, WATERFALL-REVIEW-*.md, or AUDIT-SUPPORT-*.md) |
Output
Generates FUND-REVIEW-REPORT.pdf by default (or a custom path when invoking the Python script directly) containing:
- Cover Page -- fund name, report type, date, confidentiality notice
- Executive Summary -- key findings, scores, and top-level metrics
- Score Gauges -- visual gauge charts for LPA Safety Score, compliance scores, and risk ratings (0-100 scale with color coding)
- Risk Dashboard -- high / medium / low risk counts and provision summaries
- Data Tables -- formatted tables with alternating row colors, headers, and totals
- Findings Detail -- full analysis content organized by section with page references
- Appendices -- supporting data, methodology notes, glossary of terms
- Footer -- page numbers, confidentiality legend, generation timestamp
Example
/fund review-lpa greenfield-fund-iv.pdf
/fund report-pdfIf you need a custom output filename when invoking the helper directly, pass the review Markdown or normalized JSON into the script:
python3 scripts/generate_fund_pdf.py --input path/to/review.md --output Greenfield-IV-review.pdfRelated Commands
/fund review-lpa-- generate an LPA review to convert to PDF/fund performance-calc-- generate performance data for PDF reporting/fund benchmark-- generate benchmark data for inclusion in the report