Here’s How I Track My Dividends

dividendTrackers2


Disclosure: I am not a financial advisor. None of the securities listed in this post should be taken as investment recommendations.


My favorite form of passive income is dividends. 

Each month I receive dividends from a combination of stock funds, individual stocks, REIT’s, and interest from my Ally Savings account.

I love this type of income because it requires no effort on my part. After my initial investment I just sit back and watch the dividends roll in each month.

I track these dividends using a simple Excel spreadsheet:

dividendTrackers2.PNG

On the left side I have the stock tickers color-coded according to the type of investment.

The pink names are index ETF’s

  • VYM = Vanguard High-Dividend Yield ETF
  • VDC =Vanguard Consumer Staples ETF

The blue names are individual stocks

  • CVS = CVS Pharmacy
  • KR = Kroger

The orange names are REITS (real estate investment trusts)

  • WPC = W.P. Carey
  • OHI = Omega Healthcare Investors
  • JCAP = Jernigan Capital
  • LADR = Ladder Capital

The purple is my Ally Savings Account, which currently pays 1.25% annually in interest.

Along the top of the spreadsheet I have the months listed.

The green cells represent the dividends I received each month as well as the dividends I expect to receive in the upcoming months. For example, in December I see that I’ll be receiving dividends from VYM, KR, and my Ally Savings account:

dividendTrackers3.PNG

The easiest way to find out when these companies expect to pay dividends is by looking up their stock tickers on Nasdaq’s website:

dividendTrackers4.PNG
LADR will be paying their next dividend on January 3rd, 2018

I like to track my dividends in this manner because it lets me see the individual dividend growth of certain investments over time and the total amount of dividends I receive each month.

For example, I received my first dividend payment from CVS back in May for $9.50 and just by reinvesting the dividends I have increased my dividends to $9.62 in November. Over time this number will only continue to grow larger and larger as CVS increases their dividend payments and I continue to reinvest in the company:

dividendTrackers5.PNG

Also, I can see that the total dividends I’m receiving each month are increasing over time:

dividendTrackers6.PNG

dividendTrackers7.PNG

For me, tracking my monthly dividends is an adrenaline rush. It’s exciting to see the numbers increasing each month so rapidly and it’s fun to watch the dividend growth over time. My monthly dividends will continue to grow over time due to:

  • Companies I invest in will (hopefully) declare higher dividends
  • I will continue to reinvest dividends
  • I will continue to make new investments in dividend-paying sources

Ultimately I plan on using dividends as a source of passive income when I eventually quit my day job.

Is dividend investing part of your investment strategy? Do you track monthly dividends? Do you have your own spreadsheet you use to track dividends? I’d love to hear your thoughts 🙂


My favorite free financial tool I use is Personal Capital. I use it to track my net worth, manage my spending, and keep an eye on my monthly cash flow. It only takes a few minutes to set up and it makes tracking your finances simple and easy. I recommend trying it out.

You can also sign up to have my most recent articles sent straight to your email inbox for free 🙂






5 Replies to “Here’s How I Track My Dividends”

  1. Great article, Zach! Remember to check out PSEC – over 1% monthly dividend adrenaline rush. I’ve been been trading them for years.

    I’ll have to check into CVS and the other stocks.

    Do you take cash or reinvest automatically?

  2. Hi Zach, I use very similar spreadsheets and charts for a portfolio of dividend stocks I have. So obviously, I like what I see. I’m looking forward to watching your portfolio of stocks grow and that dividend income increasing over time. By starting this at such a young age, you can take great advantage of the power of compounding over time. Wish I had started sooner than I did. Take care.

Leave a Reply

Your email address will not be published. Required fields are marked *