Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
InnoV
Level 2

Import Excel file to inventory list

Hello,

Since I wasn't able to do Advanced Import under multi-user mode, I uploaded the Excel file by pasting it through Add/Edit Multiple Items. Everything went through nice and easy, but only Qty on Hand cannot be imported. I did have the column of it as well as a column of As of Date. These are new items, so there's no beginning balance on Quickbooks Desktop yet. Thank you for the help in advance.

1 Comment 1
SashaMC
Moderator

Import Excel file to inventory list

Hello InnoV, 

 

Nice to see you in the Quickbooks Community! Just a quick question before we dive in further. When using the Add/Edit Multiple Items, are you using more than four columns? In the meantime, I am adding this video presentation that shows how to import Inventory into QuickBooks Desktop using Add/Edit Multiple Items screen.

 

I will be awaiting your response! Take care for now. 


 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up