Each accepted transaction must have one balancing SPL line.
Supported input and export details
IIF input supports simple, balanced transactions with a single split. Multi-split transactions and other IIF record types are rejected.
Set required export details in “Account and export details” before converting. The preview shows up to ten transactions and totals by account and currency. Opening or running balances are not inferred, and previewed transactions cannot be edited here. Download links expire after 24 hours.
Why convert IIF files to CSV
This converter accepts balanced General Journal transactions with one SPL line. Multi-split entries, list exports and other IIF record types are rejected rather than flattened or silently skipped.
Multi-split and non-transaction records are reported as unsupported.
The !TRNS and !SPL column definitions are read so values land under the right names.
Amounts keep the sign QuickBooks assigned, so totals reconcile with the register.
DOCNUM values are written as text so leading zeros survive in a spreadsheet.
The IIF export is checked, fingerprinted and removed from the server as soon as the job exists.
Who converts IIF to CSV
Exported transactions can be checked in a spreadsheet before an import into another company file.
A client's IIF export becomes a table that can be sorted by account or vendor.
Transaction history leaves in a form the next system can import.
Spend by account or class is a pivot table away once the data is in rows.
IIF to CSV: how each field is mapped
Supported IIF transactions map to CSV columns. Multi-split transactions and unsupported records are rejected.
| Field | In IIF | In CSV |
|---|---|---|
| Date | DATE field on each TRNS line | One text column; ISO format recommended |
| Description | NAME and MEMO fields | Free-text column, quoted when it contains commas |
| Amount | Signed AMOUNT with balancing SPL lines | Signed Amount column, or Debit and Credit columns |
| Balance | Not stored; QuickBooks recalculates it | Optional Balance column |
| Reference | DOCNUM field | Optional Reference column |
| Account | ACCNT name that must exist in the company file | Not stored unless added as a column |
| Currency | Company currency | Not stored unless added as a column |
Converting IIF to CSV in practice
Flattening IIF transaction blocks into rows
This converter accepts balanced IIF transactions with one SPL line. Transactions with multiple splits, list exports and other record types are rejected so accounting detail is not silently flattened.
Each accepted transaction becomes one row with its parsed date, amount, payee, memo, reference and account. Check that the source contains only the transaction form supported by this page.
After converting, check that:
- Each source transaction has exactly one balancing SPL line
- Amounts and dates match the source
- Unsupported list or multi-split records were not present
How to convert IIF to CSV in three steps
- 1Upload the IIFAdd a supported QuickBooks Desktop General Journal export.
- 2Check entries and datesConfirm each transaction has one balancing SPL line and dates are unambiguous.
- 3Download the CSVOpen the accepted transaction rows in your spreadsheet.
About IIF and CSV
IIF is QuickBooks Desktop's tab-delimited format. This tool supports a narrow balanced General Journal pattern rather than every IIF transaction and list type.
CSV is a flat table; multi-split allocations and IIF list records are not represented by this converter.
Specifications and vendor help for IIF and CSV: QuickBooks support · RFC 4180, the CSV specification
Questions about CSV conversion
Which row layout should I choose?
There is one row per accepted transaction. Split-row layouts are not supported.
Are list sections included?
No. Unsupported IIF record types are rejected.
Do amounts keep their sign?
Yes. The sign QuickBooks wrote is preserved so debits and credits reconcile.
Can I convert an IIF I edited by hand?
Yes, as long as the header lines are intact. Malformed files are reported with the line number.
Is this iif to csv converter free?
Yes. Uploading the IIF, choosing the row layout and downloading the CSV is free.