no transactions or securities imported
I tried importing a qif file from Quicken 2015. All of my accounts are there, but in my "Investment" accounts, the only transactions are transfers between the accounts. All checks, withdrawals, stock buy and sells, everything else is missing. There are no securities listed. My qif file 945kb so I'm assuming the data is in there. I have tried to export from Quicken and import to moneydance twice with the same results. I just purchased your program.
I should note that in quicken my investment accounts are also checking accounts, they earn interest, write checks, buy stocks, withdrawal cash, pay bills, everything. Those are the accounts that are missing transactions. My credit card data transferred correctly.
any help is greatly appreciated.
thanks
e
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 19 May, 2015 08:27 PM
Hi
I was under the impression that Quicken 2015 could not export a QIF file. Were you able to export this data from Quicken directly?
Ben Spencer
Infinite Kind Support
2 Posted by -Kevin N. on 19 May, 2015 08:32 PM
Hi emg.simon,
Assuming that you're using a Mac, take a look at this KB article regarding importing Quicken 2015 data into Moneydance
http://help.infinitekind.com/kb/importing-data-from-banks-and-other...
HTH -Kevin N.
3 Posted by Ben Spencer on 19 May, 2015 08:41 PM
Hi Kevin
I recall reading about QMTF files a little while ago and at the time being quite pleased that they were just QIF files by another name. I now think that they are in fact just a subset of a QIF file and do not make an adequate substitution for a QIF file.
Ben Spencer
Infinite Kind Support
4 Posted by -Kevin N. on 19 May, 2015 09:32 PM
Hi Ben,
As if QIF files weren't quirky enough.
I'd be curious to hear from the OP if the QMTF / QIF file properly imports their data.
-Kevin N.
5 Posted by dwg on 19 May, 2015 10:13 PM
Reckon Australia removed QIF file support many years ago, all we then got were so called Excel compatible files with an inconsistent layout.
Des
6 Posted by Elizabeth M G S... on 19 May, 2015 10:16 PM
Thanks Kevin, Those are the instructions that I followed.
It appears to be a problem specific to my investment accounts, all others (checkin, credit cards, …) imported correctly.
Ben, infinitekind instructions specifically address the qif issue for quicken 2015, I simply imported a 2007 formatted doc as specified and changed the file name to end in qif instead of qmtf. It worked just fine except for my investment accounts which show no securities nor transactions except transfers to other imported accounts.
7 Posted by Elizabeth M G S... on 19 May, 2015 11:12 PM
What do I do? Is there another way to import? The bulk of my account information is in these investment accounts. I can’t imagine I’m the only person who has transitioned from Quicken 2015 to moneydance to have experienced this problem, it seems like kind of a big one to me.
thanks,
e
8 Posted by Elizabeth on 19 May, 2015 11:58 PM
Quicken 2015 for investment accounts has the following "types":
IRA
Keogh
SEP
SIMPLE
Trust
UGMA
Brokerage
The accounts that aren't working are all specified as "Brokerage"
9 Posted by Ben Spencer on 20 May, 2015 12:15 AM
Hi Elizabeth
I do not believe it is possible to do a complete transfer of data from Quicken 2015 to Moneydance. In this version of Quicken Intuit have removed the option to export data to a QIF file. Without being able to export to a QIF file you cannot successfully import your data into Moneydance.
Ben Spencer
Infinite Kind Support
10 Posted by buffo on 20 May, 2015 12:20 AM
Use the Quicken 2015 export all accounts to one big qif file. The
first time check only the account names box. The next time check
transactions, account names, categories(?). Import the account names
only one first and then the second one in to MD. Follow the published
MD instructions for moving from Quicken to MD to finish the move.
I moved over 100 accounts using this method with very little problems.
John
11 Posted by Ben Spencer on 20 May, 2015 12:27 AM
buffo
Are you certain you were using Quicken 2015 for Mac? I understand that Quicken 2015 for Mac does not support export to QIF.
Ben Spencer
Infinite Kind Support
12 Posted by Elizabeth M G S... on 20 May, 2015 12:34 AM
so if I had my data in Quicken 2007, then I could export a true qif file and all will be good? I just don’t want to go through all of that bother unless it really is going to work.
thanks,
e
13 Posted by Ben Spencer on 20 May, 2015 12:40 AM
Elizabeth
Even if you can export your data to a QIF file there is no guarantee that the import into Moneydance will be perfect. The QIF file format was never really intended for transferring all data from Quicken to another program and as such it contains inherent ambiguities that will need to be manually corrected post import. How much manual correct needs to be done post import is hard to predict. Typically investment accounts fair worse that regular accounts in this matter.
Ben Spencer
Infinite Kind Support
14 Posted by Elizabeth on 20 May, 2015 12:52 AM
Hi Buffo, I am able to import account names only first, then transactions, but cannot see how to do it one account at a time. When I tried it (all accounts at once because I couldn't figure out how to do one at a time), the brokerage transactions still did not transfer. Quicken will not let me export one account at a time, only if I do so in CSV format.
Ben, thanks, I figure I'll need to fiddle and fix some things, I just want to get the bulk of the transactions in, I can't possibly re-enter them all, they go back decades (seriously). I'll see if I manage to get a real qif file to try.
15 Posted by buffo on 20 May, 2015 02:23 AM
Sorry I did not notice this was Quicken 2015 for the Mac, but it sounds
like she was able to export a qif.
I did several brokrage accounts at once and only had to make minor changes.
John
16 Posted by Elizabeth on 21 May, 2015 02:26 AM
I managed to get a 2007 version of Quicken up and export a QIF file. It appears that the transactions imported from my investment accounts this time although the balances are off so I'll have to track down those errors.
thanks,
e
17 Posted by -Kevin N. on 21 May, 2015 01:21 PM
Hi Elizabeth,
One place to look besides the 'Initial Balance' is to stock splits. It is likely that the QIF did not incorporate the splits.
HTH -Kevin N.
18 Posted by Elizabeth M G S... on 21 May, 2015 11:20 PM
Thanks!
e
System closed this discussion on 19 Mar, 2016 04:55 AM.