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

Cal
Sat Feb 23 14:47:54 CST 2008

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.

Sjoa
Sat Feb 23 15:49:01 CST 2008

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:

> 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.
>