Not financial or tax advice. Money Badger Mafia is a personal portfolio tracker, not a financial advisor, tax professional, or registered investment adviser. Every number here — prices, yields, ACB, tax estimates, CRA line items — is only as accurate as what you type in or import. Miss a slip, mis-key a box, or import a stale statement and the output will be wrong even though the math is right. Nothing here is filed, reviewed, or blessed by the CRA. Check your own paperwork and have a qualified tax professional verify everything before you file or make a money decision.
Read before you file
This worksheet is a draft aid, not a filed return. It calculates off the T4s, slips, trades, distributions and receipts you entered — so it is only as accurate as that information. Missing slips, wrong boxes, duplicate imports, or an out-of-date brokerage statement will produce a confident-looking but incorrect result. Tax rules also change and edge cases (residency, spousal transfers, carry-forwards, foreign reporting, Quebec TP-1) may not be covered. Reconcile every figure against your official slips and have a qualified accountant or tax professional review it before submitting anything to the CRA. You are responsible for what you file.
Cumulative tax saved vs taking it as wages
0 years counted · 0 with a filed T4 · $0 of distributions
No income years on the book yet.
Each year stacks the distributions on that year's filed employment income, then prices the same dollars as extra salary including CPP and EI. Estimate, not advice.
One year, one place: the quick boxes, scanned T4s and every other slip.
Driving every number below: $0 of wages (typed box 14), payroll from typed boxes. A scanned slip always beats the typed boxes.
Pull T3/T5 per-unit factors from CDS by ticker, CUSIP and fund name for the tax year you pick (or all years 2019–2026). ROC cuts ACB. Not a T-slip.
Batch sweep · whole book
0 names in scope
Fetch looks up CDS T3/T5 for the ticker, then fills the boxes off the filing. US names usually have no T3 — enter boxes from your slip. Apply tags every non-registered print that year (units × per-unit); ROC grinds the ACB down.
Pick a tax year — boxes are kept per year and applied across that year's non-registered prints.
No non-registered prints in 2026 — boxes will save but won't land on anything.
What the distributions actually cost, next to the same cash paid as wages on its own.
2026
AB
Take $0.00 · taxable $0.00 · print boxes
Canadian eligible
$0.00
Gross-up 38% · federal + provincial DTC
taxable $0.00 · tax $0.00 · 0.00%
Foreign income
$0.00
Ordinary income · FTC on withheld
taxable $0.00 · tax $0.00 · 0.00%
Other income
$0.00
Ordinary income (T3 other / untagged)
taxable $0.00 · tax $0.00 · 0.00%
Capital gains
$0.00
50% included
taxable $0.00 · tax $0.00 · 0.00%
Return of capital
$0.00
Not income · reduces ACB
taxable $0.00 · tax $0.00 · 0.00%
Tax on the take
$0.00
Fed $0.00 · AB $0.00 · nil — under personal amounts
If that cash were T4
$0.00
Fed $0.00 · AB $0.00 · CPP $0.00 · EI $0.00
Take cheaper by $0.00 vs wages
T4 column treats the Take as standalone salary — CPP/EI are calculated on that cash alone.
Fetch or enter T3/T5 so ROC and eligible are not taxed as wages. Line 22100 uses The Bookie investment-book interest actually paid in that year (cash basis). Personal borrowing is excluded. Not advice.
TFSA and line 22100 for 2026.
- Eligible grossed up 38% then DTC applied. Capital gains 50% inclusion. ROC is not income.
- Employment income stacked under the investment income: $0 (typed box 14). Total 2026 tax: $0 · marginal 0.00%.
- TFSA CAD Take off the T1: $0.
- TFSA US prints withheld 15%, no FTC: $0.
- Line 22100 claimed: $0 (investment book only).
Employment income only for 2026. What the job owes before a single distribution lands.
| Employment income (box 14) | $0 |
| Income tax on wages alone | $0 |
| CPP withheld (box 16) | $0 |
| EI withheld (box 18) | $0 |
| Income tax deducted (box 22) | $0 |
| Personal effective rate | — |
| All-in burden (tax + CPP + EI) | — |
Wages and the Take stacked, with line 22100 working for 2026.
| Tax on wages | $0 |
| Tax on the Take (stacked on top) | $0 |
| Combined tax before 22100 | $0 |
| Line 22100 interest claimed | $0 |
| Tax saved by 22100 | −$0 |
| Combined tax owed | $0 |
| Less tax already deducted | $0 |
| Refund | $0 |
Marginal 0.00% · average 0.00%. Savings are the difference the margin interest deduction makes at your stacked bracket. Not a T1, not advice.
Same $0 of 2026 cash, earned two ways.
If it came as salary
$0
0.00% all-in · incl. $0 CPP/EI
As the Take
$0
0.00% · no CPP, no EI
| Gross cash from the book | $0 |
| Of which return of capital (untaxed) | $0 |
| Income tax as salary | $0 |
| CPP + EI as salary | $0 |
| Tax as investment income | $0 |
| Kept by earning it this way | $0 |
This compares the Take standing alone — no employment income added. The edge comes from the dividend tax credit, the 50% capital-gain inclusion, ROC being deferred, and no payroll deductions. Not a T1, not advice.
Margin borrowing, the 22100 carry read and the Smith Manoeuvre now live on their own tab.
Filled from your T4s, other slips, distributions, dispositions and the loan interest you actually paid. Every line is editable — a hand-typed figure sticks, the rest keep tracking the book.
Read before you file
This worksheet is a draft aid, not a filed return. It calculates off the T4s, slips, trades, distributions and receipts you entered — so it is only as accurate as that information. Missing slips, wrong boxes, duplicate imports, or an out-of-date brokerage statement will produce a confident-looking but incorrect result. Tax rules also change and edge cases (residency, spousal transfers, carry-forwards, foreign reporting, Quebec TP-1) may not be covered. Reconcile every figure against your official slips and have a qualified accountant or tax professional review it before submitting anything to the CRA. You are responsible for what you file.
Lines 10100–15000
T4 box 14, every employer · book says $0.00
Tips, casual work, foreign wages · book says $0.00
T4A(OAS) box 18 · book says $0.00
T4A(P) box 20 · book says $0.00
T4A / T4RIF pension boxes · book says $0.00
T4E box 14 · book says $0.00
T5 box 24 / T3 box 49 — grossed up 38% at line 12000 · book says $0.00
T5 box 10 / T3 box 23 — grossed up 15% · book says $0.00
T5 box 13, T3 other income · book says $0.00
Included in 12100; supports the T2209 credit · book says $0.00
Withheld at source — T2209 foreign tax credit · book says $0.00
Schedule 3: dispositions + T3 box 21 + ROC past nil ACB · book says $0.00
T4A, T4RSP, T5007 and anything else reported · book says $0.00
Not saved yet. Worksheet only — not a CRA-certified return. Check every line against your slips before filing.
Every advance and payment splits the year into periods. Each period carries the balance that actually stood during it, at actual/365 daily accrual.
No draws or payments on the book yet — add a lot on The line and the schedule builds itself.
Line 22100 (paid basis): $0.00 · personal interest excluded $0.00
Open the print copy and use your browser's Print → Save as PDF for the filing binder.
The table above is accrual — what the days earned. It is a tracking record, not a claim. Line 22100 carries the interest actually paid during the tax year on the investment book (paragraph 20(1)(c), cash basis). Interest still outstanding at December 31 becomes deductible in the year you pay it.
Voluntary tip — no goods or services are provided.
If you enjoy this app and find it helpful please provide a small token of appreciation to allow me to continue making it greater and more useful. Onwards and Upwards my Friends. Thank You Greatly!
Interac e-Transfer
No card, no processor, no fees. Send any amount from your bank's e-Transfer screen to:
srtriggs@wealthsimple.meAutodeposit is on, so no security question is needed. Put your sign-in email in the message so the coffee gets credited to your book.
This is a tip, not a purchase. Every desk in the app stays unlocked either way.