How to use Bank2IIF

This tutorial shows how to convert a transaction file in CSV, Excel, PDF, QFX, QBO, OFX, QIF, MT940, STA format to IIF and import into Quickbooks Desktop.

Use the ProperConvert app to convert your transaction files to required by your accounting software file format.

Step by step instructions for Windows

Follow the steps below for the Windows version.

Make sure you are using the latest version of Bank2IIF. Download it from the Bank2IIF download page. Start Bank2IIF and select the transaction file (it could be QBO file, OFX file, QFX file, QIF file, PDF file, MT940 file, or STA).

Bank2IIF Windows Step 1: select a qif file

Review transactions before converting, check that dates are correct, have the correct year, deposits, and withdrawals are assigned correctly.

Bank2IIF Windows Step 2: review transactions

Enter the main Account Name.

Bank2IIF Windows Step 3: main account name

To match the bank account in Quickbooks.

Bank2IIF Windows Step 4: name of bank account in Quickbooks

Map payee or payer names to Vendor or Customer names in Quickbooks. In our case, we have three expense transactions (requires Vendor to be assigned) and one income transaction (requires Customer to be assigned). Bookstore Invoice, Gas Company, Hydro, and Microsoft are Payee names.

Bank2IIF Windows Step 5: payee or payer names to vendor

Let's say for 'Bookstore Invoice' we have the Vendor name 'Indigo'.

Bank2IIF Windows Step 6: vendor name in Quickbooks

Click on the 'Payee/Categories' Tab. For 'Input Payee' enter the name in the 'Output Payee' column, as you have in Quickbooks (for 'Bookstore Invoice' enter 'Indigo'). Everything else you can leave empty because the converter will not change it.

Bank2IIF Windows Step 7: payee, categories tab

The name was changed.

Bank2IIF Windows Step 8: changed vendor name

Let's check the Customer's name (in our case 'Microsoft') in Quickbooks. If you don't have the same name in Quickbooks, you can add it here.

Bank2IIF Windows Step 9: customer name in Quickbooks

Map categories or payee names to expense account names in Quickbooks. In our case, we have four categories: Office Supplies, Utilities, Utilities, and Payroll.

Bank2IIF Windows Step 10: categories

Click 'Lists' - 'Chart of Accounts'.

Bank2IIF Windows Step 11: lists, charts of accounts in Quickbooks

We have 'Utilities' (Expense), which is matching.

Bank2IIF Windows Step 12: utilities in Quickbooks

We have 'Office Supplies' (Expense).

Bank2IIF Windows Step 13: office supplies in Quickbooks

For the 'Payroll' - Income category. Let's say it should be 'Consulting Income'.

Bank2IIF Windows Step 14: consulting income in Quickbooks

Click on the 'Payee/Categories' Tab. For 'Input Category' (Payroll) enter the name in the 'Output Category' column (Consulting Income).

Bank2IIF Windows Step 15: change category

Now we have all the things in the right order. Make sure all accounts, vendors, and customers exist in Quickbooks.

Bank2IIF Windows Step 16: all teens in the right order

Click the 'Convert' button to create an IIF file.

Bank2IIF Windows Step 17: click Convert

Confirm the file name and location.

Bank2IIF Windows Step 18: file name and location, save

Import created IIF file into Quickbooks

Now the IIF file is created, let's switch to Quickbooks and import created IIF file. Make sure to backup your Quickbooks data file before any IIF import. Click 'File' - 'Utilities' - 'Import' - 'IIF Files'. Locate the IIF file you've just created.

Bank2IIF Windows Step 19: import created IIF file in Quickbooks

Done! Transactions are imported.

Bank2IIF Windows Step 20: transactions are imported in Quickbooks

Review transactions in Quickbooks after importing. Click 'Lists' - 'Chart of Accounts' - 'Wells Fargo'.

Bank2IIF Windows Step 21: Review transactions after importing in Quickbooks

Related articles