Thursday, 18 May 2017

Adjusted Cost Base Tracking Spreadsheet

ACB v1p1

This spreadsheet is designed to help you keep track of your adjusted cost basis (ACB) for your stocks, mutual funds or ETFs. You can download version 1.1 here.

The spreadsheet was updated to version 1.1 in May 2017. Ability to enter foreign exchange rates for stocks and funds listed in foreign currency has been added. 

My post Financial Basics 12 - Keeping Track of Adjusted Cost Base gives a good summary of why and how to use the spreadsheet. 

Each sheet within the workbook is to be used to track ACB for one stock, mutual fund or ETF. 

The inputs are simple.  Enter Buy, Reinvest, ROC (Return of Capital), RCGD (Reinvested Capital Gain Distributions), Sell or Split transactions. 

Enter the foreign exchange rate if the stock or fund is not listed in Canadian dollars. 

ACB value is tracked.

Schedule 3 information is produced for Sell transactions.

Disclaimer:  These posts are not fully comprehensive financial advice.  You should seek your own qualified investment, tax and legal advice.


  1. Suggestion for improvement... adding exchange rate for other currency transactions.

    1. Thanks for the suggestion. I have (finally) made the enhancements to the spreadsheet.