How to use Money Market as a cash account
Mark256
Member ✭✭
I have several investment accounts where the “cash” account is a money market account. When I buy a stock Quicken sees it as a sale of the money market account and wants to record proceeds “to this account’s cash balance.” Of course, this should be a deduction from the money market account since I purchased a stock.
This results in false balances in the money market and the non-existing “cash” account. This must be a common problem, so how do you all handle this? I know that I can create an affiliated cash account and use the money market account for that, but I already have a lot of investment accounts and this will make it confusing.
I use Quicken 2020 Home, Business, and Rental Property
This results in false balances in the money market and the non-existing “cash” account. This must be a common problem, so how do you all handle this? I know that I can create an affiliated cash account and use the money market account for that, but I already have a lot of investment accounts and this will make it confusing.
I use Quicken 2020 Home, Business, and Rental Property
0
Best Answers
-
You basically have two choices. Which is best for you depends on your personal preference and how your brokerage handles the downloaded transactions.
Option 1 is what you describe above - keep the cash in a MMF and when for example you buy stock, you sell the MMF with the proceeds going to the account's "Cash Balance" then the money for the purchase comes from the cash balance, reducing it to zero. Vanguard for example downloads all these transactions.
Option 2 is to ignore the MMF and keep all the cash in the cash balance. Some brokerages do this in their downloads, i.e. there are no Buys and Sells of the MMF. With other brokerages, you may need to delete the downloaded MMF Buys and Sells.
QWin Premier subscription6 -
For our taxable brokerage accounts, at Fidelity, I use the "Show cash in a checking account" option of the BROKERAGE accounts. These are our primary checking accounts.For our IRA accounts, I use option 2 (above).
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP5
Answers
-
You basically have two choices. Which is best for you depends on your personal preference and how your brokerage handles the downloaded transactions.
Option 1 is what you describe above - keep the cash in a MMF and when for example you buy stock, you sell the MMF with the proceeds going to the account's "Cash Balance" then the money for the purchase comes from the cash balance, reducing it to zero. Vanguard for example downloads all these transactions.
Option 2 is to ignore the MMF and keep all the cash in the cash balance. Some brokerages do this in their downloads, i.e. there are no Buys and Sells of the MMF. With other brokerages, you may need to delete the downloaded MMF Buys and Sells.
QWin Premier subscription6 -
For our taxable brokerage accounts, at Fidelity, I use the "Show cash in a checking account" option of the BROKERAGE accounts. These are our primary checking accounts.For our IRA accounts, I use option 2 (above).
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP5 -
Jim and Not CPA thanks, I would not have figured that out. You are geniuses.0
-
@Jim_Harman My Fidelity accounts technically keep cash in a core MMF, however they never properly transmit the necessary buy/sell transactions to Quicken to keep the core fund in balance in my register.
As a result, to simplify things, I have always shown my core fund as cash, this works fine for me.Quicken 2017 Premier - Windows 10 Pro0 -
Sure would be easier if Quicken allowed the stock purchase to come directly from the money market accounts instead of entering an additional transaction manipulating between money market and cash accounts for each purchase.0
-
I am trying to use a Fidelity brokerage account as a checking account - record checks, balance account etc. - Can I do that???0
-
DG@CP-nc said:I am trying to use a Fidelity brokerage account as a checking account - record checks, balance account etc. - Can I do that???
Basically you go to the account's gear menu, select Edit account details, and select Yes next to Show cash in a checking account. If your account uses a money market fund to hold its cash, you would enter a Sell for the balance of that fund and delete or not accept any downloaded Buy and Sell transactions for that fund. The account's cash will then be shown in the linked checking account, which you can treat like any other checking account.
Be sure to back up your data file before making these changes, in case you do not like the result.
QWin Premier subscription0
This discussion has been closed.