Importing your data from Quicken Essentials to MoneyWiz is easy. We have a lot of clients coming from Quicken Essentials and the import works well for them. Quicken Essentials can export accounts to separate CSV files or all accounts into a single QIF file. MoneyWiz not only supports import from this file type, it will import the transfers between your accounts as well as split payments you may have on your accounts, payees and categories.
You just need to export each of your accounts to separate CSV files, and then import them to MoneyWiz. 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. However, 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.
In this guide we'll cover the following areas:
- Exporting from your current application
- Importing to MoneyWiz
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 expense, respectively. Quicken Essentials does not have a dedicated field for recording this. In case that you have created an income or expense transaction in a manually created account to indicate the opening balance, please take a note of this too - you better create this account in MoneyWiz with the correct opening balance and after the import to MoneyWiz delete the opening balance entry to balance the account. This is preferable as otherwise the transaction will be included in your reports and that would make the statistics wrong.
Next, export your data from Quicken Essentials
1. Select the first account, you want to export, from the left hand side panel. You can start with any of the accounts - in this example I will start with a Checking account:
Just click on the account name in the side panel and then proceed to step 2:
2. Go to File > Export > Export Transactions to CSV file. Make sure to select the CSV option. The QXF file format is Quicken's proprietary format and cannot be read by MoneyWiz.
3. Select the Export Options:
a. Choose a name for the file: Make sure to name the file after the account that you selected in step 1. This way when you are importing to MoneyWiz you will know which account you are importing.
b. Select Save Location: You can choose any location that you want. Usually the easiest thing is to save the files to the Desktop or in a newly created folder on the Desktop.
c. Export: Leave this to the default option - "All Visible Transactions".
d. "Include Scheduled Transaction" - uncheck this option. The mechanism used by Quicken Essentials for scheduled transaction is quite different from the one in MoneyWiz and importing scheduled transactions won't work.
4. Click Save.
5. Repeat the above for each of your accounts, mind the filename and to uncheck the "Include Scheduled Transactions" check-box on each import. That's it! Once you have all files ready you can start importing to MoneyWiz.
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 Quicken data to MoneyWiz.