{"id":1710,"date":"2026-07-15T21:27:01","date_gmt":"2026-07-16T01:27:01","guid":{"rendered":"https:\/\/www.adjustedcostbase.ca\/blog\/?p=1710"},"modified":"2026-07-15T21:27:01","modified_gmt":"2026-07-16T01:27:01","slug":"importing-transactions-from-wealthsimple-into-adjustedcostbase-ca","status":"publish","type":"post","link":"https:\/\/www.adjustedcostbase.ca\/blog\/importing-transactions-from-wealthsimple-into-adjustedcostbase-ca\/","title":{"rendered":"Importing Transactions from Wealthsimple into AdjustedCostBase.ca"},"content":{"rendered":"

The following instructions describe how to export your transaction data from Wealthsimple, and subsequently import the data into AdjustedCostBase.ca.<\/p>\n

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

Please note that uploading data from a spreadsheet requires an AdjustedCostBase.ca Premium subscription.<\/p><\/blockquote>\n

Wealthsimple provides transaction data in 2 formats: Activities Export and Monthly Statement CSV.\u00a0 We recommend choosing the Activities Export method, but both methods are supported by AdjustedCostBase.ca and there is a settings template available for each one.\u00a0 Depending on your choice, follow either the instructions under Option A (Activities Export)<\/em><\/strong> or Option B (Monthly Statement CSV)<\/strong><\/em> to complete the process of exporting your transaction data.<\/p>\n

Option A: Activities Export from Wealthsimple (Recommended)<\/h3>\n
    \n
  1. Login to your Wealthsimple account through their web interface.\u00a0 Follow the “Activity” link found on the sidebar on the left side of the page.
    \n    \"\"<\/a><\/li>\n
  2. Click on the “Download activities” button.
    \n    \"\"<\/a><\/li>\n
  3. Select the appropriate date range.\u00a0 It should cover the time period spanning back to the last time your importing your transactions into AdjustedCostBase.ca.\u00a0 It’s perfectly fine for the time window to overlap with the time window of the transactions you previously imported into AdjustedCostBase.ca: any duplicate transactions will be automatically flagged and excluded.
    \n    \"\"<\/a><\/li>\n
  4. Select the relevant accounts associated with the portfolio on AdjustedCostBase.ca that you’re working with.\u00a0 Normally you should use a portfolio to represent all your transactions across all your personal non-registered accounts, so make sure you select them all in this case.\u00a0 Next hit the “Download CSV” button to download your transaction data.
    \n    \"\"<\/a><\/li>\n<\/ol>\n

    Here is an example of the activities export data format:<\/p>\n

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

    Option B: Monthly Statement CSV Export from Wealthsimple<\/h3>\n
      \n
    1. Login to your Wealthsimple account through their web interface (please note that monthly statements are available via Wealthsimple’s mobile app – but only in PDF format rather than the required CSV\/spreadsheet format).\u00a0 Click on your initial on the bottom left of the screen, and then follow the “Documents” link.
      \n      \"\"<\/a><\/li>\n
    2. Find the relevant monthly statements (you can filter by account and by setting the document type filter to “Performance statements” to narrow down your search).\u00a0 Click on the “CSV” links to export your transactions to a spreadsheet file for each month.
      \n      \"\"<\/a><\/li>\n<\/ol>\n

      Upload your Wealthsimple Transactions to AdjustedCostBase.ca<\/h3>\n
        \n
      1. After logging into AdjustedCostBase.ca, click the \u201cTools\u201d link on the top blue menu bar.
        \n        \"AdjustedCostBase.ca<\/a><\/li>\n
      2. Click the \u201cImport Transactions from a Spreadsheet\u201d link.
        \n        \"Import<\/a><\/li>\n
      3. Select either the \u201cWealthsimple Activities Export\u201d or the “Wealthsimple Monthly Statement CSV” settings template (depending on whether you completed the steps under Option A or Option B above) from the list of available library templates and click \u201cLoad Settings Template\u201d.
        \n        \"\"<\/a><\/li>\n
      4. Click on the \u201cClick to browse or drag & drop box\u201d to select the CSV file you downloaded from Wealthsimple (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 either of the Wealthsimple template configurations.
        \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

        And you’re set!\u00a0 Repeat this process again for any other portfolios you have that include transactions from Wealthsimple accounts.\u00a0 And periodically download your latest transaction from Wealthsimple by following the steps outlined above to ensure your transaction records on AdjustedCostBase.ca are complete and accurate.<\/p>\n","protected":false},"excerpt":{"rendered":"

        The following instructions describe how to export your transaction data from Wealthsimple, and subsequently import the data into AdjustedCostBase.ca. Please note that uploading data from a spreadsheet requires an AdjustedCostBase.ca Premium subscription. Wealthsimple provides transaction data in 2 formats: Activities Export and Monthly Statement CSV.\u00a0 We recommend choosing the Activities Export method, but both methods […]<\/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-1710","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\/1710","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=1710"}],"version-history":[{"count":11,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1710\/revisions"}],"predecessor-version":[{"id":1738,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1710\/revisions\/1738"}],"wp:attachment":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/media?parent=1710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/categories?post=1710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/tags?post=1710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}