IIF to CSV converter
Convert a QuickBooks Desktop IIF file to a CSV file in your browser: every transaction, with its date, payee, memo and amount. Your file never leaves your computer. 2 free a day, no sign-up.
No file to hand?
Convert to
Tally needs both ledger names exactly as they are in your company.
New company? Download the ledger setup file too and import it first (Import, then Masters).QuickBooks Desktop needs both account names exactly as they are in your chart of accounts.
QuickBooks makes any account it doesn’t know into a new bank account, so check the spelling.- Runs in your browser
- 2 free a day, no sign-up
- IIF in, CSV out
01 / Why convert
One account’s transactions from an IIF file as a plain CSV table.
02 / What carries over
From IIF to CSV, field by field.
What the IIF file can hold, and where it goes in the CSV file.
| In the IIF file | In the CSV file |
|---|---|
| Date | Kept |
| Amount (money in and out) | Kept |
| Payee or description | Kept |
| Memo (extra text) | Kept |
| Check or reference number | Reference column |
| Running balance | Not in a IIF file |
| Category | Kept |
| Credit card (not a bank account) | CSV has no place for it |
03 / Opening it
Opening the CSV file.
Excel
- Data, then From Text/CSV, then pick the file. Dates are written 2026-01-05, which Excel reads the same in every country.
Google Sheets or Numbers
- File, then Import (Sheets) or Open (Numbers).
Accounting apps
- Most apps that take a bank CSV ask you to match columns once: Date, Description, Debit, Credit.
04 / The IIF file
Getting a QuickBooks Desktop IIF file.
Intuit Interchange Format: tab-separated text QuickBooks Desktop imports. Each transaction is a TRNS line and its split (SPL) lines, which add up to zero.
- Point-of-sale, payroll and other tools that “export to QuickBooks Desktop” often write IIF.
- QuickBooks Desktop itself exports lists as IIF (File, Utilities, Export).
Have a bank statement PDF instead? The bank statement converter reads it in your browser too.
05 / Good to know
The details that matter.
- Dates like 03/04/2026 can mean March or April. The order is worked out from the file (a day over 12 decides it), and you can switch it when nothing does.
- You pick the account whose transactions you want; bank and card accounts are offered first. Each transaction’s other side becomes its category.
- Columns: Date, Description, then Memo, Reference and Category when the file has them, then Debit and Credit, and Balance when the file had one. UTF-8 with a byte-order mark, so Excel shows accents and ₹ signs correctly.
06 / Questions
Straight answers.
Is this IIF to CSV converter free?
Yes, for 2 files a day with no account. A free account (just your email, no password) gives you 2 more, and paid plans have no daily limit. It runs in your browser, and nothing is stored.
Is my IIF file uploaded anywhere?
No. The file is read and the CSV file is written by code running in this browser tab. Neither is sent to a server. You can check: open your browser’s developer tools, go to the Network tab, and convert a file.
Which columns will the CSV file have?
Date, Description, then Memo, Reference and Category when the IIF file has them, then Debit (money out) and Credit (money in), and Balance when the file had a running balance. Dates are real dates, oldest first.
How are dates read?
IIF files write dates in the order of the program that made them (MM/DD in the US, DD/MM in most other places). The order is worked out from the dates themselves, and you can switch it in the panel when nothing in the file decides it.
07 / More converters
Other files, same idea.
All of them run in your browser. For PDFs, start at the bank statement converter; every converter is on the converters page.