Investment Asset Allocation Report - Sold Securities Listed with $0.01 or $0.02Closed

I run the Investment Asset Allocation report without customizations and there are 6 SOLD Securities listed with values of $0.01 or $0.02. Why are SOLD securities listed on this report?

To try and fix this, for a couple of the Securities, I located the SELL transaction and Edited. I checked 'SELL ALL' and then approved the transaction. That didn't help.

I don't think it's a fractional share issue. For one of the Securities, I bought the Securities in even lots beginning in December 2020. Then, in April 2021, I sold 'ALL' 1,200 shares and reported as 'SOLD ALL' in quicken. That security continues to show in the Investment Allocation Report with a value of $0.01. The Security is not listed in Holdings in the brokerage account.

I've also done the File Validation functionality. That did not resolve the issue.

I suppose I could customize the Investment Asset Allocation report to exclude these 6 Securities, but why should I have to do that?

Is there some way to correct this that I'm just not seeing?

Thanks
Sort by:
1 - 1 of 11
    User: "Jim_Harman"
    ✭✭✭✭✭
    Accepted Answer
    Updated by Jim_Harman
    Experimenting further, I see something is a little off with the Asset Allocation Report.

    The Fidelity Investment Grade Bond Fund has a downloaded allocation of 89% bonds, 9% Cash, and 2% Other.

    In a test account, I bought 700 shares of it in lots of 100, 200, 200, and 200. I did not try buying all 700 at once. [Update - buying all 700 shares at once does not cause this problem]

    Quicken correctly allocates 623 shares to Bonds, 63 shares to Cash, and 14 shares to bonds for a total of 700.

    On 6/1 the price was 8.34 per share so the Cash should be worth 63 x 8.34 or 525.42 but both sections of the Asset Allocation report show $545.43 - off by a penny and the total holding is also off by a penny - 700 x $8.34 = $5838.00.  I don't see how this could be a rounding error.



    If I sell all the shares on 6/2, the table is clear but the graph part of the report still shows the extra penny.


     
    QWin Premier subscription
This post has been closed.