cancel
Showing results for 
Search instead for 
Did you mean: 
A-Galan
Level 1

Inventory Adjustment for different Locations in QBO?

Good afternoon to all!

 

Is there an option in QBO to record inventory and different locations? I'm having issues finding this. We have an E-Commerce business, and we just opened a brick and mortar store.

 

I removed some of my inventory from my "website" and sent it over to the store. I created a different inventory asset account (Store Inventory) and made the inventory Qty adjustment to properly move the items. Now that I'm starting to sell at the store, I don't see a way to affect "Store Inventory" properly. I know for a fact that doing a JE is not appropriate as I won't be affecting Qty or inventory, so I'm kind of lost here.

 

I appreciate any guidance in this matter.

 

Thanks!!!

4 Comments 4
AlcaeusF
Moderator

Inventory Adjustment for different Locations in QBO?

Hi @A-Galan,

 

Welcome to the QuickBooks family. Let me share some clarification about tracking inventory in different locations.

 

Currently, an option or ability to keep track of inventory in multiple locations is unavailable. As a workaround, you can search for a third-party application from the App Center.

 

Some software integrates well with the online version of QuickBooks. Since we're unable to suggest a specific app, I recommend searching for one manually.

 

  1. Log in to your QuickBooks account.
  2. On the left navigation bar, click Apps.
  3. Use the search bar or press Browse category

Also, users have an option to add class and category directly to the products and services. However, in QBO, there are basic inventory reports available only:

 

  • Inventory Valuation Detail Report
  • Inventory Valuation Summary Report

As of now, both of these reports can't run by class or category. Another method is to separate the inventory by creating a new one, but I suggest seeking expert advice from an accountant. This way, we'll be able to ensure that your books stay accurate and error-free. 

 

For additional reaference, I've attached a link you can use about how to use reports to view your sales and inventory status in QuickBooks: Use reports to see your sales and inventory status.

 

Leave a comment below if you have other concerns about your inventory. The Community and I will be around to help you.

Fiat Lux - ASIA
Level 15

Inventory Adjustment for different Locations in QBO?

@A-Galan 

You need a 3rd party app to do so.

 

A-Galan
Level 1

Inventory Adjustment for different Locations in QBO?

Thank you!

 

Any App suggestions?

Fiat Lux - ASIA
Level 15

Inventory Adjustment for different Locations in QBO?

@A-Galan 

Company has acquired an inventory management app recently to integrate with QBO.

https://go.tradegecko.com/register?code=fiat-lux

 

You may compare it to another app.

https://www.zaperp.com/ref/25/

 

Need to get in touch?

Contact us