How to download two funds in one brokerage account into two accounts in Quicken?

ilyaz
ilyaz Member ✭✭✭
edited November 26 in Investing (Windows)

I have Windows 11 Pro (updated) and Quicken v. R64.35, Build 27.1.64.35 on my desktop PC. In the past, it was easy to download all four Vanguard accounts (my wife's and my IRA, joint Money Market, and joint Total Stock accounts) into four separate corresponding accounts in Quicken. Then, Vanguard moved all our accounts into three brokerage accounts: two separate IRAs and one joint account for Money Market and Total Stock Market. The Vanguard Download page has an option (recommended) to download into one Quicken account. Now, when I download our IRA brokerage accounts from Vanguard, each goes into the corresponding IRA account in Quicken. However, when I download the joint brokerage account from Vanguard, both the Money Market and the Total Stock Market go into the Money Market account in Quicken. How should I set up Quicken or Vanguard (or both) to download these two Vanguard accounts into two corresponding accounts in Quicken?

Answers

  • BK
    BK Quicken Windows Subscription Member ✭✭✭✭

    @ilyaz, Based on what you wrote, the Money Market and the Total Stock Market are the individual Vanguard index funds, right? Where in the past you chose to have one account for each fund, they are now part of the same single joint account. Am I understanding these correctly?

    I also gather that you are manually downloading the data (exporting an OFX file) from Vanguard and then importing it into Quicken.

    Let's take the IRA's out of this discussion since they are working for you as expected and focus only on the joint account. You wrote:

    However, when I download the joint brokerage account from Vanguard, both the Money Market and the Total Stock Market go into the Money Market account in Quicken. How should I set up Quicken or Vanguard (or both) to download these two Vanguard accounts into two corresponding accounts in Quicken?

    But they are not accounts, rather two funds held in a single joint account; do you agree or am I misunderstanding?

    The question is: Why do you want to continue to have two accounts in Quicken for each fund where Vanguard already converted them into a single account? Isn't it better to have one account in Quicken (containing both funds) so that it matches exactly what Vanguard also has for you? To make a point, if you had fifty funds, would you really want to create fifty accounts in Quicken?

    In my personal opinion I'd want Quicken to be a match with my online accounts, and in your case just rename the account from "Money Market account" to whatever you like, such as "Our Joint Account". But if you insist to keep the old model, you probably have to make manual adjustments in Quicken every time you download which would be a lot of work and result in balance and share mismatch errors - a maintenance nightmare.

    - Q Win Deluxe user since 2010, US Subscription
    - I don't use Cloud Sync, Mobile & Web, Bill Pay/Mgr

  • volvogirl
    volvogirl Quicken Windows Other SuperUser ✭✭✭✭✭

    I had my Vanguard accounts set up like that too. For the regular joint account I had separate Quicken accounts for each mutual fund. I only enter the transactions manually and it was a pain to have to switch to each fund to enter and I usually entered some dividends in the wrong account. Then a couple years ago Vanguard transitioned every one to brokerage accounts so I had to move all my funds in Quicken to a new single Q account. Now it’s much easier to manually enter and track.

    I'm staying on Quicken 2013 Premier for Windows.

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    Interesting enough I believe it was actually an option you could select at Vanguard that would put them in one account or one per security. But it wasn't easy to find. Years ago, when I did have Vanguard accounts, I had them setup to download all the securities for one account in a single Quicken account.

    Signature:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

This discussion has been closed.