QuickBooksなし、ソフトのインストールなし、登録なしでIIFをCSVに変換。transactions、journal entries、accounts、classes、items、listsをExcel向けに出力します。
QuickBooks DesktopのIIFファイルはエクスポートには便利ですが、Excelで確認しにくい形式です。このIIF CSV変換ツールはTRNS、SPL、account、class、memo、item dataを読みやすい表にします。
IIF file
IIFはIntuit Interchange Formatです。QuickBooks Desktopはaccounts、customers、vendors、items、invoices、payments、checks、deposits、journal entriesの入出力に使います。
Why this IIF to CSV converter
このツールはIIFヘッダーを読み、transactionとsplit行を保持し、必要なら全レコードを出力し、Excel向けCSVを作成します。
How to convert IIF to CSV
日本語: upload IIF, preview QuickBooks rows, choose columns, and download CSV.
1
Step 1
Upload one or more QuickBooks IIF files.
2
Step 2
3
Step 3
Choose date format and amount layout.
4
Step 4
5
Step 5
Download separate CSV files or one merged CSV.
Can I convert IIF without QuickBooks?
Yes. The file is read in the browser and QuickBooks is not required.
Are account types and classes preserved?
Yes, when those fields exist in the IIF file.
Can Excel open the CSV?
Yes. The output is a standard CSV file.
Are journal entries supported?
Yes. Journal entries usually appear as TRNS and SPL rows.
Can I use it for Xero or Wave?
Often yes, but you must map columns in the target app.
IIF to CSV features
QuickBooks IIFファイルを、会計確認、移行、仕訳、スモールビジネス記録に使いやすいCSVへ変換します。
- Converts QuickBooks IIF files to spreadsheet-ready CSV.
- Reads IIF header rows such as !TRNS, !SPL, !ACCNT, !INVITEM, !CUST, and list tables.
- Exports TRNS and SPL rows for transactions and journal entries.
- Can export all rows for accounts, classes, items, customers, and vendors.
- Keeps date, type, account, name, class, amount, document number, memo, cleared status, account type, item, quantity, and price.
- Supports single amount or debit and credit columns.
- Supports ISO, US, EU, and source dates.
- Keeps IIF table and record type columns for review.
- Adds source row and source file columns for audit work.
- Adds extra IIF fields when a file has uncommon columns.
- Shows preview, counts, totals, and warnings before download.
- Warns about missing headers, no transaction rows, split rows, and multi-table exports.
When IIF to CSV helps
QuickBooks IIFファイルを、会計確認、移行、仕訳、スモールビジネス記録に使いやすいCSVへ変換します。
- Review a QuickBooks Desktop export in Excel.
- Clean client IIF data before migration.
- Inspect TRNS and SPL rows for journal entries.
- Extract account, class, item, customer, or vendor lists.
- Prepare a CSV for Xero, Wave, or another import workflow.
- Archive QuickBooks Desktop data as a spreadsheet.
- Compare old accounting records outside QuickBooks.
- Batch convert multiple IIF exports.
IIF versus CSV
IIF is made for QuickBooks import and export. CSV is easier to filter, sort, review, share, and map into other accounting software.
Tips for clean IIF to CSV conversion
Keep context columns on until you finish checking the file.
- Keep table and record type columns on for journal entries.
- Use all-record export for accounts, customers, vendors, classes, and items.
- Use ISO dates for import work.
- Use debit and credit columns for accountant review.
- Keep source row numbers when troubleshooting a rejected IIF file.
- Keep extra fields on when the IIF table is unfamiliar.
- Use the UTF-8 marker if Excel shows broken characters.
Create a clean CSV from QuickBooks IIF
Use this converter when an IIF file needs to become a readable spreadsheet.
Keep the original IIF beside the converted CSV for audit and migration records.
