specific lot selection for stock sells

deathrs

I am having a problem with the accuracy of the screen where you specify what stock lot you are selling shares. Here is my story..

I was comparing my Quicken Capital gains report to that of my Broker and while there are always some differences. I decided to look at a specific stock in a specific account at fidelity. The differences stemmed from the fact that my broker's information on selected lots was different than what was in Quicken lot history. Since I manually select which lot for Quicken to use when I reconcile with my brokers sell transaction, they should match. When they don't, that of course creates the difference between the two capital gains reports.

Here is an example of what I found.

I purchased 5.31 shares 8/6/24. Everything matched up correctly. Broker transaction report and holding report matched Quicken transaction report and holding report.

the next transaction date was 1/3/25 of 2.51 shares of the security. Again, all reports agreed. when I looked at the specify lot screen, the previous buy of the 5.31 shares was listed as available. The sale of the 2.51 shares was from another lot, so it didn't affect the 8/6/24 lot. So, all is good at this point.

The next transaction was 3/11/25, a sell of 5.31 shares from the lot dated 8/6/24. All the transaction reports agree and reflect the sell correctly. Now the problem, when I look at the specify lot screen. the 5.31 shares that were available previously, now only reflect 2.8 shares available. In addition, it reflects 2 shares available for lot 7/5/22 and .51 shares available for lot 6/14/22. those were not present in prior screens. So for some reason, Quicken has split the 5.31 shares of lot 8/6/24 into three lots, with no transactions to support it.

I have started back from the beginning and checked every transaction. I have done the validate file and rebuild lot file with no impact or change. I have deleted and reentered the 8/6/24 buy transaction for 5.31 shares with no change. It apparently is something that happened between 1/3/25 and 3/11/25. even though there is no activity reflected on the transaction reports.

In the scheme of things, this is a relatively minor issue, as I would use tax forms from my broker. I just wondering if anyone has a solution or suggestions.

Thank you

q_lurker

a) I'd be looking for a hidden placeholder transaction. Be sure your preference setting include showing hidden transactions.

b) My reading of this is that while accepting or editing the 3/11/25 sale transaction you are not seeing the right lots available. My other thought in these cases is to delete and re-enter the sale transaction. but that does not seem to be necessary here. You might consider going back through historical transactions and deleting / re-entering prior sales.

c) If you enter a sale on any date between 1/3/25 and 3/11/25, do you get the right lot selection options?

You wrote "The next transaction was 3/11/25, a sell of 5.31 shares from the lot dated 8/6/24."

Is this rephrasing also correct? "The next transaction was 3/11/25, a sell of shares that would include the 5.31 shares of the lot dated 8/6/24."  That is the 3/11/25 sale was a bigger sale than just the 5.31 shares. Just want to have a clear understanding.

Tom Young

What you might be facing - I say this because you're buying and selling lots in close proximity to one another - is that you're being affected by the wash sale rules. This is almost a certainty if any of those sales are sales at a loss. The wash sale rules require that you defer the loss and the deferred loss gets added to your basis in the stock, and the broker is following required to make those adjustments, adjustments that, most likely, are not being reported to you, it's all done behind the scenes.

deathrs

q_lunker : I went back and reread my comments, I should have been a little more clear.

8/6/24- the buy of 5.31 shares is correct on all reporting.

1/3/25- the next transaction, was a sell transaction of 2.51 shares, but from another lot it was ok and all report agreed. when I look at the "specify lot screen" to the lot (12/15/16) for the 2.51 shares was correct and I could see that the 5.31 shares from the 8/6/24 was available. So, all good.

3/11/25- was the next transaction for a sell of 5.31 shares of lot 8/6/24. when I go to the specify lot screen, now it only shows 2.8 shares available for lot 8/6/24 instead of the 5.31 shares that was reflected on the screen on 1/3/25. there were no transactions listed at the broker or in quicken between 1/3/25 and 3/11/25. In addition to the change of shares available for lot 8/6/25, the screen also reflects 2 shares for lot 7/5/22 and .51 shares for lot 6/14/22, these were there 1/3/25. When you total them, they equal the 5.31 shares.

There were two transactions after the 3/11/25 on 4/14/25 and 5/6/25 and they are correct.

I did a test as you suggested, I entered a sell and a buy transaction between 1/3/25 and 3/11/25 and they both appeared correct on the specify lot screen. I did delete and renter the transaction, but only from 8/6/24. there was no change. when I have a moment to "play" I'll start from the beginning. That is 2016, so would take a while. I don't see any placeholders, splits, or odd transactions and the show hidden transactions box is checked.

Tom Young: I understand what you are saying about the "wash sale rule", that would affect the cost basis. This would be reflected in the cost basis dollar per share. The basis per share seems to be correct when compared to my broker and transaction in Quicken. I think Quicken would adjust the cost per share and not the share count, if it sees a different cost basis.

At any rate, I appreciate both of your suggestions, and will keep looking.

Thanks

deathrs

sorry guys I can't type, q_lunker in my update commentary, the 3/11/25 paragraph should have read,

the screen also reflects 2 shares for lot 7/5/22 and .51 shares for lot 6/14/22, these were NOT there 1/3/25. When you total them, they equal the 5.31 shares.

sorry for the confusion…

q_lurker

As far as I am concerned, delete and reentry apply to sales only. The principle, in my mind is that if somehow the sale tags the wrong lots, deleting the sale clears that error. If one went to the extreme and deleted all sales, one could then start from scratch on assigning lots. I am not pushing that as advice though - to delete all sales.

Another aspect to recognize is the consideration of sequence of entry and date of transaction. Suppose you have three lots 1, 2, and 3) on March 1. You enter a sale dated May 1 specifying lot 2. You then enter a sale dated April 1. Lot 2 will not be available for the earlier April sale because the later May sale has already spoken for that lot even though logically the April sale could have used lot 2. That can lead to needing to at least edit all subsequent sales to use the default lot assignment (no lot specification), and then progressively move through old sales to new sales matching the desired lot assignments. Again, I can’t tell if that sort of sequence might be a factor for you or not, but I wanted you to be cognizant of the possibility.

deathrs

I will keep playing with it. There is something in the logic that is playing with the specify lot screen. lots available disappear with no apparent reason and then reappear at a future date. This makes me think that you are correct. There is something happening when there are multiple sell transactions on the same date. Somehow Quicken logic to reserve a lot quantities and get confused if I manually select a different lot. i will keep looking.

Thanks