How do I track the performance of cash in an investment account?
There are two ways to track the performance of cash or money market fund holdings in Quicken.
If you haven't set up the investment account for transaction download
To use this method, you must first add a money market fund security. Add a new security and name it something like MMF (for money market fund). For the security type, select Stock. For the share price, enter $1/share to represent the cash or money market fund. Then keep the account cash balance at zero by buying or selling shares of the MMF to offset any transactions that require cash (such as the sale or purchase of securities).
Pros and cons
This method may make your transaction list look closest to the statement you receive from your brokerage account. However, it's the most time-consuming method.
Example
To represent a stock purchase, enter a Buy action of the security along with a Sell action of the MMF. When you receive a dividend from the security, enter a Div action in the security, and also enter a Buy action in the MMF.
When reconciling this account, reconcile to the (typically zero) cash balances in your brokerage statement. As a part of the reconciling process, verify that the new balance for the money market fund is correct.
12/31/07 | XIn | [BANK] | $5,000 |
12/31/07 | Buy | MMF | $5,000 |
1/1/08 | Sell | MMF | $1,500 |
1/1/08 | Buy | AAP | $1,500 |
2/1/08 | Div | AAP | $5 |
2/1/08 | Buy | MMF | $5 |
2/15/08 | ReinvDiv | MMF | $12 |
3/1/08 | Sell | AAP | $2,000 |
3/1/08 | Buy | MMF | $2,000 |
If you set up your investment account for transaction download
If you set up your investment account for transaction download, the first time you download, Quicken identifies your financial institution's money market fund security and prompts you to use it for cash tracking. When you do this, Quicken calculates the performance for you, based on the money market fund's Dividend transactions.
The ability to track your money market fund balance as cash isn't available for all financial institutions. If this ability is available for your financial institution, Quicken displays the Cash Representation dialog the first time you download. (If you don't see the Cash Representation dialog during your first download, this option isn't available for your financial institution.)
If the option to track a money market fund as a security is available for your financial institution, and you initially choose to track the money market fund as a security, you can convert the fund to cash later. However, once you select to convert a money market fund to cash, you may not be able to convert it back to a money market fund later.