I feel like a kid who spent hours crafting something that shouldn’t have taken them so long but they’re still proud of it anyway!

Yes, after a few hours getting somewhat flustered and frustrated with Excel and Google Spreadsheets, I managed to create my very own dividend income spreadsheet tracker!

So far, I am set to make almost $1100 in dividend income this year from my Tax Free Trading Account and my non-registered accounts this year.  I haven’t included the dividend income from the retirement account (RRSP), there are a few dividend producers in there, but I thought I would start with this for now.

Not very much, but I’m still happy with that amount.  Now that I’ve discovered the happy happy world of dividend income tracking, I think I am going to be addicted to this idea of continually increasing the dividend income… as it helps create new goals for me.  Maybe that retirement thing isn’t so far away after all.  Okay maybe not.  Even my dog couldn’t survive on $1100 per year, so I think I have a long way to go.

Without further delay, here is a portion of my beautiful excel spreadsheet with the titles of the columns sprinkled in a beautiful and soothing mauve colour.

I have cut off a portion of my excel spreadsheet indicating my cost per share, annual yield (lol) for now.  Just in case inquiring minds are too inquisitive?

Readers, do you have a handy dandy dividend tracker spreadsheet?  If so, how often do you update it?

Article comments

17 comments
S. B. says:

I love to use Google Docs spreadsheets because you can embed the stock quotes right in the cells, and you can embed the spreadsheet right in your blog pages. It’s a bit slow compared to Excel for editing. I find it’s good for stuff where you want to share and have things update dynamically. Excel is more convenient for something I might be changing a lot.

That’s money for nothing Young!

Nice work!!!

Teacher Man says:

Hey, thanks for stopping by Mr. Millionaire Teacher!

young says:

@MOA- Congrats!! $6K is so great- it’s passive! For a goal of $30K in passive dividend income, that would equate to a dividend portfolio of around $600K, no? (with a generous 5% annual yield). Slow and steady wins the race!

Like Echo, I track my dividend stocks in Excel and just update them every time there

Leigh says:

Congrats on finally creating a dividend spreadsheet!!! I’m so proud of you! And I love the color 🙂

I have a spreadsheet in which I track my job income, as well as my interest and dividends income, but I don’t have any dividend stocks – just index funds that produce dividends. Vanguard doesn’t really announce the amounts or dates too far in advance, so it just happens when it happens and I note the amount afterwards!

young says:

@Leigh- Thanks Leigh! I knew you’d be proud of me lol. It was on my “summer break” to do list. Does your job income fluctuate? Is that why you track it?

Leigh says:

My company gives raises in the middle of the year and my bonuses are somewhat variable, so I track my overall job income to know what it’s going to say on the tax forms at the end of the year. This helps with tax planning throughout the year.

Steve says:

I update my spreadsheets after each dividend increase and I also update the income I’m paid every month.

It’s kind of nice to look over your progress and see your investment strategy working perfectly without having to do much at all. I still get giddy like a schoolboy when I see dividend increases and I probably still will when I’m 70+.

young says:

@Steve- Hahah we’re probably going to be the type that checks their online portfolio on a daily basis even at age 75! 🙂

It’s funny, it isn’t very much (e.g. $160 in dividend income annually for one stock) but that $160 feels like $16,000 🙂

Joe says:

Congrats, $1,100 is a great number for somebody in their 20s. BMO is such a great stock 🙂

young says:

@Joe- Not going to be in the 20’s for long haha. I need to step up my game. Yeah, BMO is awesome (or any Canadian bank pretty much for that matter).

I don’t personally have a dividend tracker spreadsheet but I do have a net worth tracker spreadsheet. I don’t buy dividend stocks but it would be a good idea to keep track of them if I did.

young says:

@Lance- Ooh maybe I’ll need to start that as well! My net worth tracker consists of a little book and a pen. 🙂

Echo says:

I track my dividend stocks in Excel and just update them every time there’s a dividend increase or if I add a new position. I’m at $2k in annual dividends, so I’ve got a long way to go as well 🙂

young says:

@Echo- That is awesome- $2000! I’ll have to update the spreadsheet come November too (since BMO is increasing their dividend). Hopefully I’ll remember how hahaha.