Quicken 2016 Export QIF

jwp.perry's Avatar

jwp.perry

Sep 06, 2017 @ 03:45 PM

I am attempting to migrate to MoneyDance from Quicken 2016. I have read your instructions but still am not clear.
1. When you set up quicken to export the qif file, do you check all items (Transactions, Account Lists, Category list, Memorized Payess, Security Lists) or do you just export the default export which only checks the Transaction Box. I have tried several exports but they are very confusing as I have a big database with a lot of history. I would like to mimic Quicken data as much as possible.

When importing into MoneyDance, the first process appears to do "Account Info Only", then the remainder - how does the above apply to this import?
 
Thanks, Jack

  1. 1 Posted by JL on Sep 06, 2017 @ 07:54 PM

    JL's Avatar

    Just a suggestion that may help.

    Open Quicken and when you export your QIF file (All Accounts) the Transactions box should be the only one with a check mark.

    After you import the data you may not see your accounts on the left sidebar.
    Just close and reopen MD.

    Make corrections as need as the transfer of data will not be exact.
    Run both programs at the same time.

    Read and review the KB's http://help.infinitekind.com/kb
    Also download and read the manual.
    http://help.infinitekind.com/kb/older-versions/moneydance-2015-user-guide

    Read about passwords to open MD in order to save passwords about Financial Institution downloads.

  2. 2 Posted by jwp.perry on Sep 06, 2017 @ 09:24 PM

    jwp.perry's Avatar

    Thank you, I assume that this is the case (transactions checked – only) when making the file for “account info only” in MD

    Jack

  3. 3 Posted by JL on Sep 06, 2017 @ 09:34 PM

    JL's Avatar
  4. 4 Posted by dwg on Sep 06, 2017 @ 10:25 PM

    dwg's Avatar

    You still use the "Account Info Only" option in Moneydance with a QIF file that contains all the transaction info.

    What it does is read through the QIF file and use the data therein to create the accounts and categories that it determines is required, it just does not load any transaction data. So in effect it sets up the basic structure.

    The reason for this option is that the QIF specification is not specific in its determination of whether an item is an Account or a Category or even with categories if it is an Income or Expense category. While in many cases it gets it right it does not always do so. This option allows you to do the structure setup, then you manually make any corrections that are required then go back and do the transaction load into this structure, as the accounts and categories already exist in MD the import does not try to create them it just posts the transactions.

  5. 5 Posted by JL on Sep 06, 2017 @ 11:08 PM

    JL's Avatar

    @dwg and jwp.perry

    I stand corrected.

    My mistake on the "Account Info Only" responce.

  6. 6 Posted by jwp.perry on Sep 06, 2017 @ 11:20 PM

    jwp.perry's Avatar

    Thanks, what is confusing me is I have made several attempts uploading several qif’s into several MD files, but still get transactions in some accounts so cannot figure out what I am doing wrong. I definitely have “new account”, “from another program” and “acct info only”. I do not have an issue against deleting the account transactions, then re-loading them correctly; I am just concerned that I make the structure correct as I have a lot of data/history and do not want to go to a lot of work then find I have to re-do it all. I have imported several qif files for the “acct info only”, some with all quicken boxes checked, some with just the “transaction” box checked, and I get the same results. I have not tried checking all the quicken boxes except transaction yet.

     

    Jack

  7. 7 Posted by dwg on Sep 06, 2017 @ 11:24 PM

    dwg's Avatar

    No Problem,

    Its an often overlooked option, especially with the way the documents are, but it is handy to know when you are dealing with a migration, as at times it can save a lot of post-import cleaning up. Knowing what options you have along with knowledge of tools like Batch change and Find & Replace can help smooth a migration, well at least partially :)

  8. 8 Posted by dwg on Sep 06, 2017 @ 11:32 PM

    dwg's Avatar

    Jack,

    What sort of transactions are these? Some examples may help.

    It is best to resolve as many problems as possible before doing the full migration. That being said there will always be some post-migration cleanup. The file formats we have to use were never intended for migrations so it will always be some degree from perfect.

    You will only be able to move transaction data, things like payee lists will not come through, all you can really expect to migrate is the raw transaction information.

  9. 9 Posted by jwp.perry on Sep 07, 2017 @ 01:02 AM

    jwp.perry's Avatar

    The problem I am having is: (simple example)

    Account 1 and 2 are zero’d out (no transaction in them)

    I import Account 1 transactions and everything balances with my quicken data

    Then I import Account 2 Transactions, Account 2 balances with quicken data

    But:

    Now account 1 is messed up, I guess because I have linking transactions in quicken, MD thinks they are valid entrys, it is getting pretty confusing

  10. 10 Posted by dwg on Sep 07, 2017 @ 01:49 AM

    dwg's Avatar

    Yes it does sound like account transfers are causing you some grief. It's a problem with QIF as there is no mechanism to deal with duplicates.

    This is an approach you can try.

    Import Account 1

    Now if we do have transfers you should be able to open Account 2 and see some transactions in there.

    In account 2 select all the entries and delete them. (highlight one entry then use CTRL-A to select all transactions) Yes this will delete them from Account 1 as well.

    Now Import the data into Account 2

    Now check the balances of both accounts.

    If it is transfers that are the entire cause of the problem then both accounts should balance.

  11. 11 Posted by jwp.perry on Sep 07, 2017 @ 03:46 AM

    jwp.perry's Avatar

    Thanks for your help,

    Jack

  12. System closed this discussion on Dec 07, 2017 @ 03:50 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