http://m.getsatisfaction.com/topics/7777178 Quicken 2018 Deluxe Portfolio Value Incorrect 2018-08-14T16:28:47Z 2018-08-13T01:14:15Z 7777178 http://m.getsatisfaction.com/topics/7777178 7777178 Quicken 2018 Deluxe Portfolio Value Incorrect 2018-08-14T16:28:47Z 2018-08-13T01:14:15Z AbbyKay http://m.getsatisfaction.com/people/8400269 https://www.gravatar.com/avatar/f79080ab256fc6812f10416828d705f0?d=identicon&s=55&r=PG abbykay Quicken 2018 Deluxe R10.11, Build 27.1.10.11 on Windows 10 Pro.&nbsp; I run a Portfolio Value report, subtotal by account, export to excel.&nbsp; I recalculate Portfolio value in excel by summing each account total (as Quicken exported).&nbsp; Quicken is 10% high.&nbsp; I tried to troubleshoot by recreating the math in excel starting with shares x price from the Quicken export data.&nbsp; Shares x price match Quicken.&nbsp; Sum the in each account in excel&nbsp; Account totals match Quicken.&nbsp; But, sum of account values in excel is off the same 10%.&nbsp; Any ideas? problem investing investing, bank_accounts_downloading_and_categorizing, windows active 4 4 1 comment http://m.getsatisfaction.com/topics/7777178/replies/19692671 http://m.getsatisfaction.com/topics/7777178 19692671 Tom Young responded to "Quicken 2018 Deluxe Portfolio Value Incorrect" 2018-08-13T03:54:14Z 2018-08-13T03:54:14Z Tom Young http://m.getsatisfaction.com/people/2733890 https://www.gravatar.com/avatar/2f7d7b618c13a56c7c6106bc1d993b75?d=identicon&s=55&r=PG tom_young_2448816 I just tried to duplicate what I think you said you did:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><ol alt="" name="" rel="" target="" title="" type="" value=""><li alt="" name="" rel="" target="" title="" type="" value="">Ran a Portfolio Value Report</li><li alt="" name="" rel="" target="" title="" type="" value="">Exported to Excel</li><li alt="" name="" rel="" target="" title="" type="" value="">In a cell a couple of columns to the right of the "Balance" column (column "I") I entered the formula +I9.&nbsp; That was the cell with the first "Total" for an Account as reported by Quicken.</li><li alt="" name="" rel="" target="" title="" type="" value="">I then copied that same formula down the same column to each "Total" line for each Account included in the report</li><li alt="" name="" rel="" target="" title="" type="" value="">I then summed all of the totals <br alt="" name="" rel="" target="" title="" type="" value="" /></li></ol>Excel came up with a grand total that was 1 penny different than the total reported by Quicken - which I do find somewhat curious - but it certainly wasn't 10% off.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Perhaps you've made some error in in Excel entries?<br alt="" name="" rel="" target="" title="" type="" value="" /> 0 http://m.getsatisfaction.com/topics/7777178/replies/19693367 http://m.getsatisfaction.com/topics/7777178 19693367 UKR responded to "Quicken 2018 Deluxe Portfolio Value Incorrect" 2018-08-13T16:21:11Z 2018-08-13T16:21:11Z UKR http://m.getsatisfaction.com/people/8342865 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11231531/Gartenzwerg2_medium.bmp ukr_8027544 Does your investment accounts' total of Cash Balance + cash rolled over into a Money Management Mutual Fund match the brokerage statements? <br alt="" name="" rel="" target="" title="" type="" value="" />Have you reconciled your investment accounts?<br alt="" name="" rel="" target="" title="" type="" value="" /> 0 http://m.getsatisfaction.com/topics/7777178/replies/19694271 http://m.getsatisfaction.com/topics/7777178 19694271 AbbyKay responded to "Quicken 2018 Deluxe Portfolio Value Incorrect" 2018-08-14T01:38:54Z 2018-08-14T01:38:54Z AbbyKay http://m.getsatisfaction.com/people/8400269 https://www.gravatar.com/avatar/f79080ab256fc6812f10416828d705f0?d=identicon&s=55&r=PG abbykay Thanks for helping me. <br /><br /> 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. <br /><br /> I will update you Thursday. 0 http://m.getsatisfaction.com/topics/7777178/replies/19695476 http://m.getsatisfaction.com/topics/7777178/replies/19694271 19695476 UKR responded to "Quicken 2018 Deluxe Portfolio Value Incorrect" 2018-08-14T16:28:47Z 2018-08-14T16:28:47Z UKR http://m.getsatisfaction.com/people/8342865 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11231531/Gartenzwerg2_medium.bmp ukr_8027544 &gt; You said: " I run a Portfolio Value report" and <br />"Quicken showed the cash balance twice - once as the first “position” and again as the last"<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />IIRC, there was a bug like that in earlier versions of Quicken that has since been fixed.<br alt="" name="" rel="" target="" title="" type="" value="" />Are you reusing a report created and saved in an earlier version of Quicken?<br /><br />I just ran a Portfolio Value report on my Q 2018 R 10.11 and subtotaled it by account. The Cash Balance amount is shown only once, as "- Cash -", as the last line listed before the subtotal is printed.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> 0