Possible Problems After QIF Import
Incorrect account balances
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.
Some QIF files include this initial balance transfer some don't, it depends on the software you are using.
To correct this, you can set the initial balance on your accounts in Moneydance manually.
To do this, select then account, then navigate to Account -> Edit Account. You can then enter an amount in the Initial Balance field. This is detailed further within the 'Initial Balance' section.
Foreign currency transfers with incorrect 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 the other software 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, 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 that you have specified for display purposes.
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.
You may need to repeat using each of the date formats until your data imports correctly.
Imported categories names include 'xxxx'
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.
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 'xxxx' categories can safely be deleted. However you should look at the transactions inside the category to make sure before removing it.
Incorrect categories -
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.
Duplicated transfers -
If transfers have been duplicated, you'll need to ensure that the dates are the same on both sides of the transfer.
Some software supports different dates on the other side of transfers.
Unfortunately Moneydance cannot match the two sides of a transfer in such a case.
Purchasing and Upgrading
Accounts and Categories
Register and Transactions
Online Banking and Bill Pay
Graphs and Reports
Syncing and Sharing Data
Currency and VAT/GST
Backups and Exporting
Importing Data from Other Programs
Customizing and Preferences
File Locations and Changes
ARCHIVE - Getting Started
ARCHIVE - Moneydance 2017
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
ARCHIVE - Moneydance 2014 and 2015
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - Opening a backup file in Moneydance 2015
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- View all (3 more)
ARCHIVE - Program Basics
ARCHIVE - Account Basics
ARCHIVE - Entering Transactions
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
ARCHIVE - Online Banking
ARCHIVE - Mobile
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
ARCHIVE - Budgeting and Reminders
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
ARCHIVE - International Tools
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
ARCHIVE - Investments
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Downloading security, stock or mutual fund prices from non-US stock exchanges
- View all (5 more)
ARCHIVE - Extensions
ARCHIVE - Everything Else