📊 Portfolio Calculator — FamilyFunds Portfolio Calculator

Step-by-step tax report with live P/L calculations

Step 1: Upload Your CSV

Choose your RBC or brokerage CSV file. The system will detect issues automatically.

Fix missing buys/sells, adjust data, and approve final results in one place.

Missing/Unmatched: 0 · Ignored: 0

Symbol	Currency	Buy Qty	Buy Price	Sell Qty	Sell Price	Missing Side	Fill Date	Fill Qty	Fill Price	Action
✓ All positions are matched

Change one symbol to another (e.g., SQ → XYZ).

Applied Corrections (0):

None

Used items only.

None

Combined results in one table, plus CAD-only cash totals.

Fee mode in use: Manual

Setting	Description	Inputs
Fee Mode	Choose whether fees are entered manually (total per year) or calculated automatically (per trade).	Manual Auto (per trade)
Manual Fees	Enter a yearly total for fees (used only when fee mode is Manual).
CAD Fee Rate	CAD transactions fee rate per trade (used when fee mode is Auto).
USD Fee Rate	USD transactions fee rate per trade (used when fee mode is Auto).
USD → CAD FX	Exchange rate used to convert USD fees/taxes/dividends into CAD totals.

	calc.th_all_years	2024	2025
Realized P/L	+0.00	+0.00	+0.00
P/L %	0.00%	0.00%	0.00%
Fees	0.00	0.00	0.00
Auto Fees (CAD)	0.00 (trades: 0, rate: 0.00)	0.00 (trades: 0, rate: 0.00)	0.00 (trades: 0, rate: 0.00)
Auto Fees (USD)	0.00 (trades: 0, rate: 0.00)	0.00 (trades: 0, rate: 0.00)	0.00 (trades: 0, rate: 0.00)
Auto Fees (CAD, converted)	0.00	0.00	0.00
Taxes (CAD)	0.00	0.00	0.00
Taxes (USD)	0.00	0.00	0.00
Net Realized P/L	+0.00	+0.00	+0.00
calc.row_net_after_fees	+0.00	+0.00	+0.00
calc.row_net_cad	+0.00	+0.00	+0.00
Dividends (CAD)	0.00	0.00	0.00
Distributions (CAD)	0.00	0.00	0.00
Net Realized P/L (CAD, converted)	+0.00	+0.00	+0.00
Dividends	0.00	0.00	0.00
Distributions	0.00	0.00	0.00
Total Income	0.00	0.00	0.00
CAD Deposits	0.00	0.00	0.00
CAD Withdrawals	0.00	0.00	0.00

All transactions grouped by symbol with buy/sell totals, remaining shares, and P/L.

Symbol	Currency	Buy Qty	Avg Buy	Sell Qty	Avg Sell	Left Qty	Realized P/L	P/L %

No symbol summary