formualizer

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.

Reporting TemplateB9:E56

Saved workbook valuesInputOutput

RowBCDE
9Beginning NAV - Net of Incentive Allocation$45,067,000
10Contributions - Cash & Non-Cash0
11Distributions - Cash & Non-Cash (input positive values)1,250,000
14(Management Fees – Gross of Offsets, Waivers & Rebates):(187,500)
26Total 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)
49Realized Gain / (Loss)1,000,000
50Change 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 / descriptionType / constraints / default
beginning_nav

USD 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

contributions

USD 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

distributions

USD 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_fees

USD 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_rebate

USD 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_expense

USD 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_offsets

USD 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_income

USD 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_income

USD 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_gain

USD 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_change

USD 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_change

USD 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 / descriptionType / constraints / default
net_cash_flows

USD LP #5 QTD, signed source convention. Calculated from source reconciliation formula.

Type: number

net_fees_expenses

USD LP #5 QTD, signed source convention. Net expense is negative.

Type: number

net_operating_income

USD LP #5 QTD, signed source convention. Calculated from source reconciliation formula.

Type: number

ending_nav

USD LP #5 QTD, signed source convention. Ending NAV net of incentive allocation.

Type: number

ending_accrued_incentive

USD LP #5 QTD, signed source convention. Accrued incentive liability is negative.

Type: number

gross_ending_nav

USD 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/mcp

Slug: 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.