Convert CSV/Excel, PDF, QFX/OFX/QBO, QIF, MT940 to IIF and import into QuickBooks
Need to import bank or credit card transactions in a CSV/Excel, PDF, QFX/OFX/QBO, QIF, MT940 file into Quickbooks, but cannot seem to make it work? The problem is that your bank only provides transactions in a format that Quickbooks cannot read.
The Solution: try ProperConvert(Bank2IIF) app. It can convert your transactions into a format from CSV/Excel, PDF, QFX/OFX/QBO, QIF, MT940 to IIF can import.
Convert transaction files to the IIF format
- ProperConvert (Bank2IIF) extracts transactions from CSV/Excel, PDF, QFX/OFX/QBO, QIF, MT940 files. It creates IIF files ready to import into Quickbooks.
- No data entry: convert data you already have in bank or credit card transactions file format to the IIF format
- Smart: ProperConvert (Bank2IIF) understands many layouts. It finds columns like date, amount, description, etc. of your transactions.
- Easy to use: Converting your banking transactions into IIF files could not be any easier. In a few clicks, you will have all your transactions converted to importable by Quickbooks format in no time at all.
- Free trial and support: try it for Free before you buy and receive full support before and after you order.
- Safe to use: ProperConvert (Bank2IIF) converts all your banking transactions on your computer.
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).
Review transactions before converting, check that dates are correct, have the correct year, deposits, and withdrawals are assigned correctly.
Enter the main Account Name.
To match the 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.
Let's say for 'Bookstore Invoice' we have the Vendor name 'Indigo'.
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.
The name was changed.
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.
Map categories or payee names to expense account names in Quickbooks. In our case, we have four categories: Office Supplies, Utilities, Utilities, and Payroll.
Click 'Lists' - 'Chart of Accounts'.
We have 'Utilities' (Expense), which is matching.
We have 'Office Supplies' (Expense).
For the 'Payroll' - Income category. Let's say it should be 'Consulting Income'.
Click on the 'Payee/Categories' Tab. For 'Input Category' (Payroll) enter the name in the 'Output Category' column (Consulting Income).
Now we have all the things in the right order. Make sure all accounts, vendors, and customers exist in Quickbooks.
Click the 'Convert' button to create an IIF file.
Confirm the file name and location.
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.
Done! Transactions are imported.
Review transactions in Quickbooks after importing. Click 'Lists' - 'Chart of Accounts' - 'Wells Fargo'.
