### Carta Investors Plugin

The **Carta Investors** plugin gives LLMs access to your fund's data and allows you to generate tear sheets, budgets, and financial statements. Access NAV, fund performance, partner data, journal entries, portfolio company financials, build Excel budgets and consolidating P&L / balance sheets, and generate professional PDFs for investor reporting — all with natural language.

---

## What You Can Do

With the Carta Investors plugin, ask questions like:

- **Fund Performance**
  - "What's the current NAV and TVPI for Fund I?"
  - "Show me NAV trends for the past 3 years"
  - "How does Fund II compare to Carta benchmarks?"
  - "What's the gross IRR vs. net IRR for Fund I as of Q4?"
  - "What's the average MOIC by vintage year?"
- **Partner & Investor Data**
  - "Show me contributions and distributions by LP type"
  - "What's the largest LP's capital account balance?"
  - "List all unfunded commitments"
  - "How much has each LP contributed to date?"
- **Portfolio Company Financials & Tearsheets**
  - "Show me revenue and EBITDA for [company] over time"
  - "What's the current equity value for each portfolio company?"
  - "Generate a tear sheet for [company]"
  - "Compare portfolio companies by revenue growth"
- **Custom Data Analysis & Reporting**
  - "What's the total invested capital by portfolio company over the past 5 years?"
  - "Show me NAV waterfall: cash, investments, other assets, and liabilities for Q4 2024"
  - "Pull our Form ADV Schedule D data for 2025"
  - "Generate fundraising materials based on our latest fund and portfolio performance"
  - "What's the AUM rollup by entity type?"
- **Budgeting & Financial Statements (Excel)**
  - "Build a 2026 budget for Delta-v Capital from last year's actuals"
  - "Refresh the actuals on this budget and flag where we're pacing off-plan"
  - "Model a 10% headcount trim scenario on our ManCo budget"
  - "Generate a consolidating P&L for Krakatoa Ventures for March"
  - "Generate a consolidating balance sheet across all our entities for Q4"

---

## How It Works

Beyond the core skills, Claude can query all your fund and company data. See the [data dictionary](https://docs.carta.com/carta/docs/data-dictionary) for the complete list of tables and fields available.

The plugin gives Claude access to:

1. **Fund metrics** — NAV, TVPI, DPI, IRR, and performance data
2. **Partner data** — Contributions, distributions, capital accounts, and investor information
3. **Portfolio financials** — Company-level revenue, EBITDA, valuations, and multiples
4. **Tearsheet generation** — Automatic PDF creation for portfolio company profiles
5. **Regulatory data** — Form ADV Part 1A / Schedule D, AUM rollups, and audit support
6. **Budgeting & financial statements** — Excel budgets, budget-vs-actuals pacing, what-if scenarios, and consolidating P&L / balance sheets across entities

All data queries are **read-only** — Claude can query and analyze your data but cannot create, modify, or delete records. The budgeting and financial-statement skills produce Excel workbooks locally (or in the open Claude for Excel workbook); they do not write back to Carta.

---

## Available Skills

The plugin includes the following skills that Claude uses to answer your questions:

**Reporting & data**
| Skill | What It Does |
| --- | --- |
| **explore-data** | Query and explore unlimited fund admin data via custom SQL. Claude can browse all available tables, write SELECT queries, and build reports—NAV, partners, investments, journal entries, portfolio financials, and more. Perfect for custom analysis, KPI tracking, and ad-hoc questions. |
| **form-adv** | Fetch Form ADV Part 1A filing data and generate an interactive HTML filing guide plus an Excel filing reference (Items 5.D/F/H, Schedule D §7.B.(1), beneficial owners, asset composition, capital activity). |
| **performance-benchmarks** | Compare fund performance against peer benchmark cohorts. Shows TVPI, IRR, DPI and percentile rankings vs. comparable funds. |
| **download-tearsheet** | Download tear sheets for one or more portfolio companies and funds. Single PDF preview or bulk ZIP download. |

**Budgeting & financial statements (Excel)**
These skills produce accountant-ready Excel workbooks. In Claude for Excel the output lands in the open workbook; in Claude Code it lands in a local `.xlsx` file.

| Skill | What It Does |
| --- | --- |
| **create-budget** | Build a new fund or ManCo budget workbook from Carta prior-year actuals (from prior actuals, a template, a recommendation, or sliced by tag). |
| **fetch-budget** | Pull a ManCo budget already stored in Carta and write it to an Excel workbook with monthly amounts and subtotals. |
| **budget-actuals** | Refresh actuals on an existing budget workbook — interleave Budget/Actual/Variance, separate Actuals tab, refresh in place, or extend by a period. |
| **budget-vs-actuals** | Compare YTD actuals against a budget and analyze pacing — % consumed, run-rate projection, and off-plan flags. Supports chat-only output. |
| **budget-scenarios** | Model what-if scenarios on an existing budget — trim (headcount, revenue shocks, cost rebalance) and growth (new raises, expansion hires). |
| **consolidating-pnl** | Generate a firm-wide consolidating P&L across all entities for a month — detailed tab plus a one-page executive Summary P&L; optional tag-view by department/cost center/project. |
| **consolidating-balance-sheet** | Generate a consolidating Balance Sheet across all entities for a month — side-by-side layout with Assets / Liabilities / Equity sections. |

## Form ADV

Fetches Form ADV Schedule D regulatory data and a firm-level rollup for annual filing prep. Works for any firm with Carta fund admin data.

### How to Trigger

Ask Claude anything like:

- "Pull our Form ADV data for 2025"
- "What's our regulatory AUM as of December 2024?"
- "Show me Schedule D data for last year's filing"
- "What do I need for Form PF Section 1?"
- "What's our total AUM across all funds?"

### What You Need to Provide

Just one thing: a **reporting date** (e.g. `2025-12-31`). The skill will ask if you don't include it.

### What It Returns

An interactive HTML filing guide and an Excel filing reference. Data is returned per fund/SPV, plus a firm-level rollup across all entities.

---

### Limitations

- Point-in-time only — no historical comparison across periods
- Covers Fund and SPV entities only (excludes GP/management company entities)

---

## Authentication

On first use, Claude will open a browser window asking you to log in with your Carta credentials. This is a one-time OAuth authorization:

1. You log in with your Carta username and password
2. Carta issues a secure access token
3. Claude uses that token for all subsequent queries
4. Your credentials are not stored by Claude — only the access token is used

If you log out or the token expires, Claude will prompt you to re-authenticate.

---

## Permissions & Data Access

Claude can access fund admin data that your Carta user account has permission to view. This typically includes:

- Your firm's funds and entities
- Fund financial records and NAV
- Partner and investor data for your funds
- Portfolio company information
- Journal entries and accounting records

**Data is scoped to your firm** — you cannot access other firms' data.

---

## Example Queries

### Fund Performance
```undefined
Show me NAV and TVPI for all my funds as of the most recent quarter.
```
Claude will return a summary table with current metrics for each fund.

```undefined
What's the 5-year NAV trend for Fund I?
```
Claude will query historical NAV records and show how the fund's value has changed.

### Partner Data
```undefined
List all LPs in Fund II and their total contributions to date.
```
Claude will show each LP, shares/units held, capital account balance, and total contributions.

```undefined
What are the unfunded commitments for Fund III?
```
Claude will calculate remaining unfunded amounts for each LP.

### Portfolio Analysis
```undefined
What's the portfolio composition by stage? Show count and total invested capital.
```
Claude will group portfolio companies by current financing stage and show investments.

```undefined
Compare portfolio company revenue growth: which are growing fastest?
```
Claude will analyze financial metrics and show growth trends.

```undefined
What's the total invested capital by portfolio company over the past 5 years?
```
Claude will compile historical investment data to analyze trends.

```undefined
Show me NAV waterfall: cash, investments, other assets, and liabilities for Q4 2024
```
Claude will construct a detailed NAV breakdown by asset category.

### Tearsheet Generation
```undefined
Generate a tearsheet for Acme Inc
```
Claude will create a PDF with company profile, financial metrics, ownership, and valuations.

```undefined
Generate tearsheets for all portfolio companies and download as ZIP
```
Claude will create a batch job. You can check status and download when ready.

### Regulatory Reporting & Performance Benchmarking
```undefined
Pull our Form ADV Schedule D data for 2025
```
Claude will fetch AUM by fund and entity type, firm rollup for regulatory reporting, asset composition data, and portfolio company classifications — all ready for Form ADV and Form PF filings.

```undefined
How does Fund II compare to mid-market funds in our vintage year?
```
Claude will show TVPI, DPI, IRR vs. peer cohort, your percentile ranking, distribution of peer performance, and recommendations based on peer comparison.

---

## Limitations & Considerations

- **Read-only access** — Claude cannot create, modify, or delete records or tables
- **Data freshness** — Investors data is as current as your Carta records; data is typically refreshed daily or in real-time
- **Query performance** — Large queries (e.g., 10 years of daily data for 100+ companies) may take longer
- **Bulk tearsheets** — PDF generation for 50+ companies may take several minutes; you'll get a status link to check progress.

---

## Support & Next Steps

- **Install the plugin:** See the [Getting Started](https://docs.carta.com/api-platform/docs/claude-plugins-setup) guide for installation steps
- **Data questions:** Contact [Carta Support](https://support.carta.com/) for help with data access or fund setup
- **Feedback:** Let us know how we can improve the plugin

For questions about fund accounting, NAV calculations, or financial metrics, ask Claude directly — it's trained to explain these concepts and help interpret your fund's data.

Updated about 2 months ago

---
