Free IIF to QIF Converter

Move transactions out of QuickBooks Desktop into Quicken, GnuCash or Moneydance with your categories and your split transactions intact. No signup, and your file never leaves your browser.

The reason to pick QIF over CSV

A CSV row holds one transaction and one category. That is fine until you hit a payment split across several categories, and every set of books has them: the shop run that was part office supplies and part meals, the card bill covering three things at once.

A CSV has to flatten those into a single line for the total. QIF doesn't. It has a dedicated block for splits, so each line keeps its own category, memo and amount, and the total still adds up.

Here is the same transaction in both:

In CSVIn QIF
2024-01-05, COSTCO, -150.00, (no category) T-150.00
SOffice Supplies $-100.00
SMeals $-50.00

Your categorising survives the move

In an IIF file the category is the account on the split line under each transaction. That is work you already did inside QuickBooks, and it goes straight into the QIF category field that Quicken, GnuCash and Moneydance read.

A converter that starts from a bank CSV has nothing to put there and writes Unspecified on every line, leaving you to categorise a year of transactions again by hand.

The account type is read from your file

QIF declares up front whether a batch belongs to a bank account or a credit card, and getting it wrong puts a card into a bank account without the importing software complaining. Most converters ask you and trust the answer.

An IIF file that includes its chart of accounts says which it is, so this page reads it and tells you what it found. When the file doesn't say, the page says that too, and asks.

Which software takes QIF

QIF has no transaction IDs. Import each file once.

Nothing in a QIF file tells the importing software that it has already seen a transaction. Whether duplicates get caught is up to that software, and its matching is usually date plus amount, which two identical coffees on the same day will defeat.

Import each file once and keep the date ranges from overlapping. This is a limitation of the format, not of this converter, and no QIF tool can work around it.

Questions

Why is my split showing as unbalanced?

It shouldn't. In IIF the transaction line and its split lines carry opposite signs, because it's double entry bookkeeping: spend 150 and the account line reads -150.00 while the expense lines read +100.00 and +50.00. QIF works from the account's point of view, so the split amounts have to match the sign of the total. We flip them. If you see an unbalanced split anyway, tell us, because that is a bug on our side.

Which QuickBooks versions does this work with?

Any of them. The converter reads the column layout out of the file's own headers instead of assuming a fixed order, which is what breaks other tools when a newer QuickBooks adds columns or moves them around.

What if my file has more than one account in it?

Every transaction in IIF names its own account, so nothing gets mixed up on the way in. The page tells you how many accounts it found. Most software importing a QIF puts everything into one account, though, so if the file covers several you probably want to split it up first.

Can I go the other way, QIF back into QuickBooks?

QuickBooks Desktop does not import QIF. The way in is either a .qbo Web Connect file through the bank feed, or an IIF file written straight into the company file. Which of those you want depends on whether you would rather review the transactions before they land.

Is my file uploaded anywhere?

No. Every converter here runs in the browser, and each page ships a Content Security Policy with connect-src 'none', so your browser refuses to let the page make any network request. Watch the Network tab in developer tools while you convert and it stays empty.

Related