@Charlie F Another recollection — I have seen cases where editing a transaction from one action-type to another does not produce the same result as a new entry. Suspect behavior is that some nuances of the original transaction carry over to the edited transactions when they are not aplicable. I won't swear that applies here, but it might.
So if you had a maybe a MiscInc transaction with the Other Income:Non-taxable category applied to it, and then edited that transactions to be a RtrnCap transaction, the original category might have been carried over when it should have been erased. The only way to clear such an erroneous edit carryover was (is) to delete the original and enter a new transaction.
Plausible in your case?
ROC should have been applied to all lots. How is it wrong?
Also, what Q product are you running and what BUILD of that product?
You're too cryptic. ELABORATE. And answer my questions!
If you only have 4 lots then the way to address this is to do a Remove of all shares of BRW, then do 4 Adds to get the lots reestablished in Quicken, using the correct Acquired date and basis for each lot. Back up before doing this, just in case.
" I was thinking move the ROC dates around that 1 trade to force Q to not give it the part of 2 ROC instead of the one it should. "
That might work too. The reverse split shouldn't be a problem. Even so, back up and you may want to figure, outside of Quicken, what the end results should be and then compare Quicken to that. Of couse another approach is "ive with it" if, overall, your basis and the broker's basis agree and the "miss" on the gain on sale isn't too material. You're going to have the "correct" gain on sale on the 1099 for the income tax return.
" I bought another lot x Div/ROC "
I am not clear on what that terminology means. Are you saying the security made a distribution to you that you reinvested, and then that distribution proved to be part dividend and part ROC?
If that is the case, I believe you need to be careful with the sequencing and dating. I would record the dividend and ROC a day early. The ROC will adjust the basis of the three original lots. Then on the date of the real distribution, enter the buy shares for the right share count and Div+ROC amount. Repeat as applicable for each Div/ROC distribution. Each additional ROC would adjust all prior lots - original buys and prior ROCs.
Is that what you see the brokerage doing? At one level it would surprise me becasue that DIv / ROC distinction often does not become available until 1099's get distributed which could be a year after the actual distribution.
@Tom Young 's approach using Remove and Add Shares is the only other way to bring basis around to the broker's values.
"@Tom Young, I deleted the trades and reinstalled them, no difference. Thanks."
Not sure what you're referring to here. Simply deleting the trades and then putting them back, as they were originally recorded, shouldn't come to a different result, if that's what you are saying you did here.
There really are only two logical approaches.
The first is to completely REMOVE the shares using "today's" date, and then do ADD transactions, still using today's date, where you re-establish each lot with a correct date of acquisition and a correct basis. If, as of "today" you only have a fairly small number of lots (you define "small" on your own terms), then this is a straight-forward and fairly easy process.
The second is to go back and delete each and every trade and then try to duplicate what you think the broker is doing (and maybe is doing) of entering a return of capital transaction and a dividend transaction - each appropriately timed - so that the "correct" lots are affected.
Yahoo Finance shows BRW paid a dividend 1/7/22. Seemed to consistently pay 7th, 8th, or 9th last year except for May 23. No idea why your Quicken record would show receiveds that much later. Is it similarly consistent through the year?
do you think if I change the received date it might fix the issue.
Understand. The ROC will adjust the cost basis of every lot owned at the time the ROC is dated in Quicken. If you bought shares on 1/15/22, then an ROC dated 1/26/22 will reduce the basis of that lot. An ROC dated 1/7/22 will not. I can't say what your broker is doing or did.
@Charlie R Honestly what I would likely do is recreate the sequence from scratch manually in a test file
Follow through step by step seeing how cost basis per lot and in total change. Compare to brokerage data step by step. That should (could?) lead you to identify where Quicken and the brokerage start diverging, or where Quicken says one thing one place and something else in a different location.
I don't see why Quicken would behave any differently monthly vs quarterly.
Quicken does not have a Report named Gain/Loss. That leaves me guessing at what you mean. Maybe that is a Capital Gains report but you might mean something else. Please try to be as exact and clear as possible when making such references.
Don't know. All mine categorize as Uncatergoried in Investment Transaction Reports. Where are you eeing the Other Income Non-taxable for a RtrnCap transaction?
That seems really odd. Have you tried entering a new transaction for each of those 4 oddballs?
Is it those 4 oddballs that are not adjusting the cost basis correctly?
Are you selecting the same LOTS for sale as your brokerage? Unless you specify otherwise, at time of sale, they'll almost always choose FIFO
But are you selecting the same TAX LOTS as your broker?
