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

Inventory Management

How do you address changes in costs for inventory items?  Say that I purchased 5 light bulbs at a cost of $3.00, so the value was $15.00.  I sold 3, and ordered 5 more so that I didn't run out, but now the cost of the light bulbs is $4.00.  Now I have 2 @ $3.00, and 4 @ $4.00, so I have a total value of $22.  However, when I update the product, the value is $24.  Is this just not something that QBO can handle?  I did not have this problem when working with QB Desktop.  Thanks!

Solved
Best answer April 07, 2023

Best Answers
SashaMC
Moderator

Inventory Management

Good afternoon m_seale,

 

Thanks for reaching out to the Community. With QuickBooks Online, the process is automatic. Therefore, you will need to enter the new cost on the vendor bill instead of updating the item itself.

 

Let me know if you have any other questions! I will be around. Bye for now. 

 

View solution in original post

5 Comments 5
ChristieAnn
QuickBooks Team

Inventory Management

Hi there, m_seale.

 

Thank you for visiting the QuickBooks Community. I'll be sharing steps to ensure you can view the correct total value of your inventory in QuickBooks Online.

 

The $24 total value will appear on your end if you created a purchase of 5 light bulbs at a cost of $3.00 and make a bill of 3 items at a cost of $3.00. Then, created again a purchased order of 5pcs. If that's the case the $24 will normally show in QuickBooks Online.

 

 

However, if you want to show the correct total value of the light bulbs, I suggest creating a purchase order of 5 light bulbs at a cost of $3.00. Then, make a bill for the said transaction and create an invoice for the sold 3 items you've mentioned.

 

Here's how:

 

  1. Select + New, then choose Purchase order.
  2. From the Vendor dropdown, select the vendor.
  3. Enter the Purchase Order date.
  4. Go to the Item details section and choose the light bulbs as the product name and enter 5 in the QTY field and $3.00 as an amount.
  5. Fill in the other needed information.
  6. Click Save and close.

 

Once done, create a bill for the purchased order you've created above to pay the entry.

 

After that, make an invoice for the sold 3 items in QuickBooks. Please follow the steps below:

 

  1. Select + New and select Invoice.
  2. Select Add customer and choose a customer from the ▼ dropdown. 
  3. Review the Invoice dateDue date, and Terms. Enter new dates or terms, if you need to. Tip: In the Terms field, Net refers to the number of days until the payment is due. 
  4. Choose light bulbs as a product or service and select a product or service from the ▼ dropdown.
  5. Enter the 3 as QTY and the amount.
  6. Click Save.

 

Once done, create again a purchase order for the ordered 5 more you've shared in your statement. Then, run the Inventory Valuation Detail report to see the correct total value. This way, you can now view the correct data of your inventory. Please know that if the last purchased order is 4 pcs at a cost of $4.00, the $22 will appear in your QuickBooks after following the steps above.

 

 

Furthermore, you can open this article to see information on how inventory transactions work in QuickBooks: Understand inventory assets and cost of goods sold tracking.

 

You can add a comment below if you still have concerns related to QuickBooks. I'm always around to help.

m_seale
Level 2

Inventory Management

Thank you for the explanation.  This works in Desktop, but not in Online.  QBO does not have a FIFO option, unless I missed that. 

Rubielyn_J
QuickBooks Team

Inventory Management

We appreciate your return to this discussion, @m_seale.

 

In QuickBooks Online, the FIFO option is available. The software will always regard the initial purchase (First In) as the initial sale (First Out). Every time sales of inventory items are recorded, this will adjust your assets and Cost of Goods Sold (COGS) accordingly.

 

You can also read this piece for additional information: What is FIFO, and how is it used for inventory cost accounting? It also includes an idea of how to modify the cost and initial quantity of an item.

 

To help you monitor and manage inventory in QuickBooks, I've gathered a few articles that you can read through:

 

 

If you have any questions regarding FIFO in QBO, please let me know. I'll always be available to assist. Have a great day!

m_seale
Level 2

Inventory Management

Thank you!  It was my understanding that QBO did not use FIFO.  So, when I receive the second batch of items at a new higher cost, should I update the item in "products & services", or should I only enter the new cost on the vendor bill paying for the items? 

SashaMC
Moderator

Inventory Management

Good afternoon m_seale,

 

Thanks for reaching out to the Community. With QuickBooks Online, the process is automatic. Therefore, you will need to enter the new cost on the vendor bill instead of updating the item itself.

 

Let me know if you have any other questions! I will be around. Bye for now. 

 

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

Need to get in touch?

Contact us