Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
galaxypopsandbey
Level 1

If I’m using the inventory management with QuickBooks does it keep the coast average of my inventory ex I buy 1 thing for $5 and then I buy another at $4 will it at $4.58

Also do I receive my inventory in qb or Shopify? If it’s in QB will it have all my categories so it goes to the correct spot?
2 Comments 2
4Gal
Level 11

If I’m using the inventory management with QuickBooks does it keep the coast average of my inventory ex I buy 1 thing for $5 and then I buy another at $4 will it at $4.58

As I know QB Online uses FIFO. If you prefer to use Average Cost, consider having a third-party inventory management app to sync with QBO or switching to QB Desktop Pro/Premier.

Jelayca V
QuickBooks Team

If I’m using the inventory management with QuickBooks does it keep the coast average of my inventory ex I buy 1 thing for $5 and then I buy another at $4 will it at $4.58

Thank you for reaching out to us, galaxy. I appreciate your questions regarding inventory management and how QuickBooks handles inventory costs. Let me share some insights regarding the matter at hand.

 

QuickBooks Online (QBO) always considers the first units purchased (First In) to be the first units sold (First Out) and will adjust your assets and Cost of Goods Sold accordingly whenever sales inventory items are entered. Keeping the cost average of your inventory will need an inventory management app to sync with QBO, as 4Gal said.

 

Since receiving your inventory will depend on the inventory management app you're considering, may I kindly inquire about the name of the app?

 

In response to your second question, when you receive inventory, it can be recorded in both QuickBooks and Shopify. However, please note that QuickBooks cannot automatically retrieve detailed inventory information such as the inventory levels, cost prices, and tax details from Shopify, and sync this information with QBO products.

 

Furthermore, inventory management occurs within QuickBooks to ensure accurate tracking and reporting. So, when setting up an inventory item in QuickBooks, and assigning it to a specific account or category, QuickBooks will automatically place it in the designated spot based on your configuration. This ensures that your inventory is organized correctly.

 

For reference, you can also look into these articles on how to manage inventory:

 

 

Feel free to drop a comment below if you have other managing inventory in QBO. I'll be right here to help you out. Have a great day!

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

Need to get in touch?

Contact us