Importing your data from Banktivity (formerly iBank) to MoneyWiz is easy. We have a lot of clients coming from Banktivity (formerly iBank) and the import works great for them. Banktivity / iBank can export each separate account to a QIF file and 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, payees or categories.
You just need to export each of your account to QIF file, and then import them one by one 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. Banktivity / iBank has the option to export all accounts into a single file, however it is not recommended that you do this as when all accounts are exported to a single file, Banktivity / iBank adds some data in the beginning of the file that makes it unreadable by other applications.
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.
In Banktivity / iBank that would be the first record in each account, it is called Opening Balance. 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 available in Banktivity / iBank, 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 Banktivity / iBank
Export an account
1. Go to File > Export:
2. Choose the file format to Export to:
Choose the QIF file format. The other format (TXF) is not currently supported by MoneyWiz.
3. Select the period of time for which you can export an account.
You can export the transactions from an account for any time you choose:
However, please keep in mind that you would need to know that Current Balance of the account you will be exporting on the date preceding the the start date of the export i.e. the balance of the account before the first transaction that will be in the exported file.
4. Select the account you want to export:
Select the account you want to export. Usually the first file to be exported is your Checking account. Note its name, and exact spelling.
5. Click next to proceed to choosing a save location for the QIF file.
You can choose any location that you would like. Usually the easiest thing to do is to save the file to the Desktop.
6. Enter a name for the QIF file and save it to a preferred location.
The important thing here is how to name the file. 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.
Note, Banktivity / iBank 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.
7. Click "Save" and that's it. The account will be exported.
8. Now, import it into MoneyWiz. For more details on how to do that check out the Importing from QIF/OFX and CSV guide here.
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 Banktivity / iBank data to MoneyWiz.