I've edited an IIF Item List for New Company. All has imported correctly except it won't accept my edits in the Quantity on Hand Column.

Hello there, @Flood9.

I'd be glad to guide you in the right direction to help you with importing items to a new company file.

One of the possible reasons why they don't accept the edit in the Quantity on hand column is because there are changes from the original list, mapping of accounts will be definitely affected during the financial exchange. To import correctly, you'll need to review the Quantity you enter before importing again.

Also here are some articles that you can refer to learn more about importing files in QuickBooks Desktop:

• How to Import and Export IIF files in QBDT?.
• What to do if IIF files were not imported in QBDT?.

I'll be around in the Community to help if you have more questions with importing in QBDT. Stay safe

To do the mapping, do I need to import it in an Excel format?  Don't see that as an option in IIF?  All other columns are importing fine.

Hello Flood9, 

We can open an IIF file into Excel. Then, we can edit your item list from there before importing it to QuickBooks Desktop. Here's how to do it:

1. Open your Excel, go to File, and select Open.
2. Browse to your IIF file, select it, and click Open.
3. In the Text Import Wizard, select Next, then Next and Finish.
4. Make the changes to your IIF file. Go to the File menu and select Save.
5. Select Yes. Close Excel. You'll get a prompt to save the IIF again. Select Don't Save.

You can follow the steps in this article on how to export, import, and edit IIF files.

Also, we can do a batch edit if you have imported your items already. Please follow these steps:

1. Go to the Lists menu and select Add/Edit Multiple List Entries.
2. From the List drop-down, select item type (Inventory Parts or Inventory Assemblies).
3. Locate the Qty On Hand column and make the changes.
4. Click Save Changes.

Please post again here if you need anything else. Stay safe and healthy!