cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

Reversing Inventory Adjustments with Importing and Exporting in Excel

Are you able to do mass inventory adjustment that include Quantity and Value by importing and exporting with Excel?  

2 Comments
Highlighted
QuickBooks Team

Re: Reversing Inventory Adjustments with Importing and Exporting in Excel

Hello 12313,

 

Welcome to the Community. It would be my pleasure to answer any questions you may have with creating inventory adjustments in QuickBooks Desktop.

 

The ability to make adjustments to the quantity and value of the inventory items are only available within the QuickBooks program. Right now, importing  and exporting adjustments with Excel is currently unavailable.

 

For additional insight into adjusting inventory quantity or value, such as the available options, I'm adding the article that I recommend:

 

Adjust inventory quantity or value.

 

Please know I'm always available here whenever you need further assistance with inventory adjustment. You can keep in touch with the Community anytime.

BRC
Established Community Backer ***

Re: Reversing Inventory Adjustments with Importing and Exporting in Excel

Yes, you can import inventory adjustments, but not directly from Excel. Instead they can be imported as IIF files.

 

Use the BRC IIF Transaction Creator Pro  to help you import inventory adjustments (and most other types of transactions.)  As when recording them manually, the adjustments can be Qty only, Cost only, or both Qty and Cost adjustments.