Templates · Investing
Free Investment Portfolio Tracker Template
See all your investments in one place — stocks, bonds, ETFs, mutual funds, the works. Track your cost basis, see how much you have gained or lost, check your asset allocation, and keep tabs on dividend income.
- Investing
- Tracker
- Free template
What's included
This tracker includes 4 sections covering everything you need.
Holdings
All your current investments with what you paid and what they are worth now.
| Symbol | Name | Asset Class | Shares | Avg Cost | Current Price | Market Value | Gain/Loss | Gain/Loss % |
|---|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
Asset Allocation
How your money is spread across asset classes — and whether that matches your targets.
| Asset Class | Target % | Actual % | Difference | Market Value | Action Needed |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Transaction Log
A running record of every buy, sell, and dividend reinvestment.
| Date | Symbol | Action | Shares | Price | Fees | Total | Account |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Performance Summary
How your whole portfolio has performed over different time periods.
| Period | Starting Value | Ending Value | Contributions | Return | Return % |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
Enter all your current holdings — the number of shares and your average cost per share.
- 2
Set your target asset allocation based on your risk tolerance and how far off retirement is.
- 3
Update prices weekly or monthly (or let Clarity handle it automatically).
- 4
Log every buy, sell, and dividend reinvestment in the transaction log.
- 5
Check your asset allocation quarterly. If anything has drifted more than 5% from target, rebalance.
- 6
Track performance over time to make sure you are on pace for your long-term goals.
Who this template is for
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.
Why use Clarity instead?
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.
- Automatic transaction imports from 12,000+ institutions
- Real-time portfolio values and net worth tracking
- AI-powered spending insights and budget recommendations
- Tax-ready reports with automatic cost basis calculations
- One dashboard for banks, brokerages, crypto, and DeFi
Frequently Asked Questions
How do I calculate my average cost basis?
Add up everything you spent buying a security (including reinvested dividends), then divide by the total shares you own. For example, 10 shares at $50 plus 10 at $60 gives you an average cost of $55 per share.
How often should I update my portfolio tracker?
Once a month is plenty for most people. Checking too frequently leads to emotional decisions. Always update before you buy, sell, or rebalance. Clarity syncs prices daily if you want it hands-free.
Should I track retirement accounts and taxable accounts separately?
Yes — taxes work very differently between account types. Track them separately, but look at the combined total when thinking about asset allocation. Pro tip: hold tax-inefficient stuff (bonds, REITs) in your tax-advantaged accounts.
Related templates
Other templates you might find useful.
Stock Portfolio Spreadsheet
A stock tracker for people who pick their own companies. Get detailed per-position tracking, sector allocation breakdowns, and realized vs. unrealized gain calculations — all the way down to lot-level detail.
InvestingDividend Income Tracker
Keep track of every dividend you earn across all your holdings. Monitor your yield, payment dates, ex-dividend dates, and projected annual income. Also tracks DRIP reinvestments and year-over-year income growth.
InvestingPortfolio Rebalancing Worksheet
Figure out exactly what to buy and sell to get your portfolio back on target. This worksheet shows the drift in each asset class and suggests trades, including tax-efficient options so you keep more of your gains.
Net WorthNet Worth Tracker
Find out what you are actually worth financially. List everything you own (bank accounts, investments, property, crypto) and everything you owe (mortgages, student loans, credit cards), then watch your net worth change month over month.
Ready to go beyond spreadsheets?
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.