Import inventory data

Forum|Forum|7 years ago
December 23, 2018
3 replies
5 views

I want to 'update' my inventory -- I specifically want to import an Excel file (or similar) to load in the values from a year-end physical inventory. Is there a way? What I've seen so far say, "No."

QuickBooks Desktop

Best answer by Rustler

Unfortunately the No answer you found is the correct one. you can not import an adjustment

RustlerAnswer

Level 15

Unfortunately the No answer you found is the correct one. you can not import an adjustment

ClintonPartsLLPAuthor

Thank you.

Anonymous

You can import inventory adjustment transactions. One way using an IIF file created by our BRC IIF Transaction Creator Pro

Note that you do need to calculate the adjustment you want to import, as there is no way to import something that will automatically adjust the inventory to a specific qty.