1. Home
  2. Quicken Personal Finance
  3. Mysterious cash balance - Q2009Deluxe

Mysterious cash balance - Q2009Deluxe

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

Reply to
usaf.jayhawk
Loading thread data ...

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.

Reply to
John Pollard

snipped-for-privacy@gmail.com wrote in news:ne13s55q5jfvlpack0hbetvn0ofottiro7@

4ax.com:

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.

Reply to
CSM1

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.

Reply to
usaf.jayhawk

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.