Importing QIF create multiple Imported Investment accounts
I am trying to import a QIF file that was create with Quicken
2007 for MAC. I have been able to successfully able to import all
my other accounts except for my eTrade account. When I import the
QIF, I get multiple Imported Investment Accounts. I have followed
the advice here:
http://moneydance.com/trac/ticket/1007
but that did not appear to do anything. How can I import my eTrade
QIF correctly?
Thanks,
Glen
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Ben Spencer on 20 Aug, 2009 03:17 PM
Hi Glen
This is not typical behavior. Moneydance does not create accounts that are not present in the QIF file. What is the nature of the accounts? Do you recognize the names of them? It sounds like Quicken has exported these accounts from somewhere.Perhaps it was using the as hidden accounts.
It might be worth exporting your data again from quicken and seeing if there are some options that change the way investment accounts are exported.
Sincerely
Ben Spencer
2 Posted by Glen on 21 Aug, 2009 02:03 AM
Ben,
To export the qif, in Quicken, I go to file --> export --> selected items to QIF --> Transactions in selected accounts --> select my etrade account.
From MoneyDance, which is on another computer, I open Moneydance, file --> Quicken Interchange Format (QIF). Select the file that was generated above --> open.
Import to new account
file source from another program
check the box for import account info only --> ok
When it is done, on the home page I show under investment accounts eTrade and multiple Imported Investment Accounts.
I repeat the above steps import to existing account --> eTrade
file source from another program
When it is done importing I have 2 stocks listed under eTrade, some empty Imported Investment Accounts, some Imported Investment Accounts with stocks listed under them.
Thanks,
Glen
3 Posted by Ben Spencer on 22 Aug, 2009 02:13 PM
Hi Glen
There is another users who has having what seems to be the same experience you are having and they have resolve the problem. Here is a link to that discussion:
http://help.infinitekind.com/discussions/problems/262-qif-import
to quote their most recent post:
"Ok, I figured it out. Turns out that some of my transactions were wrongly labeled as "deposit" transactions. I guess when Moneydance saw this, they figured they were deposits into new accounts. I changed these labels to "interest income" or whatever they really were supposed to be, and it worked out ok."
Perhaps the cause of their problem is the same as yours. Please check to see if any of your transaction were incorrectly labeled as deposit transactions.
Sincerely
Ben Spencer
4 Posted by Peter Dempsey on 03 Jan, 2010 01:29 AM
I am having this same issue. Mine does not seem to be related to having "Deposit" transactions. I can not figure out the pattern, but when I bring in a single account from Quicken, it creates 8 Imported Investment Accounts even though I had previously created the correct account (Import Account Info Only) and then re-imported without checking that button. Is there any way to merge or move these imported accounts into the real account?
5 Posted by Larry on 15 Jan, 2010 04:34 AM
I am having the same problem importing investment accounts from Quicken to Moneydance. One investment account in Quicken transfers over to multiple investment accounts in MD. (One with the correct name and several with the name "Imported investment account") I tried to batch change the transactions in the "imported investment accounts" to change the account to the single correct account (an attempt to merge the accounts). That still doesn't work.
6 Posted by Manny Eggers on 19 Jan, 2010 06:39 PM
Same problem here, too!!
My TD Ameritrade account comes over with some transactions / securities (some of which have long been divested) others (like current securities) come over in various separate (10+!) "imported invested accounts". They all belong to the same account, but I don't seem to be able to get them imported together any which way. And I don't see a way to merge them.....?
7 Posted by horse_shoe_joe on 20 Jan, 2010 01:01 AM
I am in the process of converting from Quicken 2007 for Mac and encountered the same problem. The problem seems to occur as a result of the way quicken codes bank related transactions contained within a brokerage account. I found the use of the codes for check, deposit, or withdrawal will cause the separate account to occur. Also, the data which causes the split, is not imported into Money Dance. I changed the data within the Quicken file as follows: Checks were changed to XFR if the item related to another quicken account, if not, i changed them to MISC if they related to an outside vendor payment. Deposits to my money market account within the brokerage account I changed to MISC and I set up the money market account as a security. These changes did not effect anything within the quicken program, but did result in a perfect export from quicken, and a perfect import into Money Dance.
If you want to test your data, export about 30 to 60 days of transactions, and then import only those transactions into money dance. It is easy to review the information and identify any problems that you might have. Make sure the test period you export contains one or more of the offending quicken codes. It should work for you.
8 Posted by Manny Eggers on 20 Jan, 2010 02:43 AM
Sounds like a workable approach. But while I was ready to switch to Moneydance, I am not sure I am motivated to go though 15 years of data plus try and errors to make it happen.
Instead of hundreds/thousands(?) of users go through this: why not fix it in Moneydance?I have not heard yet any feedback on that.
I did import my QIF file successfully back into Quicken and I did not separate my investment account into 15 separate accounts!
9 Posted by Larry on 20 Jan, 2010 04:14 AM
I agree: It's not practical to individually change years' worth of transactions to get a proper import. There's definitely an intrinsic problem within the Moneydance application. It's interesting to note that when I deleted all the individual transactions in an "Imported Investment account," the total value of this account did not change to zero even though there were no transactions in the register! When I deleted this account, the total value of the "correct" imported account changed even though no transactions were added (or subtracted) from it.
10 Posted by horse_shoe_joe on 20 Jan, 2010 02:42 PM
I agree that Money Dance needs to find a fix for the problem. However, as a former Quicken for Mac user, I did not have any choice. Quicken has discontinued individual investment tracking in their newest release. I had 12 years of investment history, and making the changes took me only two hours.
By creating a test period of 30 to 60 days you will quickly fine the problem. There is not that much trial and error involved.
As far as all my checking and credit card accounts, there was no problem at all with the imports.
11 Posted by JB2 on 28 Feb, 2010 05:15 PM
A related but different question
I have been experiencing the same problem importing from Quicken Mac 2007. When importing one of my retirement accounts split transactions between one correctly named account and one labeled "imported investment account". The sum of the shares in the two accounts add to the correct total.
I tried batch changing the transactions to the correct account, which seems to have worked, EXCEPT the total number of shares in the two accounts did not budge, and in "securities detail" view the accounts still show the transactions that I moved. Any idea about how to get the correct account to recognize the transactions? They are in the register, the register cash balance is correct, but the share balance is not correct.
12 Posted by Jon Hoover on 12 Mar, 2010 02:58 PM
Hi all,
Sorry for being late in getting back to you all. I've talked to our lead developer regarding this problem and he is wondering if someone would be willing to send him a copy of a preferably short QIF file that exhibits this problem? His email is: [email blocked].
Jon Hoover, Moneydance Support
13 Posted by George on 25 Apr, 2010 04:50 PM
I'm wondering if there's been any follow up here. I just imported a TIAA-CREF account from Quicken 2007 into MD and encountered the same problems described in this thread: one account became multiple imported accounts, moving transactions into the correct CREF account (a) did not zero out the balance of the incorrectly created import account, and (b) did not seem to affect the number of shares reflected in the correct CREF account. In fact, the CREF account only seems to count shares identified in the initial transactions listed in the register for each security. It is not totaling the shares as more buys are made.
14 Posted by Tom Freeman on 16 Jun, 2010 08:08 PM
George,
Would you be willing to email a copy of the qif file to our lead developer, [email blocked]. Please reference this thread. He can then look at it and help solve your problem.
Tom
15 Posted by john.prewitt on 15 Jul, 2010 05:08 AM
I have this problem with transferring Quicken 2007 for Mac. All the stocks and register entries for the CS - CA account got put into an Imported Investment Account. This account goes back 22 years. I followed the procedures found in the Knowledge Base > Importing from Quicken for MS Money in importing the QIF file. I will forward the QIF file to the lead developer.
Angie Rauscher closed this discussion on 09 Aug, 2010 01:42 AM.