Other questions

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!