Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 09-04-2006, 01:47 AM
Gordon
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

On Sun, 03 Sep 2006 19:18:34 -0500, Cal Learner-- MVP
<via_newsgroup[at]please.tnx> Eingereicht:

- quote -

> In microsoft.public.money, Gordon wrote:
> > I think I see what you mean. I didn't realize that the Investment
> > Transactions Register view had means for entering these items. It
> > seems that if I click the New button then under the Activity
> > drop-down there is a way to key this information into the
> > Investment Transactions. Should I now delete all those entries
> > from the Cash Transactions register. There aren't but about a
> > dozen of these transactions, so it wouldn't be hard to delete
> > them and start all over from scratch.

> Almost. I would tend to mark them Void for now until I was pretty
> sure I have the data moved over. If you are sure you have that data
> retained, then you could delete them now.
> While you are working with the register, there are some style
> choices you can use. For example, if you un-tick
> ShowTransactionForms, you will get a style where you enter the
> transactions right into the register. If you press Ctrl+T keys you
> will toggle from single-line to a different display.
> But yes, if you use the Transactions Forms setting to enter a new
> transaction, you click New.
> And a comment on using the Dividend, Long Term Capital Gain, Short
> term ... etc, those let Money associate the income source with a
> given security.
> I would also point out that a ReinvestDividend is like a Dividend
> and a Buy combined. Ditto for the various Reinvest... transaction
> types.

Thanks, Cal. This seems to have resolved all the problems. I had
no idea that these transactions had to be/could be entered in the
Investments Transactions Register. I have been just keying them
into the Cash Transactions Register, but of course they didn't
show up in the Investments Register, and my account would not
balance against my brokerage statements.

There weren't but some 10 or 12 such transactions, and they
weren't of any serious magnitude, but they just kept the account
from balancing against my brokerage statemens. Now everything
balances. Thanks for the help.

I tried the style choices and will work with them some more. This
may be an easier way to enter the data. I'll give it a whirl and
see how it works out. I appreciate the information you supplied.

Gordon
  #4  
Old 09-04-2006, 12:18 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

In microsoft.public.money, Gordon wrote:

- quote -

> I think I see what you mean. I didn't realize that the Investment
> Transactions Register view had means for entering these items. It
> seems that if I click the New button then under the Activity
> drop-down there is a way to key this information into the
> Investment Transactions. Should I now delete all those entries
> from the Cash Transactions register. There aren't but about a
> dozen of these transactions, so it wouldn't be hard to delete
> them and start all over from scratch.


Almost. I would tend to mark them Void for now until I was pretty
sure I have the data moved over. If you are sure you have that data
retained, then you could delete them now.

While you are working with the register, there are some style
choices you can use. For example, if you un-tick
ShowTransactionForms, you will get a style where you enter the
transactions right into the register. If you press Ctrl+T keys you
will toggle from single-line to a different display.

But yes, if you use the Transactions Forms setting to enter a new
transaction, you click New.

And a comment on using the Dividend, Long Term Capital Gain, Short
term ... etc, those let Money associate the income source with a
given security.

I would also point out that a ReinvestDividend is like a Dividend
and a Buy combined. Ditto for the various Reinvest... transaction
types.
  #3  
Old 09-03-2006, 11:35 PM
Gordon
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

On Sun, 03 Sep 2006 17:02:49 -0500, Cal Learner-- MVP
<via_newsgroup[at]please.tnx> Eingereicht:

- quote -

> In microsoft.public.money, Gordon wrote:
> > On Sun, 03 Sep 2006 11:37:42 -0500, Cal Learner-- MVP
> > Eingereicht:
> > > > In microsoft.public.money, Gordon wrote:
> > > > > > My Money 2006 setup shows a net loss for my mutual funds although
> > > > there is actually a net gain when the additional shares purchased
> > > > with reinvested dividends are correctly tallied up. What settings
> > > > should I look for to get this error resolved?
> > > > > Are you looking at the TotalReturn column in the Portfolio views?
> > > > > Are the additional share purchases entered in the register as
> > > ReinvestDividend or Reinvest[somethingElse], or what?
> > > > > > > > > > > > > It seems that Money is not acknowledging the income from the
> > > > dividends, but merely calculates the number of shares owned and
> > > > the average price paid per share, then compares this to the
> > > > current price per share X number of shares held, net value.
> > > > Yes, Cal, I am looking at the column; Total profit or loss since

> > the date of purchase. This is the right most column on the
> > Portfolio Manager screen.

> There is no "Total profit" column. There is a "Total Return -- All
> dates" column. The columns can be moved around. You can choose what
> items you want by going to

I'm talking about the Portfolio Manager view. (I have mine set
for Standard view.) The right-most column has the heading, "Gain"
but when I move my mouse pointer over this header I get a popup
that reads "Total profit or loss....etc.
- quote -

> ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns and
> adding or removing items.
> > > I have these items listed as Investment Incomeividends, when

> > the money came in, then I show them as Buy entries on the same
> > investment account.

> That is the problem then. They should be entered as Dividends etc in
> the Investment transactions register rather than in the Cash
> transactions register.

I think I see what you mean. I didn't realize that the Investment
Transactions Register view had means for entering these items. It
seems that if I click the New button then under the Activity
drop-down there is a way to key this information into the
Investment Transactions. Should I now delete all those entries
from the Cash Transactions register. There aren't but about a
dozen of these transactions, so it wouldn't be hard to delete
them and start all over from scratch.
- quote -

> If you are downloading that way, then you will need to rework the
> information to get things right. One way would be to Void the
> transactions in the Cash transactions register and change the
> Dividend transactions into ReinvestDividend transactions.
> If you are downloading, who is the institution who is sending the
> data that way, in case it comes up in the future?


  #2  
Old 09-03-2006, 10:02 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

In microsoft.public.money, Gordon wrote:

- quote -

> On Sun, 03 Sep 2006 11:37:42 -0500, Cal Learner-- MVP
> Eingereicht:
> > In microsoft.public.money, Gordon wrote:
> > > > My Money 2006 setup shows a net loss for my mutual funds although
> > > there is actually a net gain when the additional shares purchased
> > > with reinvested dividends are correctly tallied up. What settings
> > > should I look for to get this error resolved?
> > > Are you looking at the TotalReturn column in the Portfolio views?
> > > Are the additional share purchases entered in the register as

> > ReinvestDividend or Reinvest[somethingElse], or what?
> > > > > > > > It seems that Money is not acknowledging the income from the
> > > dividends, but merely calculates the number of shares owned and
> > > the average price paid per share, then compares this to the
> > > current price per share X number of shares held, net value.

> > Yes, Cal, I am looking at the column; Total profit or loss since

> the date of purchase. This is the right most column on the
> Portfolio Manager screen.


There is no "Total profit" column. There is a "Total Return -- All
dates" column. The columns can be moved around. You can choose what
items you want by going to
ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns and
adding or removing items.

- quote -

> I have these items listed as Investment Incomeividends, when
> the money came in, then I show them as Buy entries on the same
> investment account.


That is the problem then. They should be entered as Dividends etc in
the Investment transactions register rather than in the Cash
transactions register.

If you are downloading that way, then you will need to rework the
information to get things right. One way would be to Void the
transactions in the Cash transactions register and change the
Dividend transactions into ReinvestDividend transactions.

If you are downloading, who is the institution who is sending the
data that way, in case it comes up in the future?
  #1  
Old 09-03-2006, 07:39 PM
Gordon
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

On Sun, 03 Sep 2006 11:37:42 -0500, Cal Learner-- MVP
<via_newsgroup[at]please.tnx> Eingereicht:

- quote -

> In microsoft.public.money, Gordon wrote:
> > My Money 2006 setup shows a net loss for my mutual funds although
> > there is actually a net gain when the additional shares purchased
> > with reinvested dividends are correctly tallied up. What settings
> > should I look for to get this error resolved?

> Are you looking at the TotalReturn column in the Portfolio views?
> Are the additional share purchases entered in the register as
> ReinvestDividend or Reinvest[somethingElse], or what?
> > > It seems that Money is not acknowledging the income from the

> > dividends, but merely calculates the number of shares owned and
> > the average price paid per share, then compares this to the
> > current price per share X number of shares held, net value.

Yes, Cal, I am looking at the column; Total profit or loss since
the date of purchase. This is the right most column on the
Portfolio Manager screen.

I have these items listed as Investment Incomeividends, when
the money came in, then I show them as Buy entries on the same
investment account.

All the data is there, and I can run the figures with my hand
calculator and get the right results, but the MS Money Total
Profits column fails to recognize the income from these
dividends. I'm thinking this must be a glitch caused by some
improper setting or entry, but I can not locate it.

All my other accounts and holdings balance to the third decimal
place, but htis one seems to be doing something strange with my
money.

Gordon

 
Old 09-03-2006, 04:37 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Funds balance

In microsoft.public.money, Gordon wrote:

- quote -

> My Money 2006 setup shows a net loss for my mutual funds although
> there is actually a net gain when the additional shares purchased
> with reinvested dividends are correctly tallied up. What settings
> should I look for to get this error resolved?


Are you looking at the TotalReturn column in the Portfolio views?

Are the additional share purchases entered in the register as
ReinvestDividend or Reinvest[somethingElse], or what?



- quote -

> It seems that Money is not acknowledging the income from the
> dividends, but merely calculates the number of shares owned and
> the average price paid per share, then compares this to the
> current price per share X number of shares held, net value.

  #-1  
Old 09-03-2006, 04:28 PM
Gordon
Guest
 
Posts: n/a
Default Mutual Funds balance

My Money 2006 setup shows a net loss for my mutual funds although
there is actually a net gain when the additional shares purchased
with reinvested dividends are correctly tallied up. What settings
should I look for to get this error resolved?

It seems that Money is not acknowledging the income from the
dividends, but merely calculates the number of shares owned and
the average price paid per share, then compares this to the
current price per share X number of shares held, net value.

Gordon
 

Tags
balance, funds, mutual
Similar Threads
Thread Forum Replies Last Post
Tracking Mutual Funds from ING
Chris Veal: I have a 401k plan that invests in mutual funds, which update their amounts daily. Is there somewhere I can add this to Money and start tracking how...
Microsoft Money 7 05-12-2005 08:30 PM
Tracking Mutual Funds
Chris Veal: I have some mutual funds that I get updates on daily as to what amount of interest they are gaining me towards my retirement. Is there a way to...
Microsoft Money 1 05-11-2005 07:48 PM
Mutual Funds and symbols
Jeff: I have two of the same mutual funds, one is being used as a Roth IRA and the other as a general investment. MS Money 2004 will not allow me to...
Microsoft Money 2 03-11-2005 12:23 PM
Mutual funds merging with other mutual funds
Rod: In Money 2000 Deluxe, how do you record when a mutual fund company combines with another mutual fund? I had 200 shares of fund a, which was...
Microsoft Money 1 12-09-2003 12:28 PM
Mutual funds not updating
Rudolf: Hi Yep have the same problem mine stopped updating since the 19th this happendlast year a couple of times also MS told me at that time that they...
Microsoft Money 2 07-04-2003 01:12 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:45 PM.