Let users choose how Money Market transactions are treated
I'm pretty sure this is not a new idea, but I would like Quicken to let us choose how we want to treat money market transactions that brokers use for sweep accounts. Some brokers code these transactions as cash and some code it as a fund where you buy and sell shares as money comes in or goes out of the account. Some of us like it when the broker handles it as cash and some like it when they treat it like a Fund.
The situation is amplified when we have multiple accounts where these transactions are treated differently. Having accounts at both Fidelity and Vanguard for example. Some may just roll with it being different, but it seems many of us would prefer a consistent representation across all of our accounts. We end up spending way too much time editing the downloaded transactions in the accounts that don't handle the 'cash' the way we'd prefer it to be treated. It's time consuming yet somehow, I'm still doing it. Always hoping one day either the broker or Quicken will offer us a way to choose what we want.
I personally want to see these transactions represented as cash. That way I can easily see the cash available in each account. I like it so much better that I'm willing to change every money market "ReinvDiv" transaction to a plain "Div" transaction in all of my Vanguard accounts ("Reinvest - Income Reinvested" to "Inc - Income (Div, Int, etc.)").
It would be great if Quicken could come up with a way we can chose the option we prefer. Something that would intercept the incoming MMF transactions and change them to cash transactions (and vice versa for those who chose to have it the other way).
Comments
-
Hello @Geobrick,
To clarify the idea, are you wanting Quicken to create an interface that would allow users to essentially tell it "this fund is a Money Market account and I want you to show it as cash" or "the cash amount is actually a Money Market account, and I want you to show it as a fund by this name: XY123"?
Thank you!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
I think Quicken already does this up to its ability to do it. With maybe the exception being handling what Chase is doing (But maybe they can improve on it somehow).
First let me state the impossible case that you somehow think Quicken can handle. If the financial institution doesn't send any Mutual Market Fund transactions, it would be impossible for Quicken to know how to turn the "lack of transactions" into transactions.
That brings me to doing the opposite treating a Mutual Market Fund transactions as cash. When I setup for downloading my accounts at Chase it prompted me asking if I wanted to treat QDERQ as cash, and I said yes. So, Quicken removes these transactions and the buys/sells go to the cash balance. Now here is the rub. I know this question didn't popup on all the different financial institutions I have been with, and got the transactions. So, what triggers this? I would have to guess there is something in the information that they get from the financial institution that lets Quicken know that these are in fact Mutual Market Fund. Without that information it would be asking you for every one of your securities. So, I'm guessing that some financial institutions don't send this information correctly and Quicken has no idea that it is a Mutual Market Fund security.
Maybe they could allow for the user to just specify what is a Mutual Fund security somehow.
Chase on the other hand is just plain strange.
There is the QDERQ fund as I mentioned, but they also have these "back accounts" that are used for various things like cash is moved in and out of them for gathering interest, or holding cash where they are waiting for 3 days for the transaction to complete.
The result is none of these actually show up in the transactions, but when comparing shares they show up as different than what Quicken has until the sell completes in 3 days.
Signature:
This is my website: http://www.quicknperlwiz.com/1 -
Yes. I think that sums it up.
It's also about how Quicken enters the transactions for these situations. For those who want to treat it as cash, don't enter buy transactions after a dividend or deposit and don't enter any sell transactions for payments or stock buys. It would work the opposite way for someone who wants it treated as a MMF when their brokerage codes it as cash in the quicken downloads.
0 -
I've seen that come up at times in the past but not for something like the Vanguard sweep account.
I don't know exactly how quicken would implement my suggestion. I would think there's something in the downloaded data where it's coded in a way that quicken understands.
For a Money market, the # of shares are always equal to $1 so for your impossible situation, if the user wants to show the sweep amount as shares in a money fund to match their statements but their broker codes it as cash, it seems to me quicken can create a Reinvest Dividend transaction when cash is received by using the amount to come up with the proportional # shares bought as a reinvestment. In the other situation, Quicken can take an incoming ReinvDiv and change it to just a Div by ignoring the #shares. A more brute force method would be a macro-like script that runs after any update that looks for a specific type of transaction and converts it to the other. Kind of the way the renaming rule works. We'd set up rules for specific money market transactions and tell quicken what to do with them. I'm sure the programmers can come up with something more elegant but I'll except either.
0 -
Coincidently, I just got an email from Vanguard offering a new settlement option called the Vanguard Cash Deposit. It's an FDIC banking product. Right now, it seems to have a 3.7% return which is less than their Federal Money Market. That would probably fix things for me in quicken for vanguard but the cost of switching to a lower rate settlement fund isn't worth the convenience I'd get.
0 -
@Quicken Kristina I would like see the first option you described - Quicken receives money market fund transactions but treats them as cash - for the settlement fund in my Vanguard accounts. I think the user interface would have to let you specify which fund(s) to treat this way, because you can hold money market funds in addition to the settlement fund and users might not want to make an all or nothing decision.
A benefit of this is that it would make the "Show cash in a checking account" option more useful for Vanguard accounts. As it is, if you select this option, the linked checking account balance is always zero, because as soon as cash comes in it is swept into the money market settlement fund.
You can sort of do this manually by deleting all the downloaded Buys and Sells for the settlement fund and converting the monthly Reinvest transaction from a ReinvDiv to a Div. It's a pain so I don't currently do it. One downside of this currently is that if you do a Reconcile Shares, it will complain that there are zero shares of the settlement fund in Quicken.
QWin Premier subscription0 -
I would like to add one thing if this does get implement this (and I think they should) and that is it would be ideal if the user could specify multiple securities to treat in this way. As I described above, Chase has multiple ones that I would like to ignore.
I think the main "short coming" of the existing system is that "Quicken guesses" at which funds fall into this category and probably because of "bad data" from the financial institutions it isn't always right. This seems like a case of realizing that it will never be 100% correct and just allowing the user to specify it.
Signature:
This is my website: http://www.quicknperlwiz.com/1 -
I agree, the user should be allowed to choose whether or not the cash sweep is treated as cash or as a mutual fund for EVERY brokerage, not just select brokerages. It might also be useful if users could change this feature "on-the-fly" later, in case they accidentally choose to treat the cash sweep as a mutual fund instead of cash when they configure their brokerage in Quicken.
I am a 30 plus year Quicken user, and this has been a problem for many years with my Vanguard brokerage account. My Vanguard Account in Quicken forces me to use the VMFXX cash sweep as a mutual fund rather than an actual cash sweep. Consequently, every time I download a cash sweep "sales" transaction from my Vanguard Brokerage into my Quicken Desktop Software Quicken forces me to choose whether or not to "specify lots" or not. This should not be necessary because the cash sweep money market fund will always have a share value of $1, and therefore the lots are irrelevant. I even tried manually specifying that this cash sweep fund (VMFXX) is treated as "Average Cost Basis" in the Quicken software. But the Quicken software still asks me to specify lots. I have a very busy Vanguard brokerage account, and sometimes if I have not audited my downloaded Vanguard transactions in a while, I am required to go through hundreds of downloaded cash sweep transactions and specify that I do not want to choose lots—even if I specify automatic download.
There are other likely related problems with tracking cash in my Vanguard Account with Quicken. For many years, I tracked my Vanguard cash separately in my Vanguard account so that I could write checks and handle the cash separately from the investment transactions. (Vanguard no longer allows check writing within Vanguard Brokerages.) But when I did this, the Quicken software required a duplicate of every cash transaction in both my Vanguard Brokerage and the Matching Vanguard Brokerage Cash Account, and I had to manually create the second half of each transaction to balance my brokerage account. This was far too time consuming, so I abandoned this approach.
I contacted both Quicken Help and Vanguard about these issues 7-10 years ago, and I was told that Vanguard did not allow the cash sweep to be treated as cash in Quicken, but instead required that the cash be treated as a mutual fund. This is unlike my Fidelity Brokerage, which gives me the option of treating the cash as a mutual fund or as a cash sweep when I configure a new brokerage in Quicken.
Consequently, even though I love Vanguard and still retain most of my mutual fund assets on the Vanguard platform, I have moved most of my stock trade and cash activities to Fidelity instead of Vanguard, because it is too difficult to track and match my transactions in Quicken with my Vanguard Account. The Fidelity Brokerage is much easier to use in Quicken than Vanguard.
Geobrick noted that Vanguard has a new dedicated cash account. But it is my understanding that this is a separate account from the Vanguard brokerage. Therefore, this will not solve the problem of handling cash within Quicken Vanguard Brokerage accounts. This is a problem that must be negotiated between Quicken and Vanguard and/ or solved by Quicken alone depending on the technical issues. Improving Quicken performance in this regard would be a good business decision given the massive market share of Vanguard.
1
