Excel workbook · Catalog edition v1.1
ILPA Reporting Template — LP Quarterly Reconciliation
Institutional Limited Partners Association (ILPA)
Reconcile quarterly LP capital, management fees, partnership expenses, offsets, commitments and accrued incentive allocations using ILPA v1.1 source formulas.
- Inputs
- 57
- Outputs
- 17
- File size
- 781 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | B | C | D | E |
|---|---|---|---|---|
| 9 | Beginning NAV - Net of Incentive Allocation | $45,067,000 | ||
| 10 | Contributions - Cash & Non-Cash | 0 | ||
| 11 | Distributions - Cash & Non-Cash (input positive values) | 1,250,000 | ||
| 14 | (Management Fees – Gross of Offsets, Waivers & Rebates): | (187,500) | ||
| 26 | Total Offsets to Fees & Expenses (applied during period): | 82,600 | ||
| 41 | (Total Management Fees & Partnership Expenses, Net of Offsets & Rebates, Gross of Fee Waiver) | (152,900) | ||
| 49 | Realized Gain / (Loss) | 1,000,000 | ||
| 50 | Change in Unrealized Gain / (Loss) | 1,000,000 |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
- 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.
What it computes
Ports for the compact flow: quick_lp_quarter. The full port contract includes all 74 ports.
Inputs (12)
| Port / description | Type / constraints / default |
|---|---|
beginning_navUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 45067000. | Type: number Default: 45067000 |
contributionsUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 0. | Type: number Constraints: min: 0 Default: 0 |
distributionsUSD for LP #5 QTD only. Enter distributions as positive; formula subtracts them. Default equals the source illustrative example. Source default: 1250000. | Type: number Constraints: min: 0 Default: 1250000 |
gross_management_feesUSD for LP #5 QTD only. Enter expenses, reductions or accrued carry as negative values. Default equals the source illustrative example. Source default: -187500. | Type: number Default: -187500 |
fee_rebateUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 0. | Type: number Default: 0 |
legal_expenseUSD for LP #5 QTD only. Enter expenses, reductions or accrued carry as negative values. Default equals the source illustrative example. Source default: 0. | Type: number Default: 0 |
applied_offsetsUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 82600. | Type: number Default: 82600 |
interest_incomeUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 500. | Type: number Default: 500 |
dividend_incomeUSD for LP #5 QTD only. Positive amount unless the source convention requires a signed adjustment. Default equals the source illustrative example. Source default: 10000. | Type: number Default: 10000 |
realized_gainUSD for LP #5 QTD only. Signed amount; gains/increases positive. Default equals the source illustrative example. Source default: 1000000. | Type: number Default: 1000000 |
unrealized_gain_changeUSD for LP #5 QTD only. Signed amount; gains/increases positive. Default equals the source illustrative example. Source default: 1000000. | Type: number Default: 1000000 |
accrued_incentive_changeUSD for LP #5 QTD only. Enter expenses, reductions or accrued carry as negative values. Default equals the source illustrative example. Source default: -300000. | Type: number Default: -300000 |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
net_cash_flowsUSD LP #5 QTD, signed source convention. Calculated from source reconciliation formula. | Type: number |
net_fees_expensesUSD LP #5 QTD, signed source convention. Net expense is negative. | Type: number |
net_operating_incomeUSD LP #5 QTD, signed source convention. Calculated from source reconciliation formula. | Type: number |
ending_navUSD LP #5 QTD, signed source convention. Ending NAV net of incentive allocation. | Type: number |
ending_accrued_incentiveUSD LP #5 QTD, signed source convention. Accrued incentive liability is negative. | Type: number |
gross_ending_navUSD LP #5 QTD, signed source convention. NAV before accrued incentive liability. | Type: number |
Questions this workbook answers
- Reconcile ILPA quarterly LP ending NAV and fees
- Calculate net management fees and unapplied fee offsets
- Roll forward private equity LP unfunded commitment
Questions and answers
Is this a publisher-operated service?
No. This independent executable mapping cites and preserves the pinned publisher workbook. It is not publisher endorsed.
What are the scope and units?
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.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: ilpa-reporting-template · Edition: v1.1
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "ilpa-reporting-template",
"edition": "v1.1",
"flow": "quick_lp_quarter",
"inputs": {
"gross_management_fees": -250000,
"legal_expense": -30000,
"unrealized_gain_change": 500000,
"applied_offsets": 100000
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_lp_quarter
Quick lp quarter
Main decision inputs; omitted inputs retain the pinned source example defaults.
12 input ports · 6 output ports. Full membership in the port contract.
full_lp_quarter
Full lp quarter
57 input ports · 17 output ports. Full membership in the port contract.
REST example
Bundle scenario: higher_fees · Flow: quick_lp_quarter
curl 'https://catalog.formualizer.com/v1/models/ilpa-reporting-template/v1.1/evaluate?flow=quick_lp_quarter' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"gross_management_fees":-250000,"legal_expense":-30000,"unrealized_gain_change":500000,"applied_offsets":100000}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"net_cash_flows": -1250000,
"net_fees_expenses": -228000,
"net_operating_income": -218500,
"ending_nav": 45098500,
"ending_accrued_incentive": -5000000,
"gross_ending_nav": 50098500
}
}Looking for another spreadsheet? Request a workbook.