How to Track Investments Without Logging Every Trade

Short answer: to know what your investments are worth, you only need two things per holding — how many units you hold, and the current price. You do not need to log every buy and sell. But the moment you sell in a non-registered account, Canada wants your adjusted cost base (ACB), and that's a separate record from your net-worth total.

Understanding which job you're doing is the whole trick.

The snapshot method

A snapshot tracks a holding as: ticker, number of units, and currency. Its value is simply:

units × current price

When your position changes, you edit the number of units. When the price moves, you refresh it. That's the entire model.

This mirrors how most people actually used a spreadsheet: a row per holding, a STOCK()-style price, and a share count you update occasionally. It's fast, and it answers the big question — what am I worth? — without demanding a trading journal.

What snapshot tracking answers

• Net worth. Cash plus liabilities plus investments at current value, in your reporting currency.
• Allocation. How much is equity vs. fixed income vs. cash; which sectors or regions you're tilted toward.
• Change over time. Look at the number this month and last.

For a personal balance-sheet view, that's exactly the right level of detail. No lot tracking, no dividend ledger, no journal entries for each purchase.

What it cannot answer

Snapshot tracking is current value only. It does not tell you:

• Your cost basis for a holding.
• Your realized or unrealized capital gain.
• What a sale will do to your taxes.

Those are not flaws in the method; they're a different question. A snapshot is a valuation. A cost base is a tax fact. Conflating the two is how people end up surprised at tax time.

Adjusted cost base, briefly

In Canada, your capital gain or loss on a sale is the difference between what you sold for and your adjusted cost base — the amount of the investment that has already been taxed.

For "identical properties" (the same security bought more than once), the ACB is an average, not a per-purchase number:

ACB per unit = total cost of all identical properties ÷ total units owned

So if you buy the same fund three times at three prices, you average them. The ACB is a moving target, not a single receipt.

Things that move your ACB

ACB drifts more than people expect. Common adjustments include:

• Reinvested distributions. When a distribution is reinvested, that amount is added to your ACB.
• Return of capital. A distribution that is partly return of capital reduces your ACB, which makes a future gain larger.
• Superficial losses. If you sell at a loss and repurchase the same security too soon, the loss can be denied and added to the ACB of the units you still hold.
• Spousal transfers and elections. Transfers between spouses generally happen at ACB, but an election for fair market value can reset it.
• Historical elections. Older provisions (such as the 1994 capital-gains election) can have bumped your ACB decades ago.

None of this is guessable from a current price. It requires the transaction history.

Run both records — but separately

The clean approach is to stop asking one tool to do two jobs:

Use the snapshot for the glance and the ACB record for the tax year. They'll agree on units, which is the one number both need.

FAQ

Do I need to track ACB for my RRSP or TFSA? No. ACB is a concern for non-registered (taxable) accounts, because that's where capital gains are reported and taxed. Registered accounts don't work that way.

Can a snapshot app calculate my capital gains for me? Not if it has no cost basis. That's why apps that snapshot investments say so plainly. Keep ACB where it belongs.

Is the snapshot method accurate? It's accurate for current value, which is what it claims to be. It is not a tax cost base, and it shouldn't be described as one.

What about dividends? A snapshot doesn't track income by default. If you need income reporting, that's a separate record too.

Sources

Accessed 2026-10-23.

• Manulife Investment Management — An investor's adjusted cost base: A moving target
• Canada Revenue Agency — Line 12700: Capital gains