Track all your investments in one spreadsheet — stocks, bonds, ETFs, mutual funds, and alternatives. Includes cost basis tracking, gain/loss calculations, asset allocation percentages, and dividend income.
This tracker includes 4 sections covering everything you need.
All current investment positions with cost basis and current values.
| Symbol | Name | Asset Class | Shares | Avg Cost | Current Price | Market Value | Gain/Loss | Gain/Loss % |
|---|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
Breakdown by asset class with target vs actual percentages.
| Asset Class | Target % | Actual % | Difference | Market Value | Action Needed |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Record of all buys, sells, and dividend reinvestments.
| Date | Symbol | Action | Shares | Price | Fees | Total | Account |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Portfolio-level returns over various time periods.
| Period | Starting Value | Ending Value | Contributions | Return | Return % |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Follow these steps to get the most out of this template.
Enter all current holdings with the number of shares and your average cost per share.
Set target asset allocation percentages based on your risk tolerance and time horizon.
Update current prices weekly or monthly (or use Clarity for automatic updates).
Log every buy, sell, and dividend reinvestment in the transaction log.
Review the asset allocation section quarterly and rebalance when any class drifts more than 5% from target.
Track performance over time to see if you are meeting your long-term return goals.
Self-directed investors managing their own stock and ETF portfolios.
Anyone with investments spread across multiple brokerage accounts.
Investors who want to track their real cost basis and actual returns.
People transitioning from robo-advisors to self-managed portfolios.
This template is great for manual tracking, but Clarity automates everything for you. Connect your bank accounts, brokerages, exchanges, and wallets and see real-time data without entering a single number.
Add up the total amount you spent on all purchases of a security (including reinvested dividends), then divide by the total number of shares you own. For example, if you bought 10 shares at $50 and 10 at $60, your average cost is $55 per share.
Monthly is sufficient for most investors. Checking too frequently can lead to emotional decisions. However, always update before making buy/sell decisions or rebalancing. Clarity automates this with daily price syncing.
Yes. Tax treatment differs significantly between account types. Track them separately but view the total portfolio together for asset allocation purposes. Consider holding tax-inefficient assets (bonds, REITs) in tax-advantaged accounts.
Other templates you might find useful.
Stock Portfolio Spreadsheet
A focused stock portfolio tracker with detailed per-position tracking, sector allocation, and realized/unrealized gain calculations. Built for active stock pickers who need lot-level detail.
InvestingDividend Income Tracker
Track dividend income across all your holdings. Monitor yield, payment frequency, ex-dividend dates, and annual income projections. Includes DRIP tracking and year-over-year income growth analysis.
InvestingPortfolio Rebalancing Worksheet
Calculate exactly how much to buy or sell in each asset class to bring your portfolio back to target allocation. Includes threshold-based triggers and tax-efficient rebalancing suggestions.
Net WorthNet Worth Tracker
Calculate and track your net worth over time. List all assets (bank accounts, investments, property, crypto) and liabilities (mortgages, student loans, credit cards), then track your net worth month over month to see your financial trajectory.
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.