Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Net Gain doesn't match

Questions on using, creating, or understanding data in Fund Manager reports.

Postby mcrews » Mon Sep 28, 2020 12:42 pm

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.
mcrews
 
Posts: 34
Joined: Fri Nov 02, 2012 11:13 am

Postby Mark » Mon Sep 28, 2020 12:55 pm

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".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby mcrews » Mon Sep 28, 2020 12:56 pm

Follow up: It's definitely an issue with the "Invested" tally, which is large and not accurate.
mcrews
 
Posts: 34
Joined: Fri Nov 02, 2012 11:13 am

Postby mcrews » Mon Sep 28, 2020 1:04 pm

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
mcrews
 
Posts: 34
Joined: Fri Nov 02, 2012 11:13 am


Return to Reports

Who is online

Users browsing this forum: No registered users and 2 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.