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.
Step 1
Upload one or more QuickBooks IIF files.
Step 2
Check records, TRNS rows, SPL rows, tables, totals, and warnings.
Step 3
Choose date format and amount layout.
Step 4
Keep account type, class, memo, document number, item data, source row, and extra fields when needed.
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.
