Investment Tracker Spreadsheet: See Your Real Return

There is a particular smile a mate gets when he tells you his investments are up.

It is Ren here, and I got that exact smile across a backyard fence a few weekends ago, tongs in one hand, phone in the other.

"Portfolio is up fifteen percent this year," he said, turning the screen to me like a fishing photo.

I did not have the heart to ask the one question that would have wiped the grin clean off his face.

Up fifteen percent on what?

He had tipped a few thousand dollars of his own money in over those same months, and a balance that climbs because you keep feeding it is not the same as money that actually grew. That gap, between what you put in and what genuinely grew, is the whole reason an investment tracker spreadsheet earns a place next to your budget.

"The individual investor should act consistently as an investor and not as a speculator." — Benjamin Graham

Why a rising balance is not the same as a good return

A rising account balance tells you almost nothing about how well your investments are actually doing.

Most of us open the app, see a bigger number than last month, and quietly feel like a genius. The trouble is that the number grew for two completely different reasons, and only one of them is anything to do with skill.

One reason is growth. The holdings you already owned went up in value.

The other is contribution. You simply added more of your own money.

An investment tracker spreadsheet is the one simple tool that pulls those two apart.

Let me show you with a real run of numbers I worked through. Say you put $600 into an index fund on the first of every month for a year.

By December the balance reads about $7,850, and the instinct is to feel pretty clever about it.

But you contributed $7,200 of that yourself. The part the market genuinely grew is closer to $650, a return of roughly five percent once you allow for the fact that the later contributions were only invested for a month or two.

So the balance is up by what feels like a small fortune, and the genuine investment return is a modest, perfectly respectable five percent. Both things are true at once. Only the sheet shows you which is which.

This matters the moment you try to judge a decision. Did the fund you switched into really do better, or did you just happen to pour more in that quarter? Without cost basis and contributions written down, you are flying on the balance alone, and the balance lies to you in the nicest possible way.

What an investment tracker spreadsheet should include

An investment tracker spreadsheet should include one row per holding and a tight set of columns that turn a balance into a story about return.

Keep it calm and consistent. The value is in logging every buy properly, not in clever formatting.

The columns that matter are the ones that let the sheet separate your money from the market's work, and tell you what a sale would cost you in tax.

That last row catches people out. A holding can drift sideways in price for a year and still have paid you real money in dividends, and if your sheet only watches the price you will swear it did nothing.

🧾 Cost basis: the column that decides your tax

Cost basis is the total you paid for a holding, and it is the single number that decides what you owe the day you sell.

It sounds simple until you have bought the same fund three or four times at different prices, which is exactly what anyone investing a bit each month ends up doing.

Here is how it actually works. Say you buy 100 units at $20, then later another 50 units at $32. Your cost basis is $2,000 plus $1,600, which is $3,600 for 150 units, a blended $24 each.

Now you sell 60 units at $40. The proceeds are $2,400, the cost of those 60 units is $1,440, and your realised gain is $960. That $960 is what tax is calculated on, not the headline price rise, and not the units you kept.

This is the difference between a realised gain and an unrealised one. A realised gain is locked in because you sold, and it is the part the tax office is interested in. An unrealised gain is still riding in a holding you own, and it is not taxed until you actually sell.

Keep those two in separate columns and two good things happen. You can see your real, spendable progress without confusing it with paper gains that could still evaporate, and you walk into tax time already knowing your number instead of trying to reconstruct three years of buys from a broker statement.

How an investment tracker differs from a net worth spreadsheet

An investment tracker measures the return on the money you have invested, while a net worth spreadsheet measures everything you own against everything you owe at a single moment.

They look similar because both list assets and totals, but they answer different questions, and using one for the other job is where people get muddled.

Your net worth sheet wants the current value of the portfolio as one line, sitting alongside your home, your car and your debts. It does not care how that value was built.

Your investment tracker cares about nothing else. It wants the cost basis, the contributions and the gains, because its only job is to tell you whether the investing itself is working.

If you want the whole-picture snapshot, the net worth spreadsheet takes that single portfolio value and sets it against your debts. The tracker is what sits underneath it, explaining how the number got there.

How to set up an investment tracker spreadsheet in an afternoon

You can build a working investment tracker spreadsheet in an afternoon, then keep it alive with about ten minutes a month.

1. List every holding on its own row. Pull up each account and give every fund, share or ETF a single row with its name and ticker, so nothing hides inside a lump sum.
2. Enter the cost basis for each one. Add up what you paid across every buy, including brokerage, and record that total, because this is the anchor every other number leans on.
3. Add a current value column. Put units in one column and today's price in the next, then multiply, so the sheet revalues itself the moment you update a price.
4. Split gains into unrealised and realised. Subtract cost basis from current value for what you hold, and keep a separate line for the profit on anything you have sold.
5. Log contributions and income as you go. Note every dollar you add and every dividend you receive, so you can always tell your own money apart from the market's.
6. Set one monthly update reminder. Once a month, refresh the prices and add any new buys, then close the sheet, because daily checking only feeds anxiety, not returns.

Recommended template

Keep the investing beside the budget that funds it

The Ultimate Budget System gives the contributions that feed your investments a proper home, with 28 connected tools, twelve auto-populated months, a bill calendar and debt tools in one sheet. One time $37, lifetime use, no subscription, and trusted by over 76,000 customers.

Get the Ultimate Budget System →

🧹 Mistakes that quietly distort your returns

• Reading the balance as your return. Fix it: log contributions in their own column so you can subtract your own money from the climb.
• Never recording cost basis. Fix it: enter what you paid the day you buy, while the figure is in front of you, not years later at tax time.
• Ignoring dividends and distributions. Fix it: add an income column, because a flat price with steady dividends is still a real return.
• Checking it every single day. Fix it: update once a month, since daily price noise drives bad decisions far more often than good ones.
• Mixing the tracker in with your net worth sheet. Fix it: keep them as two tools, one for return on investing, one for the whole-picture snapshot.

🎯 Your action steps this week

• Open a blank sheet and add the seven columns before you fill a single row.
• Enter your three largest holdings tonight, with their real cost basis.
• Add a contributions column and total what you have put in this year.
• Work out the genuine growth, the balance minus your contributions, and sit with that number.
• Point the whole thing at a target with the retirement planning spreadsheet, so the returns have a finish line to aim at.

❓ Frequently asked questions

How do I track investments in a spreadsheet?

Give every holding its own row, then add columns for units, cost basis, current value, unrealised gain, realised gain and income. Current value is units times today's price, and the unrealised gain is that value minus your cost basis. Update the prices once a month and log any new buys or dividends as they happen, and the sheet keeps your true return in view without daily fuss.

What should an investment tracker spreadsheet include?

It should include the holding name and ticker, the units you own, the cost basis, the current value, the unrealised and realised gains, and any income received. The cost basis column is the one that matters most, because both your return and your tax are measured from it. A contributions column alongside lets you separate your own money from the growth the market provided.

Should I update my investment tracker every day?

No, once a month is plenty for a long term investor. Daily price swings are mostly noise, and watching them tends to trigger selling at exactly the wrong moments. A monthly refresh shows you the genuine trend, keeps the admin light enough that you actually keep doing it, and protects you from reacting to a bad afternoon that does not matter.

Is a spreadsheet better than my broker's app for tracking investments?

A spreadsheet wins when you hold investments across more than one account, because no single broker app can see the others. It also lets you track cost basis and contributions exactly the way you want, rather than the way an app decides to show them. The app is fine for one account, but a sheet gives you the one combined view of your real return.

My neighbour is still up fifteen percent, by the way, and good on him.

The difference now is that I could tell you how much of that the market actually handed him, and how much he simply carried over the fence himself.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.