cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

QBO inventory starting / opening quantity

I imported my products (inventory) with zero qty as I did not have final stock on hand figures and wanted to start using the system.  I have since done invoices, which puts my Inventory Asset account into negative and now want to enter my starting stock qty, I know how to do this one by one but I have three pages of stock items - is there anyway to do this as an import ? I think (?) it must be starting stock and not an inventory adjustment. The start date of inventory seems to be a factor vs invoice date.

Thanks

Solved
Best answer January 22, 2020

Best Answers
Highlighted
QuickBooks Team

QBO inventory starting / opening quantity

You can re-import the inventory file that you previously used, NicoleZimbo.

 

Just make sure to enter the updated Quantity on hand and Quantity as-of Date details. Then, check the Overwrite all values for each product or service that you import with the identical name box when importing the file so it will not create duplicate items.

 

Quickbooks will also automatically adjust the Quantity on hand as long as the invoice date is after the starting date of the inventory. You might want to do it first on one or two items for you to see how it affects your Inventory Asset account and Quantity on hand in QBO once imported. 

 

You can also bookmark or save these articles and video guides in case you might need them in the future:

 

Tap on us again or ask another question if you need more help with the products that you're selling.

 

 

View solution in original post

3 Comments
Highlighted
QuickBooks Team

QBO inventory starting / opening quantity

You can re-import the inventory file that you previously used, NicoleZimbo.

 

Just make sure to enter the updated Quantity on hand and Quantity as-of Date details. Then, check the Overwrite all values for each product or service that you import with the identical name box when importing the file so it will not create duplicate items.

 

Quickbooks will also automatically adjust the Quantity on hand as long as the invoice date is after the starting date of the inventory. You might want to do it first on one or two items for you to see how it affects your Inventory Asset account and Quantity on hand in QBO once imported. 

 

You can also bookmark or save these articles and video guides in case you might need them in the future:

 

Tap on us again or ask another question if you need more help with the products that you're selling.

 

 

View solution in original post

Highlighted
Level 2

QBO inventory starting / opening quantity

Can this method be used to import beginning quantities for multiple site locations?  We have 5 different site locations setup in Quickbooks Enterprise and are looking to import beginning quantities for each location.

 

Thank you,

Bernie

Highlighted
Level 14

QBO inventory starting / opening quantity

@BernieJ 

Utilize the importer tool for QB Desktop. It will query the advanced inventory settings to determine what fields to add to the Importer mapping screen

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Need to get in touch?

Contact us