Incorrect cash value makes market value of investments incorrect

Unknown
Unknown Member
edited August 2018 in Investing (Mac)
Suddenly, several (but not all) of my investment accounts are showing the incorrect market value because the Cash Balance shown is wrong. In some cases the cash value is essentially zero, but the updated download puts (almost exactly but not quite) the fund(s) value into the Cash Balance box. That makes the market value of the portfolio almost double what it should be. Reloading does not help.

Comments

  • Quicken_Tyka
    Quicken_Tyka Alumni ✭✭✭✭
    edited July 2018
    Hey Ernie,

    Sorry you're experiencing this difficulty!

    What is the Financial institution that you download from?

    What type of investment accounts are these?

    Do you have any placeholders in the transaction portion on any of these accounts, if you're unsure please review https://getsatisfaction.com/quickencommunity/topics/faq-what-are-placeholder-transactions-in-quicken....

    -Quicken Tyka

     
    ~~~***~~~
  • Unknown
    Unknown Member
    edited August 2018
    Fidelity. I have been downloading this portfolio for a long time (years) and never had this problem before, nor do I have this problem with the other two portfolios I have at Fidelity. 

    In the Portfolio -> Portfolio Value view in Quicken, the problem is apparent. All of the Value columns match what my Fidelity account shows. What is wildly wrong is the Cash Balance is off by a factor of 27! That is, the cash value that Quicken is showing is MORE than the current market value of the equities (for example, it should be $1,000 to match Fidelity's cash figure and it is showing $27,000). Further, there are NO placeholders in the Transactions on this account, and all of the transactions look correct in Quicken.

    Since I can't see how Quicken is calculating or where it is getting the Cash Value figure, I am stumped as to where to go next. 
  • Unknown
    Unknown Member
    edited August 2018
    Problem found. It must have been that I never noticed this over a LONG time, but something was set up incorrectly when the account was created from some other Fidelity account. I just went in and made a balance adjustment and the numbers now look correct. So, my problem lay in having a running incorrect balance column all of the time. I was also looking at the problem backwards. The Portfolio page pulls its info out of the transactions, so if the Balance column (which is really the Cash Balance column) is out of whack, the whole summary is in error. Thanks for your patience. Problem solved.
  • Unknown
    Unknown Member
    edited August 2018
    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018

    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?

    Are you saying that the total Market Value is correct, but the end of the graph shows twice that amount? Is the Price and Holdings As Of in the upper right corner set to today's date? 

    I don't have any explanation if that's what you are seeing. If it's not too private, can you post a screenshot of this?

    FAQ: Posting a Screenshot
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Unknown
    Unknown Member
    edited January 2018

    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?

    Getting late here and I am crosseyed. Will get back on this tomorrow and report/post one way or the other. It may be oK. The error got started way back, but once the balance adjustment is made the curve drops to the right point. Tomorrow. (I am thinking best idea is to fix the beginning if possible and not on current date so the curve will be credible).
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018

    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?

    Yes, you should either date your adjustment on the date when things went wrong. Or just change the original erroneous transaction. 
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Unknown
    Unknown Member
    edited January 2018

    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?

    This took more hours of sleuthing than I cared to commit to. I traced the problem back to when this account was set up. A couple of years ago I split up a large portfolio into several separate ones. When I established the portfolio in question with a new name, etc., I funded it with a transfer of cash from my large portfolio. That was late 2015. At that time, Fidelity was using 3 different bank cash accounts to handle core cash funds. Somehow I missed the fact that these core bank accounts, which were used to buy and sell traded assets, were never set up correctly (never funded) by Quicken. As time went by Quicken saw the bank accounts as tradable assets. The trades on these bank "assets", which were never seen as funded or bought with the initial cash funds by Quicken, caused errors to accumulate over the last two years. I went in and just deleted these bank transactions and everything is fine. Quicken is apparently handling the interest and cash flow in and out to an unnamed cash account/fund. 

    Anyway, maybe this may help someone. Fidelity in the last couple of years changed the way it was handling core cash funds. Quicken seems not to have a problem with the current setup.
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited January 2018

    Ooops. Spoke too soon. The totals are all correct, but now the curve on the Portfolio page is 2X what it should be. Any ideas there?

    Thanks for sharing.
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)