Dividend Tracker (FREE Spreadsheet Download)

When you get started on your dividend investing journey, the best part is dividend tracking. It is so rewarding to input your dividend raises that come from your dividend paying companies (without having to add your own invested capital).  However, despite the popularity of dividend investing, it is difficult to find a dividend tracker spreadsheet online to keep track of your forward dividend yield.  Here’s a free dividend tracking spreadsheet for you to download with a step-by-step guide on how to use THIS dividend tracker spreadsheet in Excel.

Dividend Tracker Spreadsheet

Why Use A Dividend Tracker?

First, let me explain why a dividend tracker spreadsheet is a good idea for any avid dividend investor.  Similar to tracking your net worth or tracking your spending, tracking your dividend yield is a great way to look at how much more in income producing assets you are accumulating.  

Also, unless you are an index investor,  it is good practice to review which companies are cutting or increasing dividends. Once a company cuts their dividends, this is usually bad news for investors and also for the company.

I personally update my dividend yield spreadsheet on a monthly basis and you can check my recent forward dividend income updates here if you’re interested.  

Genymoney.ca dividend yield spreadsheet

Here’s how to use a dividend yield spreadsheet to keep track of your dividends which we can’t forget to cultivate and weed, just like your vegetable garden.  Thanks to my investing and Excel spreadsheet savvy husband, he helped create this spreadsheet for me. I personally use a similar one to keep track of my dividends with Google Sheets.

Some brokerages like Scotia iTrade have a dividend tracker (forward yield) built into their dashboard and interface, while others, like Questrade don’t.

I also use Dividend Pro App to keep track of the ETF distribution changes and I update my spreadsheet.

Free Dividend Portfolio Tracker Step-by-Step Guide

If you haven’t already downloaded this dividend yield spreadsheet, you can sign up here.  Once you receive it in your email, press the orange button to download it.

If you don’t like subscribing to genymoney.ca you can always unsubscribe, but I do hope that you won’t 😉

Here’s an explanation of each column in your Excel spreadsheet that you have just downloaded.

Name

This is pretty self-explanatory.  Here you can input the Ticker Symbol of the dividend stock that you have purchased in your portfolio.

Market Value

For this, you don’t have to input anything into the spreadsheet.  It is automatically calculated using the spreadsheet by multiplying the current price by the number of shares owned.

Price

Every time you want to update your dividend portfolio, you will need to update this manually with the current market price of the dividend stock.  This number is the market price, or what it is currently sold at on the stock market.  Google Docs has an option where you can input a Google Finance command and it pulls the data so you don’t have to update manually.  However, this spreadsheet is in Excel instead.

Book Value

Book value will be inputted when you first buy your dividend stock and will be adjusted every time you add to your dividend stock.  This includes adding via dripped shares or buy additional purchases of equities.  The book value is the actual cost of how much you spent buying these shares including commissions.

ACB (Adjusted Cost Base)

The adjusted cost base is the book value divided by the number of shares that you own.  You don’t need to input this, as it is calculated from the dividend spreadsheet.  It is the price per share that you bought the stock at.  You will want this to be as low as possible 🙂

Capital Gain/ Loss

The capital gain or loss is calculated by subtracting book value (what you have purchased the dividend stock at) from the market value (what the dividend stock is currently priced at on the market).  Again, you don’t need to input this, as it is calculated from the dividend spreadsheet automatically.

percentage %

The percentage (shown as an increase or decrease, or a positive or negative number) is basically the capital gain or loss divided by the Adjusted Cost Base (ACB).  You do not need to input this as the calculation is built into the spreadsheet.

Shares

This is self-explanatory and you can input the number of shares that you own of your dividend company.  If you have dividend re-investment plan (or DRIPs) you can change the number of shares that you own.  In addition, when you purchase more shares you can update the numbers here.

To DRIP or not to DRIP that’s a matter of personal preference for any dividend investor.  I like a balanced approach.  I have one dividend stocks that I DRIP (Sunlife Financial, SLF.TO).  I do like to have control over most of my dividend income and use the dividends received to buy other dividend stocks that might be more well-priced than what the DRIP stocks are offering.

Dividends per Share

The value (may it continue to increase for you) will need to be updated as companies increase their dividend (or decrease… or cut).  Increasing dividends is MUSIC to any dividend investor’s ears.  “X company increases their dividend by 12% to $3.50/share paid out on a quarterly basis”.

The dividend per share will be the annual dividend per share.  Some companies pay every month and some pay every quarter.  Here’s where you would find this information in a stock quote.  

This is an example of Altria (NYSE: MO) on Yahoo Finance.

Dividend Per Share in Stock Quote
Source: Yahoo Finance

This post may contain affiliate links. Please see genymoney.ca’s disclaimer for more information.

Total Dividend

The total dividend is calculated for you in the spreadsheet and equals the dividends per share multiplied by the number of shares you own.  This number is very soothing when it keeps going up, especially if the dividends per share keeps going up and the company continues to increase their dividend- and not because the number of shares held is going up!

Dividend Yield

Finally, this is another field that is calculated for you.  It is equal to the total dividend divided by the adjusted cost base.  This is how much of a dividend yield you are getting on the amount of dividend stock you paid.

The lower you paid for your dividend stock, usually the higher your dividend yield is.

You can also see the total dividends (the sum of all the dividend income) and the total dividend yield of your portfolio.  This is probably one of the most important numbers available because it tells you how much dividend yield you are getting from your portfolio as a whole.  The total dividend yield number is created by the total dividends divided by the total ACB or total cost of your portfolio.

You may have a few dividend stocks that are paying a 10% dividend and others that are 1.35% but you don’t know what your average dividend yield is.  When you know the total dividend yield, you do.

Hope that explains the spreadsheet and how to use it!  

Again, if you’re interested in downloading it, please subscribe to genymoney.ca updates and get a free dividend yield spreadsheet tracker!

How to Track Dividends Received

This dividend tracker spreadsheet helps you track your forward annual dividend yield (or expected dividends in the next 12 months, give or take depending on whether you invested before the ex-dividend dates).

I hope the dividend tracker template is useful for you on your dividend investing journey. I wouldn’t say it’s the best dividend tracker spreadsheet out there, but it’s free and easy to use and gets the job done!

Dividend investing is like gardening, very enjoyable to see your fruits of labour!

Wealthica: The Personal Capital of Canada

To track actual dividends received, I use Wealthica, which is a net worth and portfolio tracker in Canada. It’s very easy for me to track my dividends received.

I just log into Wealthica (it’s free) and I go to “Power Ups” and then click on Income.

It then tells me the past 12 months of dividends received. It separates both US dollar dividends and Canadian dividends and converts the total to Canadian dollars.

Here’s a screenshot of what the dividend tracker in Wealthica looks like. You can toggle the timeline to any date or period of time, for example, you can check how many dividends you received for the month of December.

Dividends Received January 2020

You can click here to sign up for Wealthica for free here. They have an app and a desktop version which are both excellent.

Dividend Pro App

Another way to keep track of forward dividend yield very specifically, even down to ex-dividend dates and the exact pay dates of your dividends is using a dividend tracker app called Dividend Pro.

It’s free to download but after certain time period, you are only allowed 3 stocks to monitor and if you want to unlock all the stocks you inputted previously, you have to pay $12.99 per year to access them.

Dividend Predictor App Tracker

Here’s my review of the Dividend Predictor app.

Passiv

Finally another alternative is using Passiv. It is also free (if you are a Questrade user) and provides excellent analytics and tracking of your dividends and dividend history.

Passiv Dividend Income Tracking

This is what Passiv looks like when you are looking at tracking your dividends:

Passiv Dividends Received

Here’s my review of Passiv if you are interested.

If you want to get started dividend investing, a good way is to check out what other dividend investors are investing in or you can start off by looking at these top 5 Canadian Dividend Stocks.  Feel free to check out my compilation of the Ultimate List of Canadian Dividend Investing Bloggers.

If you’re interested in reading more about dividend investing through books, here are the top 5 dividend investing books that I would recommend.

You may also be interested in:

Readers, do you use a dividend investing spreadsheet?  

How often do you update your dividend tracker spreadsheet?

How to Use a Dividend Yield Spreadsheet
Become a Stock Market Millionaire with a Dividend Yield Spreadsheet to Keep Track of Your Passive Income. Dividends are the best form of passive income and here's how to use a spreadsheet to keep track of them. #dividends #passiveincome #makemoney #stockmarket #millionaire #money
Get the Young Money Bootcamp PDF FREE

Free Dividend Yield Spreadsheet Tracker Download and Blog Updates

30 thoughts on “Dividend Tracker (FREE Spreadsheet Download)”

    • @Tom- Haha 🙂 If Mrs DD was second to your dividend spreadsheet the Internets would be in a full-blown uproar! 😉

      Reply
  1. Hi, GYM! I would love to download the spreadsheet but since we are already subscribing to your list, it is giving me an error. Is there a different link to download it by chance? Or maybe I’m missing something obvious! It happens haha. 🙂

    Reply
  2. Yup, I use yours ever since I downloaded the spreadsheet a while back. I go by every quarter which means I’ve used it twice so far. Very helpful on how much passive income I’m getting. Thanks again for the spreadsheet GYM!!

    Reply
    • @Jim Wang- I have a Google Sheet as the one I use (love the data pull automatically) but this one that I send out is just an Excel spreadsheet. My husband just uses the Excel spreadsheet too. The other day I tried to input the Google function into the Excel spreadsheet and was getting flustered as to why it wasn’t working (hahaha…).

      Reply
  3. Hey GYM!

    Another great post! I love using spreadsheets in order to track my investments. I recently moved to Google Sheets. Google Sheets has the formula “GoogleFinance” which is able to pull delayed data from the stock market, its just too cool!, have you tried it out? I would definitely recommend it to you.

    Have a great day!

    Reply
    • @Derek- I have Google Sheets for my own dividend spreadsheet (and it basically looks like the one that you can download) but thought to share this one since I didn’t know how to share Google sheets as a download haha 🙂 Thanks for visiting and have a great day too!

      Reply
    • @Andy- The % column is the percentage gain or loss. It calculates the capital gain/loss divided by Adjusted Cost Base (ACB).

      Reply
  4. I cannot seem to get the spreadsheet either. Please email to me. I have one account which has all my drip stocks in it. How do i adjust your spreadsheet to show the number of additional shares I get every quarter on each share in the account and how do I adjuist the cost basis each quarter? I apologize for asking such an elementary question.

    Reply
    • @Morris- Sure I’ll email to you! Weird that you didn’t get it though, it should be included as a link in the welcome email 🙂

      No question is ever elementary! (One thing my dad taught me to not be afraid to ask questions!)

      1) To show additional shares, you just update the “shares” column with the new number of shares you have. Column “I” in Excel.

      2) To adjust the cost base each quarter, the spreadsheet has a built-in calculation for that. You just need to update your book value (which your online brokerage should show).

      Reply
    • @Lewis Kwan- Have you tried clicking on the orange button? Once you click that button it should download. If you are still having troubles please email me through ‘contact me’ Thanks!

      Reply
      • I can’t seem to locate the “Orange Button” either. Could you please tell me if the button has a label and where about it is in the webpage? Thanks.

        Reply
        • @Anonymous- It’s not on the webpage, you have to subscribe (to the right blue box where you can enter your email address), and then the email with the free spreadsheet will be sent to you 🙂

          Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.