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

can you create a report of inventory on hand by location ?

can you create a report of inventory on hand by location ?

2 Comments
Highlighted
QuickBooks Team

can you create a report of inventory on hand by location ?

A pleasant morning, peter46.

 

While we're unable to create a report that will show inventory on hand by location, there are several statements you can see your sales and inventory status.

 

QuickBooks Online allows you to check what's in stock using these reports:

 

  • Inventory Valuation Summary: The quantity on hand, value, and the average cost for each product.
  • Inventory Valuation Detail: Your transactions for each inventory item, and how they affect quantity on hand, value, and cost.
  • Physical Inventory Worksheet: Your inventory items with space to enter your physical count, so you can compare to the quantity on hand in QuickBooks.

Check out the Use reports to see your sales and inventory status page to learn how to see items you buy and sell including what's on hand.

 

You can also pull up the Product/Service List report to see your items with the sales price, name, description, and quantity on hand.

 

Here's how to open a report you want:

  1. Go to the Reports from the left navigation bar.
  2. Open a statement you want to view.
  3. Customize it depending on your needs.

Let me know if you have follow-up questions, and I'm always around to help you out.

Highlighted
Level 15

can you create a report of inventory on hand by location ?

No, because there is no multiple location tracking in QBO

 

Location is a reporting tag only, reporting on transactions

Need to get in touch?

Contact us