What it’s worth. What it pays you. All in one place.
Every holding across your brokerage, IRA and 401(k), with what you paid, what it’s worth now, your gains and every dividend. Plus your estimated yearly income. No macros.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Holding | Value | Gain % | Weight | Income / yr |
|---|---|---|---|---|
| SP500 · S&P 500 Index ETF | $11,969 | +16.3% | 19.3% | $156 |
| DIVGR · Dividend Growth ETF | $11,473 | +11.8% | 18.5% | $377 |
| BOND · Total Bond ETF | $9,412 | +1.1% | 15.2% | $338 |
| TMKT · Total Market ETF | $8,748 | +16.5% | 14.1% | $116 |
| CNSMR · Consumer Goods Co. | $5,555 | +10.1% | 9.0% | $140 |
| TECH1 · Tech Co. | $4,671 | +33.8% | 7.5% | $22 |
Your investments are scattered across apps
Three apps, no big picture
A brokerage, an IRA and a 401(k), each showing a different slice and none showing the whole.
Where are the dividends?
Small payments every quarter, easy to lose track of, and hard to add up for the year.
Is it working?
What did you actually pay, what’s it worth now, and how much is it paying you?
Log it once. See it all.
Add your holdings
Ticker, name, type, account, today’s price and the yearly dividend per share.
Log buys, sells and dividends
Shares, cost and dividends add up for every holding automatically.
Check the dashboard
Value, gain, dividends, estimated yearly income, allocation and a monthly chart.
Every holding: cost, value and gain
Shares and average cost come from your transactions. Type the latest price and see the value, gain, gain %, weight, dividends over the last 12 months and yield on cost.
- Up to 40 holdings
- Stocks, ETFs, bond funds, REITs and cash
- Brokerage, IRA and 401(k) accounts
| Ticker | Shares | Avg cost | Price now | Gain | Dividends (12 mo) | Yield on cost |
|---|---|---|---|---|---|---|
| SP500 | 23 | $447.48 | $520.40 | +$1,677 | $142.80 | 1.5% |
| DIVGR | 130 | $78.92 | $88.25 | +$1,213 | $282.75 | 3.7% |
| BOND | 130 | $71.58 | $72.40 | +$107 | $273.00 | 3.6% |
| REIT1 | 50 | $85.60 | $90.60 | +$250 | $126.00 | 4.2% |
| TECH1 | 22 | $158.67 | $212.30 | +$1,180 | $28.00 | 0.6% |
One log for every trade
Date, account, ticker, shares, price and fees. Buys and sells update your shares and average cost straight away, with room for 1,000 transactions.
- Buy and sell, with fees
- Pick the ticker from a drop-down
- Average cost worked out for you
| Date | Account | Ticker | Buy / Sell | Shares | Price | Total |
|---|---|---|---|---|---|---|
| Jan 12 | Roth IRA | SP500 | Buy | 5 | $470.00 | $2,350.00 |
| Mar 8 | Brokerage | DIVGR | Buy | 40 | $81.00 | $3,240.00 |
| Apr 20 | 401(k) | BOND | Buy | 50 | $72.50 | $3,625.00 |
| Aug 2 | Brokerage | TECH1 | Sell | 8 | $205.00 | $1,640.00 |
| Sep 15 | Brokerage | TMKT | Buy | 8 | $255.00 | $2,040.00 |
Watch your dividend income grow
Log each dividend as it’s paid, reinvested or not. See the last 12 months by month, your estimated yearly income, and how close you are to your dividend goal.
- Dividends by month for the last 12 months
- Estimated yearly income
- Dividend goal with progress bar
For DIY investors
Dividend investors
See every payment, your yearly income and your yield on cost.
Index fund investors
Track your ETFs across your IRA, 401(k) and brokerage in one place.
Anyone with more than one account
One clear picture instead of three apps.
Everything you get
- Holdings list for up to 40 investments
- Shares, average cost, value, gain and gain %
- Weight of each holding in your portfolio
- Transactions log for buys and sells, with fees
- Dividends log with reinvested check
- Dividends over the last 12 months and yield on cost
- Estimated yearly income and a dividend goal
- Dashboard: top holdings, allocation by type and monthly dividends chart
- Works with any broker: nothing to connect
One-off payment. Yours to keep.
Get instant access $9.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This tracker uses the SUMIFS, INDEX and MATCH formulas from my tutorials, so everything adds itself up.
Questions
Are prices updated automatically?
No. Type the latest price on the Holdings tab whenever you check in. Monthly is plenty, and it only takes a couple of minutes.
Does it link to my broker?
No. Nothing is connected to your accounts. You log trades and dividends yourself, from your statements.
Can I use it for taxes?
It tracks your average cost, but for tax reporting use the figures your broker provides.
Is this investment advice?
No. It tracks what you own and doesn’t recommend anything to buy or sell. The example holdings and prices are made up.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
See your whole portfolio, clearly.
Holdings, gains, dividends and income, all in one file.
Get the tracker $9.99Want to see it first? Watch how it works on YouTube.