تبدیل IIF به CSV بدون QuickBooks، بدون نصب نرم افزار و بدون ثبت نام. خروجی transactions، journal entries، accounts، classes، items و lists برای Excel.
فایل IIF در QuickBooks Desktop برای خروجی گرفتن خوب است، اما خواندن آن در Excel آسان نیست. این ابزار IIF to CSV ردیف های TRNS و SPL، حساب، کلاس، memo و item را به جدول قابل بررسی تبدیل می کند.
IIF file
IIF مخفف Intuit Interchange Format است. QuickBooks Desktop از آن برای accounts، customers، vendors، items، invoices، payments، checks، deposits و journal entries استفاده می کند.
Why this IIF to CSV converter
این ابزار header های IIF را می خواند، transaction و split را حفظ می کند، all records را خروجی می دهد و CSV سازگار با Excel می سازد.
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.
