Upload your broker exports
One row per file · IBKR, Questrade, Wealthsimple, ActiveACB XLSX, or any broker CSV/XLSX
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.
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.
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 workflow. Their platform relies on manual entry or basic spreadsheet imports. For 20 transactions a year, that works. For 200 or 2,000, it’s a full-day project with a high chance of errors. ActiveACB parses your broker export file directly. Nothing to type, nothing to miss.
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 engine runs over 2,800 automated tests against real 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), and Wealthsimple (Activity Export CSV). All are parsed directly, including trades, dividends, interest, corporate actions, and FX where applicable. 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; the uploaded file itself is never retained. 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 file(s)” and select all your exports at once, or add them one at a time, from multiple IBKR, Questrade, Wealthsimple, ActiveACB-export, or column-mapped accounts. 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. 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.
Calculating your taxes…
Tax Summary
Saved to your calculation history for re-download and later edits.
Capital Gains
Distributions received
Interest
FX Gains
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
| Date | Symbol | Action | Qty | Price (CAD) | Comm (CAD) | Currency | FX rate | Account | Broker | Actions |
|---|
Advanced fields
Asset type, multiplier, description, settlement date, and option fields are preserved during inline edits.
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.
