Why can't I just import a CSV directly into QuickBooks Desktop?

Because it can't — QuickBooks Desktop has no built-in CSV or Excel import for transactions at all (confirmed directly on Intuit's own support community). IIF has been the standard workaround for this for years, which is exactly what this converts to.

What kind of CSV works?

Any CSV with a date, a description, and an amount column — a bank export, an accounting tool's export, or your own spreadsheet. Headers are detected automatically; there's no fixed template to match.

Does it assign categories or vendor names to each transaction?

No — a bank statement or plain CSV doesn't carry that information to begin with, so there's nothing to map it from. You'll categorize inside QuickBooks after import, the same as reviewing a bank feed.

How do I import the IIF file into QuickBooks Desktop?

File > Utilities > Import > IIF Files, then select the file this tool downloaded. QuickBooks Desktop reads it directly — no other steps needed.

Will this work with QuickBooks Online?

No — IIF is specifically a QuickBooks Desktop format. QuickBooks Online doesn't import IIF at all; use our CSV to OFX converter instead for QuickBooks Online.

Does IIF stop working after a few years, like QBO does?

No, and that's a real reason to prefer it — QuickBooks' own QBO (Web Connect) format stops importing once it's about three years old, requiring an upgrade. IIF has no such expiry.

Is my data uploaded anywhere?

No. The conversion runs entirely in your browser — nothing is sent to a server.

BalanceExtract

local

Format converter

Free CSV to IIF Converter for QuickBooks Desktop

Runs entirely in your browser — your file is never uploaded to a server.

100% private

Never uploaded

Instant

Runs in your browser

CSV & Excel

Real spreadsheet output

No signup

No account, no card

Convert a CSV to IIF

Drop your file below — runs entirely in your browser, nothing is uploaded.

Drag and drop your CSV file hereor click to browse your files CSV→IIF

Only have a PDF statement? That converts too.

A CSV file means your bank gave you structured data — which most banks only do for the last few months. Beyond that you get a PDF, and a PDF won't open in Excel. BalanceExtract reads those directly: it works out the column layout from the document itself, handles scanned statements with OCR, checks that every running balance reconciles, and flags any row it isn't confident about before you export.

Same IIF output, same on-device processing, nothing uploaded.

Convert a PDF statement6 pages free, no signup, no card

How to convert CSV to IIF in 3 steps

Step 1: Drop in your CSV file

Drag the file onto the box above or click to browse. It is read in your browser — nothing is uploaded to a server, which you can confirm in the Network tab.

Step 2: Check what was found

Every transaction is read out with its date, payee, description, amount and transaction ID, along with any warnings about rows that need a look.

Step 3: Download the IIF

The IIF file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.

QuickBooks Desktop has no built-in way to import a CSV or Excel file of transactions — Intuit's own support community confirms this isn't a missing setting, it simply doesn't exist. IIF (Intuit Interchange Format) has been the standard workaround for years. This guide covers exactly what an IIF file looks like, what a converter can and can't reasonably do with it, and how to get your data in.

Quick summary

Closing the books in QuickBooks Desktop without hand-entering every transaction depends on getting past a real limitation: QuickBooks Desktop can't import CSV or Excel directly — IIF is the real path in. This tool reads any CSV with a date, description, and amount column, and builds a standard TRNS/SPL/ENDTRNS block per transaction. It won't invent categories or vendor names that weren't in your source file, and unlike QuickBooks' own QBO format, IIF never expires.

What an IIF File Looks Like

Each transaction becomes a three-line block in the output file.

Line	What It Contains
TRNS	The transaction itself — date, amount, and account, offset against Uncategorized Income or Expense
SPL	The offsetting split line, opposite sign, completing the double-entry structure IIF requires
ENDTRNS	A marker closing the record — nothing else follows until the next transaction

What This Converter Doesn't Do

Worth being direct about, rather than letting you find out after importing:

No categories or vendor matching: a plain bank CSV doesn't carry that data, so there's nothing to map it from. You'll categorize inside QuickBooks after import, same as any bank feed.
No account splits: each transaction is a simple two-line entry (one account, one offset) — not a multi-line split transaction across several accounts.
QuickBooks Online isn't supported by IIF at all: this is a QuickBooks Desktop-only format; QuickBooks Online needs a different import path entirely.

Frequently Asked Questions

Why can't I just import a CSV directly into QuickBooks Desktop?: Because it can't — QuickBooks Desktop has no built-in CSV or Excel import for transactions at all (confirmed directly on Intuit's own support community). IIF has been the standard workaround for this for years, which is exactly what this converts to.
What kind of CSV works?: Any CSV with a date, a description, and an amount column — a bank export, an accounting tool's export, or your own spreadsheet. Headers are detected automatically; there's no fixed template to match.
Does it assign categories or vendor names to each transaction?: No — a bank statement or plain CSV doesn't carry that information to begin with, so there's nothing to map it from. You'll categorize inside QuickBooks after import, the same as reviewing a bank feed.
How do I import the IIF file into QuickBooks Desktop?: File > Utilities > Import > IIF Files, then select the file this tool downloaded. QuickBooks Desktop reads it directly — no other steps needed.
Will this work with QuickBooks Online?: No — IIF is specifically a QuickBooks Desktop format. QuickBooks Online doesn't import IIF at all; use our CSV to OFX converter instead for QuickBooks Online.
Does IIF stop working after a few years, like QBO does?: No, and that's a real reason to prefer it — QuickBooks' own QBO (Web Connect) format stops importing once it's about three years old, requiring an upgrade. IIF has no such expiry.
Is my data uploaded anywhere?: No. The conversion runs entirely in your browser — nothing is sent to a server.