Quicken 2018 Deluxe Portfolio Value Incorrect

AbbyKay

Quicken 2018 Deluxe R10.11, Build 27.1.10.11 on Windows 10 Pro.  I run a Portfolio Value report, subtotal by account, export to excel.  I recalculate Portfolio value in excel by summing each account total (as Quicken exported).  Quicken is 10% high.  I tried to troubleshoot by recreating the math in excel starting with shares x price from the Quicken export data.  Shares x price match Quicken.  Sum the in each account in excel  Account totals match Quicken.  But, sum of account values in excel is off the same 10%.  Any ideas?

Tom Young

UKR

AbbyKay

Thanks for helping me.



Yes, I reconciled my accounts. And, I double checked my excel calcs. I am without my computer for a couple of days, but will try running the report with no sub totals and the do it account by account to see if I can isolate the problem. BTW, for one brokerage account, Quicken showed the cash balance twice - once as the first “position” and again as the last. But, it only counted it once in the total for that account. Strange.



I will update you Thursday.

UKR

AbbyKay

AbbyKay

Good news.  I just ran a 7-31-18 Net Worth Report and compared the "Investments" section to the Portfolio Value Report.  The reported totals for each account in the two reports match.  The reported totals of all the two reports match.  I verified that the sum of the investment accounts in the Net Worth report is reported correctly in Quicken. So, it appears that the cash reporting bug (I'll call it a bug for now) in the Portfolio Value Report is not affecting the Net Worth Report.

Jim_Harman

AbbyKay

AbbyKay

AbbyKay

Jim_Harman

AbbyKay

Jim_Harman

AbbyKay

Just validated.  It found and corrected some errors, but none to do with this account.  I ran the PV report again and got same results.  Duplicate -Cash- entry goes away if I exclude that account from the report.  And, the problem still starts 11/3/14.  Any other suggestions?  4 years worth of transactions is too much to re-Ienter manually.  But if you thought it would work, I could delete all the November transactions, look for old statements (maybe on line) and manually re-enter November 2014.

Jim_Harman

AbbyKay said:

Just validated.  It found and corrected some errors, but none to do with this account.  I ran the PV report again and got same results.  Duplicate -Cash- entry goes away if I exclude that account from the report.  And, the problem still starts 11/3/14.  Any other suggestions?  4 years worth of transactions is too much to re-Ienter manually.  But if you thought it would work, I could delete all the November transactions, look for old statements (maybe on line) and manually re-enter November 2014.

No, don't delete everything. Copy the details of the 11/3/14 transactions, delete them one at a time and re-enter, checking to see if the problem goes away. I assume you have a recent backup just in case, as mentioned above.