What's the best way to fix Avg Cost when data does not migrate to new acct?

Question

I have a few key investments that have this same characteristic:

* I bought some shares in a Fidelity IRA - Quicken Windows and Mac have the entire history - Bought in Feb 2019
* Transferred the account's holdings to Merrill - Quicken Windows and Mac have history - transferred into Merrill equiv account in August 2019
* Migrated to Mac
* I then transferred certain equities in this account to a Merrill self directed account for ease of trading in Sept 2020 - and the aggregate shares of a given equity came over as one line item under "Shares Added" at a zero cost.  Instead of having a purchase - # of shares @ X cost plus 4-5 quarters of dividend reinvestments - which were properly captured in items #1 & #2 above.   So - My goal is to rectify this so that I can more truthfully look at the performance of the equity over time regardless of which account it was in originally.
* Would this work:

a) Recreate the original purchase and dividend transactions missing in the newest account? b) Then delete the aggregate transfer transaction?  It's not a lot of labor, and the performance of the equities affected by this are way off base, and it skews the gains performance of the newer account drastically as there is a $0 basis for 90% of the value of the equity

jacobs · Answer

Okay, I thought you created it, but Quicken did. Doesn't matter. You can delete the Add Shares transaction and the Remove Shares transaction from your old account, then do the Transfer Shares from the old to the new, and you'll have multiple Add Shares transactions on one date, but each with it's own Date Acquired to preserve your investment history.

MauryJ · Answer

I've never created any Add Shares or Remove Shares in any account since I started using Quicken. Those were either Quicken interpretations when the transfers occurred or the broker doesn't prepare the data properly (my guess).  The dates for the Adds/Removals was the date of the aggregated transfers, so therefore the date of acquisition and div reinvestments is missing from the newer account

jacobs · Answer

If you want to step back to that date, you can do the transfer between accounts the "right" way: use the transaction type of Transfer Shares. Instead of one Add Shares transaction Quicken will create a series of Remove Shares transactions in the original account, and Add Shares transactions in the destination account, all on the same date, but the Add Shares transactions will have a Date Acquired corresponding to each purchase date in the original account. (You'd have to delete the Add Shares transaction you created manually.) This approach would give you the correct investment history. I suggest if you want to try this, that you make a backup of your file before starting, so if things get messed up, you can quickly revert to the backup.