How is "Amount Income" calculated in Investing page ?

Question

I was with HSBC Canada and was migrated to RBC. I transferred investment accounts in Quicken from HSBC to RBC accounts. After the Quicken transfer, the Amount Income on Investing page only shows Income Amount since the transfer date; the Income Amount prior to account transfer date has not been carried over.

How can I fix ?

Chris_QPW · Answer

Since this is calculated using the transactions what gets calculated will depend on how the view is grouped and what accounts are selected.  If group by security and include both accounts then it should have the transactions it needs to calculate the Amount Income.

BeeGeeWeeGee · Answer

Thanks for your explanation, Chris,

Yes I used the Transfer Securities feature. I wanted to differentiate the history from each account. The transactions for each security in the old HSBC and transferred RBC accounts are all intact. I have some securities in 2 or more separate accounts and the Income Amounts appear to be calculated by summing the transactions in the separate accounts -True for HSBC accounts and RBC accounts , but NOT for HSBC + RBC   - Why ??

What would be nice would be to have a Security object that tracks the "Amount Income" and "Return" for each Security.

Chris_QPW · Answer

How did you transfer the accounts?

If everything is transferred, if you don't mind not having the old "HSBC Canada" account the easiest way to do this just deactivate the account for downloading and then rename it and reconnect it with RBC.

I suspect though that you used the "Transfer securities" action.  What that does is put remove share transactions in the old account and add shares in the new account with the cost basis filled in. This makes the cost basis right, but the "Amount Income" and other fields like "Return" are calculated from the transactions.  And now that you are in a new account those transactions aren't there when looking at the new account.