For years I have been updating an investment account manually. I am using
split accounts where the core funds are in a cash flow account and the
various investment positions are in the investment account.
The financial institution recently enabled a Quicken 2005/2006 interface so
data can be downloaded directly to Quicken. Trouble is Quicken treats
transactions involving the core money market as ordinary mutual fund
transactions. How do I get Quicken to recognize these as core account
When you use Quicken in a non-standard way, you can't expect your bank download
to accommodate you.
The only solution I see is to change your "core funds" to an investment account,
because that's where Quicken expects them to be. Either that, or don't use the
download feature, and keep updating the prices manually.
Are you using the MMF (i.e., the "cash flow account") as a "Linked"
account? If so, check out Q Help for linking an external MMF to an
Having an investment account with an external (i.e., "cash flow") MMF
was, previously, the preferred means of handling the issue. It became
optional with 2005 (?), but I maintain my Fidelity MMF as a separate
account because it's our primary checking account and I prefer the
visibility that such an arrangement affords.
There may be two possible approaches.
As Dan Brown indicated, Quicken will allow you to keep your
investment cash in a Quicken "cash flow" account linked to your
Quicken investment account. But you can not link an existing
Quicken cash flow account to a Quicken investment account; a new
Quicken cash flow account must be created by going to Edit
Account Details in the Account Attributes pane of the Summary
tab for the investment account ... and clicking "Yes", "Show
cash in a checking account". Quicken will create a new checking
account and link it to your Quicken investment account.
I have not spent any time recently on this subject, but I think
you could then do a select-all/copy/paste to move the existing
checking account transactions to the new linked checking account
and delete the old checking account.
An alternative approach may be possible if your fi allows it;
Quicken can simply treat mm fund transactions as cash
transactions, ignoring any buy/sell transactions (and I suspect,
treating reinvestments as plain Interest transactions). To see
if this is possible, open your investment account to the
Transactions tab; the select Investing Activities in the Quicken
Investing menu and click "Update Cash Balance". If you see a
button labelled "Cash Representation" at the bottom of the
resulting dialog, click that and I believe you will get the
chance to have Quicken treat your mm fund transactions as cash
transactions ... within your investment account. (If the Cash
Representation button is not present, I believe that means your
fi does not offer the option).
Perhaps I wasn't clear. I had already created a linked cash management
account long before attempting the automatic update. The automatically
downloaded money-market transactions don't get posted in the CMA. I did as
you suggested ("Update Cash Balance") and get a message "You cannot
reconcile or update the balance of a CMA linked investment account because
its cash balance is always zero. To reconcile the cash balance go to the
linked bank account." If I select the linked bank account I find that the
Update Cash Balance option is grayed out.
I guess for now I'll note and manually enter money market transactions (then
kill the downloaded transactions). Transactions involving the rest of my
investment positions can be downloaded normally. Cranky but still easier
than logging on and transcribing the stuff manually.
... Quicken treats transactions involving the core
The "two possibilities" I mentioned are mutually exclusive. If
you have a linked cash account, you can't have the mm fund
treated as cash in the investment account ... with a linked cash
account, there can be no cash in your investment account.
If you want to try treating the mm fund as cash in the
investment account, you have to tell Quicken to unlink the