CSV2IIF: Convert CSV/XLS/XLSX to IIF

Easy to use secure solution to review/convert your transactions and import into your accounting software. Convert CSV/XLS/XLSX to IIF and import into QuickBooks (Win/Mac), (Win/Mac). Work directly in Excel and copy data into the converter and convert



What can I do with CSV2IIF (CSV/XLS/XLSX to IIF Converter)?

Why should I trust CSV2IIF?

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

Can I try before purchasing?

Convert CSV to IIF format and import into Quickbooks

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.

Step by step instructions for Windows

See below steps for the Windows version, followed by the Mac 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.

CSV2IIF Windows Step 1: select a CSV file

The IIF format allows better control for imported data than the QBO format, and importable by older Quickbooks.

CSV2IIF Windows Step 2: source, raw view

CSV file must have, date, amount, category (expense/income account), Payee (Vendor in Quickbooks), bank or credit card account name.

CSV2IIF Windows Step 3: review transactions before converting

Click 'Charges/Withdrawals' to reverse amount signs for whole file. Useful for credit card files with positive amounts for expenses.

CSV2IIF Windows Step 4: Charges

Review transactions before importing, and click 'Convert' button to create an IIF file.

CSV2IIF Windows Step 5: click Convert

Confirm the file name and location.

CSV2IIF Windows Step 6: 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.

CSV2IIF Windows Step 7: backup in Quickbooks

In Quickbooks, click 'File' - 'Utilities' - 'Import' - 'IIF Files'. Locate the IIF file you've just created.

CSV2IIF Windows Step 8: import in Quickbooks

Done! Transactions are imported.

CSV2IIF Windows Step 9: transactions are imported in Quickbooks

Review transactions in Quickbooks after importing.

CSV2IIF Windows Step 10: Review transactions after importing in Quickbooks