Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
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