This article contains instructions on how to import transaction data from Scotia iTRADE into AdjustedCostBase.ca in order to accurately calculate your ACB and capital gains.
Please note that uploading data from a spreadsheet requires an AdjustedCostBase.ca Premium account.
Download your Data from Scotia iTRADE
- Login to the Scotia iTRADE web interface.
- Navigate to your non-registered account and select the “Activity” tab.
- Optional: Update the date range to include all the transactions you need to upload. For example, if you haven’t uploaded your transactions for the past year, ensure that the date range covers that time period. Please note: it’s perfectly fine to include a broader date range than necessary (you can include transactions that were previously imported). For example, you can upload a spreadsheet containing transactions from the past three months on a monthly basis. Duplicate transactions will be automatically detected and excluded from the data import.
- Click on the CSV download link to save your transactions to a local CSV (comma separate values) file.
- Repeat the above process for any other relevant accounts (for example, if you have a USD Cash account or a Corporate account). You do not need to track your ACB for registered accounts, so you can skip downloading data for any RRSP / TFSA / RESP / etc. accounts.
Example transaction data exported from Scotia iTRADE:
Upload your Scotia iTRADE Transactions to AdjustedCostBase.ca
- After logging into AdjustedCostBase.ca, click the “Tools” link on the top blue menu bar.
- Click the “Import Transactions from a Spreadsheet” link.
- Select the “Scotia iTRADE” settings template from the list of available library templates and click “Load Settings Template”.
- Click on the “Click to browse or drag & drop box” to select the CSV file you downloaded from Scotia iTRADE (or drag and drop it into the box). Click “Import Spreadsheet”.
- Review your transactions for completeness and accuracy. Please note that any rows that already map to existing transactions will be flagged as duplicates and excluded from the import. Only purchases, sales, and DRIP transactions need to be imported; other transaction types, such as cash dividends or cash transfers across accounts, do not need to be imported into AdjustedCostBase.ca. These transactions will be ignored when using the Scotia iTRADE template configuration.
- Map unrecognized securities if necessary. If the data includes purchases and sales of securities that haven’t been added to AdjustedCostBase.ca, select the “Add as New Security” option. If a security name isn’t recognized but corresponds to an existing security on AdjustedCostBase.ca, choose the “Map to Existing Security” option and select the appropriate security from the drop-down list. It is important to perform this process correctly to ensure that your transactions don’t get incorrectly split across multiple securities on AdjustedCostBase.ca. When using the “Map to Existing Security” option, by default (assuming you leave the “Save unrecognized security names as aliases for future imports” option enabled), we’ll remember the name mapping for your next import, making the process quicker and easier next time.
- Click “Add Transactions” to finalize the data import.
That’s it! Repeat this process periodically to ensure that your latest transactions are reflected in your ACB and capital gains calculations on AdjustedCostBase.ca.