Overview


Importing your data from MoneyDance to MoneyWiz is easy. We have a lot of clients coming from MoneyDance and the import works great for them. MoneyDance can export accounts to separate QIF files or all accounts into a single QIF file. MoneyWiz not only supports import from this file type, it will detect the transfers between your accounts as well as split payments you may have on your accounts and your payee or categories.


You just need to export your accounts to a QIF file, and then import the file to MoneyWiz. If you choose to export the accounts one by one, do not worry about creating duplicates. MoneyWiz will take care of this by detecting any duplicates based on the dates and the amount of the transactions in the different files. Please note that if you don’t import all accounts, the other accounts might not come up with the correct balances, because of the transfers between them and the accounts you haven't imported.


Please notice that if you have Investment & Assets accounts, those will probably not import into MoneyWiz because MoneyWiz currently works with Cash, Loan, Checking, Credit/Debit and Savings accounts. Click the Link to see the current status of the investment and assets accounts development, and how to manage your assets and investment instruments in MoneyWiz.

 

First, get prepared before the export


Note the Opening Balance of your accounts


Before starting to export your accounts, please take a note of their Opening Balance. You would need this information when creating your account in MoneyWiz. For the accounts to come up with the right balance after the import they need to have their Opening Balance set as of the date of the first transaction that you will be importing.


Take a note of the Opening Balance for each account that you will be exporting. You would need to see your Running Balance to determine what the Opening Balance is. It would be Running Balance entry minus/plus the first transaction in the list depending on the direction of this transaction i.e. if it is an income or an expenses, respectively.


Note the names of your accounts and their exact spelling


This is needed so that when you are exporting each account, you name the QIF file exactly as the name of the account. It is important to do this, as due to the structure of the file i.e. if the account is called Visa Gold, the QIF file for it should be called Visa Gold. Please mind the capitals, and spaces, the file format is cases sensitive.


Export from MoneyDance


1. Go to File > Export:



2. Select the Export Options:



a. Select the Format: Leave QIF selected. The other options QIF: Tab Delimited, Moneydance XML, Moneydance 2008 are not supported by MoneyWiz.

b. Select Account: You can choose to export all accounts into a single file or to export each account to a separate file. Sometimes it is better to export to separate files for compatibility issues, although we've tested the single file in MoneyWiz and it imports as good as with the separate files.

c. Choose Date: Select All Dates, if you want to export all of your transactions.

d. You can choose any currency. This information is irrelevant to MoneyWiz as it imports the transactions in the currency of the account that you are importing - if you set up the corresponding account in MoneyWiz with the US Dollar currency, all transaction imported to it will be in this currency.


3. Name the file and choose save location.


You can choose any location that you prefer. Usually the easiest thing to do is to save it to the Desktop.


The important thing here is how to name the file. That would depend on whether you chose to export all accounts or a single account in the previous step.

a. If you choose to export all accounts to a single file, you can name the file anything that you would like, say, MoneyDanceFinance as the default name:




b. If you chose to export each account separately then you need to name the file after the account that you chose to export.


If the account you are about to export is called, say, Credit Card then this is how you need to name the QIF file. Please note that this is case sensitive, so capital letters do matter as well as spaces: creditcard.qif or credit card.qif will not work correctly, so as per the example you need to name the file Credit Card.qif.




The reason for this is that many applications to not specify the name of the account within the file and due to this we have made MoneyWiz to read the filename and to list it as the name of the account in the list of accounts when you are importing.


MoneyDance, however, exports the file correctly and it lists the name of the account in a dedicated line in the QIF file, so if you name the file differently when importing it to MoneyWiz, you will see two accounts: the one as specified in the file and the one called after the filename. The tricky thing is that by reflex you will import the one that is called as the account name and not the filename but nothing will import as all transactions will be actually linked by MoneyWiz to the other account - the one with the filename.


By naming the file exactly as the name of the account in MoneyDance, you will avoid this from happening and when importing into MoneyWiz, only one proper account will show in the list of Account to import.


4. That's it! The selected account has been exported to the location that you chose in step 3 with the filename you entered. If you exported all accounts to a single file, you can continue with importing it to MoneyWiz.


If you chose to export each account individually, you would have to repeat this for each of your accounts. Once you have all files, you can start with importing them to MoneyWiz.


Please note that it is possible that the exported file(s) do not have an extension. So, in order to import them to MoneyWiz you will need to add it manually before starting the import. Just start renaming the file and add ".qif" at the end. 


Importing to MoneyWiz


Click "Import OFX, QIF and CSV files from banks or other applications" to see how to set up MoneyWiz before you import your MoneyDance data to MoneyWiz.