Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Strange Portfolio Value Totalling Error

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

Postby surendar jeyadev » Thu May 19, 2011 5:57 pm

Mark,

I downloaded the monthly transactions from my broker and noticed
that one sale was a bit off -- the security sale did not come through,
but the cash was credited to the account. So, I manually put in the
sale and then removed the double transaction in the Cash Account.

Now the funny bit. When I produce a report, I find that the *total*
portfolio value is off by the sale amount. However, the really funny
bit is that each security value is correct! So why the wrong total?

I copied the report to a spreadsheet and added up the numbers in
stocks, funds and cash (the way the broker classifies the holdings)
and each component matches correctly with what the broker
statement says. And they, naturally, all add up to
what the broker claims. However, FM reports a portfolio value that
is less.

Why is this, when the numbers that it is adding all add up to what
the broker statement says?

Note that the difference is exactly the sale I mentioned.

thanks
sj
surendar jeyadev
 
Posts: 52
Joined: Tue Dec 11, 2007 6:14 pm

Postby Mark » Thu May 19, 2011 6:28 pm

Hi sj,

This sounds like you have a hidden investment, that has a value on that date. Try turning on "View / Hidden Investments/Portfolios" and see if that doesn't clarify things.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11811
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby surendar jeyadev » Fri May 20, 2011 4:52 am

Mark,

Thanks. It is resolved.

This particular security was a spin off and never 'came in' properly
and I created a 'Buy' transaction by hand. OTOH, the sale went to
a different .dat file! I fixed up the file issues and it all went away.

sj
surendar jeyadev
 
Posts: 52
Joined: Tue Dec 11, 2007 6:14 pm


Return to Reports

Who is online

Users browsing this forum: No registered users and 1 guest

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