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. 

Financial Basics 12 - Keeping Track of Adjusted Cost Base

This post is about why and how to keep track of the adjusted cost base (ACB) of your ETFs in your taxable account. 


Just to make doing your taxes even more painful? Seems that way!

Updated May 2017 as the ACB spreadsheet has been enhanced to include foreign exchange input for transactions in foreign currency. 
Updated December 2016 to add another link in the Other Info section and update the RCGD table to include 2015 and 2016.