why does my portfolio value report incorrectly calculate balance for a few securites

leonidshower

as of Nov 26 and Nov 27, walmart inc com shows a portfolio value of $12,034.66. the report shows correctly that I have 49.82 shares at the quoted price is $91.31.

my account overview correctly displays this balance as $4549.06

this happens on a number of securities, not just walmart

I checked a few dates and this bug holds

Jim_Harman

Have you backed up your data, then done a File > Validate and repair? Sometimes that fixes this sort of issue.

If not, click on the Holdings button in the affected account and look at Walmart. If that is correct, set the As of date for the Holdings view and the ending date for the report back in time until the error goes away.

Zero in on the date when the error first occurs and look for a transaction on that date that might explain the issue.

Sometimes deleting and re-entering the suspicious transaction will fix a problem like this.

Please let us know what you find.

leonidshower

thank you. Interim report - the error occurred after a stock split transaction on 2/24/2024. the transaction was recorded as a 3-1 split and got the correct number of shares. however the portfolio value report reports the resultant balance incorrectly.

its odd to me that the portfolio and investment displays (portfolio view, holdings view, etc) are correct, while the specific PV report is incorrect

leonidshower

i also did the validate as you suggested. i guess there will be five or six of these kind of problems and tracking down each one is quite laborious

what on your your end, what is the reason for this problem

leonidshower

i think this means you cannot use these reports for tax purposes since the gain calculation will not be correct

i think this is a priority fix for you guys

Jim_Harman

The Portfolio value report is calculated differently from the other reports.

Portfolio Value is cost basis + gain/loss and Net Worth is shares * share price. These should be the same but sometimes they can get out of synch. For example sometimes with a stock split the brokerage will download an Added transaction to correct the share count. If Quicken has anything other than just a Split transaction, it may cause this problem.

See this discussion for more info.

https://community.quicken.com/discussion/7904995/quicken-reports-and-bad-math

For tax purposes, you should compare Quicken's Tax > Capital Gains report to the 1099B you receive from the brokerage and make sure they agree.

leonidshower

Thanks Jim, I suspected it was something like this (cost basis plus gain/loss). I continue to believe this algorithmic issue should be fixed, since it is a clear mistake.

Of course I compare my statements with Quicken, and resolve them, but I don't think I should have to find mistakes like this. Sometimes, I resolve to accept the limitation and sometimes I try to change my data to make the report provide reliable data.

I will read the discussion you linked and thank you for your time

Bill

Jim_Harman

If the problem is as described above, it is not an algorithmic issue but rather incorrect transactions downloaded and accepted.

You should always review downloaded transactions and correct them if necessary before accepting them.