Incorrect cash value makes market value of investments incorrect
Options
Unknown
Member
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.
0
Comments
-
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
~~~***~~~0 -
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.0 -
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.0
-
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?0
-
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?wizardchef said: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?
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 ScreenshotQuicken Mac Subscription; Quicken Mac user since the early 90s0 -
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).wizardchef said: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?
0 -
Yes, you should either date your adjustment on the date when things went wrong. Or just change the original erroneous transaction.wizardchef said: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?
Quicken Mac Subscription; Quicken Mac user since the early 90s0 -
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.wizardchef said: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?
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.0 -
Thanks for sharing.wizardchef said: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?
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(Now Archived, even with over 350 votes!)
(Canadian user since '92, STILL using QM2007)
0
This discussion has been closed.