no transactions or securities imported

's Avatar

emg.simon

19 May, 2015 08:17 PM

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

  1. 1 Posted by Ben Spencer on 19 May, 2015 08:27 PM

    Ben Spencer's Avatar

    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. 2 Posted by -Kevin N. on 19 May, 2015 08:32 PM

    -Kevin N.'s Avatar

    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. 3 Posted by Ben Spencer on 19 May, 2015 08:41 PM

    Ben Spencer's Avatar

    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. 4 Posted by -Kevin N. on 19 May, 2015 09:32 PM

    -Kevin N.'s Avatar

    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. 5 Posted by dwg on 19 May, 2015 10:13 PM

    dwg's Avatar

    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. 6 Posted by Elizabeth M G S... on 19 May, 2015 10:16 PM

    Elizabeth M G Simon's Avatar

    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. 7 Posted by Elizabeth M G S... on 19 May, 2015 11:12 PM

    Elizabeth M G Simon's Avatar

    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. 8 Posted by Elizabeth on 19 May, 2015 11:58 PM

    Elizabeth's Avatar

    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. 9 Posted by Ben Spencer on 20 May, 2015 12:15 AM

    Ben Spencer's Avatar

    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. 10 Posted by buffo on 20 May, 2015 12:20 AM

    buffo's Avatar

    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. 11 Posted by Ben Spencer on 20 May, 2015 12:27 AM

    Ben Spencer's Avatar

    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. 12 Posted by Elizabeth M G S... on 20 May, 2015 12:34 AM

    Elizabeth M G Simon's Avatar

    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. 13 Posted by Ben Spencer on 20 May, 2015 12:40 AM

    Ben Spencer's Avatar

    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. 14 Posted by Elizabeth on 20 May, 2015 12:52 AM

    Elizabeth's Avatar

    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. 15 Posted by buffo on 20 May, 2015 02:23 AM

    buffo's Avatar

    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. 16 Posted by Elizabeth on 21 May, 2015 02:26 AM

    Elizabeth's Avatar

    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. 17 Posted by -Kevin N. on 21 May, 2015 01:21 PM

    -Kevin N.'s Avatar

    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. 18 Posted by Elizabeth M G S... on 21 May, 2015 11:20 PM

    Elizabeth M G Simon's Avatar

    Thanks!

    e

  19. System closed this discussion on 19 Mar, 2016 04:55 AM.

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

Recent Discussions

24 May, 2024 07:05 PM
24 May, 2024 06:20 PM
24 May, 2024 06:07 PM
24 May, 2024 04:23 PM
24 May, 2024 03:21 PM