Home → Problems →

Mutual Fund Current Balance Calculations are incorrect

• Edit

jhtpvance

Apr 30, 2015 @ 01:44 PM

I recently switched from Quicken to MD and am having a problem with the mutual fund current balance calculations. When I imported data from quicken, everything went fine and after some tweaking, MD worked well for a few weeks. However, in the last 2 weeks the current balance calculations have all been miscalculated. Some balances are double or triple, and some are under calculated. I've checked all the settings and the ticker symbols are correct, the share balance is correct, and when I look into the security details, the share price is correct. But the current balance calculations are all wrong. I've looked through the forums and can't find any help. Any suggestions?

1. 1 Posted by sth on Apr 30, 2015 @ 02:44 PM

   

   That seems weird. Let me ask a few questions. You have an account that has a single mutual fund in it? When you look at that account there are a couple of views, one is the portfolio view that shows shares, price and balances and that is correct?

   But when you look at the securities detail tab, then the current balance is incorrect? Does the securities detail tab also show the correct transactions in the account?

   • Edit

2. 2 Posted by dwg on Apr 30, 2015 @ 09:30 PM

   

   Perhaps a couple of screen shots that show the problem may help as well.

   • Edit

3. 3 Posted by jhtpvance on Apr 30, 2015 @ 09:58 PM

   

   I have attached a screenshot of a partial list of account balances. The
   fund labeled RPMGX is correct. The first fund Vang Value index has the
   correct number of shares, but has somehow assumed the RPMGX share price
   (and name). The third fund, Vang Midcap Value has done the same thing. I
   have looked at all the fund tickers and they are correct.

   As to your question: The portfolio view has the correct number of shares
   but the wrong share price. Securities detail has the correct number of
   shares and the wrong share price as well.

   I had thought that going into the account and entering a correct share
   price would solve the problem, but as of now I haven't determined how
   to do that.

   Interestingly, the program was doing fine and suddenly, things went
   haywire. It's very frustrating, and I'm beginning to wonder if
   Moneydance is worth the effort.

   Thanks for any help you can provide.

   James

   • Screen_Shot_2015-04-30_at_5.45.24_PM.png 41.8 KB
   • Edit

4. 4 Posted by dwg on Apr 30, 2015 @ 10:10 PM

   

   Looking at that screen shot it looks like the security IRA-TRPr MCp GR is in three investment accounts,where as I expected to only see it in the second in the list.

   I'd be checking to see what securities I have added to each Investment account and what securities I have been entering transactions against in accounts 1 & 3

   • Edit

5. 5 Posted by sth on Apr 30, 2015 @ 11:01 PM

   

   James, Ok, something is very weird about your setup and securities definitions. We may have to do some cleanup but I think you have multiple securities that you think are the same.

   What I assume you sent me was a screen shot from the "Summary" screen.

   First, in general there should be one account with multiple securities. Thus there is a "Vanguard IRA" account which would have the 4 securities in it. Not 4 accounts each with one security. This may have gotten confused in the conversion from quicken.

   Also the units are weird in that you ended up with RMPGXShares not just "Shares" which is the normal setting.

   Open the tools->Securities window and see if you have more than one entry for each of the mutual funds. If you double click a mutual fund you should get the history window for that fund, and the edit button should give the specifics. See the example below for the specifics on a Vanguard fund.

   The cleanup should be that there is only one entry in the Securities for each fund and that it has the correct name, ID and symbol. As far as I know the ID is assigned by downloading the data.

   • Screen_Shot_2015-04-30_at_6.59.54_PM.png 27.6 KB
   • Edit

6. System closed this discussion on Mar 19, 2016 @ 04:56 AM.