Auto update of Financial accounts

Apr 02, 2007 3 Replies

I am having trouble setting up a one step update for my Janus Accounts. I have several Janus mutual funds most are in separate accounts in Quicken, most accounts are individual funds, one has two different funds in it. When I try to set up the download Quicken allows me to select the account for only one of the funds it then tells me I have to set up a new account in Quicken for the second fund. This defeats having the two funds totaled in the portfolio view. All of the individual funds work ok. I want to have the capability of the account to be totaled. Any ideas?


You don't have any choice about what securties can be held in which Quicken accounts, if you want to download: it's the financial institution's choice. If the fi is sending data treating each security as being in a separate account, that's the way you have to setup Quicken.

John if that is the case how do I separate the two funds I have in the account? The transaction data for both funds go back several years. I sure don't want to enter them all over again.

First, I would double check with Janus about whether they absolutely require this. Vanguard, for instance, will let you

*choose* to have multiple funds in one Vanguard account (they will change your Vanguard account so it holds multiple funds). [Janus is very new to downloading to Quicken, and my first experience with them suggests they are not very Quicken savvy at this stage, so I'd be prepared to push my way up the support chain.]

Off hand I can think of two approaches.

1.) Use the Quicken "transfer shares between accounts" to transfer shares of one of the funds to a new Quicken account. This will leave the existing historical detail in the old account, but is a simple process that will let you track the security in the new Quicken account from this point forward. You can check to see if you like this approach by creating a Copy of your Quicken data and entering the transfer in the Copy.

2.) Download the free Excel macro, "xl2qif" (Google will find it). Export your existing Janus account to a qif file. Use "xl2qif" to open that qif file in Excel. Sort the transactions by security. Select all the transactions for one security, and have "xl2qif" create a new qif file for that security ... select the other security, and create a second qif file for that security. Modify the 2 qif files according to instructions posted in this group several times, or in the Intuit Quicken forums (search there for "qif post Q2004"). Create 2 new Quicken investment accounts and import each qif file into its new Quicken account.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required