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?