Security Search in Cost Basis v5117

Henry Sully's Avatar

Henry Sully

17 Apr, 2024 04:26 PM

Just upgraded to 5117. When searching by security in the cost basis reports, I am seeing two problems.

1) Typing in the security search box the description of the security does not find all the instances of that security. It may find it in one account, but not all accounts. And you cannot select both "Account" and "By security" at the same time.

2) Using the pull down search function reveals a long list of securities that seem to be sorted by both "Account" and by "Security description" in alphabetical order, which is good. However, not all the security/account combinations that I am searching for are present in the list. For example, I may have four accounts and for three of those account there is IBM found. But not in the fourth. Selecting IBM an any account will produce a report that contains all four accounts with IBM. But I really only wanted to see IBM in the fourth account.

Therefore, the only option I seem to have left to find the security from the account I am looking for is to select the "Account" and hit OK, which then lists all of the securities in that account in the report that is generated, which is good. But I don't want to have to scroll through the entire account in this way to view the one security whose cost basis I am interested it. There could be 100 securities in one account.

So, it seems that something may be broken here or maybe this is the way it is supposed to work?
Being able to select both the account and the security would seem to have a big advantage. I have 12 investment accounts and hundreds of securities. That may sound like a lot, but if you have a spouse, and you have taxable, roths, ira, and 401k, there can be a lot of accounts piling up and a financial advisor likes to diversify in each account and many of the same securities reside in multiple accounts. This is real world for me.

  1. 1 Posted by Stuart Beesley ... on 17 Apr, 2024 05:06 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    It's certainly clunky...

    I believe you can do this... First, select by Account and select any account with the security you want.. Then switch to security and select the security... I believe when you run the report it will select all Securities that match the one you selected in all accounts..

    Let me know?

  2. 2 Posted by Henry Sully on 17 Apr, 2024 07:13 PM

    Henry Sully's Avatar

    Hi Stuart. Yes you are correct. But I already mentioned that (basically) in #2 above. The problem I wanted to avoid is having a report of one security in all the accounts. Maybe I didn't make it clear above. What I am after is to have one security in only the one account of interest. I really do have many accounts that have the same security in those accounts. So, if I pick by security only, then I get cost basis for every account where this security is owned.

    I failed to mention this too, but cost basis can change many times beyond my control. Each time I get a 1099-DIV it may list a lot of dividends that got updated in the year from an ordinary dividend to a return of capital. ROC means that the cost basis is affected. So I have to go in an do sellxfr at current basis and buyxfr at new basis. Then I need a way to check it all out in the cost basis report for that particular security in that particular account. Otherwise when I go to sell, my cap gains are all wrong. The reports are handy but potentially they could be much handy with what seems like a minor update (IMO). In my case I spend a whole lot of time chasing this kind of thing. Every time there is merger, etc., you get this kind of thing too. And when you have multiple lots in an account it gets very difficult. I need the tools to work better or I spend many more hours on this than it should really be taking. Thanks.

  3. 3 Posted by Stuart Beesley ... on 17 Apr, 2024 07:28 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok, so can you not just select the account option and in there, within the account in question, can you not just select that security there? I believe if you do this, it should be just that one?

  4. 4 Posted by HH Sully-Gmail on 17 Apr, 2024 09:16 PM

    HH Sully-Gmail's Avatar

    Well, it does not seem like I can do it in that way that you described (if I
    understand correctly).

    There are only three possible choices to select (All investment accounts,
    account or by security), but only one of the three can be selected at any given
    time. If we don't select Account, then it is greyed out and I cannot enter
    anything in that box. If it is selected, it will not let me type in the security
    name. It will only let me select the account.  If "By Security" is selected,
    then I can only enter the name of the security, or use the pull down. But in any
    event, when I type or select the security for that particular box, then what I
    get in the report is every instance of that security that happens to be in there
    for as many investment accounts that I have setup in Moneydance.  I can see that
    the account I selected in the account box still shows a particular account (it
    is grey, but still there), but the report ignores this and just puts the
    security from all the accounts into the report.

    -Henry Sully

  5. 5 Posted by Stuart Beesley ... on 18 Apr, 2024 08:17 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Yes, you are right... You do not seem to be able to select a single account's security.. This needs to be a bug report / feature request...

  6. 6 Posted by HH Sully-Gmail on 18 Apr, 2024 12:45 PM

    HH Sully-Gmail's Avatar

    How does a user create a bug report / feature request? Or is this it?



  7. 7 Posted by Stuart Beesley ... on 18 Apr, 2024 12:48 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    This is kind of it, but really you want support to chime in and agree/acknowledge. Regardless, I have onward reported it.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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