Bank2IIF: Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to IIF

Bank2IIF: Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to IIF

Finally, the solution to import your transactions in the IIF format. Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to IIF and import into QuickBooks (Win/Mac), (Win/Mac). Review transactions in a readable view before converting



What can I do with Bank2IIF (CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to IIF Converter)?

Why should I trust Bank2IIF?

If I need any help with conversion, can you help me?

Can I try before purchasing?

Convert CSV, Excel, PDF, QFX, QBO, OFX, QIF to IIF and import into Quickbooks (Win/Mac)

This tutorial shows how to convert a transactions file to IIF format. We will use Bank2IIF utility.

Step by step instructions for Windows

See below steps 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 a transactions file (it could be QBO file, OFX file, QFX file, QIF file or PDF file).

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 in correct places.

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 Vendor name 'Indigo'.

Bank2IIF Windows Step 6: vendor name in Quickbooks

Click on 'Payee/Categories' Tab. For 'Input Payee' enter the name in '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 Customer 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 'Payroll' - Income category. Let's say it should be 'Consulting Income'.

Bank2IIF Windows Step 14: consulting income in Quickbooks

Click on 'Payee/Categories' Tab. For 'Input Category' (Payroll) enter the name in '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