Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 02-23-2008, 08:49 PM
Sjoa
Guest
 
Posts: n/a
Default Re: automatic investment results in negative cash transaction

Thanks Cal...you rock! I missed the little drop down menu from the pop up
box that asked me where the money was coming from....

thx again...

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sjoa wrote:
> > Hi, I'm using MS Money 07 Deluxe.
> > > I have automatic investments set up for some of my Mutual Funds. This money

> > is drawn directly out of my checking account. I also have MS Money
> > automatically updating the prices and account balance of these investments,
> > so when I log on, I have transactions to read.
> > > When these automatic investments trigger, my account balance for these

> > Mutual Funds is always short the amount I invest. For instance, I invest
> > $100 per month in one mutual fund, and when Money updates this investment,
> > the account balance is $100 short of what it should be. This $100 is listed
> > as a cash transaction in the account summary.
> > > So, I asked Money to stop tracking cash transactions for this account, but

> > the only way to do this is to disable automatic updates, which doesn't make
> > sense. I want Money to update this account automatically, but why does it
> > list the amount I automatically invest as a negative?
> > > Is there a way to have it track my automatic investments with auto update

> > and still be accurate with the balance?

> I think you are saying that you download a monthly Buy transaction
> from the mutual fund company.
> If your amount is actually fixed, you could schedule a transfer of
> $100 monthly from checking to the cash account of the mutual fund
> account. That would balance out the cash transactions register.
> Alternatively, manually change the TransferFrom field of the Buy to
> select the checking account. Ctrl+T will let you see the
> TransferFrom field in the register even when you are not editing a
> transaction. It is a toggle. When/if you download the checking
> account, you would want to match to the $100 transfer.

 
Old 02-23-2008, 07:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: automatic investment results in negative cash transaction

In microsoft.public.money, Sjoa wrote:

- quote -

> Hi, I'm using MS Money 07 Deluxe.
> I have automatic investments set up for some of my Mutual Funds. This money
> is drawn directly out of my checking account. I also have MS Money
> automatically updating the prices and account balance of these investments,
> so when I log on, I have transactions to read.
> When these automatic investments trigger, my account balance for these
> Mutual Funds is always short the amount I invest. For instance, I invest
> $100 per month in one mutual fund, and when Money updates this investment,
> the account balance is $100 short of what it should be. This $100 is listed
> as a cash transaction in the account summary.
> So, I asked Money to stop tracking cash transactions for this account, but
> the only way to do this is to disable automatic updates, which doesn't make
> sense. I want Money to update this account automatically, but why does it
> list the amount I automatically invest as a negative?
> Is there a way to have it track my automatic investments with auto update
> and still be accurate with the balance?


I think you are saying that you download a monthly Buy transaction
from the mutual fund company.

If your amount is actually fixed, you could schedule a transfer of
$100 monthly from checking to the cash account of the mutual fund
account. That would balance out the cash transactions register.

Alternatively, manually change the TransferFrom field of the Buy to
select the checking account. Ctrl+T will let you see the
TransferFrom field in the register even when you are not editing a
transaction. It is a toggle. When/if you download the checking
account, you would want to match to the $100 transfer.
  #-1  
Old 02-23-2008, 06:43 PM
Sjoa
Guest
 
Posts: n/a
Default automatic investment results in negative cash transaction

Hi, I'm using MS Money 07 Deluxe.

I have automatic investments set up for some of my Mutual Funds. This money
is drawn directly out of my checking account. I also have MS Money
automatically updating the prices and account balance of these investments,
so when I log on, I have transactions to read.

When these automatic investments trigger, my account balance for these
Mutual Funds is always short the amount I invest. For instance, I invest
$100 per month in one mutual fund, and when Money updates this investment,
the account balance is $100 short of what it should be. This $100 is listed
as a cash transaction in the account summary.

So, I asked Money to stop tracking cash transactions for this account, but
the only way to do this is to disable automatic updates, which doesn't make
sense. I want Money to update this account automatically, but why does it
list the amount I automatically invest as a negative?

Is there a way to have it track my automatic investments with auto update
and still be accurate with the balance?
Thanks in advance,
Bill

 

Tags
automatic, cash, investment, negative, results, transaction
Similar Threads
Thread Forum Replies Last Post
Money 2008 Investment Cash Transaction
MikeV06: I just noticed when converting M4 to M8 that I have investment cash transactions going all the way back to 1997. I guess one has to carry...
Microsoft Money 5 09-08-2007 04:35 PM
How to save 'Forecast your cash flow' results
@shish daga: Hi, The way I can create various reports with different settings and save them in favourites so that I can use that setting in future, how can I...
Microsoft Money 3 06-12-2007 02:49 PM
Negative Cash Transaction Account Balance in 401k account
MikeyFrat: Hi, I have a 401k investment account from a former employer,setup in Money 2006 DLX as a retirement account, tracking cash transactions. Though I...
Microsoft Money 3 01-29-2007 04:59 AM
Investment balances show contributions as negative cash balance
J.Delage: Hi, I'm using Money 2006. When I downloaded transaction for the first time, Money added up all my cash contributions as a negative cash balance....
Microsoft Money 6 06-04-2006 02:17 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 12:41 AM.