CSV2IIF: Convert a CSV file to IIF and import into QuickBooks

CSV2IIF: Convert a CSV file to IIF and import into QuickBooks

This tutorial shows how to convert a CSV file to IIF format. We will use CSV2IIF utility.

We will use a sample.csv file.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 1: sample csv

The CSV file has four transactions and it has the column, properly marked.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 2: review sample

Also, it has the category, which has expense account names, Payee names, that matching Vendor names in Quickbooks. And there is one Check. It has simple Amount column and the converter recognizes this file automatically, there is no need to remap this file. And it is for a single account. All transactions are for Checking account. And we will set the Account Name, that will be used for IIf file on the right side panel, as a Checking Account Name. If you need, on the left sidebar, there are some controls to set, to tell the Converter how your file is organized and your CSV file is created. You can tell Date format, you can tell if a year is missing. If it is Credit Card file with reversed amounts (like expenses are positive and payments to the account are negative), then you can click 'Change +/-' to reverse all amounts.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 3: change button

So, importing to IIF file, your file must have a category column, because IIF file requires two accounts for each transaction. One account, that is Bank or Credit Card Account Name, you can also specify a separate column, called Account Name and Map this column in the Mapping. But usually, when you download from your bank, the CSV file is for the specific account. Set the Account Name, that you have in Quickbooks, not Account Number. The CSV file from the bank is usually will have the category missing and you need to open the file in Excel and add the category column, enter doc expense, income Account Names and done 'Convert'.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 4: csv mapper

Click 'Convert' and create a sample.iif file.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 5: click convert

Switch to Quickbooks and check the 'Chart of Accounts'. If Checking Account does not exist when you are importing the IIF file, Quickbooks will create everything, that is missing. So if your Vendor records are missing or they not matching, what you have, then Quickbooks will create new Vendor records. If expense/income accounts are missing, then Quickbooks will create them. IIF is considered low-level system format. It means that you provide data and Quickbooks will just import it. The converter does the same thing, it does not do anything accept format your file to follow IIF format. It takes your data, as you provide and formats the file to match what Quickbooks expect.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 6: checking in quickbooks

To import the IIF file click 'File' - 'Utilities' - 'Import' - 'IIF Files'. Before importing any file make sure to do backup your Quickbooks Company file: make the copy, backup, do what Quickbooks tells you to do in terms of backup. When you import things, something bad could happen: it could damage your file, it could do some changes, specially IIF file, that you need to revert later. So to quickly go back, you just make a copy before importing.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 7: file import in quickbooks

Open the IIF file.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 8: sample iif file

Now we have this file imported.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 9: data imported

Get sight of that Account Payroll was not in Quickbooks, it was in the file, as 'Payroll', so that Account was created.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 10: payroll

What happens for that type? Quickbooks tells that you must use on the IIF file general ledger Account type and then Quickbooks will look at your transactions and select transaction type for that transactions. Because it is a Checking Account and the money coming out, and they supposed to be Check. That's why it is marking as CHK - Check Account. When Check Account is presented, it was used from the IIF file, those are Vendor records, Account Names: Payee, Bookstore Invoice, Office Supplies (account number and account name are shown). But overall the file was created and expected transactions are in the right place.

CSV2IIF Convert a CSV file to IIF and import into QuickBooks Step 11: review imported transactions

Related articles