Why you should keep a record

In 2017, I bought shares of a company I was excited about. I remember the feeling. I’d done research, I liked the product, the valuation seemed reasonable. I was confident it was a good buy.

What I don’t remember is the price I paid. Or the exact date. Or how many shares I bought. Or whether I added to the position later that year or early the next year. I have a vague memory of “somewhere around $45” and “I think it was the fall.” That’s it.

I was investing without keeping any record beyond what my brokerage provided. And brokerage records, while accurate, aren’t built for reflection. They’ll tell you what you own today. They won’t tell you why you bought it, what you were thinking at the time, or how the position has evolved over years of contributions and withdrawals.

The spreadsheet years

At some point, I started keeping a spreadsheet. Nothing sophisticated at first. Just a list of what I owned, what I paid, and when I bought it. I’d update it every couple of weeks, pulling numbers from my brokerage accounts.

That spreadsheet changed how I thought about investing.

Suddenly I could see things I’d never noticed before. I could see that I’d been slowly building a position in one stock over 18 months, buying a little more every few weeks. I could see that a dividend stock I considered “boring” had quietly returned 40% over three years once you included the reinvested dividends. I could see exactly how much I’d contributed vs. how much was market growth.

The spreadsheet got more detailed over time. I added columns for dividends received, for sector breakdowns, for the Canadian vs. U.S. split. I started tracking my actual rate of return instead of relying on what my brokerage reported. That habit became an obsession, and eventually that obsession became Greenline.

But the core insight was simple: having a record changes the way you invest. Not because the record does anything magical. Just because it lets you see patterns you’d otherwise miss.

Memory is terrible at this

Ask someone what their portfolio returned last year, and most people will give you a rough number based on feel. “I think I was up like 12%?” Ask them what they returned three years ago, and they’ll have almost no idea.

Ask them when they bought their largest position, and you’ll get “I think it was 2019, maybe 2020.” Ask them how much they’ve contributed in total vs. how much is growth, and they genuinely won’t know.

This isn’t a criticism. It’s just how memory works. You remember the big moments. The crash. The time a stock doubled. The day you opened your first account. But the slow, steady accumulation that makes up 90% of investing? That fades. The monthly contributions blur together. The small purchases get absorbed into the larger picture.

Without a record, your entire investment history becomes a handful of vivid memories surrounded by fog. And that fog makes it hard to learn from your own experience.

What a record lets you do

When you have years of documented history, you can answer questions that most investors can’t.

You can look at a position and know exactly what you paid, when you bought each tranche, and what your total return has been. Not the stock’s return. Your return, based on your actual purchase dates and amounts.

You can see how your portfolio has changed over time. Not just what’s in it today, but what was in it two years ago. What did you sell? What did you add? How has your strategy evolved?

You can review your decisions during bad months and see whether you held, sold, or bought more. You can compare what you thought would happen with what actually happened.

You can calculate your real cost basis for tax purposes instead of scrambling to reconstruct it at the end of the year.

And maybe most importantly, you can see the cumulative effect of years of consistent investing. Watching your portfolio grow from a spreadsheet with four rows to one with dozens, covering multiple accounts and years of history, is genuinely motivating. It’s a record of discipline.

You don’t need to be detailed about it

I went overboard with my spreadsheets. Most people don’t need to track 15 different metrics per position. The basics are enough.

What do you own? When did you buy it? How much did you pay? What have you contributed in total? Those four things, updated regularly, give you more insight than most investors will ever have.

The format matters less than the habit. A spreadsheet works. A notes app works. Something like Greenline works. The point is that the information exists somewhere you can access it and review it over time.

The key word is “over time.” A snapshot of your portfolio today is useful. A series of snapshots going back years is transformative. It turns investing from something you’re vaguely doing into something you can study, improve at, and learn from.

The people who don’t keep records

I have friends who’ve been investing for a decade and couldn’t tell you their overall return. Not approximately. Not within 20%. They have genuinely no idea whether they’ve made money or lost money in aggregate. They know their accounts are worth something, and they know they’ve put money in, but the gap between those two numbers is a mystery.

They’re not careless people. They’re just people who never established the habit of writing things down. And now, years later, reconstructing that history would be an enormous project. Brokerage statements going back 10 years, multiple accounts, transferred positions, name changes after mergers. It’s a mess.

Starting a record today means you won’t be that person five years from now. You’ll have a clear, continuous history of your investing life. Every contribution, every trade, every dividend, every return calculation, all in one place.

That history is worth more than you think. Not because it makes you money directly, but because it makes you a more informed, more confident, and more self-aware investor. And those things do make you money over time.

Start keeping a record. Future you will be grateful.