handling of ESPP v. RSU v. ~ "regular purchase" shares
For the same stock (CMCSA) I have shares accumulated from ESPP, restricted stock awards (RSU), and generic purchases that carried over from my transfer from Quicken.
While there's a need to be able to identify the different types of shares/purchases (for tax purposes) I also need to see only one list of all CMCSA lots when I go to sell the shares (regardless of how I obtained the shares). For example, I just did a sale where in one transaction with Fidelity I sold both ESPP-obtained shares as well as some restricted stock shares.
As you can see in the attached screenshot, when I look at my portfolio MD seems to track three different CMCSA securities (based on I assume a combo of security name + suffix)... even though all are in the end CMCSA shares. The extends to the drop-down where I select which share I sold. Right now to track the recent sale referred to above I would have to create two different sales in MD - one for the ESPP shares sold and another for the restricted stock shares.
Is there some way to be able to ID ESPP v. restricted versus regularly-purchased share yet have them all be the same single security when I go to sell? Fidelity does not treat it as two different sales so I feel I should be able to track as a single sale in MD as well.
(I can imagine in an ideal world when I go to sell it shows ALL of my CMCSA shares but maybe has an add'l column that shows the prefix or suffix info?)
-
2023-01-20_14_07_18-.png
1000 KB
2023-01-20_14_07_18-.png
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 23 Jan, 2023 09:44 AM
You clearly have three separate securities on Tools/Securities.. MD will do nothing to show these as one.. As far as it's concerned you have three different securities...
The 'proper' way to do this is to have one security and then three different investment accounts.. These can all hold the same security, but they can each be managed differently..
Are these 'paper' securities, or held in an account somewhere?
2 Posted by Greg Bonawitz on 23 Jan, 2023 12:50 PM
Hi. Thanks a lot for replying!
These are all securities that are held in ONE investment account at
Fidelity. In fact if I go to sell CMCSA the website show all 3 types in
one list (I.e. I have only 1 security)... With the different lots having a
different notation in a column called "source" - which here is not
different accounts at Fidelity but rather the type of purchase, i.e. ESPP,
restricted stock, or from an options exercise.
I completely understand that right now MD "sees" 3 different securities
because of the differences in prefix, suffix, and other fields from "Edit
Security" and that I have counts for each. Based on my reading of Help
content, however, aren't the prefix and suffix fields meant to delineate
for this type of situation?
I have only account with Fidelity.
They tell me I have only one security with total X...
...even though X is comprised of A ESPP shares + B restricted shares + C
shares from options exercised.
I was thinking perhaps from a MD list of securities POV it could still have
3 (in order to keep track of the ESPP v options v restricted stock,) but
when I go to sell MD could provide a combined list since at the end of the
day they're all CMCSA? That would match how Fidelity handled it (and I
assume how other brokerages do too).
Sent from my mobile device.
Please excuse any typos or brevity
3 Posted by Greg Bonawitz on 23 Jan, 2023 12:50 PM
Hi. Thanks a lot for replying!
These are all securities that are held in ONE investment account at
Fidelity. In fact if I go to sell CMCSA the website show all 3 types in
one list (I.e. I have only 1 security)... With the different lots having a
different notation in a column called "source" - which here is not
different accounts at Fidelity but rather the type of purchase, i.e. ESPP,
restricted stock, or from an options exercise.
I completely understand that right now MD "sees" 3 different securities
because of the differences in prefix, suffix, and other fields from "Edit
Security" and that I have counts for each. Based on my reading of Help
content, however, aren't the prefix and suffix fields meant to delineate
for this type of situation?
I have only account with Fidelity.
They tell me I have only one security with total X...
...even though X is comprised of A ESPP shares + B restricted shares + C
shares from options exercised.
I was thinking perhaps from a MD list of securities POV it could still have
3 (in order to keep track of the ESPP v options v restricted stock,) but
when I go to sell MD could provide a combined list since at the end of the
day they're all CMCSA? That would match how Fidelity handled it (and I
assume how other brokerages do too).
Sent from my mobile device.
Please excuse any typos or brevity
4 Posted by simon on 25 Jan, 2023 09:06 AM
I have exactly the same situation, and record in Moneydance in 3 separate accounts, even if the broker shows one. For unvested shares I then sell and buy into vested account on vest date to record the tax transaction.
If you sell in Fidelity and they show you the source, ie that its from different originating plans, you can record that in each account in MD.
It will make a quick reconciliation of number of shares a bit harder, but much easier to admin in MD.
5 Posted by Stuart Beesley ... on 25 Jan, 2023 09:09 AM
The extract data extension. Option stockglance2020 will help. It totals shares across multiple accounts.
6 Posted by dwg on 25 Jan, 2023 10:03 AM
Having three different security definitions for what is one traded security will cause you pain, we have seen the results of doing that in the past. With Moneydance you really need to have each Ticker only used in one security definition. Moneydance will not stop you defining three identical securities.
Suffix and prefix are more of display options for a security, not to differentiate between different instances of what is really the same security.
I understand the need you have to track the shares you have separately, however there is no provision in Moneydance that would enable the differentiation you need in a single Investment account for the one security. I'm not sure how Fidelity would differentiate them in downloaded data, that could be interesting to see.
The only way of doing it in Moneydance today that I can see is through separate Investment accounts, so the differentiation is being done at the account level instead of the security level.
7 Posted by gbonawitz on 27 Jan, 2023 12:13 AM
Ty for the replies. I went back and look at the actual trade statements from Fidelity, and for whatever reason the single statement had multiple blocks/groups of trades.
"Ahh, they broke ESPP, restricted, and options into distinct trades?" Yes and no: some of the blocks are solely lots of one type (e.g. ESPP)... but some others had a combination of lots comprising of ESPP and options. I can't figure out what they were thinking with splitting it up like that.
It sill doesn't feel 100% right/intuitive to have to use separate accounts (one for each type of stock)... but I see all of the replies pushing as much such I guess it's a situation of "don't question - just accept" :-)
8 Posted by dwg on 27 Jan, 2023 01:39 AM
It is a case of if you need to track what is the same stock in different ways in Moneydance then separate accounts is the only way to do it. The only provision for handling the same stock in different ways in a single account is when using lot matching so each lot is distinguished, on cost basis, but also when selling. But there is no visible way of distinguishing that one lot is different from another in other ways, it is purely for determining things like capital gains on sales