Auto update of Financial accounts

Posted by Dick on April 2, 2007, 1:50 pm

Please log in for more thread options

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?

Posted by John Pollard on April 2, 2007, 2:22 pm

Please log in for more thread options

Dick wrote:

> 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.

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 Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Posted by Dick on April 2, 2007, 5:11 pm

Please log in for more thread options

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.

> Dick wrote:

>> 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.

> 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 Pollard

> First initial underscore Last name at mchsi dot com

> Please reply to newsgroup

Posted by John Pollard on April 2, 2007, 6:55 pm

Please log in for more thread options

Dick wrote:

> 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.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup