{"id":1667,"date":"2026-06-29T18:00:07","date_gmt":"2026-06-29T22:00:07","guid":{"rendered":"https:\/\/www.adjustedcostbase.ca\/blog\/?p=1667"},"modified":"2026-06-29T18:38:04","modified_gmt":"2026-06-29T22:38:04","slug":"importing-transactions-from-td-direct-investing-into-adjustedcostbase-ca","status":"publish","type":"post","link":"https:\/\/www.adjustedcostbase.ca\/blog\/importing-transactions-from-td-direct-investing-into-adjustedcostbase-ca\/","title":{"rendered":"Importing Transactions from TD Direct Investing into AdjustedCostBase.ca"},"content":{"rendered":"

The spreadsheet import functionality on AdjustedCostBase.ca enables you to easily import transactions from your TD Direct Investing accounts. We have a template readily available that is compatible with the TD Direct Investing CSV (comma separated value) format. Just follow the steps outlined below.<\/p>\n

\"\"<\/a><\/p>\n

Please note that you’ll need access to AdjustedCostBase.ca Premium to unlock the spreadsheet import functionality.<\/p><\/blockquote>\n

Download your Data from TD Direct Investing<\/h3>\n

Important:<\/strong> TD Direct Investing provides access to download a variety of reporting data. For example, the data from the “Gain & Loss” tab for each account is available for download. They also provide an annual report called “Trade summary spreadsheet (CSV)”, which is accessible from the “Documents (eServices)” page via the “Tax Documents” tab. Don’t use either of these for AdjustedCostBase.ca data imports – stick with downloading data directly from the “Activity” tab for the relevant account(s), as described below.<\/p>\n

    \n
  1. Log in to your TD Direct Investing account using the web interface.<\/li>\n
  2. Navigate to your Cash (non-registered) account.
    \n    \"TD<\/a><\/li>\n
  3. Navigate to the “Activity” tab.
    \n    \"TD<\/a><\/li>\n
  4. Optional:<\/strong> Update the date range to include all the transactions you need to upload. For example, if you haven\u2019t uploaded your transactions for the past year, ensure that the date range covers that time period. Please note: it\u2019s 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.
    \n    \"TD<\/a><\/li>\n
  5. Click on the “Export” icon on the top right of the screen to save your transaction data to a local file in CSV (comma separated value) spreadsheet format.
    \n    \"TD<\/a><\/li>\n
  6. 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.<\/li>\n<\/ol>\n

    Here is an example is a CSV spreadsheet file containing transactions exported from TD Direct Investing:<\/p>\n

    \"\"<\/a><\/p>\n

    Upload your TD Direct Investing Transactions to AdjustedCostBase.ca<\/h3>\n

    After downloading the relevant transaction spreadsheets you’re all set to import the data into AdjustedCostBase.ca. Follow the steps outlined below.<\/p>\n

      \n
    1. After logging into AdjustedCostBase.ca, click the \u201cTools\u201d link on the top blue menu bar.
      \n      \"AdjustedCostBase<\/a><\/li>\n
    2. Click the \u201cImport Transactions from a Spreadsheet\u201d link.
      \n      \"Import<\/a><\/li>\n
    3. Select the \u201cTD Direct Investing\u201d settings template from the list of available library templates and click \u201cLoad Settings Template\u201d.
      \n      \"Template<\/a><\/li>\n
    4. Click on the \u201cClick to browse or drag & drop box\u201d to select the CSV file you downloaded from TD Direct Investing (or drag and drop it into the box). Click \u201cImport Spreadsheet\u201d.
      \n      \"\"<\/a><\/li>\n
    5. 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 TD Direct Investing template configuration. Also, TD Direct Investing may split out a single trade into multiple rows in the spreadsheet (representing different fills executed for the trade). The TD Direct Investing configuration template has the “Combine Adjacent Rows with Same Date \/ Security \/ Transaction Type” option enabled by default. This option will result in these rows being merged into a single transaction on AdjustedCostBase.ca.
      \n      \"\"<\/a><\/li>\n
    6. Map unrecognized securities if necessary. If the data includes purchases and sales of securities that haven\u2019t been added to AdjustedCostBase.ca, select the \u201cAdd as New Security\u201d option. If a security name isn\u2019t recognized but corresponds to an existing security on AdjustedCostBase.ca, choose the \u201cMap to Existing Security\u201d 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\u2019t get incorrectly split across multiple securities on AdjustedCostBase.ca. When using the \u201cMap to Existing Security\u201d option, by default (assuming you leave the \u201cSave unrecognized security names as aliases for future imports\u201d option enabled), we\u2019ll remember the name mapping for your next import, making the process quicker and easier next time.
      \n      \"\"<\/a><\/li>\n
    7. Click \u201cAdd Transactions\u201d to finalize the data import.
      \n      \"\"<\/a><\/li>\n<\/ol>\n

      Repeat these steps periodically to enable your complete data from your TD Direct Investing account to be included in your ACB\/capital gains calculations on AdjustedCostBase.ca.<\/p>\n","protected":false},"excerpt":{"rendered":"

      The spreadsheet import functionality on AdjustedCostBase.ca enables you to easily import transactions from your TD Direct Investing accounts. We have a template readily available that is compatible with the TD Direct Investing CSV (comma separated value) format. Just follow the steps outlined below. Please note that you’ll need access to AdjustedCostBase.ca Premium to unlock the […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1667","post","type-post","status-publish","format-standard","hentry","category-adjustedcostbase-ca-site-help"],"_links":{"self":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/comments?post=1667"}],"version-history":[{"count":9,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1667\/revisions"}],"predecessor-version":[{"id":1704,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1667\/revisions\/1704"}],"wp:attachment":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/media?parent=1667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/categories?post=1667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/tags?post=1667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}