How to Merge Securities in Quicken Classic for Windows

aDail

I have recently changed brokerages and I find that I now have duplicate securities with slightly different names and for the Symbol field one brokerage used the ticker symbol and the other used the CUSIP ID. Is there a way to merge the two securities so I don't lose the history or do I need to manually swap the securities in the brokerage that has the least number of transactions?

Quicken Classic for Windows Version R64.35 Build 27.1.64.35 (Windows 11 Home)

Quicken Anja

Hello @aDail,

Thanks for your question! At this time, merging securities is only available in Quicken Classic for Mac, and unfortunately, that feature isn’t available in the Windows version.

If you’d like to request this feature for Windows, a great option is to create an Idea post in the Quicken Community. This allows other users who have the same or a similar request to vote on your idea. Our Development and Product teams often review these Idea posts when considering improvements and new features for Quicken, so submitting one can help bring attention to this request.

In the meantime, please review this Community Thread where our SuperUsers provide some helpful insights.

I hope this helps!

q_lurker

I have recently changed brokerages and I find that I now have duplicate securities with slightly different names and for the Symbol field one brokerage used the ticker symbol and the other used the CUSIP ID. Is there a way to merge the two securities so I don't lose the history or do I need to manually swap the securities in the brokerage that has the least number of transactions?

In my opinion, to maintain history properly, the first step is to use the "Shares Transferred between accounts" function to remove the shares from the old account and add them to the new account. That process will maintain the cost basis and acquisition date of each lot of each security.

Short of restoring a backup from before you took your approach, I would:

• Delete the transactions that removed holdings from your old account.
• Delete the transactions that added shares of your holdings into the new account.
• Use the Share Transferred function to make the transfer.
• Edit any other transactions in the new account to properly reference the securities as had been referenced in the old account.
• From the Security List, delete the now unused securities as named by the new brokerage.
• On your next download from the new brokerage, make sure the securities they are downloading are properly matched to the securities already in your file.
• Also, make sure the securities use the proper ticker symbol as applicable. The ticker is not applicable for individual bonds and the CUSIP may be used for those. The CUSIP is not a suitable symbol for tradeable securities (stocks, mutual funds, ETFs, etc.).

aDail

@q_lurker It ends up that your suggestion, although it will be a bit time consuming to complete, is my best approach. Thank you for your assistance!