cancel
Showing results for 
Search instead for 
Did you mean: 
ClintonPartsLLP
Level 1

Import inventory data

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."

Solved
Best answer December 24, 2018

Best Answers
Rustler
Level 15

Import inventory data

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

View solution in original post

9 Comments 9
Rustler
Level 15

Import inventory data

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

ClintonPartsLLP
Level 1

Import inventory data

Thank you.

Malcolm Ziman
Level 10

Import inventory data


@Rustler wrote:

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


Are you sure? Because in QBO you can import a file with quantities, and adjustment is created if quantity is different

Rustler
Level 15

Import inventory data

yes I am sure

Malcolm Ziman
Level 10

Import inventory data

I am surprised. I'd think it's an easy thing to do. 

Rustler
Level 15

Import inventory data

I prefer it this way, it makes you actually think about what you are doing, just too easy to mess up a spreadsheet for import.  And since you should only be doing this kind of thing periodically throughout the year it is just not that big a deal to me

Anonymous
Not applicable

Import inventory data

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.

 

 

Rustler
Level 15

Import inventory data

[smile]

ok from now on I will caveat my statements with "not without investing in a third party utility"

Fiat Lux - ASIA
Level 15

Import inventory data

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us