Convert DES to IIF

Understanding DES and IIF file formats

DES files are typically associated with QuickBooks Layout Designer or embroidery design software, containing layout or design data. On the other hand, IIF (Intuit Interchange Format) files are text-based files used by QuickBooks for importing and exporting financial data such as transactions, lists, and other accounting information.

Why convert DES to IIF?

Converting a DES file to IIF is usually required when you need to transfer design or layout data into QuickBooks for accounting or record-keeping purposes. This process is not straightforward, as the formats serve different purposes, and a direct conversion is rarely supported natively.

How to convert DES to IIF

Since DES and IIF files are fundamentally different, conversion typically involves exporting the relevant data from the DES file into a format that can be mapped to IIF fields. This may require manual data extraction or the use of intermediary formats like CSV.

1. Export data from DES: If your DES file is from QuickBooks Layout Designer, open it in the software and export the data to a CSV or TXT file if possible. For embroidery DES files, use the software's export or save-as function to get a readable format.
2. Format data for IIF: Open the exported file in a spreadsheet editor (like Microsoft Excel). Arrange the columns to match the IIF format required by QuickBooks (e.g., headers like NAME, TYPE, AMOUNT).
3. Save as IIF: Save or export the file as a tab-delimited text file. Change the file extension to .iif.

Best software for DES to IIF conversion

The conversion is best handled with a combination of tools:

• Microsoft Excel or Google Sheets for editing and formatting data.
• QuickBooks for importing the final IIF file.
• For embroidery DES files, use Wilcom Embroidery Studio or TruEmbroidery to export data.

There are no direct online converters for DES to IIF due to the specialized nature of these formats. Manual mapping and formatting are usually required.

Step-by-step example using Excel

1. Open your DES file in the appropriate software and export to CSV.
2. Open the CSV in Excel.
3. Arrange columns to match IIF requirements (refer to QuickBooks IIF import kit for templates).
4. Go to File → Save As and select Text (Tab delimited) (*.txt).
5. Rename the file extension from .txt to .iif.
6. Import the IIF file into QuickBooks via File → Utilities → Import → IIF Files.

Conclusion

While there is no direct DES to IIF converter, using spreadsheet software to manually map and format your data is the most reliable method. Always back up your QuickBooks data before importing IIF files to prevent data loss.