Allocation by Security lists Cash incorrectly, also Asset Allocation lists Cash incorrectly

Depending on which brokerage or IRA accounts I include, the Allocation by Security lists Cash either correctly or incorrectly. It seems to be wrong when one brokerage account in particular is included. If I show just that one account, there is no Cash listed (but there is a cash balance in the account). If I show that one account, plus only one of the other accounts, there is also no Cash listed. If I show all five brokerage and IRA accounts, I see Cash but the total is wrong, by a lot. What could be wrong with that one account?

On another note, the Report > Asset Allocation shows Cash, but if the account(s) holds mutual funds, the total Cash includes the mutual funds.
Is there any way to get Quicken to list Cash correctly in any report?
Quicken user since 1995, now using Premier Subscription on Win10 Home.

Answers

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Some brokers put your uninvested money in money market "sweep" fund so it does not show as cash in the account. Is that what is happening here?

     The Asset Allocation report shows the allocations you have set or downloaded for your securities, including mutual funds. Money market funds should be 100% in cash but other funds may have part of their assets in cash and that will be reflected in the report.
    QWin Premier subscription
  • DericRock
    DericRock Member ✭✭
    This has nothing to do with a "sweep" fund. The cash in the account is shown in the Quicken account register. Why would the Allocation by Security not show the Cash for one account, but show it for another account?

    As for the Asset Allocation, I guess this is meant to be used for brokerage accounts with only funds. The first report you get lists Cash in each fund, plus Large Cap Stocks, Small Cap Stocks, International Stocks, Domestic Bonds and a few other categories. If I click on "Cash" in the first report, I get another report with Cash (which is wrong, just like in the Allocation by Security) and all the funds listed. My own cash in the account register is probably not included...?

    So it appears that the wrong Cash value I am seeing is the amount of cash held by each fund, and not my own cash. It seems not possible to combine accounts with a mix of individual stocks, funds and a register balance of cash. Is that what others experience?

    Should I report these issues as bugs? How can I best do that?
    Quicken user since 1995, now using Premier Subscription on Win10 Home.
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    edited July 9
    Let's look at what is supposed to be shown in the Investing > Allocations page.

    First, the total dollar amounts in each panel should be the same within a few pennies and if you have selected all accounts and all securities, should match the total of your investing accounts in the Account Bar.

    The Asset Allocation panel at the top shows shows the selected accounts and securities by asset class. If a security includes Cash in its allocation, that cash will be included in the Cash amount. This may or may not be what you think of as your asset allocation. There are ways to fix this if that is your issue.

    The Allocation by Account panel shows the selected accounts and securities subtotaled by account.

    The Allocation by Security panel shows the securities you hold and does not look at the underlying allocations of the securities. The Cash in that panel should be the total actual cash in the selected accounts.

    I do see an issue when I click on Show full graph under Allocation by security. The percentages are different and the total amount does not include the cash held in the accounts. Also if I click on Show Report, the cash is a large negative number, and the total is different from the graph. 

    But if I go to Reports > Investing > >Portfolio Value, with the same accounts and securities selected (all of each in my case) which should be the same report as above, the values are correct.

    Something strange is going on here. See update below.

    Does this match your observations?  


    QWin Premier subscription
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    edited July 9
    Update - Looking further, the large negative amount of cash in the Allocation by Security full graph and report is caused by a long-empty Employee Stock Option account which has caused problems elsewhere as well. If I exclude that account at the top the Allocations page, everything looks OK.

    I think the Allocation by Security full graph is limited so that the Cash (and probably any other security) cannot be negative. This makes sense for a pie chart, which can't show negative values. When I include the account with the large negative bogus cash amount, the cash and the amount in the graph show as zero.
    QWin Premier subscription
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    This issue may be related to this one
    https://community.quicken.com/discussion/comment/20118821#Comment_20118821

    where long-empty Employee Stock Option accounts affected the Investing Dashboard.
    QWin Premier subscription
  • David Walsh
    David Walsh Member ✭✭
    The grand total for the Asset Allocation report is simply incorrect. If you tally the subtotals for each category of the report, the result is off by exactly the amount of cash held in investment accounts that is not invested in sweep funds. In other words, the value that appears first in the cash allocation detail noted as "-Cash-" is the amount the report grand total is off by.