Convert a CSV file to IIF and import into QuickBooks

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

We will use a sample.csv file.

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

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 a 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 the 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 a 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.

So, importing to the IIF file, your file must have a category column, because the 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’.

Click ‘Convert’ and create a sample.iif file.

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 a 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.

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 the IIF file, that you need to revert later. So to quickly go back, you just make a copy before importing.

Open the IIF file.

Now we have this file imported.

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

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.

Originally published at https://www.propersoft.net.

--

--

--

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Python 2 vs Python 3

🆕 Windows: Box integration

Big Interview with Michael Scott — research career, global trends in programming and mathematics…

5 Useful Channels to Find Hackathons

Where do web development project ideas come from?

How to Fix Microsoft Office Excel Error Stdole32.tlb

Python map() Function

SQL won’t save us. Sequelize won’t either, but at least it’s nicer to look at.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sergiy Tytarenko

Sergiy Tytarenko

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

More from Medium

Scheduling Through Linear Programming

First data update — February 22

The 10 Best Machine Learning Algorithms for Data Science Beginners

Project Spotlight: Andrew Warburton