Why Portfolio Tracking Breaks for Multi-Fund GPs
Most portfolio tracking tools were designed for single-fund managers. When you run Fund I, Fund II, and a rolling SPV alongside them, the spreadsheet model collapses. Co-investments live in one file, direct investments in another, follow-ons tracked in a third. Getting a clean view of total exposure, MOIC across vintages, or which co-investors you see the most requires weekend work.
The problem compounds at reporting time. Each LP wants a view of their specific vehicle. You pull from three separate files, reformat the columns, recalculate MOIC by hand, and hope the formulas didn't drift since last quarter. One entry in the wrong cell and your aggregate numbers are wrong — and you won't know until an LP asks a question you can't immediately answer.
This isn't a process problem — it's a tooling problem. The tools weren't designed for GPs managing multiple vehicles simultaneously. Meridia was.
The Meridia Portfolio Tracker
Meridia models portfolios as a multi-fund architecture from day one. Every investment is tagged to a vehicle — Fund I, Fund II, SPV-A, or any custom vehicle name — so you can view your portfolio at the total GP level or drill into a single vehicle in one click. There is no consolidation step, no pivot table, no manual aggregation. The rollup is always current.
MOIC, IRR, and unrealized/realized value are computed automatically from your records. You see the number, not the formula — and the formula is auditable if an LP asks. Every metric traces back to a dated cash flow entry, so your numbers are defensible not just presentable.
Meridia is also built alongside Meridia's AI deal sourcing and investment memo generator — so the companies you source and underwrite feed directly into your tracked portfolio without re-entry.
MOIC and IRR Tracking — How It Works
MOIC (Multiple on Invested Capital) is the simplest performance metric: total value (realized proceeds + current unrealized fair market value) divided by total invested capital. A 3.0x MOIC means you have three times what you put in, whether that's cash returned or paper value. Meridia calculates MOIC per position, per fund, and across all vehicles simultaneously.
IRR (Internal Rate of Return) is the time-weighted return, accounting for when cash flows occurred. A €500K investment that returned €2M in 18 months looks very different from the same return over 8 years — IRR captures that difference. Meridia uses the XIRR method, which accounts for exact calendar dates rather than assuming uniform periods, so the number is precise even for irregular follow-on schedules.
If you invested €500K in a company now valued at €3M after a Series B, Meridia shows 6.0x MOIC for that position. If you invested in three tranches over 24 months — €200K at seed, €200K at pre-Series A, €100K at Series A — IRR is computed from each individual cash flow date automatically. No spreadsheet entry required.
Both metrics update whenever you log a new round, a distribution, or a revised FMV mark. There is no manual recalculation step. The numbers are always current.
Multi-Fund Architecture
In Meridia, each investment record carries the fields that matter for multi-vehicle management: fund vehicle, investment date, cost basis, current fair value mark, pro-rata rights status, and follow-on notes. These aren't free-text fields — they're structured, queryable data.
The portfolio dashboard rolls these up into a complete GP-level view:
You can toggle between Fund I, Fund II, SPV-A, or all-funds view in a single click. Each view recalculates every metric in real time — blended MOIC, realized gains, time-weighted IRR, unrealized NAV. No export, no recalculation, no waiting.
Bulk Upload and Data Import
Getting historical data in shouldn't take a week. Meridia accepts data three ways, so you can start with what you already have:
- Excel / CSV bulk upload — Map columns (company, fund, investment date, amount, current valuation) and import. A 50-company portfolio loads in under an hour.
- PDF subscription documents — Subscription agreements and closing docs are parsed automatically, extracting company name, vehicle, amount, and date without manual entry.
- Manual entry — Add individual positions directly. Useful for new investments as they happen.
After the initial import, updates are point entries: a new round, a markdown, a distribution payment. You don't re-import the whole portfolio — you log the event, and every metric recalculates. Stale data is flagged automatically (no update in 12+ months), so you always know which marks need refreshing before an LP report goes out.
Cross-Fund Visibility: What You Actually See
The value of Meridia's portfolio tracker isn't any single metric — it's the views that only exist when all your data lives in one structured model. These are the views multi-fund GPs actually need:
- Sector concentration across all funds — Which verticals dominate your total exposure? Where are you over-indexed across vintages?
- Co-investor frequency — Which other funds appear most in your cap tables, across all vehicles? Build the picture of who you actually work with.
- Follow-on rights expiring this quarter — Pro-rata rights have deadlines. Meridia surfaces positions with rights that expire in the next 90 days before the window closes.
- Stale positions — Any position with no valuation update in 12+ months is flagged automatically. You go into LP reporting knowing exactly which marks are current and which need a founder call.
- Realized vs. unrealized split — See total returned capital vs. paper value at the fund or GP level, with drill-down to individual positions.
These views exist because the data model was designed for them — not retrofitted into a spreadsheet. A spreadsheet can technically show any of these things. But it requires you to maintain the discipline to keep columns consistent, add new rows in the right format, and build the formulas from scratch. Meridia just shows you.
Portfolio Tracker vs. Spreadsheets
Most VC firms still run their portfolio out of Excel. The comparison below is honest about what spreadsheets are genuinely good at (flexibility, familiarity) and where they break for multi-fund GPs at scale.
| Capability | Spreadsheets | Meridia Portfolio Tracker |
|---|---|---|
| Multi-fund support | Manual sheet splitting, no rollup | Native multi-vehicle model, one-click toggle |
| MOIC / IRR calculation | Error-prone formulas, manual XIRR setup | Automatic, audit-ready, updates on every entry |
| Bulk import | CSV paste with manual column matching | Excel / CSV + automatic PDF parsing |
| Follow-on tracking | Manual notes in free-text cells | Structured fields, expiry alerts |
| Cross-fund views | Painful manual consolidation | Real-time rollup, always current |
| Stale position flags | Never — only if you check manually | Automatic 12-month threshold flag |
| LP reporting | Export and reformat every quarter | One-click LP report per vehicle |
LP Reporting
When LP reporting season arrives, the question is never "do we have the data" — it's "how long will it take to format it." For most multi-fund GPs, the answer is days of reformatting, cross-checking, and version management.
Meridia generates portfolio summaries per vehicle directly from your tracked data: invested capital, fair market value, MOIC, realized gains, unrealized NAV, and notable exits for the period. No reformatting. No copying cells between tabs. No formula drift between the working sheet and the LP presentation.
Each LP report is generated at the vehicle level — so Fund I LPs see only Fund I positions, Fund II LPs see only Fund II positions, and you see everything. Reports export in PDF and Excel formats. If an LP asks a follow-up question about a specific position, the underlying data is one click away.
Combined with Meridia's AI investment memo generator, you can take a company from first screen through tracked portfolio position to LP report without switching tools or re-entering data.