Everything CRA wants to see, laid out to match S3-F6-C1. Export to CSV for your accountant.
Commingling
CLEAN
No personal charges on HELOC
Direct-use test
PASS
Every draw traced to investment
Holdings
QUALIFY
All income-producing
Docs retained
36/36
Complete through this year
Year
Event type
Export
Date
Event
Account
Amount
Link
Receipt
Deductible
2026-04-01
Mortgage payment
Mortgage sub-acct
-1,461.48
Principal: 339.12
Statement
N/A
2026-04-01
HELOC re-advance
HELOC sub-acct
+339.12 limit
Auto
Statement
N/A
2026-04-02
HELOC draw
HELOC sub-acct
-339.12
Transfer to Brokerage
Transfer confirm
Yes
2026-04-02
Brokerage deposit
Brokerage NR
+339.12
From HELOC
Statement
N/A
2026-04-02
Trade: 10 VDY
Brokerage NR
-335.00
VDY @ 33.50
Trade confirm 8472
N/A
2026-04-15
Dividend: VDY
Brokerage NR
+3.40
42 shares x 0.081
T5 2026
N/A
2026-04-16
Sweep to chequing
Chequing
+3.40
From Brokerage
Statement
N/A
2026-04-16
Mortgage prepayment
Mortgage sub-acct
-3.40
From Chequing
Statement
N/A
2026-04-30
HELOC interest
HELOC sub-acct
+7.50 capitalized
Auto, 6.5%/yr pro-rated
Statement
Yes
HELOC interest (ours)
1,184.22
Sum of monthly capitalizations
Lender T5
1,184.22
Reconciles
Investment income (taxable)
132.40
Dividends grossed up 1.38x
Quebec allowed deduction
132.40
+1,051.82 to carryforward
You would be able to produce:
Every HELOC statement (36 months retained)
Every brokerage statement (36 months retained)
Every trade confirmation (127 total)
Every T5/T3 slip (6 total: 2 from lender, 4 from brokerage)
Three annual reconciliation spreadsheets
Investment policy statement, dated 2024-02-14
Filed T1 with line 22100 and Schedule N for 2024, 2025
If we ever detect contamination
Example: a personal charge appearing on the HELOC sub-account, or a non-HELOC deposit in the brokerage. You will see a red banner here. The strategy can often be salvaged, but only if caught quickly. Do not wait for the accountant to flag it.