Private Equity Holdings Database

I’m a private equity analyst managing an Excel file for an Investment Office holdings within a family office structure.

I need help or tips on how to structure the excel file on how I am going to add, update and generate reports on this asset class.

Currently, each row represents a holding (either a direct company investment or a fund), and includes the following fields:

1. Holding name (company or fund) 2. ID (we use this to identify internal LP allocations within the family office) 3. Commitment 4. NAV 5. Investment type (Direct, Fund, etc.) 6. Strategy (Buyout, Growth, etc.) 7. Stage (Early, Late, Pre-IPO, etc.) 

And others…

In addition to maintaining a current snapshot of the portfolio, I need to track updates over multiple years, including:

• Capital calls • Distributions • NAV changes • Changes in exposure or reclassifications 

My goal is to structure the Excel file in a way that cleanly separates the current portfolio view from historical activity, while keeping it scalable and easy to audit over time.

How would you structure this workbook?

• What additional columns would you include in the holdings tab? • Would you separate transactions (capital calls, distributions, revaluations) into a different tab? • How would you design it to allow both a live snapshot and a full historical trail? 

Any suggestions on architecture, tab structure, or best practices for long-term portfolio management in Excel would be appreciated.