# ILPA Reporting Template — LP Quarterly Reconciliation Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/ilpa-reporting-template) - [Subject guide (text)](https://formualizer.com/catalog/subjects/finance/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/finance/llms.json) - [Publisher page](https://ilpa.org/resource/ilpa-reporting-template-xlsx/) - [Ports (text)](https://formualizer.com/catalog/agents/ilpa-reporting-template/v1.1/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/ilpa-reporting-template/v1.1/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "ilpa-reporting-template/v1.1", "title": "ILPA Reporting Template — LP Quarterly Reconciliation", "summary": "Reconcile quarterly LP capital, management fees, partnership expenses, offsets, commitments and accrued incentive allocations using ILPA v1.1 source formulas.", "edition": "v1.1", "html": "https://formualizer.com/catalog/ilpa-reporting-template", "parent": { "text": "https://formualizer.com/catalog/subjects/finance/llms.txt", "json": "https://formualizer.com/catalog/subjects/finance/llms.json" }, "publisher": "Institutional Limited Partners Association (ILPA)", "publisherPageUrl": "https://ilpa.org/resource/ilpa-reporting-template-xlsx/", "verificationLevel": "scenario-independent-arithmetic", "verificationExplanation": "Changed-input scenarios match an independent calculation.", "rightsExplanation": "The workbook download opens on the publisher’s site.", "limitations": [ "Historical v1.1 packet last updated October 17, 2016; not the newer ILPA reporting standard.", "Mapped domain is LP #5 quarterly E-column statement only; YTD, inception, total-fund, GP and underlying-fund schedules retain example values.", "Underlying fund fees output is a source-example allocation, not recalculated from user-supplied underlying holdings.", "Offset percentages are disclosures. Input offset amounts are already LP allocated; no automatic multiplication by the displayed percentages.", "Contributions for NAV and commitment reconciliation are separate signed inputs; full flow exposes both.", "ILPA source is reference-only; no redistribution or endorsement rights are asserted." ], "releaseBlockers": [], "licenseClass": "reference-only", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_lp_quarter", "title": "Quick lp quarter", "description": "Main decision inputs; omitted inputs retain the pinned source example defaults.", "inputPorts": [ "beginning_nav", "contributions", "distributions", "gross_management_fees", "fee_rebate", "legal_expense", "applied_offsets", "interest_income", "dividend_income", "realized_gain", "unrealized_gain_change", "accrued_incentive_change" ], "outputPorts": [ "net_cash_flows", "net_fees_expenses", "net_operating_income", "ending_nav", "ending_accrued_incentive", "gross_ending_nav" ] }, { "id": "full_lp_quarter", "title": "Full lp quarter", "description": "LP #5 quarterly E-column; USD with source signs. Full flow exposes all numeric nonformula E9:E90 statement entries and all mapped formula outputs; other periods and fund schedules stay at source defaults.", "inputPorts": [ "beginning_nav", "contributions", "distributions", "gross_management_fees", "fee_rebate", "accounting_expense", "audit_expense", "bank_expense", "custody_expense", "due_diligence_expense", "legal_expense", "organization_expense", "travel_expense", "other_expense", "applied_offsets", "advisory_offset", "broken_deal_offset", "transaction_offset", "directors_offset", "monitoring_offset", "capital_markets_offset", "organization_offset", "placement_offset", "other_offset", "beginning_unapplied_offsets", "fee_waiver", "interest_income", "dividend_income", "interest_expense", "other_income", "placement_fees", "realized_gain", "unrealized_gain_change", "beginning_accrued_incentive", "incentive_paid", "accrued_incentive_change", "total_commitment", "beginning_unfunded", "commitment_contributions", "recallable_distributions", "released_commitments", "other_unfunded_adjustment", "earned_incentive", "escrow_incentive", "returned_clawback", "capitalized_nonrelated_fees", "distributions_for_fees", "related_party_partnership_expense", "capitalized_related_fees", "portfolio_advisory_fees", "portfolio_broken_deal_fees", "portfolio_transaction_fees", "portfolio_directors_fees", "portfolio_monitoring_fees", "portfolio_capital_markets_fees", "portfolio_other_fees", "portfolio_reimbursements" ], "outputPorts": [ "net_cash_flows", "total_partnership_expense", "recognized_offsets", "offsets_applied_display", "ending_unapplied_offsets", "net_fees_expenses", "net_operating_income", "ending_nav", "ending_accrued_incentive", "gross_ending_nav", "ending_unfunded", "underlying_fund_fees", "related_management_fees", "related_offsets", "related_incentive_change", "portfolio_total_fees", "total_received_related_parties" ] } ], "example": { "id": "higher_fees", "flow": "quick_lp_quarter", "inputs": { "gross_management_fees": -250000, "legal_expense": -30000, "unrealized_gain_change": 500000, "applied_offsets": 100000 }, "expectedOutputs": { "net_cash_flows": -1250000, "net_fees_expenses": -228000, "net_operating_income": -218500, "ending_nav": 45098500, "ending_accrued_incentive": -5000000, "gross_ending_nav": 50098500 }, "inputsJson": "{\"gross_management_fees\":-250000,\"legal_expense\":-30000,\"unrealized_gain_change\":500000,\"applied_offsets\":100000}", "expectedOutputsJson": "{\"net_cash_flows\":-1250000,\"net_fees_expenses\":-228000,\"net_operating_income\":-218500,\"ending_nav\":45098500,\"ending_accrued_incentive\":-5000000,\"gross_ending_nav\":50098500}" }, "ports": { "text": "https://formualizer.com/catalog/agents/ilpa-reporting-template/v1.1/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/ilpa-reporting-template/v1.1/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/openapi.json", "types": "https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```