انتقل إلى المحتوى
TradingFormsمستندات وأدوات تجارية مجانية

IIF File Format Explained, With a Real Bank Example

· قراءة 6 دقائق

IIF File Format Explained, With a Real Bank Example

The IIF file format is a plain text file, with columns separated by tabs, that QuickBooks Desktop uses to import and export lists and transactions. IIF stands for Intuit Interchange Format. Each transaction is written as a TRNS line, one or more SPL lines, and an ENDTRNS line, and the amounts must add up to zero.

That's the short version. The format makes more sense when you watch one real bank row turn into IIF lines, so we converted a small bank export and read the result. One row didn't make it, and the reason is worth knowing before you import anything.

What is an IIF file?

An IIF file is a text file with the .iif extension that holds accounting data in rows and tab separated columns. You can open it in Notepad or Excel. QuickBooks Desktop reads it through File, Utilities, Import, IIF Files.

Three facts matter in practice:

  • It's for QuickBooks Desktop only. QuickBooks Online doesn't import IIF files. For Online, use a QBO Web Connect file or a CSV upload.
  • It writes straight into your books. A bank feed puts transactions in a review list first. An IIF import posts them to the accounts named in the file.
  • It has almost no safety net. Intuit's own IIF overview warns that error checking is limited, and a badly formatted file can import wrong data without any error.

So the format is simple. Getting it right is the careful part.

How an IIF file is laid out

An IIF file starts with header lines that begin with an exclamation mark, followed by data lines that use the same columns. For bank transactions there are three headers: !TRNS, !SPL and !ENDTRNS.

Line What it holds
!TRNS, !SPL, !ENDTRNS Column names, once at the top of the file
TRNS The bank side of one transaction: type, date, account, name, amount
SPL The other side: the income or expense account and the opposite amount
ENDTRNS Closes the transaction

The columns we use for bank data are TRNSTYPE, DATE, ACCNT, NAME, AMOUNT, DOCNUM and MEMO. Dates are written MM/DD/YYYY. A TRNS amount and its SPL amounts must total zero. That's double entry bookkeeping written as text.

We converted a 12 row bank CSV. Here's what came out

We made an October export from a business checking account: 12 rows with Date, Description, Check No, Amount and Balance columns. It had deposits, two paper checks, card purchases, ACH debits, and an opening balance row with an amount of 0.00. We dropped it into our CSV to IIF converter.

The tool matched all the columns by itself, including Check No as the reference. We typed "Chase Checking 4417" as the bank account and "Uncategorized Expense" as the offset account, then downloaded the IIF.

What we checked Result
Rows in the CSV 12
Rows the tool read 11
Transactions written to the IIF 10
Money in 9,665.40
Money out 4,141.25
IIF file size 2,464 bytes

Here's check 1042 for $1,280.00, as it appears in the file (tabs shown as wide gaps):

TRNS    CHECK   10/03/2026   Chase Checking 4417     CHECK 1042 Harbor Freight Lines   -1280.00   1042
SPL     CHECK   10/03/2026   Uncategorized Expense   CHECK 1042 Harbor Freight Lines    1280.00   1042
ENDTRNS

Money out became a CHECK with a negative amount on the bank line. Money in became a DEPOSIT with a positive amount. The SPL line carries the same number with the opposite sign.

The two rows that didn't arrive

The opening balance row was left out of the IIF on purpose. Its amount was zero, and a zero transaction has nothing to post.

The other one was our mistake, and it's a common one. One description had a comma and quote marks in the middle of the text: POS PURCHASE "USPS PO 4851230275, AUSTIN". The quotes didn't wrap the whole field, so the row no longer split into clean columns, and it never showed up in the preview. That was a $23.80 purchase. The real money out for the month was 4,165.05, not 4,141.25.

Nothing flagged it. We only caught it because the count said 11 and the statement had 12 lines. So here's our strongest advice: compare the transaction count and both totals with your bank statement before you import. It takes a minute.

How to convert CSV to IIF

You need a CSV with a date, a description and an amount. Separate money in and money out columns work too.

  1. Open the CSV to IIF converter and choose your file. It's read in your browser and isn't uploaded.
  2. Check "Which column is which". Fix any column the tool guessed wrong, and set the date order if your bank writes day first.
  3. Compare Transactions, Money in and Money out with your statement.
  4. Open "File settings" and type the QuickBooks bank account name exactly as it appears in your chart of accounts. Then name the offset account.
  5. Click IIF (QuickBooks Desktop) to download the file.

Starting from a bank download and not a spreadsheet? The QBO to IIF converter takes QBO, QFX and OFX files and writes the same kind of IIF.

How to import an IIF file into QuickBooks Desktop

Back up the company file first. Then, in QuickBooks Desktop, go to File, Utilities, Import, IIF Files, and pick the file. QuickBooks tells you when the import has finished.

Open the bank register and check the first and last entries against your CSV. Then recategorize the offset side. Every transaction sits in the one offset account until you move it to rent, freight, sales and so on.

Why IIF imports go wrong

In our experience, nearly every bad import comes down to one of these four.

  • The account name doesn't match. "Chase Checking" and "Chase Checking 4417" are two accounts to QuickBooks. If the name in the file isn't in your chart of accounts, QuickBooks can create a new account with that name.
  • The file was imported twice. IIF has no duplicate check. Import the same file again and every transaction is entered again.
  • Day and month are swapped. IIF wants MM/DD/YYYY. A file that reads 03/10/2026 as March when the bank meant 3 October puts everything in the wrong period.
  • A row was lost before the conversion. That's what happened to our USPS purchase. Commas and quote marks inside a description are the usual cause.

Should you use IIF or a QBO file?

We'd pick a QBO file for routine monthly bank activity, and IIF only for catch up work. Here's why.

IIF QBO (Web Connect)
Works with QuickBooks Desktop Desktop and Online
Where transactions land Straight in the register In the bank feed, for review
Duplicate protection None Yes, by transaction ID
Sets the accounts for you Yes, both sides No, you categorize in the feed
Best for Bulk catch up, a move from another system Regular monthly imports

A QBO file is harder to get wrong, because QuickBooks shows you each line before it posts. IIF is faster when you have a year of history to load and you know your account names. If you want the safer route, the CSV to QBO converter builds a Web Connect file from the same CSV.

One limit of our tool: it writes bank transactions only. It won't build IIF files for invoices, bills, customer lists or journal entries.

This guide is for organizing your records. It isn't accounting or tax advice, so ask your accountant before a large import into live books.

Have a CSV ready? Run it through the CSV to IIF converter, and check the count before you import.

Frequently asked questions

What does IIF stand for?

IIF stands for Intuit Interchange Format. It's a tab separated text format that QuickBooks Desktop uses to import and export lists, such as customers and accounts, and transactions, such as checks and deposits.

How do I open an IIF file?

Open it in a text editor such as Notepad, or in Excel as a tab delimited file. You'll see header rows that start with an exclamation mark, then TRNS, SPL and ENDTRNS rows. To load it into your books, use File, Utilities, Import, IIF Files in QuickBooks Desktop.

Can QuickBooks Online import an IIF file?

No. IIF is a QuickBooks Desktop format. For QuickBooks Online, upload a CSV or a QBO Web Connect file in the banking section. You can make a QBO file from a CSV with a CSV to QBO converter.

Will importing an IIF file twice create duplicates?

Yes. IIF has no duplicate detection, so a second import enters every transaction again. Back up the company file before you import, and keep a note of which files you've already loaded.

What date format does an IIF file use?

MM/DD/YYYY, the US order, for example 10/03/2026 for October 3. If your bank export writes the day first, tell the converter the date order so October 3 doesn't become March 10.

Why does my IIF import fail or create new accounts?

Usually the account name in the file doesn't exactly match a name in your chart of accounts. QuickBooks treats a different spelling as a different account. Other common causes are amounts that don't total zero within a transaction and a file that isn't tab separated.