youngandthrifty Dividend Income Update- August 2012

Last Updated on

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?

The following two tabs change content below.
Young is a writer and former owner of Young and Thrifty and the main "twitter' behind Young and Thrifty's twitter account. She lives in Vancouver, BC and enjoys long walks on the beach, spending time with her anxious dog, and finding good deals. If you like what you read, consider signing up for email updates.

16 Comments

  1. Echo on September 6, 2012 at 4:06 pm

    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 🙂



  2. Lance @ Money Life and More on September 6, 2012 at 5:35 pm

    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.



  3. Joe on September 6, 2012 at 7:35 pm

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



  4. Steve on September 6, 2012 at 8:48 pm

    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+.



  5. Leigh on September 8, 2012 at 12:28 am

    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!



  6. My Own Advisor on September 8, 2012 at 9:18 am

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



  7. young on September 8, 2012 at 2:09 pm

    @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.



  8. young on September 8, 2012 at 2:10 pm

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



  9. young on September 8, 2012 at 2:11 pm

    @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).



  10. young on September 8, 2012 at 2:12 pm

    @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 🙂



  11. young on September 8, 2012 at 2:13 pm

    @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?



  12. young on September 8, 2012 at 2:15 pm

    @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!



  13. Leigh on September 9, 2012 at 9:04 am

    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.



  14. Andrew Hallam on September 11, 2012 at 4:10 am

    That’s money for nothing Young!

    Nice work!!!



  15. Teacher Man on September 11, 2012 at 7:17 am

    Hey, thanks for stopping by Mr. Millionaire Teacher!



  16. S. B. on March 11, 2013 at 10:39 pm

    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.



  17. February 2014 net worth update: +1530 (+0.5%) on February 16, 2014 at 8:33 pm

    […] Check out my dividend income spreadsheet! […]



Leave a Comment





> >