IIF Format

Excel to IIF Converter Online (Free) for QuickBooks Desktop

Save the sheet as tab-delimited text, rename it .iif, import it — that is the manual route, and every guide describes it. It also fails quietly. Excel rewrites dates on the way out, drops the leading zeros from account numbers and turns long reference numbers into scientific notation, so the import succeeds and the figures are wrong. Put the workbook through the box above instead: the .iif is assembled from the cell values themselves, so what reaches QuickBooks is what the bank actually sent. That is the whole of what it takes to import Excel to QuickBooks Desktop.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

Saved it as CSV?
The CSV route to the same .iif file
On QuickBooks Online?
IIF is Desktop-only — send a .qbo instead
Only have a PDF?
Skip the spreadsheet step entirely

Why Use Our Excel to IIF Converter Tool?

Excel never writes the file

The corruption people hit converting a sheet by hand happens inside Excel's own Save As, which reformats dates, strips leading zeros and pushes long numbers into scientific notation on the way to text. Here the cell values are read directly and the .iif is assembled from those, so Excel's display formatting never touches the output.

The two failures that reject a batch

An IIF naming an account your chart of accounts does not contain fails with error 11110, and a transaction whose two sides do not sum to zero fails as out of balance. Every account used is declared before anything references it, and every entry is written as a matched pair.

Semicolons and tabs cannot break a row

A semicolon opens a comment in IIF, so QuickBooks stops reading the line where one appears — a narration like "POS PURCHASE; CARD 1234" severs the amount off its own row and the import fails as out of balance. Semicolons, tabs and line breaks are all neutralised before the file is written.

How to convert Excel to IIF in three steps

1

Start with your bank's workbook

An .xls or .xlsx exactly as it arrived from net banking, a card issuer or a payment processor — xlsx to IIF and xls to IIF are the same conversion here. Dates are read from the cell rather than its formatting, so a column Excel stores internally as 45790 still reads as 13/05/2025.

2

Upload the spreadsheet

Use the box above to upload Excel to QuickBooks Desktop format, up to 10MB. Whichever sheet holds the transactions is located and read, and any heading rows printed above the table are skipped past, so nothing needs tidying beforehand.

3

Say how the account reads, then download

Two settings appear, because a workbook declares neither: whether the account is a current account or a card, and which way round its dates should be written. Pick both and the .iif is ready.

What goes wrong between a spreadsheet and QuickBooks

Excel rewrites the data on the way out

Saving a worksheet as tab-delimited text is the manual route to an IIF, and Excel applies its own formatting as it writes: dates come out in whatever order the machine is set to, account numbers lose their leading zeros, and any reference number long enough tips into scientific notation as 1.23457E+11. None of it raises an error, so the file imports cleanly and the figures inside it are wrong.

Import from Excel does not take transactions

QuickBooks Desktop genuinely has an Import from Excel menu, which is why this trips people up. Its scope is your lists — customers, vendors, items, the chart of accounts — and not a single transaction among them; the QuickBooks Desktop Excel import template it offers covers those lists alone. Bank and card entries arrive through IIF or a Web Connect file and through nothing else, so anyone trying to import Excel into QuickBooks Desktop for a statement is looking at the wrong menu.

Most Excel to IIF guides are about journal entries

Search the phrase and the results are dominated by importing journal entries — a bookkeeper's own spreadsheet with a debit account and a credit account typed against every line. A bank statement is not that: it records money in and out of one account and names no ledger at all, so it converts to register transactions instead. Worth knowing before following a guide written for the other job — and if journal entries really are what you need, an Excel add-in like Big Red Consulting's IIF Transaction Creator is built for exactly that.

One unknown account name rejects the batch

IIF matches your chart of accounts letter for letter — capitals, punctuation and stray spaces all count, so an account entered as "Office Supplies" will not meet one recorded as "Office supplies", and anything nested has to carry its full parent path. QuickBooks creates nothing on the fly to cover the difference; it halts with error 11110 and refuses the batch entire.

Who turns a workbook into QuickBooks entries

Statements arriving as .xlsx

Net banking hands out workbooks far more often than anything QuickBooks Desktop accepts, so the file that already holds every figure is the one file the software will not read. How to import Excel bank statement into QuickBooks Desktop has exactly one answer, and it starts with converting it.

Anyone who tried Save As first

Saving a sheet as tab-delimited text and renaming it .iif is the documented workaround, and it is where most people lose an afternoon — the file imports, and the dates and reference numbers are quietly wrong.

Multi-sheet bank workbooks

Bank exports routinely arrive with a cover sheet, a summary tab and the transactions somewhere behind them. The statement sheet is found rather than assumed, and a title block above the table is stepped over.

Card statements in a workbook

Nothing inside a spreadsheet says whether it came from a current account or a card, and QuickBooks posts the two to different registers. Naming it on the download step is what decides which transaction types the file carries.

Day-first date countries

IIF carries no date order of its own, so QuickBooks reads it from the importing machine. Choosing day-first here keeps 03/04 as 3 April on a UK or Australian install.

Bookkeepers paid by the hour

Re-keying a client's month of bank rows is the work nobody costs properly. One pass per workbook produces every entry, and the accounts are declared so the batch does not bounce on the first unknown name.

Frequently Asked Questions — Excel to IIF Converter

QHow do I import an Excel file into QuickBooks Desktop?

The workbook has to become an IIF before Desktop will look at it. Once it is one, the menu path is File → Utilities → Import → IIF Files. Whether you searched how to import Excel data into QuickBooks Desktop or how to import Excel bank transactions into QuickBooks Desktop, that is the same destination — there is no option anywhere to upload Excel to QuickBooks Desktop as it stands, which is why an Excel to IIF converter exists at all.

QHow do I convert Excel to IIF file format?

Upload the workbook above and download the result — that is the whole of it. To create an IIF file from Excel by hand you would arrange the columns into TRNS and SPL rows under the right ! headers, save as tab-delimited text and rename the extension, which is where most attempts come apart. Converting Excel to IIF free here writes those rows for you, with the accounts declared and every entry balanced. The phrase people usually type — how to convert Excel to IIF file, or convert Excel to IIF format — describes this one upload either way.

QCan I import Excel into QuickBooks Desktop directly?

For lists, yes — the Import from Excel menu handles customers, vendors, items and a chart of accounts. For transactions, no. Bank and credit card entries come in through IIF or a Web Connect (.qbo) file only, so a spreadsheet of statement rows has to be converted before Desktop will read it.

QCan I just save my Excel file as an IIF?

You can, and it is why so many of these files fail. The method is File → Save As → Text (Tab delimited), then renaming the .txt to .iif — but Excel reformats as it writes, so dates follow the machine's regional setting, leading zeros disappear from account numbers and long references become scientific notation. The import then succeeds with wrong data in it, which is harder to spot than an outright rejection.

QDoes this create journal entries in QuickBooks?

No, and that is deliberate. It writes register transactions — CHECK and DEPOSIT for a bank account, CREDIT CARD and CCARD REFUND for a card — each balanced against a single Expenses or Income line. A general journal entry needs a debit and a credit account chosen per row, and a bank statement does not carry that information: it records money moving in and out of one account. If you have a spreadsheet where you have already assigned accounts line by line, that is a journal entry import and a different job from this one.

QWhich accounts do the transactions post to?

Three: Bank Account (or Credit Card), Expenses and Income. Every withdrawal offsets to Expenses and every deposit to Income, because a statement does not say which expense head a payment belongs to. Each is declared in the file before it is used, so the import cannot fail on a missing account, and reclassifying three accounts inside QuickBooks afterwards is far less work than categorising several hundred rows by hand.

QWhat is the best Excel to IIF converter?

It depends what you are importing and how often. Big Red Consulting's IIF Transaction Creator is an Excel add-in at around $109 a year, $139 for the Pro edition, covering bills, invoices and journal entries as well as bank lines — though it needs Excel for Windows and will not run on a Mac. SaasAnt Transactions Desktop starts near $25 a month and imports Excel, CSV and IIF across most QuickBooks entities. ProperSoft's ProperConvert and Dancing Numbers both sell Windows tools in the same space. If you are importing every kind of transaction every week, one of those earns its money. For a bank or card statement now and then, a free Excel to IIF converter online settles it in a browser tab on whatever machine is nearest.

QIs there an Excel to IIF converter online free, with no download?

This is one — no download, no trial period and no account. The searches around it are worth separating, though: an Excel to IIF converter free download almost always means a Windows program or an Excel add-in that installs into your copy of Excel, which is a different thing from a converter that runs in a browser tab. Only the second works the same on a Mac, on a locked-down work laptop, or on a machine you do not have rights to install software on.

QDoes it work for credit card statements too?

Yes. The one fact a spreadsheet never records is which kind of account it came from, which is why that is the first of the two settings before download. Choose card and the entries are written as CREDIT CARD and CCARD REFUND rather than CHECK and DEPOSIT, and QuickBooks files them in a card register accordingly.

QMy dates imported the wrong way round. What happened?

Nothing went wrong in the conversion. An IIF carries no date order of its own, so QuickBooks applies the regional settings of whichever computer opens it — write the file month-first, import it on a day-first install, and 03/04 lands as 4 March. Re-convert with the other order chosen and import again.

QI am on QuickBooks Online. Can I use this?

No — Online cannot read IIF at all. IIF is a QuickBooks Desktop format, covering Pro, Premier, Enterprise and Mac. QuickBooks Online takes CSV, or a .qbo, .qfx or .ofx file instead, so the Excel to QBO converter is the one you want.

QIs there an Excel to IIF converter free download for Windows?

Several exist, and that is the catch: almost every one is a Windows executable, so anyone on a Mac is stopped before they begin. This runs in the browser, which makes the operating system irrelevant — no download, no signup and no trial ceiling on how many transactions a file may hold.

QDoes it read .xls as well as .xlsx?

Both, along with the .xls files older net banking portals still produce. The workbook is parsed the same way either way, and if it holds several sheets the one carrying the transactions is identified rather than assumed — bank exports very often put a cover sheet or a summary tab in front of the data.

QIs my spreadsheet uploaded anywhere?

The workbook is not. It is opened and read inside the browser, and the .iif is assembled there as well, so neither the spreadsheet nor the file you download is ever transmitted. What does travel is the extracted rows, on their own, so the columns can be worked out — and they are discarded the moment the conversion returns.

QHow many rows can it convert at once?

No cap on transactions and no trial ceiling. What does bind is a 10MB upload and 50,000 rows read from one sheet — limits a statement does not come close to, since twelve months of even a heavily used account still lands in the low thousands of rows.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to QBO Converter

Convert to QBO

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to IIF Converter

Convert to IIF

Turn the spreadsheet into an import file

An .xlsx is the one file almost every bank now hands out, and the one file QuickBooks Desktop will not open. Convert Excel to IIF for QuickBooks above, then take the result through File → Utilities → Import → IIF Files and point it at the account it belongs to. No signup, nothing to install, and no ceiling on how many rows the sheet holds.