← Back

How to Export Your Qtrade Account History for Tax Calculation

Qtrade Direct Investing keeps every transaction since the account was opened on its Account history screen and lets you download it as an Excel file. Exporting takes a few minutes, and the ACB calculator reads the file directly.

By Published Last reviewed

Part 1

Download Your Qtrade Account History

  1. Sign in at qtrade.ca from a computer. The Qtrade app has an Account history link under its Accounts button, but no export from the app is documented.

  2. From your account summary, select Account history.

  3. Choose your non-registered Canadian-dollar account. Important: leave TFSA, RRSP and other registered accounts out. The export names neither its account nor its currency, so every file is treated as a taxable account in Canadian dollars and every symbol as a TSX listing. Tell support before uploading the US-dollar side of an account.

  4. Request the widest date range, back to the day the account was opened. Important: ACB is cumulative, so one year on its own gives the wrong cost base for anything bought earlier. See the January look-forward note before choosing the end date.

  5. Press Go to refresh the list.

  6. Click the page icon above the history table to download it as an Excel file. The printer icon beside it opens a print view instead.

  7. Repeat steps 3 to 6 for each other non-registered Canadian-dollar account.

Check your file. The layout ActiveACB supports has nine columns. They are Entry Date, Settlement Date, Action, Qty, Symbol, Description, Price, Comm. and Net Amount. Qtrade describes Account history as showing every transaction on the account since inception, including buys, sells, transfers, deposits, stock splits and dividends. The history visible online may exceed what a single download contains, so check the first and last rows of the file against your records.

Part 2

Upload to ActiveACB

  1. Open the calculator.

  2. Add every Qtrade file exactly as it downloaded. Important: do not open and save it in a spreadsheet program first. A re-saved copy can change how dates and quantities are stored.

  3. Run the calculation. Each file is labelled QTRADE XLSX and read directly, with no column mapping.

The calculator recognizes the file by its nine column names, rather than a particular filename or sheet name.

What ActiveACB Reads From Your Qtrade File

BUY and SELL rows take their cash from the Net Amount column. TRUST INC&PARTNERSHP DIST rows are recorded as income under the fund. EFT rows are deposits and withdrawals and change nothing.

Some return of capital rows have no amount. The sample used to develop the parser contains ROC COST ADJ rows with blank amounts. ActiveACB names those unapplied rows and uses return of capital factors where it covers the fund and year. For other holdings, obtain the distribution amounts and dates from the fund or broker and reconcile them with Box 42 of your T3 before entering the missing adjustments. Do not apply an annual total a second time if those distributions are already included.

Internal transfers. Units moved between your own accounts appear as INTERNAL TRANSFER rows with no price. They are listed on the transfers card and neither added to nor removed from your cost base. Upload the other account’s history alongside, or enter the cost in the trade editor.

Commissions changed in October 2025. Qtrade moved to $0 commissions on stocks and ETFs on October 28, 2025, with options at $0.75 a contract. Older rows may include commissions, and other charges can still apply. Use the amounts actually shown in your export. Net Amount is what the calculation uses either way.

Early support, and your file helps. Qtrade support is newer than IBKR, Questrade or Wealthsimple and was built from real customer exports. To keep improving it, each Qtrade file you upload is kept privately for 7 days and then deleted, as the privacy policy describes. You can turn this off on your profile page. Rows the parser does not recognize are never guessed at, and each one is named in your warnings with its row number.

Fill In Older History

If the download stops short of the day the account was opened, or a holding arrived from another firm, the calculator needs those purchases from somewhere else. Upload the earlier broker’s export alongside your Qtrade file, or rebuild the missing buys, sells and other ACB adjustments from your statements and trade confirmations and add them through the trade editor. Purchases alone are not enough.

Came over from Credential Direct? Qtrade told migrated clients their full Credential Direct transaction history would be available through Qtrade’s platform, so the same screen should reach back past the move.

If This Applies to You

Mutual funds post a day late. Qtrade sends fund orders to the fund company at the end of the trading day, and the transaction appears in Account history on the next business day.

Sold at a loss in December? Important: extend the date range at least through January 30 of the following year so January repurchases are included. If that date has not arrived yet, export again after it has passed. Without those rows, the calculator cannot detect superficial losses caused by those repurchases.

Holding accounts at more than one broker? With season access you can upload your Qtrade files alongside a Questrade XLSX, a Wealthsimple CSV or an IBKR Flex Query XML in the same session. The engine pools your ACB across all of them and detects superficial losses that span brokers.

Optional: compare with your T5008. See why your Qtrade T5008 may not reflect your true ACB.

Which Qtrade tax slips should I expect?

For a non-registered account, Qtrade’s Tax Centre put the T5, the T5008 and the Trading Disposition Summary in the week of March 2, 2026 for the 2025 tax year, and the T3 and T5013 in the week of March 31. Quebec residents receive the matching Relevé slips.

The Account history file is still the better source for an adjusted cost base calculation. Request enough history to include the original purchases and all later trades and cost-base changes, then check that the export actually includes them. The slips and the Trading Disposition Summary describe one account for one year, and Qtrade says the book cost on them is not guaranteed.

The schedule comes from Qtrade’s Tax Centre.

Prefer ActiveACB in your Google results. Add activeacb.ca as a preferred source and Google shows you more of our tax guides in your own search results.

Add ActiveACB in Google
Upload Your Account History →