In 2018 my broker transferred all stocks from one account to another in kind with a different brokerage firm.
To enter these transactions I used the SymbolTransferOut transaction type and specified Qty and Price.
Total TransferOut amount was $361,522. Total Cost Basis was -$296,398 as shown in the TransInfo worksheet.
But when I run a report in PowerBi, it shows me a Capital Gain loss of -$373,653.
Total Value and Cost Basis for that account come out as zero (as expected?).
CapGain in that account before the transfer was correct and is also correct in the new account that I transferred into.
Since the CapGain loss is close to the TransferOut amount, I suspect that somehow the Start Value of the TransferOut Account is wrong. Must be close to zero. In the Yearly Movements table (Yearly worksheet), the amount shows up as a negative deposit of -$379,772 which results in a CapGain Loss of (only) -$12,131.
So why am I getting two different results between PowerSlicer and PowerBI and what could explain the large CapitalGain loss shown in PowerBI?
Thanks for any advice you might have.