importing Quicken 2017 into Moneydance

KATHLEEN MARSCHEL's Avatar

KATHLEEN MARSCHEL

27 Jan, 2020 08:59 PM

Need some very basic step by step help in importing my quicken info into moneydance

  1. 1 Posted by KATHLEEN MARSCH... on 27 Jan, 2020 09:00 PM

    KATHLEEN MARSCHEL's Avatar

    running windows not MAC

  2. 2 Posted by jkosa on 30 Jan, 2020 10:45 PM

    jkosa's Avatar

    I'm a newbie user trying to do the same conversion Q17 to Moneydance.

    There's a thread here https://infinitekind.tenderapp.com/discussions/switching-from-another-personal-finance-program/15629-switch-from-quicken-to-moneydance that was started on 1/29/20 by Billy Schultz that should help you. Also there's a lengthy detailed thread here https://infinitekind.tenderapp.com/discussions/switching-from-another-personal-finance-program/15012-the-vicissitudes-of-quicken-to-moneydance that dantdavis started and explains various quirks/issues he had.

    So far, my experience (started 1/29) is mixed. some things worked ok, some things not. Still evaluating a bit to see if I can really kick quicken to the curb after 20+yrs.

  3. 3 Posted by -Kevin N. on 31 Jan, 2020 01:10 AM

    -Kevin N.'s Avatar

    Hi All,

    There's a lot of information in the Moneydance knowledge base.
    https://infinitekind.tenderapp.com/kb
    Importing from other programs is here.
    https://infinitekind.tenderapp.com/kb/importing-data-from-other-pro...

    -Kevin N. (not a member of MD support)

  4. 4 Posted by Andrew on 02 Feb, 2020 10:11 AM

    Andrew's Avatar

    Hi Kathleen,

    I can see you’ve received a reply from one of our knowledgeable Moneydance customers.
    To add to this useful information I thought it's worth to provide you the following detailed information:

    • If you are importing from Quicken please note, QDF and QXF files use a proprietary file format that can only be read by Quicken and Intuit programs. You need to open Quicken to export your data into one or more QIF files.

    Ideally you'll export one QIF file that contains all of your account data. Use the option to export 'all accounts' within one QIF file if this is available within the software you're using.

    If this is not possible, you should export one QIF file for each account in your file. You should name each file so it's clear which account is contained within each QIF file.

    Make sure you export any closed or inactive accounts containing transfers to your open accounts. You may need to re-open these accounts before exporting.

    If you're using Moneydance for the first time, when you open the program, you'll see the Welcome window. Choose “Create a new account set” and setup a new data file.
    If you have opened Moneydance previously, you can create a new data file by choosing File --> New --> Create a New File. Then follow the prompts to enter a name and currency for your new file.

    When viewing your new data file, choose File --> Import. Then navigate to and select one of your QIF files.

    The import window will appear, and you should see the name of the account you're importing (as it was displayed within Quicken).
    Highlight the account name, and check the account is displayed as the correct account 'type' (bank, credit card etc.), and also ensure the correct currency is used. If needed, you can amend the account type and currency within the import window by selecting these options to the right of the account name.

    Below the account names, Moneydance will automatically try to determine the date format and decimal character used within the QIF file.
    The 'Date Format' field should be set to the date format used in the QIF file, rather than the date format you used in Quicken or want to use in Moneydance.
    If you want to check these settings, open the QIF file with a text based program like NotePad or TextEdit. This will allow you to check which date format and decimal character are being used within the QIF file.

    When you're happy with the settings, choose 'Import' and wait for your data to populate into the Moneydance program.

    As you're just importing one account at a time, you'll see accounts that have transfers to/from the imported account are automatically created within Moneydance. These account balances will likely display discrepancies, but they will eventually correct themselves as you import the other QIF account files.

    Repeat these steps for each QIF file you have until all of your accounts have populated into Moneydance.

    If it appears some of your accounts are missing from the left side bar after importing, press the '+' button at the bottom of the side bar. Choose 'Advanced'. You should see the missing accounts in the panel on the left - highlight the account name and press 'Add' to move the accounts into the panel on the right. When you're done press OK and these accounts should then be available for selection from within the side bar.

    Some QIF files don’t include an 'Initial Balance' for your accounts (sometimes referred to as a beginning balance or a starting balance). If this is the case, you'll see all transactions have imported but the account balance will show a discrepancy.
    To fix this, select the account and choose Account --> Edit Account. In this window, you can enter an amount into the 'Initial Balance' field.

    For investment accounts, QIF file don’t always carry security prices other than buy/sell prices, so investment account balances may be wrong until you update with the current security prices.

    Reminders are not included in QIF files as the QIF file format has no ability to include reminder data.

    Hopefully this information is useful. Do not hesitate to contact us again, if you need further assistance.

    --
    Andrew, Infinite Kind Support

  5. System closed this discussion on 03 May, 2020 10:20 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