QIF to QBO Converter QIF to QBO Converter

Download IIF to CSV Converter for QuickBooks Desktop Exports

IIF to CSV Converter turns a QuickBooks Desktop export into a spreadsheet you can sort, filter and hand on. Transactions and splits, read on your own PC.

   
 Download for Free
QIF to QBO Converter Screenshot.
An IIF file does not have to be called .iif, and quite often it is not. QuickBooks Desktop writes plain tab-delimited text, whoever ran the export clicks Save, and the thing lands on the disk as a .txt. A converter that decides by the file name turns that file away without reading a byte of it. SoftOrbits IIF to CSV Converter looks inside instead. It reads the opening lines, and if the !TRNS header is sitting there, the file is read as an IIF export, whichever of the two legacy extensions it carries.

How to download and use the IIF to CSV Converter

The export does not have to move.

1. The export does not have to move

1. The export does not have to move

Download the IIF to CSV Converter and install it on the PC that holds your QuickBooks Desktop export. The file is worked on where it already lies, so it does not have to travel to anybody's server first.

Add the file, extension and all.

2. Add the file, extension and all

2. Add the file, extension and all

Drag the export into the program. The queue takes .iif files; what is inside decides how they are read. Nothing is written until you say so, and the preview is where you look first.

Pick CSV and write the file.

3. Pick CSV and write the file

3. Pick CSV and write the file

On the Convert page choose CSV in the output box, point at a folder and run it. The result opens in Excel, and in Google Sheets or LibreOffice just as well. From there it goes into Xero or a reconciliation workbook like any other spreadsheet.

Transactions cross over. Lists stay behind..

Transactions cross over. Lists stay behind.

An IIF export can carry far more than money moving in and out. A chart of accounts lives in there, and so do customers, vendors, inventory items, classes. What crosses over into your CSV here is the postings, dated and described, with amounts against accounts. The name lists do not. If a customer roster or the account tree is what you came for, that is not what you will end up with. Worth checking against the list above before you spend a download finding out.

   
 Download for Free

The import option Intuit tells you not to pick

On its own help page about IIF import, Intuit says it does not recommend the option 'Import it for me. I'll fix it later', because some of the info may end up wrong or incomplete in your books; choosing it also means switching QuickBooks into single user. So take the export apart yourself before any of it is posted. IIF to CSV Converter lays the dates, the payees, the accounts and the signs out in plain columns, where a mistyped account costs you a single cell instead of an afternoon spent unpicking a posted batch.

   
 Download for Free

The import option Intuit tells you not to pick.
One export, the whole book.

One export, the whole book

A bank statement covers one account for one month. An IIF export is another thing entirely. It lists the suppliers your firm pays, the notes your bookkeeper typed against them, the account tree somebody invented back in 2011, and every figure attached to all of that. It is worth to know this before the whole thing goes into a web form on a site you found ten minutes ago. Nothing is uploaded anywhere here. The export stays on the machine you run it on, and the CSV appears beside it.

   
 Download for Free

Read by content, not by extension

IIF to CSV Converter probes every file it is given. The parser comes from the bytes, not from the extension. One honest note. IIF and QIF are two separate grammars, and where a file could pass for either, the program calls it QIF. That call is worth knowing about, because a genuine Quicken archive belongs on the page where you open a QIF archive as a spreadsheet.

Columns found by name

Each section of an IIF file opens with a header line that starts with an exclamation mark and names its own columns. DATE, ACCNT, NAME, AMOUNT, MEMO. Whatever else that particular export carried is written out there too, by QuickBooks itself. Those names are what gets read, not the column positions. An export with the columns in an order nobody warned you about still lands in the right places.

Splits that do not cancel themselves out

IIF writes a split twice over. The !TRNS line carries the total, the !SPL lines carry the parts with the sign turned around, and adding the file up exactly as it stands gives you zero. A card charge of 1,200 split three ways sits in the export as a total line of -1,200 and three parts adding back up to +1,200. That is the moment people decide a converter is broken. Every transaction comes out as one row holding the TRNS total, and the reversed SPL parts are not written out beside it, so the Amount column is something SUM() can be run over.

Boundaries that hold down a long file

!TRNS, !SPL and !ENDTRNS repeat for every transaction in the export, and a year of a small company's books in one file is nothing unusual. Each block is closed where the file closes it. Nothing from one transaction leaks into the next, and the row count in your spreadsheet is the transaction count in the export.

A look at the parse before anything is written

Text preview comes first. It reports how many transactions came back, which encoding the file turned out to be in and how the opening rows come out. If an export was edited by hand in Notepad at some point, which happens to IIF a lot, this is where the count stops to match what you expected, and not two steps on in a workbook you have already started building formulas in.

Three outputs, one program

CSV sits one setting away from QBO and PDF on the same Convert page. Same program writes .qbo too, for the case where the data has to go back into accounting software rather than into a spreadsheet, and that side of it is covered on the convert QIF to QBO page. IIF to CSV Converter also reads .qif files, so a folder with both kinds of legacy export does not need two tools.

QIF to QBO Converter
QIF to QBO ConverterDownload the IIF to CSV Converter, drop in the export QuickBooks Desktop gave you, even the one sitting there as a .txt, and read your transactions as a spreadsheet.
 Download

Who needs IIF to CSV Converter Tool

For admins on QuickBooks Desktop

You keep the company file, the workstations and the backups. IIF is the format that still moves the data in and out of Desktop when the bank feed has gone quiet, and CSV is what the rest of the office can actually open.

For bookkeepers with a Desktop client base

Clients on Desktop send exports, not access. Reading them as columns is how you check a period before it is posted, and how you build the summary the client asked for without typing anything twice.

For consultants running a migration

A move off Desktop arrives as a pile of mixed exports. IIF out of Desktop itself, .qif from something older, .qbo files the bank once sent and nobody kept a reader for. That last kind you can convert a QBO file to CSV as well, and the whole pile ends up in one shape before it goes into the new system.

QIF to QBO Converter

QIF to QBO Converter

Languages
File Size

9 Mb

Version

1.0

Last updated on

25/06/26

$ 29.99

🖥️ System Requirements

  • Windows 11/10/8.1/8/7 (32/64 bit)
  • Intel i3, AMD Ryzen 5 or above
  • 4 GB of RAM or above
  • NVIDIA® GeForce® series 8 and 8M, Intel® HD Graphics 2000, Quadro FX 4800, Quadro FX 5600, AMD Radeon™ R600, Mobility Radeon™ HD 4330, Mobility FirePro™ series, Radeon™ R5 M230 or higher graphics card with up-to-date drivers
  • 1280 × 768 screen resolution, 32-bit color
  • 1 GB of free hard disk space or above

🙋 Frequently Asked Questions

Install the program, drag the export in, set CSV as the output format and run it. The trial writes out the first 20 transactions, enough to see the columns and the amounts from your own export instead of a sample somebody else prepared.

Short answer: Intuit Interchange Format. Tab-delimited text, and only QuickBooks Desktop ever really used it. Long answer: the file is built from sections, each one opening with a header line that begins with an exclamation mark and names the columns that follow. That is why one file can hold transactions, accounts and name lists at once. There is a field-by-field walkthrough of what an IIF file is in the glossary. Do not confuse it with the .qbo Web Connect file your bank sends; that one is a different format with a different job.

Excel will open it, because it is text, but what you get is the raw sections. Header lines with exclamation marks, split rows carrying reversed signs, and one long column when the tab delimiter is not picked up. Converting to CSV first gives you dated rows and an Amount column instead. It also keeps you out of the other habit, editing the IIF by hand and saving it back, which is how these files get corrupted in the first place.

No. The export is a text file and it is read as one, so a machine that has never had QuickBooks on it will do. That covers the common case, where the subscription lapsed or Desktop was removed from the workstation and only the exported files were kept.

In QuickBooks Desktop it goes through File, Utilities, Import, IIF Files. Intuit rebuilt that tool in QuickBooks Desktop 2019 and the newer one runs in multi user mode, so the version you are on decides how the import behaves. Converting to CSV is the other direction: reading what the export contains, not putting it back.

Not with this program. It reads IIF and QIF and writes CSV, QBO and PDF, so the road runs out of QuickBooks Desktop and into a spreadsheet, not back the other way. Getting back in starts from a table rather than from an IIF file, and the route that builds a .qbo from a spreadsheet is the one QuickBooks accepts on import.

QuickBooks Desktop writes them itself, from the File menu under Utilities and Export. The result is the tab-delimited text described above, and that is the file to bring here.

Rate QIF to QBO Converter

  • Windows 7
  • Windows 8
  • Windows 10
  • Windows 11
Author: SoftOrbits (English)
Avg. rating: 4.5 from 842 votes
 Download for Free

Risk-free download

14-day money-back guarantee
Full refund, no questions asked
progressive-webapps/apis/offline-first Created with Sketch.
100% offline
Your files never leave your PC
Safe & secure download
Directly from the official website
No sign-up required
No account or email to get started
Trusted since 2006
Desktop software for Windows