![]() From this window set the 'File Source:' to 'From Another Program'. b) The 'Import QIF File' window will be displayed. a) Select File -> Import in Moneydance and select your QIF file for importing. Unfortunately Moneydance cannot match the two sides of a transfer in such a case. Make sure you import each QIF file into the corresponding account in Moneydance you created in step 7. Some software supports different dates on the other side of transfers. If transfers have been duplicated, you'll need to ensure that the dates are the same on both sides of the transfer. If the categories have imported incorrectly, or all transactions have been assigned to the same category - It's most likely that your settings were slightly incorrect when you imported the QIF file. However you should look at the transactions inside the category to make sure before removing it. Generally speaking these 'xxxx' categories can safely be deleted. Others may include a number of $0.00 transactions that were likely used for storing budget information. Some might be used for the initial balance transfer. These were hidden categories that your software was using behind the scenes for various reasons (depending on the software you were using) and have been included in the QIF export file. You may need to repeat using each of the date formats until your data imports correctly. You can create a new blank data file (navigate within Moneydance to File -> New) and try the import again with one of the other "Date Format" options you haven't yet tried. The date format used in the QIF file is not necessarily the same as the date format that you have specified for display purposes. The Moneydance QIF import window has a "Date Format" option. 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 QIF file can store the dates in one of 3 different formats. If you have a lot of foreign currency transfers, 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. 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. There is no way to get the correct exchange rate information out of the other software for your transactions. Moneydance is using the current rate on all foreign currency transfers. Unfortunately QIF files do not contain any currency or exchange rate information. Foreign currency transfers with incorrect rates This is detailed further within the 'Initial Balance' section. You can then enter an amount in the Initial Balance field. To do this, select then account, then navigate to Account -> Edit Account. ![]() To correct this, you can set the initial balance on your accounts in Moneydance manually. Some QIF files include this initial balance transfer some don't, it depends on the software you are using. If transactions in your account appear up to date, but the balances are incorrect - it's most likely the QIF file did not include an initial balance transfer as the first transaction for the account.
0 Comments
Leave a Reply. |