Multi-Member Fund Portfolio Management Tool in Excel

 If you are trying to track investing activity of a fund (personal or otherwise) over time, this tool will assist you. The Excel spreadsheet below can handle up to 20 members with lots of positions. Investment management software is very expensive for a reason and this template was made to give a workaround for smaller funds or even individuals that want to accurately track holdings activities and the profits generated.


$75.00 USD

The template will be immediately available for download after purchase. This template is also included in the joint venture and industry-specific template bundles.

If you want a tracking sheet where profits / distributions are manually defined rather than based on buying/selling stock (i.e. for real estate funds or the like), check out this preferred return fund tracking spreadsheet.

Here are some of the features of this fund management tool:

  • Long only positions
  • Built for positions that last more than 1 month (not for day trading)
  • Is able to account for dividends
  • Track activity for up to 50 separate assets
  • Space for up to 20 members (expandable without too much work)
  • Tracks up to a period of 20 years by month and year
  • Client Summary tab
  • Displays IRR of investors (monthly and annual basis)
  • Allows for a management fee
  • Allows for preferred return (hard or soft) with IRR hurdles (based on monthly IRR basis)
The user will go in and enter their members, the dates of deposit / withdrawals, and then start entering position activity in a database-like tab. All entries and exits are tracked on the same tab. There is a unique features in this template that is used to accurately capture profit/losses on each sale. 

This is the idea of a bundle and all it means is the cost basis is by the bundle. You can start building a position and cost average your way in. Once you start to sell the position, you can't re-buy more of the asset in the same bundle, you would move to the next bundle. Every buy or sell execution allows the user to define the bundle (up to 40 per asset) and there is an inventory tab that shows the current balance of units in each bundle for each asset to make it easier to figure out how much you can sell. This was done to accurately track a cost basis when there is multiple buy/sell activity over time.

Overview visuals include total fund holdings value over time and a second chart that shows holdings value by asset type over time. There is also a cumulative profit distribution chart that is client specific and shows deposits/withdrawals, profits/cumulative profits on a monthly basis.

There are monthly summaries by client and by month and year for all profit distributions and cumulative cash flows based on distributions after fees.

The user will be entering the month-end price of each asset manually over time in order to accurately track the holdings value.

Investor Distributions

Based on the defined deposits and withdrawals of each client, the net percentage share of available distributions will populate for each client in each month. Profit distributions to the investor pool will then be split accordingly on a pro rata basis.

Building a general fund tracking software tool is really hard, but I believe what is created here is the best shot at doing it in Excel.

I usually always decline consulting jobs that want to build something like this because it is always so complicated. However, I think with the bundle feature and long-only nature, this is the best thing I can come up with to track such activity.

Please watch the video to really understand hot it works and get the best possible use out of this logic.

If you wanted to, you can use this as an individual investor to track your own positions and performance over time.