Home Quicken for Windows Investing (Windows)

Previously sold mutual funds showing up in Portfolio over a year later

ScooterlamScooterlam SuperUser ✭✭✭✭✭
edited June 24 in Investing (Windows)
Tonight, I noticed I have 2 old mutual funds showing up in my Portfolio view that I previously sold (all shares) in Apr. 2019 and Dec. 2018.  The two funds have very small, negative share balance.  See image.



As mentioned, all shares of these funds were sold and have not appeared in my portfolio view since they were sold, until recently.  File validation revealed nothing unusual and closed lots are not shown.  Also did a few restores from this morning and yesterday but they all exhibited this issue.

Anyone else have this occur?  Could this have surfaced from a recent change introduced in R27.20?  



I'm currently running QW HBR R27.23.

What's the best way to adjust the share amounts to close them out, without introducing placeholders?

Tagged:

Comments

  • q_lurkerq_lurker SuperUser ✭✭✭✭✭
    Edit the last sale of those securities in that account and choose the Sell all shares option. 
  • Jim_HarmanJim_Harman SuperUser ✭✭✭✭✭
    This sounds like the same issue as this one
    https://community.quicken.com/discussion/7877215/tiny-residual-holdings-showing-up-in-portfolio-views-after-r27-20-quicken-update-edited

    I have not experimented with this, but it appears that if any of the tax lots is negative, Sell All may not get the balance to zero and you have to combine it with a CoverShort or something.
    -- Jim QWin Premier subscription
  • Chris_QPWChris_QPW Member ✭✭✭✭
    If Sell All doesn't fix the negative shares what I would do tweak the last transaction for that security to that it comes out with zero shares.
    (I'm using the latest Quicken subscription version)
  • q_lurkerq_lurker SuperUser ✭✭✭✭✭
    edited June 25
    This sounds like the same issue as this one
    https://community.quicken.com/discussion/7877215/tiny-residual-holdings-showing-up-in-portfolio-views-after-r27-20-quicken-update-edited

    I have not experimented with this, but it appears that if any of the tax lots is negative, Sell All may not get the balance to zero and you have to combine it with a CoverShort or something.
    I’m sure it is the same issue. I’d sure like to see these scattered discussions consolidated to one spot. 
    Note - I’ve not upped to 27.20+ yet so I am only speculating. 
    My suggestion has always been EDITING the last sale to use Sell all shares. That should prevent small positive and negative fractions.

    A new Sell or Remove action can only address the small positive fractions. 
    A new CvrShrt might address a small negative fraction but sort of begs the question. 
    For a trader, it is conceivable to me that the small negative might have been introduced by some sale before the last sale. If so, that earlier sale would need to be identified and edited. 
    I’ll be curious to see how this impacts me because I am pretty rigorous about tracking mutual funds to 3-decimal precision.  Hope I don’t develop too many such fractions. 
  • ScooterlamScooterlam SuperUser ✭✭✭✭✭
    Thanks all.  @q_lurker suggestion to "sell all" on the last transaction fixed the problem.
  • Bob_LBob_L SuperUser ✭✭✭✭✭
    I noticed this earlier this AM after the update.  Sell all shares took care of it.
    Quicken Premier Subscription, Windows 10 Home
  • Jim_HarmanJim_Harman SuperUser ✭✭✭✭✭
    I had the same problem after the update: One holding had .000026 shares and another had .0001 share.

    A quick way to resolve this if the residual is positive is:
    -- click on the security name in the Portfolio view, bringing up the Security Detail view for that security.

    -- double-click on the last Sold transaction.in the Detail view. This takes you directly to the entry dialog for that sale. Note the number of shares sold.

    -- Select Sell all shares in this account and note the new number of shares. The difference should be residual you are seeing in the Portfolio view. If so, click on Enter/done and accept the choice to adjust the price if prompted.

    These residual holdings probably account for the few pennies' discrepancies I have been seeing in some reports.
    -- Jim QWin Premier subscription
  • Scott BainesScott Baines Member ✭✭
    edited July 1
    I just realized i am having the same problem. I tried the sell all shares but it didn't fix the problem, any other ideas? This is a mess.
  • Bob_LBob_L SuperUser ✭✭✭✭✭
    You may need to play around with additional  shares way out in the decimal places to that last sell transaction until you get it right.
    Quicken Premier Subscription, Windows 10 Home
  • Scott BainesScott Baines Member ✭✭
    I finally figured out how to use the "sell all shares" to fix the problem. It was tricky but got it work, thanks for the tips.
This discussion has been closed.