Free preview before you pay

Convert a QuickBooks IIF file to CSV

IIF is plain tab-separated text, so Excel will open it, and then rewrite dates, drop leading zeros and pile several tables into one grid. Upload it here for a real CSV and xlsx, with the transactions shown before you pay.

Select your IIF file A transaction IIF file, the kind a payroll service or a QuickBooks add-on writes. Not the file QuickBooks Desktop's own export menu gives you, which is lists.

The finished CSV and xlsx, made from an invented example

This is the real output of this tool, made from an invented example by the same code that makes yours. The people and details in it are fictional.

Transactions 10From 5 Jan 2026To 20 Mar 2026Money in USD 2,850.00Money out USD 1,017.99Price $9

date	amount	description	payee	type
2026-01-05	-269.00	Harris Plumbing	Harris Plumbing	CHECK
2026-01-06	950.00	M. Collins	M. Collins	DEP
2026-01-09	-48.20	City Power Co	City Power Co	CHECK
2026-01-14	-120.00	Greenway Gardens	Greenway Gardens	CHECK
2026-02-03	950.00	M. Collins	M. Collins	DEP
2026-02-10	-310.44	Oakfield Insurance	Oakfield Insurance	CHECK
2026-02-17	-95.00	Bright Clean Co	Bright Clean Co	CHECK
2026-03-02	950.00	M. Collins	M. Collins	DEP
2026-03-13	-114.00	Letting Desk Ltd	Letting Desk Ltd	CHECK
2026-03-20	-61.35	City Water	City Water	CHECK

Download the sample download (transactions.csv and transactions.xlsx)

How are the dates written in this fileLeave this on auto unless the preview gets it wrong. Change it and the preview updates with the new reading, without uploading the file again.

What currency is this statement inLeave this on auto unless the preview says it guessed. Whatever is set here is written into the file you download. Change it and the preview updates.

How it works.

IIF is QuickBooks' own format, and nothing else reads it. QuickBooks Desktop's own export menu writes lists only, customers, vendors, items, the chart of accounts, never transactions, so a transaction-shaped IIF came from somewhere else. Its column order and even which columns exist changes from one export to the next, so a converter that hardcodes the layout breaks on the next file. This reads the header line of each section and maps every row by name. The one thing that still has to be checked before you pay is which way round the dates go, since IIF says nothing in the file itself about which convention it used.

Step 1

Upload your transaction IIF

This is not something QuickBooks Desktop's own File, Utilities, Export, Lists to IIF Files menu gives you, that produces lists. A file with a !TRNS header in it came from somewhere else: a payroll service, a bookkeeper's export tool, or a third-party QuickBooks add-on. One file at a time.

Step 2

Check the date reading

The preview states how the dates were read and shows the row that settled it. If it looks wrong, set the date order below and preview again before you pay.

Step 3

Download the CSV and xlsx

Every transaction, not just the preview's first 20, as a plain CSV and as a real xlsx with the dates and amounts typed correctly.

Guides on this

Trust, with receipts.

No invented review scores, no badges, no “trusted by thousands”. Here is what is actually true, and you can check every line of it.

You see the result before you payUpload, look at your own parsed file, then decide. No account, no card, no email required to get that far.
Files are deleted within 7 daysYour upload, anything extracted from it, and the finished download. Automatically, on a schedule.
A person answers the emailOne Time Tool is a small independent studio in Johannesburg, South Africa. Questions go to hello@onetimetool.com and a person replies, not a bot.
Your card never touches this siteCheckout is hosted by Dodo Payments. We never see your card number.
One payment, for this one jobThere is no subscription, no plan and nothing to cancel. Depending on where you are, checkout may show the price in your currency and add local VAT or sales tax.
7-day money backIf the output is not what you needed, email us and we refund it. No form to fill in.

Questions, answered.

Does this come from QuickBooks Desktop's own export menu?

No. QuickBooks Desktop's File, Utilities, Export, Lists to IIF Files menu exports lists only, customers, vendors, items, the chart of accounts, and Intuit's own help pages say plainly that you can import transactions with IIF but cannot export them from QuickBooks. So if you are holding a file with a !TRNS header, it came from somewhere else: a payroll service, a bookkeeper's export tool, or a third-party QuickBooks add-on that writes transactions in this format. If what you actually want is your bank transactions out of QuickBooks Desktop itself, the route that works there is a report exported to Excel or CSV, not IIF.

Can I not just open the IIF file in Excel?

You can, and Intuit's own instructions tell you how: File, Open, set the file type to All Files, and walk through the Text Import Wizard. Two things go wrong from there. Excel rewrites values as it reads them, so leading zeros vanish, long numbers turn into scientific notation and anything shaped like a date becomes one, unless you set every column to Text by hand. And an IIF file is not one table: each !TRNS, !SPL and !ENDTRNS header starts a new section with its own columns, stacked on top of each other, so the sheet looks broken even when it is not. If your file is small, the free route is fine. This does the sections, the typing and the split lines for you. Xero is different: it does not import IIF at all.

What happens with dates like 03/04/2024?

On their own those are genuinely ambiguous. The whole file is checked for a row where one reading is impossible, such as a day past 12, and that settles it for every row. If nothing in the file settles it, QuickBooks itself is overwhelmingly a US product so it defaults to month-first, and the preview says plainly that it is a default rather than a finding, so you can set it yourself before paying.

What does it do with split transactions?

A QuickBooks transaction has the account it hit (the TRNS line) and one or more offsetting accounts (the SPL lines). A single split becomes the category on that row; more than one is listed in the memo instead of dropped, since a split transaction is still one line in a spreadsheet.

Does it handle list-only IIF exports, like a customer or item list?

No, this reads transaction exports specifically, the ones with a !TRNS header. A list export has a different shape entirely and is refused with an explanation rather than misread as transactions.

What happens to my file?

It is deleted within 7 days, along with the finished CSV and xlsx. It is used to make your file and nothing else. Nobody reads it.

Do I need an account?

No. There is no signup, no subscription and no password. You upload, you see the result, you pay once if you want it.