> For the complete documentation index, see [llms.txt](https://help.modelreef.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.modelreef.io/use-cases/portfolio-funds-vc-pe-and-family-offices/lp-reporting-dashboard.md).

# LP Reporting Dashboard

This guide explains how to build an LP reporting dashboard for funds, VC, PE and family offices in Model Reef.

You will:

* Design a consistent LP reporting pack using dashboards and reports.
* Combine portfolio company and fund level metrics in one view.
* Track commitments, calls, distributions and residual value over time.
* Use scenarios to show base, downside and upside portfolios.

Model Reef does not generate legal statements or audited reports. It provides a flexible analytical dashboard environment for LP communications and internal use.

***

## When to use this pattern

Use this pattern when:

* You want to improve LP communication with clearer visuals and scenarios.
* You manage multiple funds or sleeves and want standardised reporting.
* IC, board and LP packs should all be based on one modelling environment.
* You need quick updates when portfolio or fund assumptions change.

It builds on:

* Portfolio Company Forecasting
* Fund Cash Flow (Capital Calls and Distributions)
* IRR MOIC and Waterfall Models
* Build a Multi Scenario Valuation Pack

***

## Architecture overview

LP reporting dashboards use:

{% stepper %}
{% step %}

### Data inputs

* Portfolio company model outputs.
* Fund level cashflow and valuation outputs.
* Commitment and contribution data.
  {% endstep %}

{% step %}

### Dashboards and reports

* High level summary dashboards.
* Detailed portfolio and company views.
* Fund cash, commitment and distribution charts.
  {% endstep %}

{% step %}

### Scenarios

* Base, downside and upside cases.
* Strategy or macro based scenarios.
  {% endstep %}
  {% endstepper %}

***

## Step 1: Decide on the LP reporting framework

Define a standard LP pack structure, for example:

* Fund overview and key metrics.
* Portfolio composition and performance.
* Top holdings and case studies.
* Cash, commitments and distributions.
* Scenario outlook for the remainder of the fund life.

Translate this into required charts, tables and KPIs such as:

* Commitments, contributed capital, distributed capital and residual NAV.
* DPI, RVPI and TVPI where calculated.
* Top 10 holdings by value or contribution.
* Sector, geography and stage breakdowns.
* Fund IRR and money multiple.

***

## Step 2: Prepare portfolio and fund level series

From portfolio company and fund models, ensure you have series for:

* Company level valuations and cashflows.
* Fund level cashflows, IRR and multiples.
* Sector, stage and geography tags per company.
* Commitments, contributions and distributions.

You can either:

* Keep these series in a dedicated Portfolio model, or
* Import them into a separate Reporting model that only handles dashboards and reports.

Ensure that naming and categorisation is consistent across funds and vintages.

***

## Step 3: Build LP summary dashboards

Create one or more dashboards for LPs, for example:

* Fund Summary dashboard with:
  * Committed, contributed, distributed and residual value.
  * Fund IRR and multiple.
  * Cash and undrawn commitments over time.
* Portfolio dashboard with:
  * Holdings by sector and geography.
  * Top holdings table with key metrics.
  * Value bridge from cost to current value.
* Cash and Distribution dashboard with:
  * Capital calls and distributions by period.
  * Cumulative calls and distributions.
  * Projections under base and downside portfolios.

Use clear, consistent labelling and avoid unnecessary complexity.

***

## Step 4: Add company and deal drilldowns

Provide drilldown paths from LP dashboards to:

* Company level models and dashboards where appropriate.
* Deal level IRR and MOIC, or at least summary metrics.
* Notes and qualitative commentary on key holdings.

You might provide:

* Read only links for LPs if internal policies allow.
* Internal only drilldowns for IC and board use, with LP packs exported as PDF or images.

Keep a clear separation between internal detail and external appropriate transparency.

***

## Step 5: Layer in scenarios and outlook views

Use scenarios to present:

* Base Case portfolio, consistent with current plans.
* Downside Case, showing resilience under stress.
* Upside Case, showing potential if strategy and markets perform well.

On LP dashboards, include scenario toggles or separate charts showing:

* Projected fund value and distributions under each scenario.
* Scenario based IRR and multiple ranges.
* Commentary on drivers (for example exit timing, valuation multiples, growth).

This helps LPs understand not just a single point estimate but a range of possible outcomes.

***

## Step 6: Use exports for formal reporting

For formal LP reporting, you can:

* Export dashboards and reports as PDF.
* Export tables as CSV for inclusion in other documents.
* Use images from dashboards in slide decks or written reports.

Ensure that exported packs clearly identify:

* As of date.
* Scenario used (for example Base Case as at quarter end).
* Any major modelling assumptions or caveats.

***

## Check your work

* LP dashboards align with LP documentation and side letters where relevant.
* Reported metrics match audited or official figures for current and historical periods.
* Scenario views are clearly labelled and not confused with official valuations.
* Packs are easy for non modelling specialists to read.

***

## Troubleshooting

<details>

<summary>LPs find the dashboards confusing</summary>

Simplify layouts, reduce chart and table count on the main pages and push detail into drilldowns or appendices.

</details>

<details>

<summary>Metrics differ from fund administrator reports</summary>

Reconcile model inputs with official records and decide whether you are showing official figures or internal estimates, clearly labelled.

</details>

<details>

<summary>Hard to update packs across multiple funds</summary>

Use consistent templates and a shared Reporting or Portfolio model pattern, so that adding a new fund reuses most of the dashboard logic.

</details>

***

## Related guides

* [Dashboards & Reporting](/how-tos/dashboards-and-reporting.md)
* [Build an Inventory Timing Model](/how-tos/operations-and-unit-economics/build-an-inventory-timing-model.md)
* [Stock ticker fundamentals: What It Does](/help/stock-ticker-fundamentals/what-it-does-fundamentals-only.md)
* [Scenario Toggle Behaviour](/syntax/scenario-syntax/scenario-toggle-behaviour.md)