Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Faulty sum for total portfolio value

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

Postby Mary Kennedy » Wed Jul 19, 2017 12:01 pm

I am attaching a jpg of a section from a portfolio report which includes two faulty sums.

(a) The top three lines are from "Tom's IRA." Notice that Tom owns a fund valued at $65000, yet the total portfolio value is just $1219.

(b) The second batch of holdings reflects the "Trust" account, which also has a faulty sum but you'd have to calculate it yourself to see it. My calculation is $241488, which is roughly where the broker puts it. But FM puts it at about $30,000 over that.

Neither account has any pending activity that might confuse the totals. Also I manage about five other portfolios that are reported correctly. Can you figure out what's up with these two?
Attachments
FM Addition Problem.jpg
FM Addition Problem.jpg (84.81 KiB) Viewed 1573 times
Mary Kennedy
 
Posts: 102
Joined: Sat May 08, 2010 2:36 pm

Postby Mark » Wed Jul 19, 2017 2:43 pm

Hi Mary Kennedy,

If you turn on "View / Hidden Investments" I suspect that will fix the summing issue, and allow you to see where the extra money is coming from.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby aviator » Sat Jul 22, 2017 12:31 pm

Hi Mark,

As we wait in anticipation of the next major release, I hope it will include something, anything, to alert users that the total does not equal the sum of its rows (only when this happens, of course). This one issue has tripped me up many times and, I'm guessing Mary Kennedy, too. Please (please!) do something to fix it.
aviator
 
Posts: 419
Joined: Thu Jul 09, 2009 4:47 am

Postby Mark » Sat Jul 22, 2017 4:56 pm

Hi Aviator,

We will be doing something to address this in the next major release.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 4 guests

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