Need to import transactions, but the format is not supported? Convert CSV/XLS/XLSX to IIF and import into QuickBooks (Win/Mac), (Win/Mac). Open files in XLS and XLSX or CSV formats. Review transactions in a readable view before converting
Another product, Bank2IIF, supports more formats.
This tutorial shows how to convert a CSV file from your bank or credit card statement to IIF format and import into Quickbooks. We will use CSV2IIF utility.
Follow the steps below for the Windows version.
Make sure you are using the latest version of CSV2IIF. Download it from the CSV2IIF download page. Start CSV2IIF and select a CSV file.
The IIF format allows better control for imported data than the QBO format and importable by older Quickbooks.
CSV file must have Date, Amount, Category (expense/income account), Payee (Vendor in Quickbooks), Bank or Credit Card Account name.
Click 'Change +/-' to reverse the amount sign for the whole file. Useful for Credit Card files with positive amounts for expenses.
Review transactions before importing, and click the 'Convert' button to create an IIF file.
Confirm the file name and location.
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.
In Quickbooks, click 'File' - 'Utilities' - 'Import' - 'IIF Files'. Locate the IIF file you've just created.
Done! Transactions are imported.
Review transactions in Quickbooks after importing.