Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #9  
Old 11-21-2004, 05:06 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

In microsoft.public.money, Derf wrote:

- quote -

> I'd like to use that, actually, but Money requires me to use the other
> method for another financial institution on my list. Is it possible
> to select both methods (some accounts use the MSFT servers, some
> direct download)?


As I understand it, the data will be on the server if you use a
Passport in case you want to access the data via secure web
connection.

I think that if you connect to companies with direct OFX access,
those data and passwords are not handled by Yodlee. Others are
handled by Yodlee.

- quote -

> I'm not really wild about storing my info on Yet
> Another Server with Yet Another Privacy Policy.


It is possible to choose institutions with that in mind.

  #8  
Old 11-21-2004, 12:57 AM
Derf
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

On Fri, 19 Nov 2004 17:15:41 GMT, via_newsgroup[at]please.tnx(Cal
Learner-- MVP) wrote:

- quote -

> > 1. Why Microsoft interprets Fidelity accounts in such an odd fashion.
> > It isn't as if Fidelity was a minor player with a one-off website.

> Fidelity does most things rather well, but this is not their best.
> In direct OFX download,


I'd like to use that, actually, but Money requires me to use the other
method for another financial institution on my list. Is it possible
to select both methods (some accounts use the MSFT servers, some
direct download)? I'm not really wild about storing my info on Yet
Another Server with Yet Another Privacy Policy.

[...]
- quote -

> Adding shares messes up any calculation of gain.

D'oh! Right, add cash, buy shares for the initial setup. OK, many
thanks.

--
regards, Fred

"Verbing weirds language." -- Calvin
  #7  
Old 11-19-2004, 04:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

In microsoft.public.money, Derf wrote:

- quote -

> On Fri, 19 Nov 2004 05:50:02 GMT, via_newsgroup[at]please.tnx(Cal
> Learner-- MVP) wrote:
> Thank you, too, for your help. This is very beneficial.
> > I am assuming you can get into the "Advanced Register" state as
> > represented in the upper right hand corner of the account register.

> Yes.
> > > I tried that, but the Rename box just let me rename the investment.
> > > There were no other options available in the Rename dialog. I am
> > > using Advanced Register, but changing to Essential Register gave the
> > > same result.
> > > It's a little different in Money 2005. Right-click the account in

> > the account list and choose See Account Settings. Look for a
> > checkbox labeled Track Cash Transactions and put a check there.

> Yes, I've had that checked during the earlier adventures.
> > Then, I think, going to the account will let you click Cash
> > Transactions or Investment Transactions on the left.

> Yes, I have those items on the menu and they show all the
> transactions. For mutual fund investments, I see cash dividends and
> then purchases of additional shares (I'm presuming this is an artifact
> of the way Fidelity presents account activity -- ReinvestDivident
> would be slightly better). I see dividends from the Cash Reserves
> investment, but no purchases of additional shares in Cash Reserves. I
> understand that now, and I think I'll have to manually add the
> matching share purchase to keep everything in sync.
> Two things puzzle me.
> 1. Why Microsoft interprets Fidelity accounts in such an odd fashion.
> It isn't as if Fidelity was a minor player with a one-off website.


Fidelity does most things rather well, but this is not their best.

In direct OFX download, the OFX file comes directly to you from
Fidelity without going to a third party. There is a spec (obscure;
OFX.net), but it is up to the Financial Institution (FI) to
implement. In the other paradigm, a third party (Yodlee) accesses
the web site of the FI for you. The OFX method is the one that fits
my needs. It means that there are variations from FI to FI in how
some things are handled, but that is OK.


- quote -

> 2. Why Money won't let me designate one investment as the cash sweep
> investment, which would keep all those dividends from just piling up
> as loose cash in the account.
> Oh, and one more thing. What in the world is the Cash Portion Details
> section of the Change Account Settings used for? Money 2005 doesn't
> seem to have any context sensitive help, or at least I can't find the
> right way to trigger it. The local help file has nothing for 'cash
> portion details', the online User's Guide doesn't list this in the
> index, and I can't figure out how to search the Guide (hint, hint
> Money developers reading this post). Maybe I'm just dense, but I'm
> coming to the view that the guides and help documentation aren't very
> good.


Searching on "cash transactions", or even just "cash", will present
an item called "Track cash transactions for investment accounts".


- quote -

> > > I have an investment that is the cash in the account (1 share is 1
> > > dollar). Fidelity posts interest payments to this investment as
> > > Dividend transactions.
> > > Normally these would be Buy, Sell, Dividend and ReinvestDividend

> > (which is a combination of a Buy+Dividend in one transaction).

> Yes, but for some reason, by the time it gets to Money, interest from
> a cash reserve investment is presented as a dividend only. There is
> no matching buy of shares to keep the value of the investment
> accurate. Yes, I can add it in manually, but why can't MSFT and
> Fidelity get together on this and present an accurate record of
> account activity? I'd also like a lo-cal tasty and delicious
> chocolate cake while they are at it, too!


Keeping the swept money as part of the cash is one of the three
ways that the OFX spec describes. I think that in that case the FI
perhaps should enter the dividends as an Interest item. If that
seems better, you could change the downloaded Dividend transaction
to Interest each month.

A handy way to be able to work with all transactions for a
particular security is to look at the Investment Activities for the
investment. There you can see and modify all of the transactions for
a particular investment.


- quote -

> > > These dividends show up in the Cash summary
> > > line for the account,
> > > Cash Summary line?

> I think I understand now. The dividends had no home, so they fell
> through to an investment line that read Cash ($). That's just free
> cash in the account, as best I can tell. I initially thought it
> represented all cash-equivalent positions in the account, but your
> questions told me I'm incorrect. Thanks for setting me straight.
> > > but the shares I added when I initially set up
> > > the account do not.
> > > I would enter a Buy for the "Money Market Fund" that you are

> > describing in the amount of your initial shares. You will probably
> > also want to make a Deposit into the cash transactions register to
> > represent the money you started with.

> What advantage does a deposit+buy transaction pair have over just
> adding shares? I'd also have thought that the account setup process
> would prompt for this kind of information.


Adding shares messes up any calculation of gain. Money could use
some improvement here. I would like to be able to check the yield of
a MMF etc over a time period I specify. Analysis,
InvestmentActivities, PriceHistory, and Details are choices you have
available when you "go to" an investment by right-clicking any
reference.

But doing AddShares or RemoveShares with MMF is not as bad as doing
so for other shares. One thing of note is that when you do buy and
sells of an investment defined in Money as a Money Market Fund, they
don't generate schedule D lines.

I don't like to use AddShares where I can do it another way. If I
were doing it by hand, I would just let the swept cash be
represented by the Cash Transactions balance and enter interest
transactions.




  #6  
Old 11-19-2004, 03:11 PM
Derf
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

On Fri, 19 Nov 2004 05:50:02 GMT, via_newsgroup[at]please.tnx(Cal
Learner-- MVP) wrote:

Thank you, too, for your help. This is very beneficial.

- quote -

> I am assuming you can get into the "Advanced Register" state as
> represented in the upper right hand corner of the account register.


Yes.

- quote -

> > I tried that, but the Rename box just let me rename the investment.
> > There were no other options available in the Rename dialog. I am
> > using Advanced Register, but changing to Essential Register gave the
> > same result.

> It's a little different in Money 2005. Right-click the account in
> the account list and choose See Account Settings. Look for a
> checkbox labeled Track Cash Transactions and put a check there.


Yes, I've had that checked during the earlier adventures.

- quote -

> Then, I think, going to the account will let you click Cash
> Transactions or Investment Transactions on the left.


Yes, I have those items on the menu and they show all the
transactions. For mutual fund investments, I see cash dividends and
then purchases of additional shares (I'm presuming this is an artifact
of the way Fidelity presents account activity -- ReinvestDivident
would be slightly better). I see dividends from the Cash Reserves
investment, but no purchases of additional shares in Cash Reserves. I
understand that now, and I think I'll have to manually add the
matching share purchase to keep everything in sync.

Two things puzzle me.

1. Why Microsoft interprets Fidelity accounts in such an odd fashion.
It isn't as if Fidelity was a minor player with a one-off website.

2. Why Money won't let me designate one investment as the cash sweep
investment, which would keep all those dividends from just piling up
as loose cash in the account.

Oh, and one more thing. What in the world is the Cash Portion Details
section of the Change Account Settings used for? Money 2005 doesn't
seem to have any context sensitive help, or at least I can't find the
right way to trigger it. The local help file has nothing for 'cash
portion details', the online User's Guide doesn't list this in the
index, and I can't figure out how to search the Guide (hint, hint
Money developers reading this post). Maybe I'm just dense, but I'm
coming to the view that the guides and help documentation aren't very
good.

- quote -

> > I have an investment that is the cash in the account (1 share is 1
> > dollar). Fidelity posts interest payments to this investment as
> > Dividend transactions.

> Normally these would be Buy, Sell, Dividend and ReinvestDividend
> (which is a combination of a Buy+Dividend in one transaction).


Yes, but for some reason, by the time it gets to Money, interest from
a cash reserve investment is presented as a dividend only. There is
no matching buy of shares to keep the value of the investment
accurate. Yes, I can add it in manually, but why can't MSFT and
Fidelity get together on this and present an accurate record of
account activity? I'd also like a lo-cal tasty and delicious
chocolate cake while they are at it, too!

- quote -

> > These dividends show up in the Cash summary
> > line for the account,

> Cash Summary line?


I think I understand now. The dividends had no home, so they fell
through to an investment line that read Cash ($). That's just free
cash in the account, as best I can tell. I initially thought it
represented all cash-equivalent positions in the account, but your
questions told me I'm incorrect. Thanks for setting me straight.

- quote -

> > but the shares I added when I initially set up
> > the account do not.

> I would enter a Buy for the "Money Market Fund" that you are
> describing in the amount of your initial shares. You will probably
> also want to make a Deposit into the cash transactions register to
> represent the money you started with.


What advantage does a deposit+buy transaction pair have over just
adding shares? I'd also have thought that the account setup process
would prompt for this kind of information.

- quote -

> > Obviously, I am misunderstanding something. I'm
> > completely frustrated with TFM that Microsoft provides. I see a Cash
> > Portion Details in the Change Account Settings view, but I have no
> > idea what affects what. Arrrrgh.

> I don't know that TLA.


It comes form a FLA. RTFM (read the fine manual, although some people
substitute another word for fine). I'm really disappointed over the
documentation for Money 2005. I guess I'll need to find a book to
really be able to use this program.

- quote -

> However lets hope that something here helps
> you progress to where you want to go.


Yes, your comments were very helpful. Thank you again.

--
regards, Fred

"Verbing weirds language." -- Calvin
  #5  
Old 11-19-2004, 04:50 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

In microsoft.public.money, Derf wrote:

- quote -

> On Thu, 18 Nov 2004 21:24:17 -0700, "Dick Watson"
> <littlegreengecko[at]mind-enufalready-spring.com> wrote:
> > Change "Details" to "Settings" and these instructions should still be good.

> Thanks for your help.


I am assuming you can get into the "Advanced Register" state as
represented in the upper right hand corner of the account register.
- quote -

> I tried that, but the Rename box just let me rename the investment.
> There were no other options available in the Rename dialog. I am
> using Advanced Register, but changing to Essential Register gave the
> same result.


It's a little different in Money 2005. Right-click the account in
the account list and choose See Account Settings. Look for a
checkbox labeled Track Cash Transactions and put a check there.

Then, I think, going to the account will let you click Cash
Transactions or Investment Transactions on the left.


- quote -

> I have an investment that is the cash in the account (1 share is 1
> dollar). Fidelity posts interest payments to this investment as
> Dividend transactions.


Normally these would be Buy, Sell, Dividend and ReinvestDividend
(which is a combination of a Buy+Dividend in one transaction).

- quote -

> These dividends show up in the Cash summary
> line for the account,


Cash Summary line?

- quote -

> but the shares I added when I initially set up
> the account do not.


I would enter a Buy for the "Money Market Fund" that you are
describing in the amount of your initial shares. You will probably
also want to make a Deposit into the cash transactions register to
represent the money you started with.


- quote -

> Obviously, I am misunderstanding something. I'm
> completely frustrated with TFM that Microsoft provides. I see a Cash
> Portion Details in the Change Account Settings view, but I have no
> idea what affects what. Arrrrgh.



I don't know that TLA. However lets hope that something here helps
you progress to where you want to go.

  #4  
Old 11-19-2004, 04:34 AM
Derf
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

On Thu, 18 Nov 2004 21:24:17 -0700, "Dick Watson"
<littlegreengecko[at]mind-enufalready-spring.com> wrote:

- quote -

> Change "Details" to "Settings" and these instructions should still be good.

Thanks for your help.

I tried that, but the Rename box just let me rename the investment.
There were no other options available in the Rename dialog. I am
using Advanced Register, but changing to Essential Register gave the
same result.

I have an investment that is the cash in the account (1 share is 1
dollar). Fidelity posts interest payments to this investment as
Dividend transactions. These dividends show up in the Cash summary
line for the account, but the shares I added when I initially set up
the account do not. Obviously, I am misunderstanding something. I'm
completely frustrated with TFM that Microsoft provides. I see a Cash
Portion Details in the Change Account Settings view, but I have no
idea what affects what. Arrrrgh.

--
regards, Fred

"Verbing weirds language." -- Calvin
  #3  
Old 11-19-2004, 03:24 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

Change "Details" to "Settings" and these instructions should still be good.

"Derf" <derf[at]savrola.org> wrote in message
news:5cqqp09f36npkihl489sjvk0gf8v364p13[at]4ax.com...
- quote -

> On Sun, 7 Nov 2004 07:34:10 -0700, "Dick Watson"
> <littlegreengecko[at]mind-enufalready-spring.com> wrote:
> > You setup a Cash Account for an Investment Account. An Investment Account
> > holds Investments like, say, Mutual Funds.
> > > If you have an Investment Account setup, you can add a Cash Account to it

> > by
> > going into the Investment Account Details (change account details or
> > R-click
> > on the account in the account list and select account details) and
> > clicking
> > on the Rename button. In that box, of all places, is a check box for
> > enabling or disabling an associated cash account.

> How would one do this for M2005? TIA.
> --
> regards, Fred
> "Verbing weirds language." -- Calvin



  #2  
Old 11-19-2004, 02:34 AM
Derf
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

On Sun, 7 Nov 2004 07:34:10 -0700, "Dick Watson"
<littlegreengecko[at]mind-enufalready-spring.com> wrote:

- quote -

> You setup a Cash Account for an Investment Account. An Investment Account
> holds Investments like, say, Mutual Funds.
> If you have an Investment Account setup, you can add a Cash Account to it by
> going into the Investment Account Details (change account details or R-click
> on the account in the account list and select account details) and clicking
> on the Rename button. In that box, of all places, is a check box for
> enabling or disabling an associated cash account.


How would one do this for M2005? TIA.

--
regards, Fred

"Verbing weirds language." -- Calvin
  #1  
Old 11-07-2004, 02:19 PM
Mangy Moose
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uaKWhcNxEHA.824[at]TK2MSFTNGP11.phx.gbl...

[snip]
- quote -

> on the account in the account list and select account details) and
> clicking on the Rename button. In that box, of all places, is a check box
> for enabling or disabling an associated cash account.


That's what I was looking for. I never thought of looking in the "rename"
option. How intuitive.

Thanks.
Moose

- quote -

> "Mangy Moose" <mangy.moose[at]nowhere.us> wrote in message
> news:O7S2dUNxEHA.4008[at]TK2MSFTNGP10.phx.gbl...
> > Is it possible to set up a cash account in a mutual fund in Money 2004?
> > > If so, how do I go about doing it?



 
Old 11-07-2004, 01:34 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Mutual Fund Cash Account

You setup a Cash Account for an Investment Account. An Investment Account
holds Investments like, say, Mutual Funds.

If you have an Investment Account setup, you can add a Cash Account to it by
going into the Investment Account Details (change account details or R-click
on the account in the account list and select account details) and clicking
on the Rename button. In that box, of all places, is a check box for
enabling or disabling an associated cash account.

"Mangy Moose" <mangy.moose[at]nowhere.us> wrote in message
news:O7S2dUNxEHA.4008[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Is it possible to set up a cash account in a mutual fund in Money 2004?
> If so, how do I go about doing it?



  #-1  
Old 11-07-2004, 01:21 PM
Mangy Moose
Guest
 
Posts: n/a
Default Mutual Fund Cash Account

Is it possible to set up a cash account in a mutual fund in Money 2004?

If so, how do I go about doing it?

Regards,
Moose


 

Tags
account, cash, fund, mutual
Similar Threads
Thread Forum Replies Last Post
Mutual Fund Fees
Gregg: How is the best way to enter mutual fund fees? My fees are settled via selling of actual shares to cover the cost of fees. Any comments would...
Microsoft Money 1 09-17-2004 07:50 PM
Choosing mutual fund under investment account
John Chow: How to create an investment account. In the investment account how to go about choosing whether the account is a stock or bond or mutual fund. I...
Microsoft Money 1 10-08-2003 02:07 AM
M2004: Can a money market fund be changed to regular mutual fund?
Aloke Prasad: My retirement plan (TSP for Govt employees) used a system of providing quarterly valuations. I handled this by creating an investment called CFund...
Microsoft Money 4 08-26-2003 01:36 AM
Mutual Fund ???
fountain 27: I can not get the "gain" column to calculate correctly on the mutual funds I own? Any suggestions?
Microsoft Money 1 07-13-2003 09:48 PM
Designate a MMkt fund as the associated cash account?
Don Gatz: I opened a new Fidelity brokerage account to receive some stocks and mutual funds being transferred from another account. In the transferred-in...
Microsoft Money 1 07-08-2003 01:40 PM



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 09:13 PM.