cancel
Showing results for 
Search instead for 
Did you mean: 
marikosakoda
Level 2

How does QBO determine the Initial Cost on inventory

I'm trying to find information on how QBO determines the initial costs of inventory.

I began tracking inventory on 7/1/23. Some products were entered with 0 starting initial quantity on hand, because we were out of the product. I have since restocked the product several times, entering an expense reflecting the purchase quantity and amount.

 

When I pull up the Purchases by Product/Service Detail report I noticed some products with a 0 starting initial quantity on hand now how a rate/cost by it, and some do not. Some products with a positive starting initial quantity on hand also have a rate/cost by it (I can't remember if I entered the initial cost or not).

 

Does QBO generate the initial rate/cost based on the expense purchase amount? Or does it always need to be entered manually?

 

Thank you in advance!

Solved
Best answer June 27, 2024

Best Answers
MichaelaS
QuickBooks Team

How does QBO determine the Initial Cost on inventory

Let me add details to your queries, @marikosakoda.

 

Yes, that's correct. If your quantity on hand is zero, and you input a quantity manually on any purchase transactions, it will track automatically.

 

On the other hand, if you have an actual quantity of your items on hand, you can enter the beginning quantity. Just make sure to add the correct as-of-date for accurate tracking. After that, the initial cost will show immediately and reflect on your inventory asset account.

 

Additionally, here's an article you can check to pull up the status of your inventory: Use reports to see your sales and inventory status.

 

Keep us posted if you have other questions about managing inventory. I'm always here to help. Have a nice day.

View solution in original post

5 Comments 5
Clark_B
QuickBooks Team

How does QBO determine the Initial Cost on inventory

I've got you covered, Mariko.

 

I have information regarding the initial cost on inventory in QuickBooks Online (QBO).

 

To begin with, QuickBooks uses the weighted average cost to determine the value of your inventory and the cost of goods sold (COGS) when you sell inventory. The average cost is calculated by adding up the cost of all items in inventory and then dividing that total by the number of items. For further details, you can refer to this article: Understand inventory assets and cost of goods sold tracking

 

On the other hand, QBO will not generate the initial rate/cost based on the expense purchase amount. If you haven't manually entered the cost for certain products, they will still have rates in your Purchases by Product/Service Detail report as QBO will assume a rate for these items based on the transactions created, even if no cost was manually entered.

 

I'll also add this article to help you get the most out of your financial reports: Customize reports

 

In case you have any follow-up questions regarding the initial cost on inventory or anything else related to QuickBooks, feel free to ask me. I'm always here to help you, Mariko. Take care!

marikosakoda
Level 2

How does QBO determine the Initial Cost on inventory

Thank you for the clarification @Clark_B!

Good to know that the cost will be generated in the Purchases by Product/Services Detail report even if I don't manually enter the initial rate/cost. 

 

Please correct me if I'm wrong, but I thought QBO used FIFO  to determine the value of inventory and COGS, not weighted average. Article: What is FIFO and how is it used for inventory cost accounting?

ErwinQ
QuickBooks Team

How does QBO determine the Initial Cost on inventory

Hello there, @marikosakoda. Allow me to clarify about the costing method in QuickBooks Online (QBO).

 

The initial cost and quantity of the item are determined by the purchased amount. Entering this information during the initial setup of the item will result in an incorrect value in the inventory asset account.

 

Yes, you're right, QBO uses FIFO (First In, First Out) to calculate the value of inventory and will adjust your assets and Cost of Goods Sold (COGS) accordingly whenever sales of inventory items are entered. The weighted average is only applicable to QuickBooks Desktop (QBDT).

 

You can visit these resources as a guide to managing your inventory effectively:
 

 

Please know that you can always return here to the Community, if you have more questions related to inventory in QBO. I'm here to help you out. Have a great day.

marikosakoda
Level 2

How does QBO determine the Initial Cost on inventory

Thank you for clearing that up @ErwinQ!

 

Just to make sure I understand initial costs:

If I start with 0 quantity on hand, do not enter the initial cost or quantity. The purchase expense will take care of this.

If I start with say 2 quantity on hand, is it correct enter the initial cost and quantity?

MichaelaS
QuickBooks Team

How does QBO determine the Initial Cost on inventory

Let me add details to your queries, @marikosakoda.

 

Yes, that's correct. If your quantity on hand is zero, and you input a quantity manually on any purchase transactions, it will track automatically.

 

On the other hand, if you have an actual quantity of your items on hand, you can enter the beginning quantity. Just make sure to add the correct as-of-date for accurate tracking. After that, the initial cost will show immediately and reflect on your inventory asset account.

 

Additionally, here's an article you can check to pull up the status of your inventory: Use reports to see your sales and inventory status.

 

Keep us posted if you have other questions about managing inventory. I'm always here to help. Have a nice day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us