Security Search in Cost Basis v5117
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.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | 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
1 Posted by Stuart Beesley ... on 17 Apr, 2024 05:06 PM
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 Posted by Henry Sully on 17 Apr, 2024 07:13 PM
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 Posted by Stuart Beesley ... on 17 Apr, 2024 07:28 PM
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 Posted by HH Sully-Gmail on 17 Apr, 2024 09:16 PM
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 Posted by Stuart Beesley ... on 18 Apr, 2024 08:17 AM
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 Posted by HH Sully-Gmail on 18 Apr, 2024 12:45 PM
How does a user create a bug report / feature request? Or is this it?
Thanks,
Henry
7 Posted by Stuart Beesley ... on 18 Apr, 2024 12:48 PM
This is kind of it, but really you want support to chime in and agree/acknowledge. Regardless, I have onward reported it.
System closed this discussion on 18 Jul, 2024 12:50 PM.