Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 12-20-2008, 02:30 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF

The MMF is an investment, much as a share of stock is. When you moved
from Chase to JPM, you moved the investment from one account to another.
Money has a way to do that between investment accounts. It cannot
transfer an investment from a 'bank' account, because it doesn't see the
bank account as an investment.

The only way to accomplish this is by transferring the cash in the bank
account to a new investment account. If you choose at that point, you
can purchase the MMF. Personally, I wouldn't recommend that. Since MMF
funds are always (you hope) valued at $1, it's essentially the same as
cash. You can buy and sell the $1 MMF shares, if you want to, but it's
not worth the hassle.

All I do (and others here do the same) is hold cash in the cash side of
investment account, and record MMF dividends in the investment
transactions part. Money will gripe that you're recording dividends of
an investment you don't own, but ignore that. It's not a requirement.
When you get dividends, deposit them to the cash account. The balance in
the cash account reflects the MMF balance.

Alternatively, open an investment account without a separate cash
account. You can deposit/withdraw directly from the account itself, in
that case. That may better represent the MMF, but which you choose
doesn't matter much. If you have online connections, the account
structure created by the account manager pretty much dictates what you
have to do.
--
Chris Cowles
Gainesville, FL

"Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
news:OdyBgqyWJHA.4280[at]TK2MSFTNGP02.phx.gbl...

- quote -

> No this is not what happened. It is the exact same Money Market Fund,
> same symbol, same everything. It's just that it was transferred from
> being processed through my bank (Chase) to be processed the a
> brokerage (JP Morgan Chase brokerage). It is no different than moving
> an investment from one brokerage house to another. The problem is
> that I did not set up the MMF as an investment, but as an account, so
> I can't move it in Money.



  #4  
Old 12-11-2008, 12:22 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF

In microsoft.public.money, Marilyn & Bob wrote:

- quote -

> > I don't think there is a way to directly do that. You could
> > File-> Export the deposits and withdrawals from that bank account,
> > and File-> Import into the cash transactions register.

> Yes, but how do I then get all the transactions from the cash transactions
> register to the investment account register?


After the File-> Import, they would be in the cash transactions
register of the investment account as they were in the bank account.

- quote -

> > > > account I'll just keep the MMF as a separate savings account and keep the
> > > brokerage account empty.
> > > How is that better than doing the Transfer of the full value to the

> > cash transactions register of the brokerage account?

> Only reason is that I would like to keep the continuity as everything is the
> same (including my account number) except that it is now held by their
> brokerage section, not their banking division. Closing the pre brokerage
> account and transferring the money to a new investment account seems to me
> like *archiving* and we know why we want to avoid that <g> .


But closing the account differs from archiving in that the old
transactions are still there. A closed account is still accessible,
except that you can hide or not hide it from view in the account
list etc.


  #3  
Old 12-11-2008, 04:28 AM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:mqt0k4hl4tfk4uc37fop9o3nl1itbkv4k0[at]4ax.com...
- quote -

> In microsoft.public.money, Marilyn & Bob wrote:
> > Thanks for your quick response. Comments interspersed.
> > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message

> > news:5ua0k494ebop2rqg2ehg83oiiuvtfrm7l9[at]4ax.com...
> > > In microsoft.public.money, Marilyn & Bob wrote:

<<<SNIP> > > > As I said, I did and will do all the transactions manually, no
> > downloading.

> Downloads from brokers tend to be pretty reliable. Can't tempt ya.


You can't tempt me because Chase does not have a download feature (direct or
from the website) for its Investment Accounts, even though it has direct
download for its bank and credit card accounts. Moreover, my main broker is
Merrill Lynch and while they do provide downloads from their website, it
doesn't work for me because of their poor coding. I have a Nuveen Municipal
Mutual Fund with them that they classify as a Stock in their ofx file which
complete screws up the whole download, so I can't use it. (I tried
converting the Fund to a stock in Money, but it couldn't handle the internal
Capital Gains transactions). I do download (direct) from Dreyfus (one mutual
fund).


- quote -

> > I think that if there is no way to convert my bank account to an
> > investment

> I don't think there is a way to directly do that. You could
> File-> Export the deposits and withdrawals from that bank account,
> and File-> Import into the cash transactions register.


Yes, but how do I then get all the transactions from the cash transactions
register to the investment account register?

- quote -

> > account I'll just keep the MMF as a separate savings account and keep the
> > brokerage account empty.

> How is that better than doing the Transfer of the full value to the
> cash transactions register of the brokerage account?


Only reason is that I would like to keep the continuity as everything is the
same (including my account number) except that it is now held by their
brokerage section, not their banking division. Closing the pre brokerage
account and transferring the money to a new investment account seems to me
like *archiving* and we know why we want to avoid that <g> .

- quote -

> If you are
> happy with the way you were doing it, you could just rename that
> bank account to reflect that the money is now at the broker.


I'm not happy with it, but it looks like it's the best I can do. From
hindsight, I should have set this up originally as a MMF, but it's obviously
too late now.
--
Peace,
BobJ


  #2  
Old 12-11-2008, 01:24 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF

In microsoft.public.money, Marilyn & Bob wrote:

- quote -

> Thanks for your quick response. Comments interspersed.
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:5ua0k494ebop2rqg2ehg83oiiuvtfrm7l9[at]4ax.com...
> > In microsoft.public.money, Marilyn & Bob wrote:
> > > > I have a Money Market Fund that I have been tracking in Money since 1996.
> > > It averages about 25 transactions per year (a monthly reinvest dividend +
> > > transfers in and out). As, at the time, the fund was not in a Brokerage
> > > Account, but handled directly through my Bank, I chose to set it up as a
> > > separate Bank Account in Money. Recently, one of their representatives
> > > convinced me to move this Fund to a brokerage account with them. I've
> > > set
> > > up the Brokerage Account in Money and would like to put the MMF into it in
> > > Money Plus Deluxe to reflect the current real life situation. Does anyone
> > > have an idea how I can convert this account with 12 years of data from a
> > > Bank Account to an Investment MMF so I can move it into the brokerage
> > > account? Note that I have not (and will not) download data in this
> > > account.
> > > I enter all transactions manually.
> > > The easiest way, and the way that will reflect what actually

> > happened, is to do a Transfer from the bank account to the cash
> > transactions of the broker account. Having done that, you can mark
> > the bank account as Closed.

> No this is not what happened. It is the exact same Money Market Fund, same
> symbol, same everything. It's just that it was transferred from being
> processed through my bank (Chase) to be processed the a brokerage (JP Morgan
> Chase brokerage). It is no different than moving an investment from one
> brokerage house to another. The problem is that I did not set up the MMF as
> an investment, but as an account, so I can't move it in Money.
> > > In the brokerage account, I would follow what method is being used

> > in the downloads directly from the broker if you are downloading. If
> > you download Buys and Sells downloaded, go with that. If you don't,
> > let the balance in the cash transactions register reflect the sweep
> > MMF balances in addition to the unsettled funds.
> > > If you are doing hand entry, in the cash transactions for that

> > account, do a Buy of the MMF. That will then remove the cash from
> > the cash transactions register.
> > As I said, I did and will do all the transactions manually, no downloading.


Downloads from brokers tend to be pretty reliable. Can't tempt ya.

- quote -

> I think that if there is no way to convert my bank account to an investment

I don't think there is a way to directly do that. You could
File-> Export the deposits and withdrawals from that bank account,
and File-> Import into the cash transactions register.

- quote -

> account I'll just keep the MMF as a separate savings account and keep the
> brokerage account empty.


How is that better than doing the Transfer of the full value to the
cash transactions register of the brokerage account? If you are
happy with the way you were doing it, you could just rename that
bank account to reflect that the money is now at the broker.
  #1  
Old 12-10-2008, 11:51 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF

Thanks for your quick response. Comments interspersed.

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:5ua0k494ebop2rqg2ehg83oiiuvtfrm7l9[at]4ax.com...
- quote -

> In microsoft.public.money, Marilyn & Bob wrote:
> > I have a Money Market Fund that I have been tracking in Money since 1996.
> > It averages about 25 transactions per year (a monthly reinvest dividend +
> > transfers in and out). As, at the time, the fund was not in a Brokerage
> > Account, but handled directly through my Bank, I chose to set it up as a
> > separate Bank Account in Money. Recently, one of their representatives
> > convinced me to move this Fund to a brokerage account with them. I've
> > set
> > up the Brokerage Account in Money and would like to put the MMF into it in
> > Money Plus Deluxe to reflect the current real life situation. Does anyone
> > have an idea how I can convert this account with 12 years of data from a
> > Bank Account to an Investment MMF so I can move it into the brokerage
> > account? Note that I have not (and will not) download data in this
> > account.
> > I enter all transactions manually.

> The easiest way, and the way that will reflect what actually
> happened, is to do a Transfer from the bank account to the cash
> transactions of the broker account. Having done that, you can mark
> the bank account as Closed.


No this is not what happened. It is the exact same Money Market Fund, same
symbol, same everything. It's just that it was transferred from being
processed through my bank (Chase) to be processed the a brokerage (JP Morgan
Chase brokerage). It is no different than moving an investment from one
brokerage house to another. The problem is that I did not set up the MMF as
an investment, but as an account, so I can't move it in Money.


- quote -

> In the brokerage account, I would follow what method is being used
> in the downloads directly from the broker if you are downloading. If
> you download Buys and Sells downloaded, go with that. If you don't,
> let the balance in the cash transactions register reflect the sweep
> MMF balances in addition to the unsettled funds.
> If you are doing hand entry, in the cash transactions for that
> account, do a Buy of the MMF. That will then remove the cash from
> the cash transactions register.


As I said, I did and will do all the transactions manually, no downloading.
I think that if there is no way to convert my bank account to an investment
account I'll just keep the MMF as a separate savings account and keep the
brokerage account empty.
--
Peace,
BobJ


 
Old 12-10-2008, 07:56 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Convert from Bank Account to MMF

In microsoft.public.money, Marilyn & Bob wrote:

- quote -

> I have a Money Market Fund that I have been tracking in Money since 1996.
> It averages about 25 transactions per year (a monthly reinvest dividend +
> transfers in and out). As, at the time, the fund was not in a Brokerage
> Account, but handled directly through my Bank, I chose to set it up as a
> separate Bank Account in Money. Recently, one of their representatives
> convinced me to move this Fund to a brokerage account with them. I've set
> up the Brokerage Account in Money and would like to put the MMF into it in
> Money Plus Deluxe to reflect the current real life situation. Does anyone
> have an idea how I can convert this account with 12 years of data from a
> Bank Account to an Investment MMF so I can move it into the brokerage
> account? Note that I have not (and will not) download data in this account.
> I enter all transactions manually.


The easiest way, and the way that will reflect what actually
happened, is to do a Transfer from the bank account to the cash
transactions of the broker account. Having done that, you can mark
the bank account as Closed.

In the brokerage account, I would follow what method is being used
in the downloads directly from the broker if you are downloading. If
you download Buys and Sells downloaded, go with that. If you don't,
let the balance in the cash transactions register reflect the sweep
MMF balances in addition to the unsettled funds.

If you are doing hand entry, in the cash transactions for that
account, do a Buy of the MMF. That will then remove the cash from
the cash transactions register.

  #-1  
Old 12-10-2008, 07:48 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Convert from Bank Account to MMF

I have a Money Market Fund that I have been tracking in Money since 1996.
It averages about 25 transactions per year (a monthly reinvest dividend +
transfers in and out). As, at the time, the fund was not in a Brokerage
Account, but handled directly through my Bank, I chose to set it up as a
separate Bank Account in Money. Recently, one of their representatives
convinced me to move this Fund to a brokerage account with them. I've set
up the Brokerage Account in Money and would like to put the MMF into it in
Money Plus Deluxe to reflect the current real life situation. Does anyone
have an idea how I can convert this account with 12 years of data from a
Bank Account to an Investment MMF so I can move it into the brokerage
account? Note that I have not (and will not) download data in this account.
I enter all transactions manually.
--
Peace,
BobJ


 

Tags
account, bank, convert, mmf
Similar Threads
Thread Forum Replies Last Post
Linking Credit Card Account to Bank Account
JimB: My credit card and my checking account are at the same bank. I wish to be able to link the two so that when I pay the credit card account balance,...
Microsoft Money 1 05-08-2006 02:24 AM
Can't download bank account activitiy to a new account
Barak: Recently i've changed my bank account. When i've tried to download the activity from my new bank account to Microsoft Money 2204 for the first time,...
Microsoft Money 2 06-25-2005 01:46 PM
Convert a category into an asset account
judy: Hi, I have been writing checks to pay for materials for a new building, and assigning those payments to various subcategories of a main category...
Microsoft Money 4 11-05-2003 09:34 PM
Saving OFX files from California Bank Of America...convert ofx?
Dennis Hussey: All, I've seen similar posts, but not exactly the same. I saved an OFX from California BofA, and I can no longer retrieve the data in a...
Microsoft Money 1 10-28-2003 04:21 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 03:11 AM.