Login
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
DMauman  
#1 Posted : Sunday, January 6, 2013 7:54:34 PM(UTC)
DMauman

Rank: Member

Posts: 12

 One of those perplexing things that only a treasurer would probably worry about.  I ran our 12/31/12 Treasurer reports, and have a very strange thing going on in our cash portion of the club's valuation within Online Club Accounting.  In the Market Value column of the Valuation Report, it shows our Total Securities as 166,359.26.  Our Total Cash Account is showing as 32,229.33.  So add those together, and one (and certainly a computer) should come up with 198,588.59.  However, instead the Total Value of Portfolio is showing as 198,588.58..... which is an incorrect total by 1 cent.  The Individual Securities and Cash totals DO match our TD Ameritrade statement, but the TD Ameritrade Statement shows the correct Portfolio Total (combined Securities and Cash) as 198,588.59 (the correct sum).  This "incorrect math" has never occurred before, and we've been using Online Club Accounting for years.  Like I said, perplexing!  Any ideas?

 

Don Maurer, Treasurer

WeVest Investment Club

Wanna join the discussion?! Login to your forum account. New Registrations are disabled.

gerlach  
#2 Posted : Monday, January 7, 2013 9:43:30 AM(UTC)
gerlach

Rank: Administration

Posts: 437

Thanks: 7 times
Was thanked: 14 time(s) in 10 post(s)

Is this Valuation from before or after your year-end allocation? Do you own fractional shares of securities? When you enter transactions, are you letting the program calculate the price per share from the number of shares and the total, or are you trying to make the cost match what the confirmation says? There are lots of potential causes for a one-cent discrepancy.

The way the program works is that it calculates the totals on an all-inclusive basis, not by figuring all the cash and all the security values and then adding those totals together, so sometimes there's a fractional penny that gets rounded in a different way.

If you want one of our techs to take a look, you can file a ticket on the ICLUB.com website.

Doug

Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.039 seconds.