How to track fund and series structures without spreadsheets.
To stop tracking funds and series in spreadsheets, model the structure as related records instead of tabs: funds contain series, series hold the underlying holdings, and each investor's commitment links that investor to a specific series. Ownership, unfunded commitment, distributions, and performance are then calculated from those links rather than typed in.
Once the structure lives in one model, the same data can feed an investor portal, a representative's client book, and the administrator's reporting without anyone rebuilding the numbers in a separate workbook.
Why the spreadsheet version breaks
A series is not a row
A fund with several series, each with its own holdings and its own investors, does not fit a flat table. Spreadsheets end up with one tab per series, and totals depend on formulas that reach across tabs.
Ownership gets typed, not calculated
When an investor's ownership percentage is entered by hand, every new commitment, transfer, or correction means updating it everywhere it appears. One missed cell and two reports disagree.
Every audience needs a different cut
Investors should see only their own positions, representatives only their assigned clients, and administrators everything. In a spreadsheet each of those becomes another copy of the data to keep in sync.
Corrections leave no trail
When a commitment amount changes, a spreadsheet shows the new number and nothing about the old one. The next question about why a total moved has no answer.
Moving the structure into one model
- 1
Define funds, series, and holdings as separate records
Each fund has its series, and each series links to the holdings it owns. Corporate actions, distributions, and converted or exited holdings attach to the holding, not to a note in a cell.
- 2
Link investors to series through commitments
A commitment record connects one investor to one series with a committed amount and an invested amount. This is the join that makes everything else calculable.
- 3
Calculate ownership and performance from the links
Ownership percentage, unfunded commitment, total distributions, current portfolio value, net gain, and multiples like MOIC, DPI, RVPI, and TVPI come from the commitment and holding records. XIRR needs the dated cash flows, so keep contributions and distributions as dated transactions, not monthly totals.
- 4
Recalculate totals when an investment changes
Series investor counts and fund totals should update when an investment is added or corrected, instead of waiting for someone to refresh a summary tab.
- 5
Scope access to the relationship
Match each investor login to its investor record, and each representative to their assigned clients. Enforce that at the data layer so every view reads from the same numbers without exposing the wrong ones.
- 6
Keep old and new values on every change
Record who changed a commitment, holding, or investor detail, and what it was before. Month-end questions become lookups instead of investigations.
What to look for in software
- A real fund > series > holding hierarchy, not a generic account table
- Commitments that link investors to series, with committed, invested, and unfunded amounts
- Ownership and performance calculated from the data, including XIRR from dated cash flows
- Separate investor, representative, and administrator views over one data model
- Documents tagged to the investor, investment, fund, and series they belong to
- Bulk import for onboarding existing investors and investments
- Audit history with old and new values, plus correction workflows
How TidalCap One handles it
TidalCap One is built on this model. Funds contain series, series connect to holdings, and investor commitments connect clients to series. Ownership, commitments, unfunded commitment, distributions, portfolio value, MOIC, DPI, RVPI, TVPI, and XIRR are calculated from those records.
From the same data, investors get a self-service portal, representatives get a client book scoped to their assignments, and administrators get bulk imports, reporting, and correction workflows. It is in production at a firm administering $300M+ in private equity AUM across 15 funds, 60+ series, and 400+ LP investors.
Common questions
What is the difference between a fund and a series?
A fund is the overall vehicle. A series is a segment within it, often tied to a specific holding or offering, with its own investors and its own capital. Tracking them as separate linked records is what lets each series report ownership and performance on its own.
How is investor ownership calculated in a series?
Ownership is the investor's invested amount relative to the total invested in that series. When commitments are linked records, ownership updates automatically whenever an investment is added or corrected.
Can we import our existing spreadsheets?
Yes. TidalCap One supports bulk client invitations and bulk investment imports, so existing investors and positions can be loaded from spreadsheets instead of entered one record at a time.
Which performance metrics can be calculated per investor?
TidalCap One calculates invested amount, ownership percentage, committed amount, unfunded commitment, total distributions, current portfolio value, net gain, MOIC, DPI, RVPI, and TVPI per investor, with XIRR computed from irregular cash flows and terminal NAV.
See your fund structure in TidalCap One.
Walk through your funds, series, holdings, commitments, and the reports your team rebuilds every quarter.