Template · Finance
Investment portfolio tracker
Holdings, cost basis, allocation against target weights, rebalancing amounts and dividend income.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Investment portfolio tracker | |||||||||||
| Example data — replace the blue input cells with your own. | |||||||||||
| Prices as of | Oct 1, 2026 | Date of the prices typed in column H (example prices, for illustration only) | |||||||||
| Rebalance band (± drift) | 3.0% | Holdings closer to target than this show Hold | |||||||||
| Tickers ending in -EX and all prices are fictional examples, not market quotes. | |||||||||||
| Ticker | Name | Asset class | Account | Shares | Average cost per share | Cost basis | Current price | Market value | Unrealized gain/loss | Gain % | Weight |
| USTK-EX | Example US Total Market Index Fund | US stocks | Taxable brokerage | 210.50 | $198.40 | $41,763.20 | $251.30 | $52,898.65 | 11,135.45 | 26.7% | 25.2% |
| USLC-EX | Example US Large-Cap Growth Fund | US stocks | Roth IRA | 85.00 | $312.75 | $26,583.75 | $356.10 | $30,268.50 | 3,684.75 | 13.9% | 14.4% |
| USSV-EX | Example US Small-Cap Value Fund | US stocks | 401(k) | 140.00 | $88.20 | $12,348.00 | $84.65 | $11,851.00 | -497.00 | -4.0% | 5.7% |
| INTL-EX | Example Developed Markets Index Fund | International stocks | Taxable brokerage | 420.00 | $47.90 | $20,118.00 | $52.35 | $21,987.00 | 1,869.00 | 9.3% | 10.5% |
| EMKT-EX | Example Emerging Markets Fund | International stocks | Roth IRA | 260.00 | $41.10 | $10,686.00 | $39.80 | $10,348.00 | -338.00 | -3.2% | 4.9% |
| BOND-EX | Example Total Bond Market Fund | Bonds | 401(k) | 610.00 | $74.60 | $45,506.00 | $72.15 | $44,011.50 | -1,494.50 | -3.3% | 21.0% |
| TIPS-EX | Example Inflation-Protected Bond Fund | Bonds | 401(k) | 180.00 | $51.25 | $9,225.00 | $50.90 | $9,162.00 | -63.00 | -0.7% | 4.4% |
| MUNI-EX | Example Municipal Bond Fund | Bonds | Taxable brokerage | 150.00 | $103.40 | $15,510.00 | $104.10 | $15,615.00 | 105.00 | 0.7% | 7.4% |
| REIT-EX | Example Real Estate Index Fund | Real estate | Roth IRA | 95.00 | $86.30 | $8,198.50 | $91.75 | $8,716.25 | 517.75 | 6.3% | 4.2% |
Showing the first 16 of 30 rows and 12 of 16 columns. Cells with formulas show the formula on hover.
| Allocation by asset class and account | ||||||||
| Current mix compared with your targets. Names must match the Asset class and Account columns on the Holdings tab. | ||||||||
| Asset class | Market value | Current weight | Target weight | Drift | Rebalance amount (+ buy / − sell) | Cost basis | Unrealized gain/loss | Holdings |
| US stocks | $95,018.15 | 45.3% | 45.0% | 0.3% | -672.10 | $80,694.95 | 14,323.20 | 3 |
| International stocks | $32,335.00 | 15.4% | 20.0% | -4.6% | 9,596.58 | $30,804.00 | 1,531.00 | 2 |
| Bonds | $68,788.50 | 32.8% | 25.0% | 7.8% | -16,374.03 | $70,241.00 | -1,452.50 | 3 |
| Real estate | $8,716.25 | 4.2% | 5.0% | -0.8% | 1,766.65 | $8,198.50 | 517.75 | 1 |
| Commodities | $0.00 | 0.0% | 0.0% | 0.0% | 0.00 | $0.00 | 0.00 | 0 |
| Cash | $4,800.00 | 2.3% | 5.0% | -2.7% | 5,682.90 | $4,800.00 | 0.00 | 1 |
| Total | $209,657.90 | 100.0% | 100.0% | 0.00 | $194,738.45 | 14,919.45 | 10 | |
| Not matched to an asset class above | $0.00 | OK | ||||||
| Account | Market value | Weight | Cost basis | Unrealized gain/loss | Holdings | |||
| Taxable brokerage | $95,300.65 | 45.5% | $82,191.20 | 13,109.45 | 4 | |||
| Roth IRA | $49,332.75 | 23.5% | $45,468.25 | 3,864.50 | 3 |
Showing the first 16 of 20 rows and 9 of 9 columns. Cells with formulas show the formula on hover.
| Dividend and interest income | |||||||||||
| Log each payment as it arrives. Income and yields are calculated for the period you set below (example payments are fictional). | |||||||||||
| Period start | Oct 1, 2025 | Income in period | $4,910.15 | ||||||||
| Period end | Sep 30, 2026 | Yield on cost (portfolio) | 2.52% | ||||||||
| Current yield (portfolio) | 2.34% | ||||||||||
| A 12-month period gives annual income; yields compare that income with cost basis and market value on the Holdings tab. | |||||||||||
| Date | Ticker | Holding | Account | Amount | Reinvested? | Ticker | Income in period | Cost basis | Yield on cost | Market value | |
| Dec 18, 2025 | EMKT-EX | Example Emerging Markets Fund | Roth IRA | $70.26 | Yes | USTK-EX | $689.40 | $41,763.20 | 1.65% | $52,898.65 | |
| Dec 18, 2025 | INTL-EX | Example Developed Markets Index Fund | Taxable brokerage | $159.96 | No | USLC-EX | $182.06 | $26,583.75 | 0.68% | $30,268.50 | |
| Dec 18, 2025 | REIT-EX | Example Real Estate Index Fund | Roth IRA | $80.32 | Yes | USSV-EX | $225.73 | $12,348.00 | 1.83% | $11,851.00 | |
| Dec 18, 2025 | USLC-EX | Example US Large-Cap Growth Fund | Roth IRA | $44.04 | Yes | INTL-EX | $661.26 | $20,118.00 | 3.29% | $21,987.00 | |
| Dec 18, 2025 | USSV-EX | Example US Small-Cap Value Fund | 401(k) | $54.60 | Yes | EMKT-EX | $290.47 | $10,686.00 | 2.72% | $10,348.00 | |
| Dec 18, 2025 | USTK-EX | Example US Total Market Index Fund | Taxable brokerage | $166.76 | No | BOND-EX | $1,588.37 | $45,506.00 | 3.49% | $44,011.50 |
Showing the first 16 of 71 rows and 12 of 14 columns. Cells with formulas show the formula on hover.
| Investment portfolio tracker |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Tracks a portfolio of funds or stocks across several accounts: cost basis, market value, unrealized gains, allocation against target weights, the trades needed to rebalance, and dividend income with yield on cost. |
| How to use it |
| 1. On the Holdings tab, replace the example rows with your holdings: ticker, name, asset class, account, shares and average cost per share. |
| 2. Type the current price of each holding in column H and the date of those prices at the top. Prices are not fetched automatically. |
| 3. Enter a target weight for each holding so the targets add up to 100%, and set the rebalance band. |
| 4. Review drift and the rebalance amount per holding, and by asset class on the Allocation tab. |
| 5. Log dividend and interest payments on the Dividends tab and set the period start and end dates. |
| Formulas and method |
| Cost basis = shares × average cost. Market value = shares × current price. Unrealized gain/loss = market value − cost basis; gain % = gain ÷ cost basis. |
| Weight = market value ÷ total market value. Drift = weight − target weight. |
Showing the first 16 of 32 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
About this template
This tracker keeps a portfolio in one place. Each holding has its shares, average cost, current price, market value and unrealized gain, plus its weight in the portfolio. Target weights show how far each holding has drifted, and the rebalance amount shows the buy or sell needed to return to target. A rebalance band keeps small drifts marked as Hold.
The Allocation tab adds up holdings by asset class and by account with SUMIF, and it checks that every holding is counted. The Dividends tab logs income by date and ticker, then calculates the income for a chosen period, plus yield on cost and current yield for each holding.
Prices are typed in rather than fetched, so update the price column and the price date before you read the results. The tickers and prices in the example are fictional and labeled as examples. They are not market quotes.
What’s inside
- Cost basis, market value and unrealized gain for each holding
- Weight, target weight and drift, with a rebalance amount and a Buy, Sell or Hold action
- Allocation by asset class and by account, totaled with SUMIF
- Dividend and interest log with income for a period, yield on cost and current yield
- Example tickers end in -EX and are fictional
Tabs
| Tab | What it holds |
|---|---|
| Holdings | Ticker, shares, cost, current price, market value, gains, weights, drift and rebalance action. |
| Allocation | Market value, weight and target by asset class and by account, with check rows. |
| Dividends | Log of dividend and interest payments, income by period, yield on cost and current yield. |
| Notes | Purpose, steps, formulas used, assumptions and limits. |
How to use it
- On the Holdings tab, replace the example rows with your holdings: ticker, name, asset class, account, shares and average cost.
- Type the current price of each holding and the date of those prices at the top of the tab.
- Set a target weight for each holding so the targets add up to 100%, and choose the rebalance band.
- Review drift and the rebalance amounts, then check the totals on the Allocation tab.
- Log dividends and interest on the Dividends tab and set the period start and end dates.
Good for
- Checking how far a portfolio has drifted from its targets
- Tracking unrealized gains across taxable and retirement accounts
- Measuring dividend income and yield on cost for a year
- Preparing a rebalancing list before placing trades
Questions about this sheet
Does the tracker download prices?
No. Prices are manual inputs. Type each price and its date on the Holdings tab, and the rest of the sheet recalculates from those prices.
How is the rebalance amount calculated?
It is the target weight times total market value, minus the current market value. A positive amount is a buy and a negative amount is a sell. Holdings inside the rebalance band show Hold.
Does it track tax lots or wash sales?
No. Each holding uses one average cost per share, and gains are shown before tax and fees.
How many holdings and payments can it hold?
Up to 20 holdings and 60 dividend entries. Insert rows inside a table to add more, and the totals expand with them.