Upload your broker exports
Add an export from a supported broker, or any other broker’s CSV or XLSX through the column mapper.
Best results: upload your complete account history, not just the tax year. Prior years build your correct opening positions and FX balances.
Standard covers up to 2 accounts. Multiple files from the same account are fine; three or more accounts needs Pro.
If an XLSX is an ActiveACB export, make sure it contains only trades not already covered by your broker files.
Custom import
Map the columns in
This file isn’t a recognized broker export. Match its columns to the fields below and we’ll import the trades. Map the Amount column too and dividend, withholding, interest, and FX conversion rows import as well, feeding the income summary and the foreign-currency gain calculation. Rows whose symbol is a standard option symbol are recognized as options automatically, with the quantity read as contracts. Splits and ticker renames have their own row types, though only if you point their action words at them below and leave the affected trades unrestated. Mergers for shares, split-offs, and spinoffs come from named-broker exports or the corporate-action builder after your first calculation. For FX conversions, map only the non-CAD leg of each conversion and point its action word at FX In or FX Out below. Building your own file? Download the starter template (XLSX), which includes a Read Me covering every action word.
Sheets in this workbook
Tick each sheet that holds transactions. Sheets read together must have the same columns, so ticking a sheet with other columns starts over on that sheet. Each sheet has its own currency for rows that name none.
Only needed when your file spells options out in words. If it prints an option symbol like NVDA 261218C00300000, options are detected automatically.
Action words in this file
The dates in this file are ambiguous. Choose Month/Day/Year or Day/Month/Year explicitly before continuing.
Still stuck on the rows that could not be read? Send this file to ActiveACB support and we will look at them. Nothing is sent unless you press the button. We keep the file privately for 30 days, use it only to fix the problem, and then delete it.
Foreign cash held on January 1 (optional)
Didn’t get it?
One-time payment. No subscription, no auto-renewal.
Questions before you get access?
Why can’t I just use my T5008 to file?
You can, but the numbers might be wrong. The CRA’s own T5008 states that Box 20 “may or may not reflect your adjusted cost base.” For a few buy-and-hold trades, it’s usually fine. But if you’ve traded the same stock multiple times, held foreign currency, or dealt with options or corporate actions, your broker’s reported cost base drifts further from reality with every transaction. You’re either overpaying or creating a liability you don’t know about.
What causes my cost base to be wrong?
More than most traders realize. Sell a stock at a loss and rebuy within 30 days? Loss denied, added back to your ACB. Sell shares at a loss then buy a call on the same underlying? ITA s. 54 can treat that call as identical property and deny the loss. Most traders don’t know that rule exists until they get reassessed.
Every USD conversion is a taxable FX event. Options assignments change the ACB of the shares you receive. Splits, spinoffs, and mergers reset your cost base. Each adjustment compounds on the next. Miss one early in the year and every calculation after it is wrong.
How is ActiveACB different from tracking this myself?
You could build a spreadsheet. But superficial loss detection means scanning a 61-day window around every sale. FX tracking means maintaining running pool ACBs for every foreign currency. Options linking means knowing the four-way CRA matrix for premiums. Most spreadsheets break down around trade 50. ActiveACB parses your broker export directly. Upload one file, get your complete report in seconds. No manual entry, no missed trades.
How does this compare to AdjustedCostBase.ca?
AdjustedCostBase.ca is a solid resource with excellent educational content. The difference is how much is done for you. Its Premium plan offers spreadsheet imports with five broker templates and custom templates. Its documented superficial loss workflow warns within one portfolio and asks you to apply the rule. ActiveACB reads seven brokers’ exports directly, offers a column mapper for other trade-history CSV or XLSX files, and calculates supported superficial loss, foreign exchange and ETF adjustments using the accounts and data you supply. See the full comparison.
What CRA rules does the engine handle?
Superficial loss detection with the full CRA three-limiter formula, including cross-account TFSA/RRSP affiliated denial, call options as identical property, and year-end December-to-January look-forward. FX cash pool ACB tracking with the $200 annual net gain or loss exemption for individuals. Options exercise and assignment linking for calls and puts. Corporate actions: splits, mergers, return of capital, name changes, fractional share cash-in-lieu, and standard cost-base spinoffs (taxable spinoffs are flagged for review). Worthless security elections with reversal detection. T1135 foreign property warnings. The project has over 13,000 automated test cases, including CRA edge cases. These are not approximations.
Can I still file with Wealthsimple Tax or TurboTax?
Yes, and that’s the recommended workflow. ActiveACB calculates your correct ACB and capital gains. You take those numbers and enter them into Wealthsimple Tax (free), TurboTax, or give them to your accountant. Calculate with us, file with your preferred tool.
Which brokers are supported?
Interactive Brokers (Flex Query XML), Questrade (Activity Report XLSX), Wealthsimple (Activity Export CSV), CIBC Investor’s Edge (Transaction History CSV), TD Direct Investing (activity CSV), Qtrade Direct Investing (account history XLSX), and National Bank Direct Brokerage (activity history CSV). All seven are parsed directly for trades, dividends and distributions, and the other six also read interest, corporate actions and FX where they apply. The National Bank parser does not yet read interest, withholding, currency conversions, corporate actions or options, as its guide lists. With season access you can upload multiple files from different accounts or brokers in a single session, and ActiveACB's own XLSX export re-imports as well. The engine merges everything and detects cross-account superficial losses automatically. Any other broker's trade-history CSV or XLSX imports through the built-in column mapper. Step-by-step guides and broker-specific T5008 explainers are linked from the export-guide page.
Is my data safe?
Your file is processed in a temporary directory and deleted the moment your report is generated. A copy of each file you add is kept privately for 7 days to improve broker support, then deleted. IBKR files are never kept, and you can turn this off on your profile page. We keep a layout profile of it, the column names and formats with none of your values, to troubleshoot failed uploads, plus a redacted sample of the first rows only if you choose to share one. Calculation results are stored in your account history and you can delete any calculation at any time.
Can I combine multiple brokerage accounts?
Yes, with season access. Click “+ Add files” and select all your exports at once, or add them one at a time, from any mix of supported brokers, ActiveACB exports, and column-mapped files. The engine processes all trades together, pools ACB correctly across accounts, and detects superficial losses across brokers, including cases where you sold in one account and rebought in another.
What tax years are supported?
Any year from 2021 onwards, and for a corporation any fiscal year ending in 2015 or later. For the most accurate results, upload your full trading history from account inception. The engine processes all years chronologically to build correct pooled ACB, but only reports dispositions for your selected tax year.
Want us to look at this file? Send it to ActiveACB support and we will see exactly which rows failed. Nothing is sent unless you press the button. We keep the file privately for 30 days, use it only to fix the problem, and then delete it.
Calculating your taxes…
Tax Summary
Saved to your calculation history for re-download and later edits.
Capital Gains
Distributions received
Interest
FX Gains
Capital dividend account and investment income
ETF tax factor sync
Review ACB adjustments
Verified issuer data is applied on each distribution record date using the taxable units held then. Reconcile these annual per-unit totals with your issuer statement and T3 Box 42 before filing. Capital gains in T3 Box 21 are not automatically treated as non-cash distributions.
| ETF | Coverage | Annual ROC per unit | Annual non-cash distribution per unit | Source |
|---|
Enter per-unit amounts, not T3 dollar totals. For missing issuer data, verify the effective distribution date before using a manual annual adjustment.
Manual adjustment
Edit trades
Edit, delete, or add trades. Changes apply only to this calculation. Your original broker file is not modified.
Corporate actions
User-entered facts
Trades on the same day are applied top to bottom. An added trade, or one moved to another day, goes last in its day, and Up and Down change the order within a day.
| Date | Settlement | Symbol | Type | Action | Qty | Price (CAD) | Comm (CAD) | Currency | FX rate | Account | Broker | Actions |
|---|
Advanced fields
A new date gives the trade the standard settlement date of that day (auto until you recalculate) unless you type one, and a trade in another currency is priced again at the Bank of Canada rate of its new settlement date. A new FX rate converts the CAD price and commission again unless you change them in the same edit. A symbol you type joins the listing this calculation already holds, and an added trade of an option it holds takes that contract’s terms, so enter its price per share. Multiplier, description and option fields are otherwise kept. Only trades can be entered here. Dividends, interest, fees and cash movements come from your broker file.
Dispositions
| Date | Symbol | Type | Qty | Proceeds | ACB | Gain / Loss | Superficial |
|---|
Give $10. Get $10.
Your friend gets $10 off their first Standard or Pro season. You get $10 credit when they buy.
