Possible problems after QIF import from Quicken

Incorrect account balances -

We'd recommend following the steps outlined here when importing your data from Quicken. You can create a new data set by navigating to File --> New, and attempt the import process again. In particular make sure you specify to Import into 'new account' rather than 'existing account'. Also ensure that the 'File Source' is set to 'From another program'.

If you've followed the steps to import your data, the most likely cause is the QIF file did not include an initial balance transfer as the first transaction for the account. Some QIF files include this initial balance transfer some don't, it depends on the version of Quicken you are using. You need to set the initial balance on your accounts in Moneydance manually. To do this go into the account register then select Account -> Edit Account, where you can enter an amount into the initial balance field.

Foreign currency transfers showing incorrect exchange rates -

Unfortunately QIF files do not contain any currency or exchange rate information. Moneydance is using the current rate on all foreign currency transfers. There is no way to get the correct exchange rate information out of Quicken for your transactions. To confound things even more, it's likely you are going to get duplicates for every foreign currency transfer because the amounts are different on each side and Moneydance is unable to match them up.

If you have a lot of foreign currency transfers in Quicken and you want to move to any other personal finance program you may want to consider starting your data set from the beginning of the year rather than trying to import all of your data.

Incorrect transaction dates -

The QIF file can store the dates in one of 3 different formats. You'll need to select the date format manually during the import process, as the QIF file doesn't tell Moneydance which format it is using. The Moneydance QIF import window has a "Date Format" option

The date format used in the QIF file is not necessarily the same as the date format the user had specified for display purposes in Quicken.

You should create a new blank data file (navigate within Moneydance to File --> New) and do the import with one of the other "Date Format" options you haven't yet tried. You may need to repeat using each of the date formats until your data imports correctly.

Categories have imported which include 'xxxx' in the category name -

These were hidden categories that Quicken was using behind the scenes for various reasons depending on the version of Quicken you were using, and have been included in the QIF export file.

Some might be used for the initial balance transfer. Others may include a number of $0.00 transactions that were likely used for storing budget information. Generally speaking these 'xxxxx' categories can safely be deleted. However you should look at the transactions inside the category to make sure before deleting it.

Transactions have imported with the same category -

It's most likely that your settings were slightly incorrect when you imported the QIF file. It's important to be sure the "File Source" is set to "From Another Program". You'll find the full instructions here


Transfers have been duplicated -

You'll need to ensure that the dates are the same on both sides of the transfer. Some version of Quicken support different dates on the other side of transfers. Unfortunately Moneydance cannot match the two sides of a transfer in such a case.