The spreadsheet importing functionality on AdjustedCostBase.ca enables you to easily import your transactions from your Questrade account. We provide a settings template that is fully compatible with the Microsoft Excel spreadsheet files that Questrade produces. Importing your transactions is simple—just follow the instructions below.
Please note that importing data from a spreadsheet requires an active subscription to AdjustedCostBase.ca Premium.
Download your data from Questrade
- Log in to your Questrade account using the web interface.
- Click on the “Reports” link on the top menu bar (highlighted in red in the screenshot below).
- Click on the “See all transaction history” button (highlighted in red in the screenshot above).
- Important: Filter the transactions to include only your non-registered/cash account. You should not include transactions from your registered accounts when uploading transactions to a portfolio corresponding to your personal non-registered accounts. This can be done by clicking on the link for your cash account (highlighted in red in the screenshot below).
- 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 “Export to Excel” link to save your transaction data to a local spreadsheet file.
Exported Excel spreadsheet example:
Upload your Questrade Transactions to AdjustedCostBase.ca
Now that you’ve exported your relevant transactions from Questrade to a spreadsheet file, you’re ready to import the data into AdjustedCostBase.ca. You can do so with the following steps:
- 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 “Questrade” 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 Excel file you downloaded from Questrade (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 Questrade 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 “Import Transactions” to finalize the data import.
