File Layout

Description	Column	Comments
Security *	A B C D E F G H I J	This specifies the name of the security.
Date *	A B C D E F G H I J	Must be in the form of MM/DD/YYYY or DD/MM/YYYY. You also need to specify which form you decided to use in the "Additional Information" section below.
Action *	A B C D E F G H I J	The type of transaction that has occured. Acceptable values are "Buy", "Sell", "Reinvested Dividend" and "Split".
Amount *	A B C D E F G H I J	Is either the total amount or the amount per share. If you don't specify a value for "Total or Per Share" then it will assume that it is the total amount.
Shares *	A B C D E F G H I J	The number of shares.
Commission *	A B C D E F G H I J	A number representing the amount it cost for you to do the transaction.
Total or Per Share	A B C D E F G H I J	This field is not required so it can be left blank. You can use the values "Total", "Per Share". The amount field will be the total cost of the transaction if use the value "Total" or leave it empty. Using the value of "Per Share" will mean that the amount field is the cost per share for the transaction.
Price in Foreign Currency	A B C D E F G H I J	You can use the words "Yes", "No" or leave it empty. If you choose "Yes" the amount will be multiplied by the exchange rate.
Commission in Foreign Currency	A B C D E F G H I J	You can use the words "Yes", "No" or leave it empty. If you choose "Yes" the commission will be multiplied by the exchange rate.
Exchange Rate	A B C D E F G H I J	A numerical value representing the exchange rate.

Please note that you must select a column letter when there is a red asterisk in the description.

Additional Information

Description	Option	Comments
Ignore First Row	Yes No	Select "Yes" if the first row of your spreadsheet has titles that describe the columns.
File Date Format	MM/DD/YYYY DD/MM/YYYY
Choose file to upload		Must be in a CSV format.

Security	Shares	ACB	ACB Per/Share
Security	Shares	ACB	ACB Per/Share

Security	Date	Action	Amount	Shares	Amount / Share	Commission	Capital Gain or Loss	Share Balance	Change in ACB	New ACB	New ACB/Share
Security	Date	Action	Amount	Shares	Amount / Share	Commission	Capital Gain or Loss	Share Balance	Change in ACB	New ACB	New ACB/Share

Security	Transaction Date	Proceeds Of Disposition	Adjusted Cost Base	Outlays and Expenses	Capital Gain or Loss
	Total