Investor & LP Reporting (RE/Funds) Agent

Close each reporting period and ship investor letters, LP distribution notices, and draw packages in hours, not days.

Updated Jun 23, 2026

Connects with

Download template

The problem it solves

Each reporting period, fund managers and IR teams lose days pulling numbers from accounting and admin systems, filling in templates, and hand-drafting a separate notice for every limited partner. This agent runs the full cycle for you: it pulls period-end data, drafts the investor letter, computes each LP's distribution or capital call through the waterfall, and routes everything for review, so the fund team approves and releases instead of building each document from scratch.

Who it's for

Fund managers running real estate funds, PE vehicles, or development JVs
Fund CFOs and controllers who own period-close reporting
Investor relations teams reporting to a roster of limited partners
Real estate sponsors managing construction or development draws
Funds with 5-100 LPs on Juniper Square, Yardi, or a spreadsheet model

What it does

1
Pull the period data
At each reporting period the agent pulls P&L, cash position, NAV, and capital accounts from your fund admin or accounting platform, plus asset-level metrics from your property or project system.
2
Draft the fund-level summary
It computes period and year-to-date returns, occupancy, and debt metrics, compares them to underwriting projections, and drafts the investor letter in the fund's voice.
3
Compute per-LP distributions
For each entitled LP it applies the configured waterfall step by step — return of capital, preferred return, then carry split — and shows the full derivation.
4
Draft LP notices
It produces a notice per LP with the distribution amount, payment date, updated capital account balance, and the supporting schedules you specify.
5
Handle capital calls
When a call is authorized, it calculates each LP's pro-rata amount from unfunded commitment, drafts a notice with wire instructions and due date, and flags any LP whose commitment is insufficient.
6
Assemble draw packages
For development assets it pulls the schedule of values, cross-references the approved budget, and builds the full draw package with cover sheet, invoices list, lien waivers, and inspection status.
7
Route for review
It posts a review summary with all flagged items to Slack or email, listing the period-end date, LP count, distribution total, and links to every draft document.
8
Release on approval
Only after an explicit approval signal does it send each notice to LPs, log delivery confirmations, archive the documents, and mark the period as reported.

Key benefits

Compress the time from period-close to LP delivery from days to hours
Every distribution number arrives with its full waterfall derivation shown step by step
Per-LP notices, capital calls, and draw packages are drafted consistently every period
Data anomalies — missing balances, stale feeds, commitment shortfalls — are flagged before they reach an LP
The fund team keeps full control: nothing is released without an explicit approval signal
All sensitive financial data stays inside your connected systems

Sample use cases

A real estate fund closes its Q3 books and owes distributions to 40 LPs

The agent pulls the period data, drafts the investor letter, computes each LP's distribution through the waterfall, and hands the manager a review summary with 40 ready-to-send notices.

The fund authorizes a capital call to fund a new acquisition

The agent calculates each LP's pro-rata amount from unfunded commitment, drafts a notice with wire instructions and due date, and flags two LPs whose remaining commitment is short before anything goes out.

A development asset submits its monthly construction draw

The agent cross-references the schedule of values against the approved budget, assembles the draw package with lien waivers and inspection status, and routes it to the manager and lender while flagging a line item over budget.

An LP's capital account has an unreconciled balance at period end

The agent pauses that LP's notice, flags the discrepancy in the review summary, and continues drafting the rest so one bad feed doesn't hold up the whole package.

Key integrations

Juniper Square
Fund administration platform for LP capital accounts, fund financials, the LP roster, and distribution records.
Yardi
Real estate accounting and fund-admin system for period financials and asset-level data.
Google Sheets / Excel
Spreadsheet-based fund financial model, schedule of values, and waterfall inputs.
Google Drive / SharePoint
Stores investor letter templates, the output folder for drafted documents, and the archive.
Slack
Review summary, approval routing, delivery confirmations, and flagged-item alerts.
Email
Delivers LP notices and routes review packages to the fund manager.

Fund teams in real estate and private equity report to limited partners on a monthly or quarterly cadence, and the work scales with the size of the LP roster — every partner needs an accurate notice tied to the same period close. This agent is built for funds with 5 to 100 LPs that run on Juniper Square, Yardi, or a spreadsheet-based fund model, where the reporting burden is real but the systems are already in place.

The agent draws a firm line between drafting and deciding. It pulls data, runs the waterfall, and assembles every notice and draw package, but it does not approve distributions, send final documents, or touch banking details without an explicit release from the authorized reviewer. It does not provide tax, legal, or investment advice — it gets the package ready so the fund team can review and release on time.

Getting started

Import the workspace into Gamut — Add the Investor & LP Reporting template to your Gamut workspace to get the agent and its skills.
Run the agent-onboarding skill — It interviews you about your fund structure, connected systems, LP roster, waterfall, and output preferences, then writes the configuration.
Give it a first task — Ask it to run the quarter's reporting package — pull the period data, draft the investor letter and LP notices, and send you the review summary.

Frequently asked questions

Does the agent send investor notices or move money on its own?

No. It drafts, computes, and assembles every document, then waits for an explicit approval signal from your authorized reviewer before releasing anything. It never initiates wires or ACH transfers or alters banking details.

Which fund systems does it work with?

It connects to Juniper Square or Yardi for capital accounts and fund financials, a Google Sheets or Excel model for waterfall inputs, Google Drive or SharePoint for templates and archives, and Slack plus email for review routing and LP delivery.

How is this different from building each report manually or using generic tools?

A generic spreadsheet or document tool still leaves you pulling numbers and copying them into one notice per LP. This agent runs the whole cycle — data pull, waterfall math, drafting, and routing — and shows the full derivation behind every distribution so you review rather than build.

Does it calculate the distribution waterfall correctly?

It applies your configured waterfall in order — return of capital, preferred return, then carried interest split — without skipping tiers, and it shows the calculation step by step so you can verify every LP's number before release.

Can it handle capital calls and construction draws as well as distributions?

Yes. It drafts pro-rata capital call notices from each LP's unfunded commitment and assembles full development draw packages with schedule of values, lien waivers, and inspection status, flagging budget overages and commitment shortfalls.

How much does it cost?

The template is free to import into your Gamut workspace; you only pay for the underlying usage and the third-party systems you connect, such as your fund admin platform.