Can QuickBooks Desktop import an IIF file to adjust inventory quantities (Inventory Adjustment)?

You need to use an importer tool to do so. You can prepare your data with the following template

then purchase TP Importer to proceed. It's a $199 one time license.

https://get.transactionpro.com/qbd

If your company is located in the US, you can get the license for free from a partner. Contact @Fiat Lux - ASIA via email directly for details.

Hey there, @justin00195.

How are you doing today? I hope all is well. 

With QuickBooks Desktop you can bulk edit your lists, including your inventory via .IIF files. Here's how:

1. Export the lists to your desktop.
   1. Go to the QuickBooks File menu, select Utilities then Export and then IIF Files.
   2. Select the checkbox corresponding to the list/s you want to export then click OK.
   3. Type a file name and choose the location where you want to save the IIF file.
2. Open the file and edit data as desired.
   1. Right-click the export file. Select Open With and select Microsoft Office Excel.
   2. Click Yes if a warning about incompatible features is displayed.
   3. Edit the data in the file then select File and then Save.
   4. Close Excel. (If prompted to save again, click No.)
3. Backup your company data file because imports cannot be undone.
4. Import the edited IIF file to QuickBooks
   1. Go to the QuickBooks File menu,  select Utilities then Import and then .IIF Files.
   2. Locate the edited IIF file then select Open.

On another note, you can also adjust the inventory in bulk within the program without needing to use the .IIF file. (Please make sure you backup your company file before making any changes to the inventory).

First, you’ll need to create an adjustment account to track your adjustments, if you haven't already.

Here's how:

1. Select Company from the menu, then choose Chart of Accounts.
2. Click on the Account dropdown, then tap New.
3. In the Other Account Types dropdown, select Cost of Goods Sold.
4. Name this account "Inventory Adjustments," then hit Save and Close.

Next, proceed to adjust a product's quantity, value, or both:

Here's how:

1. Go to Inventory, then select Adjust Quantity/Value on Hand.
2. In the Adjustment Type dropdown, select Quantity, Total Value, or Quantity and Total Value.
3. Choose your adjustment account and enter the adjustment date.
4. In the Adjust Account field, select the account you set up earlier.
5. Add a reference number.
6. Select Find & Select Items and choose the items you want to adjust.
7. Click Add Selected Items.
8. Add the new quantity or new value for each item.
9. Hit Save and Close.

For more information about using these actions, check out the help articles I'm including below:

• IIF Overview: import kit, sample files and headers
• Tasks you can do with IIF files
• Adjust your inventory quantity or value in QuickBooks Desktop

That should do the trick. Please let me know if you have any additional questions or concerns. I'm happy to lend a hand. Take care! 

HI Tori,

I am doing good.

Thanks for your answer. I did follow your instruction, export .iif file(item List) and edit the QNTY (such as before was 60, I changed to 40). 
However, When I import iif back to Quickbook Desktop, There is no changes for Quantity. 

Is there any step I did wrong?

For second option. its not Capable since I have plenty of items want to edit.

Thanks!

Hi Tori,

I am doing good.

I did follow first option. Export IIF file (item list), edit QNTY (ex: before was 60, change to 40). then select File and then Save.

However, When I import back to Quickbook. It still not change for my quantity on hand.

For option 2 is not suitable for me since I have plenty of items want to edit.

Best Regards.

It sounds like you’ve already put significant effort into making the quantity updates, especially given the size of your inventory, and I understand that option 2 may not be suitable for your needs, justin00195.

I suggest using a third-party app to import an IIF file for adjusting inventory quantities. Visit the QuickBooks Desktop (QBDT) App store and search for importing an IIF file to explore available options.

Please let us know if you have any additional questions or concerns.

Yes, QuickBooks can import inventory adjustments for quantity adjustments, value adjustments, or both.

You can use our BRC IIF Transaction Creator Pro to do it, or at least use it to figure out the IIF file format for these transactions. It can be download in trial mode - no charge. You might even like using it instead of writing your own IIF files, which can be rather complicated.

Yes Quick Books Desktop still supports importing . I IF files for inventory adjustments, but with a few important details to keep in mind.

I IF imports can update inventory quantities through the Inventory Adjustment transaction type; however, Intuit has deprecated some legacy I IF structures, so you’ll need to ensure your file is formatted correctly using the latest  I IF import standards. It’s always best to test on a backup company file first, since I IF imports bypass some data validation.