Importing your data from Jumsoft Money to MoneyWiz is easy. We have a lot of clients coming from Jumsoft Money and the import works great for them. Jumsoft Money 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, your payees or categories.
You just need to export each of your accounts to a separate QIF file, and then import each file to MoneyWiz. Do not worry about creating duplicates - MoneyWiz will take care of this by detecting them based on the dates and the amount of the transactions in the different files.
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. Note that if you are going to export an account for a shorter period than the one available in JumSoft Money, you would need to see your Running Balance for the start date of the export.
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.
Next, export your data from Jumsoft Money
1. Select the Account you want to export, from the left hand side panel. Note its name, and exact spelling:
2. Go to File > Export:
3. Enter file name, choose location and select the File type and Date Format:
a. File name: If the account you are about to export is called, say, Checking John 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: checkingjohn.qif or checking john.qif will not work correctly, so as per the example you need to name the file Checking John.qif.
The reason for this is that many applications do 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.
Jumsoft Money, however, exports the file by listing 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.
b. Choose Location: You can choose any location you prefer. Usually the easiest thing to do is to save the file to the Desktop.
c. Choose File Format: Choose the QIF file format. The other format (CSV) is also supported by MoneyWiz, although it doesn't carry as much information as the QIF carries. For example, the transfers between your accounts will be indicated in the file as credits and debits, and this is how they will be imported to MoneyWiz.
d. Choose Date Format: The recommended date formats to use are: mm/dd/yyyy and dd/mm/yyyy. Both are automatically recognized by MoneyWiz and import perfectly. Note that with disregard of the date format in the file, the dates in MoneyWiz will be displayed as per the system settings on your device.
4. Click "Export" and that's it. All of your transaction along with the categories, and the payees will be exported for the account you selected to export.
5. Now you need to repeat this for each of your accounts.
Importing to MoneyWiz
It is important to note that Jumsoft Money exports the Opening Balance in the QIF file as a simple Income or Expense transaction, depending on whether the initial balance has been positive or negative. MoneyWiz will import this transaction as an income/expense respectively.
Now, if you create your accounts in MoneyWiz with Starting Balance of zero, all accounts will come up with the correct balance. However, please note that the Initial Balance transaction will be considered in the reports, so your expenses/incomes would appear more or less then they actually are.
The better solution would be to create the accounts in MoneyWiz with the accurate Opening Balance, import the QIF file from Jumsoft Money and then delete the imported Opening Balance entries from all accounts. They would be the first transaction on each account. You can also use the search box to search for "Opening Balance" (without the quotes) and choose to see result from all accounts (with the arrow in the search box or the "eye" on Accounts). With the mass edit functionality of MoneyWiz for Mac you can select all such entries and delete them at once.
Click "Import OFX, QIF and CSV files from banks or other applications" to see how to set up MoneyWiz before you import your Jumsoft Money data to MoneyWiz.