Prev: Quicken 2010 sees transfers in as debits
Next: Q 2010: Projected Fed Withholdings not working (maybe)
From: usaf.jayhawk on 11 Apr 2010 04:22
Been tracking my 401(k) for 6 years. Entering transactions in by
hand, painful but download doesn't seem to work correctly.

Anyway, every share of every fund is correct and the security value
matches my online account value exactly...except quicken shows a
$1200+ cash balance. This account uses a money market fund instead of
a cash balance; there shouldn't be a cash balance.

How do I track these down in the register to find the source of this?
I've tried reports of all types but can't finure out what I'm looking
for.

Thanks
From: CSM1 on 11 Apr 2010 10:42
usaf.jayhawk(a)gmail.com wrote in news:ne13s55q5jfvlpack0hbetvn0ofottiro7@
4ax.com:

> Been tracking my 401(k) for 6 years. Entering transactions in by
> hand, painful but download doesn't seem to work correctly.
>
> Anyway, every share of every fund is correct and the security value
> matches my online account value exactly...except quicken shows a
> $1200+ cash balance. This account uses a money market fund instead of
> a cash balance; there shouldn't be a cash balance.
>
> How do I track these down in the register to find the source of this?
> I've tried reports of all types but can't finure out what I'm looking
> for.
>
> Thanks
>

The cash balance in the 401K register is because you are not doing a
transfer out of the 401K to the Money Market Account.

In Investment accounts, the category is DivX for Dividend Transfer.

Check your register in the 401K account, the dividends are probably
entered as _Div, which is a dividend paid.

--
CSM1
http://www.carlmcmillan.com
From: John Pollard on 11 Apr 2010 10:42
usaf.jayhawk(a)gmail.com wrote:
> Been tracking my 401(k) for 6 years. Entering transactions in by
> hand, painful but download doesn't seem to work correctly.
>
> Anyway, every share of every fund is correct and the security value
> matches my online account value exactly...except quicken shows a
> $1200+ cash balance. This account uses a money market fund instead of
> a cash balance; there shouldn't be a cash balance.
>
> How do I track these down in the register to find the source of this?
> I've tried reports of all types but can't finure out what I'm looking
> for.

So the total value of the account is overstated in Quicken by the $1200+
cash?

Where is the account showing the cash balance?

What is the value of the money market fund?

What do you see in the "Cash Bal" column of the account register? Have
you scrolled through the register to see if/where the "Cash Bal" is
changing? If you run an Investment Transactions report for all dates for
the account, you should be able to see essentially the same thing, by
watching how its Cash column changes.

--

John Pollard
news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
Your source of user-to-user Quicken help


From: usaf.jayhawk on 22 Apr 2010 03:05
On 11 Apr 2010 14:42:32 GMT, CSM1 <nomail(a)nomoremail.com> wrote:

>usaf.jayhawk(a)gmail.com wrote in news:ne13s55q5jfvlpack0hbetvn0ofottiro7@
>4ax.com:
>
>> Been tracking my 401(k) for 6 years. Entering transactions in by
>> hand, painful but download doesn't seem to work correctly.
>>
>> Anyway, every share of every fund is correct and the security value
>> matches my online account value exactly...except quicken shows a
>> $1200+ cash balance. This account uses a money market fund instead of
>> a cash balance; there shouldn't be a cash balance.
>>
>> How do I track these down in the register to find the source of this?
>> I've tried reports of all types but can't finure out what I'm looking
>> for.
>>
>> Thanks
>>
>
>The cash balance in the 401K register is because you are not doing a
>transfer out of the 401K to the Money Market Account.
>
>In Investment accounts, the category is DivX for Dividend Transfer.
>
>Check your register in the 401K account, the dividends are probably
>entered as _Div, which is a dividend paid.

Neither of your assumptions are actually correct. My 401(k) and my
company's match go in as cash from my paycheck. I then purchase all
shares from that balance. The money market fund is actually treated
as just another fund inside the 401(k). The account manager buys
money market shares at $1/share as a holding pen until he buys real
funds. However the money market fund pays dividends so it's better
than a cash balance.

All diviends are in fact entered as DivX. None over show up as cash
but are reinvested.

More digging and I found a few simple typos and simply entering in the
wrong action. Took a couple of hours and some clever work in Excel to
find it.
 | 
Pages: 1
Prev: Quicken 2010 sees transfers in as debits
Next: Q 2010: Projected Fed Withholdings not working (maybe)