Canadian DRIP Log

Stock DRIP Log for Google Sheets

A Basic Spreadsheet to Track your Dividend reinvestment Purchases

DRIP Primer What Is a DRIP? Group Buys Transfers DRIP Clubs Discount Brokers

Canadian DRIP FAQ U.S. DRIPs Letters Canadian DRIP & SPP List Links Contact Us

A basic spreadsheet to keep track of your

DRIP & SPP purchase dates and reinvestments.

Due to changes in Web Data Queries in Excel, they are no longer functioning.

I recommend using Google Sheets since it's free and Google Finance can provide stock quotes.

Sample available here.

Select "File" - "Make a Copy" to make a copy to your Google Sheets account.

Instructions

From your Statement from the Transfer Agent:

  1. Fill in purchases manually, except for the last "Total" line which will be calculated.

  2. Then fill in all cells for reinvested dividends (using discounted price if applicable). Bottom line totals will be calculated.

  3. For current share price, use the Google Finance function eg. =GOOGLEFINANCE("BCE.to", "price") for BCE.

  4. Add more lines to either "Purchases" or "Dividends" by right-clicking on the NUMBER of a blank row and selecting "Insert".

Totals at bottom will be calculated automatically

Total return is a simple return including fees paid.

Adjust Cost Base is total cash value of all share purchases including any fees, plus all reinvested dividends.

In case you want the old spreadsheet

Download the Old Log File (.xls)

In the Event of a Stock Split

If a company that you DRIP decides to declare a stock split, or issue a share dividend, it will be important to maintain proper ACB Per Share if you ever sell/transfer a single share.

Remember, a Stock Split does not change your Adjusted Cost Base, since the total amount of money you have invested or had reinvested from dividends has not changed.