Recommended Free Tools
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
QuickBooks can report some IIF import errors, but it cannot guarantee that every bad or incomplete record will be caught. The newer importer in QuickBooks Desktop 2019 and later reports detected failed records; other IIF workflows have limited error checking, and incorrectly formatted data can sometimes import without an error. Back up your company file, review any failed-record report, and verify the imported data in QuickBooks even when the import appears successful.
What IIF is—and why error reporting varies
IIF (Intuit Interchange Format) is a tab-separated text format used to import or export lists and transactions in QuickBooks Desktop. Its structure is exacting: headers identify the record type and fields, and transaction files commonly use !TRNS, !SPL, and !ENDTRNS. Intuit describes creating or adapting IIF files as technically complex. See Intuit’s IIF overview and sample files and its guide to the improved importer.
| Workflow | What Intuit documents | What that means for your check |
|---|---|---|
| General IIF import guidance | Limited error checking; incorrectly formatted data may produce an error or may import incorrectly without one. (Intuit, updated August 4, 2026.) | Do not treat the absence of an error message as confirmation that the records are correct. |
| Improved importer in QuickBooks Desktop 2019 and later | Scans for errors and, when errors are found, reports successful and failed counts and creates an IIF file with failed transactions and error descriptions. (Intuit, updated August 5, 2026.) | Use the failed-record output to diagnose detected validation issues, then still verify what was imported. |
The newer importer’s report is useful, but it does not establish that every accounting inconsistency or incorrect value will be detected. Intuit’s general warning about silent incorrect imports is why a post-import review remains necessary.
Can QuickBooks tell you what went wrong?
In QuickBooks Desktop 2019 and later, when the improved importer detects errors, its result includes counts of successful and failed records and a separate IIF file containing failed transactions with descriptions. Review the entries marked ERROR, correct the corresponding records in the source file, save it, and retry the import. The error output helps identify detected failures; it is not a substitute for checking the resulting company data.
#1 Best Overall
The importer also offers an “Import it for me. I’ll fix it later” option. Intuit says it does not recommend choosing this option because some information may be incorrect or incomplete. If accuracy matters, do not bypass the review.
How to import an IIF file more safely
- Confirm the product and version. This workflow is for QuickBooks Desktop. Identify the version before troubleshooting; do not assume the Desktop IIF procedure applies to QuickBooks Online.
- Back up the company file. Intuit’s IIF instructions call for a backup, and its import/export guidance says an import cannot be undone. Follow Intuit’s IIF import and export instructions before proceeding.
- Start from a suitable example. Where possible, use Intuit’s sample files or import kit rather than building the format from scratch. Preserve the required tab-separated structure and headers that identify record types and fields. The IIF overview explains the headers and provides examples.
- Use the improved importer if your Desktop version is 2019 or later. If it reports that the file was not imported, open the failed-record IIF and read the
ERRORdescriptions. Correct those records and try again. - Check the company file after import. Compare expected and imported totals, names, accounts, dates, and record counts. Check that all intended records are present and that the values landed in the right places. Intuit’s overview specifically advises checking the data carefully for completeness and accuracy.
Which import method fits the data?
IIF is not a universal substitute for every Desktop import route. Intuit’s QuickBooks Desktop data-transfer guide distinguishes among methods:
Rank #2
- Excel or CSV: for general data transfer where the available spreadsheet import supports the data you need.
- IIF: for more complex data structures that fit the IIF format.
- Web Connect (.qbo): for bank transactions.
Choose based on the kind of records you are moving, not simply on which method seems easiest. These formats and workflows are not interchangeable.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →When to get help
If a third-party application created the IIF file, Intuit directs users to that application’s support for help with the file. For a complex or high-volume transfer, consider a qualified QuickBooks Desktop accountant, ProAdvisor, or data-import specialist, particularly when a mistake could affect financial reporting.
Intuit’s 2019 developer-support page says IIF import is not supported in its developer-support context and recommends the QBXML SDK for developer-built Desktop data exchange. That statement is about developer support, not proof that the end-user IIF import feature has disappeared: Intuit’s current user-facing help continues to document IIF imports and the improved importer. See Intuit Developer Support’s IIF guidance.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
