:

How does Quicken identify "cash"

Quicken 2005.
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 transactions?
Thanks!
Reply to
MikeH
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.
--
Regards,
Fred
 Click to see the full signature
Reply to
Fred Smith
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 investment account.
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.
db
Reply to
danbrown
"MikeH" wrote
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).
Reply to
John Pollard
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
Reply to
MikeH
"MikeH" wrote
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 checking account.
Reply to
John Pollard

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.