experchange > money

J.Delage (06-03-06, 08:00 PM)
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. This
completely skews my portfolio view - in fact, it shows a negative cash
balance worth more than all my investments...

How can I solve this? I just started using Money and I don't have that much
work put into it so far. I'd be willing to delete & re-upload accounts if I
did something wrong initially.

Most of those contributions are direct deposit from paycheck to 401(k) and
never went through my bank account. A smaller portion are after tax deposits
from my bank account (but my bank isn't set up for Money yet).

Thanks!
Cal Learner-- MVP (06-03-06, 08:19 PM)
In microsoft.public.money, J.Delage wrote:

>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. This
>completely skews my portfolio view - in fact, it shows a negative cash
>balance worth more than all my investments...
>How can I solve this? I just started using Money and I don't have that much
>work put into it so far. I'd be willing to delete & re-upload accounts if I
>did something wrong initially.


What I suspect is happening is that the Buys were downloaded, but
the contributions that funded those buys were not. There are a
couple of ways to handle this. You could just get rid of the
contributions register. This is easier, but is not as good as having
actual contribution tracking.

I would get things going by adjusting the initial balance of the
contributions account to raise the opening balance to zero. From
that register, click ChangeAccountSettings on the left.
OpeningBalance is near the bottom. Alternatively, you can create a
single transaction that pre-dates the others. This would serve as a
catch-up contribution transaction.
Dick Watson (06-03-06, 08:34 PM)
See also . In general, you need to get the
cash in there that is getting invested.

"J.Delage" <JDelage> wrote in message
news:3175
[..]
J.Delage (06-03-06, 08:38 PM)
Cal,

Thanks. My bank is supposed to get set up for Money sometimes this month
(knock on wood) and when that happens, I suppose I will be able to link each
contribution on the bank side to the contribution on the investment side.

However, for the 401(k) that will not be possible since the money is sent
directly from my paycheck (and BTW that's also how most of my income taxes
are paid). Any suggestion on how I should manage this side?

Thanks,

Joss
J.Delage (06-03-06, 08:47 PM)
Dick - thanks for that, it's a good set of issues. I'll peruse it.

"Dick Watson" wrote:
Cal Learner-- MVP (06-03-06, 09:00 PM)
In microsoft.public.money, J.Delage wrote:

>Thanks. My bank is supposed to get set up for Money sometimes this month
>(knock on wood) and when that happens, I suppose I will be able to link each
>contribution on the bank side to the contribution on the investment side.
>However, for the 401(k) that will not be possible since the money is sent
>directly from my paycheck (and BTW that's also how most of my income taxes
>are paid). Any suggestion on how I should manage this side?


I would not go so far as making it a suggestion, but in the Account
Settings for your 401(k), you could clear TrackCashTransactions.
Dick Watson (06-04-06, 04:17 AM)
The "normal" way to do this is to a) schedule a Paycheck that includes taxes
and 401k transfers, among other things, and then b) download a deposit of
the net paycheck and match it up with the scheduled transaction. The net
amount of the scheduled Paycheck is what the downloaded deposit data from
you bank should match up with. But all of the details will NEVER get
downloaded from the bank.

"J.Delage" <JDelage> wrote in message
news:819e
panuratj5 (08-16-19, 11:06 AM)
Help
Similar Threads