SmartHelping / Fund Management / Excel
Multi-Member Fund Portfolio Management Tool
Track long-only investment activity, member capital, holdings values, and profit distributions in Excel. Manage up to 20 members and 50 assets, with monthly and annual reporting across as many as 20 years.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See how the fund tracker works.
Watch the walkthrough before entering transactions, particularly the cost-basis bundle process used to track purchases and sales.
Where this tool fits
Built for long-only portfolios held over time.
Small funds and individual investors
Track investment activity for a multi-member fund or use the workbook to follow your own positions and performance.
Positions lasting more than one month
The template is designed for long-only positions held for more than a month. It is not designed for day trading.
Core tracking features
Keep member activity and asset transactions organized.
Up to 20 members
Enter members and their deposit and withdrawal dates. The standard layout includes 20 member slots and can be expanded.
Up to 50 separate assets
Track purchases, sales, and holdings activity across as many as 50 assets.
A single transaction entry tab
Record position entries and exits in the same database-style tab, assigning a cost-basis bundle to each execution.
Dividend tracking
Account for dividends alongside the portfolio’s investment activity.
Monthly and annual reporting
Follow activity over a period of up to 20 years with month-by-month and annual summaries.
Manual month-end prices
Enter each asset’s month-end price over time to update the reported value of the holdings.
How transaction cost basis works
Use cost-basis bundles to organize purchases and sales.
The bundle workflow is central to how this template captures profit and loss on sales when an asset has multiple purchases and sales over time.
Build a position within a bundle
Group purchases into a bundle while building or averaging into a position. Cost basis is tracked at the bundle level.
Start a new bundle after selling begins
Once you begin selling from a bundle, any subsequent purchases of that asset must go into a new bundle.
Up to 40 bundles per asset
Assign the relevant bundle to each buy or sell execution. The template supports up to 40 bundles for each asset.
Check the remaining units
Use the inventory tab to see the current unit balance by asset and bundle before recording a sale.
Member capital, fees & returns
Connect member capital to available distributions.
Monthly member allocation
Each member’s deposits and withdrawals determine their net percentage share of available distributions for the month.
Pro rata investor distributions
Profit distributions assigned to the investor pool are split among the members according to those monthly shares.
Management fee
Include a management fee in the fund’s distribution calculations.
Preferred return and IRR hurdles
Configure a hard or soft preferred return with IRR hurdles based on monthly IRR.
Summaries & visualizations
Review the fund and each member’s results.
Client Summary tab
Review member-level results and investor IRR on a monthly and annual basis.
Distributions and cumulative cash flows
Follow profit distributions and cumulative cash flows after fees in the client, monthly, and annual summaries.
Fund holdings value
Use charts showing total fund holdings value over time and holdings value by asset type.
Client-specific charts
Review member deposits, withdrawals, profits, and cumulative profits in the monthly client-specific reporting.
Getting started
Build a repeatable monthly tracking process.
Set up the members and fund terms
Enter the members, deposit and withdrawal activity, management fee, and preferred-return assumptions.
Record investment activity
Enter purchases, sales, and dividends. Assign each buy or sell to the appropriate asset and cost-basis bundle.
Maintain prices and bundle balances
Update month-end asset prices and review the inventory tab. Use a new bundle for additional purchases after sales begin in an existing bundle.
Review holdings and member performance
Inspect fund values, client summaries, distribution allocations, investor IRR, and cumulative cash flows.
Choose the right tracking tool
Need to enter fund profits and distributions directly?
This portfolio tool calculates activity around asset purchases and sales. The alternative below is designed for a different input workflow.
More templates in one purchase
Explore the bundles that include this tool.
Joint Venture Templates Bundle
Explore cash-flow waterfalls, preferred returns, and fund tracking templates.
Explore the templateIndustry-Specific Templates Bundle
Explore financial models and tools across a broad range of business types.
Explore the templateSuper Smart Bundle
Explore the complete public SmartHelping financial model collection.
Explore the templateAdditional resources
Explore additional SmartHelping tools.
Questions before you start
A few useful details.
How many members and assets can I track?
The standard template supports up to 20 members and 50 separate assets, with up to 40 cost-basis bundles per asset. The member section can be expanded.
What is the tracking period?
The workbook tracks up to 20 years of activity with monthly and annual reporting.
Can I use this for day trading or short positions?
No. It is designed for long-only positions held for more than one month.
What happens if I buy more after starting to sell a position?
Record the new purchases in a new bundle. Once selling begins in a bundle, do not add more purchases to that same bundle.
Does it fetch asset prices automatically?
No. You enter the month-end price of each asset manually to maintain the holdings valuation.
Does it account for dividends and fees?
Yes. It supports dividends and a management fee, as well as hard or soft preferred returns with IRR hurdles based on monthly IRR.
How are member distributions allocated?
Deposits and withdrawals establish each member’s monthly net percentage share. Distributions to the investor pool are allocated pro rata using those shares.
Can I use it for my personal portfolio?
Yes. An individual investor can use the tool to track positions and performance over time.
Which tool should I use if I enter profits manually?
See the Preferred Return Fund Tracker linked above. It is designed for manually defined profits and distributions rather than the stock purchase-and-sale workflow used here.
How is the template delivered?
The $75 one-time purchase provides an immediate Excel download. It is also included in the bundles listed above.
Fund portfolio tracking
Connect investment activity with member-level results.
Multi-Member Fund Portfolio Management Tool — $75, one-time purchase.
