Net Gain doesn't match

[mcrews]

Hello,

I'm producing a report where the net gain is significantly different than the reported beginning value and end value. The listed securities look correct but the net is off by a factor of 5x.

I'm not sure how to track down the error. I do know there's a cash investment that isn't showing.

Thanks for any help.

[Mark]

Hi mcrews,

Are you looking in a Portfolio Performance report? Each line in that report should be self-consistent. The gain is a result of the ending value plus what you took out, minus what you started with and what you added. If the report totals aren't adding up from the listed securities, try turning on "View / Hidden Investments" or turn on the option "Options / Report Preferences... / General / Display Hidden Investments with Activity".

[mcrews]

Follow up: It's definitely an issue with the "Invested" tally, which is large and not accurate.

[mcrews]

Found it: It was a hidden security (cash) and during a generic import somehow an erroneous number was inserted into the OOP Cost Value/Tax Basis value. Removed them and all good now.

Thanks,

Matthew