Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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!
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?
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).
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.
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?
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here