Merging securities

nealagogol's Avatar


07 Dec, 2017 07:01 PM

How do you merge two security names? I have found the same security duplicated in my files. Same security with different names in different investment accounts. How do I merge them?

  1. 1 Posted by Tom Freeman on 08 Dec, 2017 11:46 PM

    Tom Freeman's Avatar

    There is no current way to merge securities. If you are using MD 2015, you can edit the transactions to the appropriate security name without changing the security.

    How were these transactions entered in moneydance, manually, imported, or direct download. We can clean up the current discrepancies, but depending how they were entered they may keep re-occurring.

    If I know how the transactions are coming into MD I can better advise on how to fix the issue going forward.

    Tom Freeman
    Infinite Kind Support

  2. 2 Posted by tedhuntley on 17 Dec, 2017 03:49 PM

    tedhuntley's Avatar

    I am having similar problem. All transactions are entered by hand. I have 2 different accounts holding the same security but for reasons lost to the mists of time I set them up as 2 different securities. I tried editing the transactions in 1 account to change the security and MD can no longer calculate the cost basis.
    MD 2017.5 (1639)
    Mac High Sierra
    Screen shot of cost basis report attached. There should be 25 years of cost basis here

  3. 3 Posted by Christopher on 18 Dec, 2017 03:12 AM

    Christopher's Avatar

    Recently I worked through this issue after moving to MD 2017 from Quicken on Mac. Quicken forced securities to be designated either taxable or not, so I named the same security different depending on if it was in taxable or not. So to undo that in MD:

    1. In a non-taxable account register, sort transactions by the security to be merged, replacing it with the security name used for the taxable account. This is to prevent upsetting lots in the taxable account.

    2. Verify there are no transactions using the name that is being replaced before deleting it from the securities list.

    3. In the securities list rename the one you’re keeping, if desired.

    Hope that helps.

  4. 4 Posted by Tom Freeman on 31 Dec, 2017 09:07 PM

    Tom Freeman's Avatar

    This happens somewhat frequently when downloading from multiple brokers. Different brokers will sometimes fill in the security ID differently and if not caught will create two unique securities within MD. Part of the download process, is if MD does not recognize the security, to prompt for a security match or none of the above.

    Christoper's fix is a good suggestion. On the next download into the edited account MD may not recognize the downloaded security as the edited security and you should be able to match it with the recent edit and after that subsequent downloads should recognize the correct security.

    Tom Freeman
    Infinite Kind Support

  5. System closed this discussion on 01 Apr, 2018 09:10 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac