Securities detail summary incorrect
Mark Meaders
I was verifying the shares total on a mutual fund, and I noticed the total number of shares on the Securities Detail page (the summary area to the right) was incorrect. I went and verified the transactions from the Register, and they were correct. I added up the Securities transactions on the Securities Detail page (the information on the left side) and they were correct. Therefore, it appears the summary itself is incorrect. It appears to be duplicating two transactions, and I don't know why or how. All the detail information and transaction information appears to be correct.
Your help would be greatly appreciated.
Comments are currently closed for this discussion. You can start a new one.
2 Posted by -Kevin N. on 15 Jul, 2012 06:37 PM
Hi Mark,
If you could take a screenshot of the 'Securities Detail' view of the investment in question and attach it to your next post it may prove helpful.
Also, so as to assist the Moneydance Support Staff in helping you, provide the following:
Version of Moneydance
Operating system and version
Version of Java installed
You should be able to glean this information from the first few lines of text displayed in the Console Window listed under Moneydance's Help menu. Copy and Paste it into your next post.
-Kevin N.
3 Posted by Mark Meaders on 25 Jul, 2012 01:42 AM
My apologies... I replied to this question shortly after it was posted. It appears it wasn't posted.
Starting Moneydance 2011r2 (803)
OS: Mac OS X 10.7.4 x86_64
Java: 1.6.0_33 (Apple Inc.)
4 Posted by -Kevin N. on 25 Jul, 2012 02:46 AM
Hi Mark,
Unfortunately, there are too many txns in the left side of the Securities Detail View to see them all.
You mentioned in your OP that there are two txns that you suspect are duplicated in the summary. It may be a long shot but could you try deleting those two txns and then recreate them in the register.
If that doesn't work, MD support may need to see the entire list of txns in the left side of the Securities Detail view. Obviously, this would require a few more screenshots.
HTH -Kevin N.
5 Posted by Mark Meaders on 25 Jul, 2012 02:52 AM
Kevin,
I did delete the two transactions and add them back, and I still encountered this issue. I will put some screen shots together and forward them in a separate email.
Thanks,
Mark
Think Green - Please do not print this e-mail unless necessary.
6 Posted by Mark Meaders on 02 Aug, 2012 12:34 AM
Here is a list of all my transactions. The two transactions that appear to be duplicated are the buys on 6/26/92 for 600.348 shares and 12/11/92 for 8.326 shares.
7 Posted by -Kevin N. on 02 Aug, 2012 01:56 AM
Hi Mark,
The two txns in question occur prior to the stock split. Is the date of the stock split correct?
-Kevin N.
8 Posted by Mark Meaders on 02 Aug, 2012 02:07 AM
The mutual fund did a 2:1 split on 6/11/1993. So, it's one day off, but basically the date of the split is correct.
Thanks,
Mark
Think Green - Please do not print this e-mail unless necessary.
9 Posted by -Kevin N. on 02 Aug, 2012 03:47 AM
Hi Mark,
The total number of shares should read 1418.752 instead of 2027.426. Correct?
I'm wondering if perhaps you set up the account with the correct number of shares and then applied the stock split afterwards.
Is it possible that the original purchase on 06/26/1992 was actually for 300.174 shares and not 600.348? Is it possible that the purchase on 12/11/1992 was actually for 4.163 shares and not 8.326?
If you cut the number of shares in half for those first two purchases your share count should reconcile.
HTH -Kevin N.
10 Posted by Mark Meaders on 02 Aug, 2012 11:52 AM
Kevin,
You are correct- the total number of shares should be 1418.752.
I imported the transactions from Quicken. I looked back my Quicken file and you are correct- the transactions were doubled in Moneydance. They should be 300.174 and 4.163. So I will make that correction and I should be good.
Thank you very much for your quick responses and help. I didn't even think of this aspect. I really appreciate it. You can close this ticket.
Thanks,
Mark
Think sustainably. Act sustainably.
11 Posted by -Kevin N. on 02 Aug, 2012 12:35 PM
Hi Mark,
You're welcome. I'm glad to hear that this appears to be sorted out.
If I remember correctly, when applying a 2:1split in Microsoft Money, the amount of shares would be doubled and the price per share halved. This sounds like what Quicken does also.
Moneydance chooses to leave the original txn in tact and just change the summary information in the Securities Detail view. I think that I prefer Moneydance's approach.
As the Original Poster (OP) you have the ability to close the thread by clicking the 'Close this Discussion' link in the upper right-hand corner of this forum page. I am not a member of the Moneydance Support staff, so I can not.
HTH -Kevin N.
Scott Meehan closed this discussion on 02 Aug, 2012 12:42 PM.