Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 25, 2020
Solved

Inventory Costing (FIFO vs Average Cost)

  • February 25, 2020
  • 11 replies
  • 62 views

When setting up a new company, we selected the FIFO inventory costing option, but Quickbooks seems to be costing items using the Average costing.  Is there something else we need to click to have QB cost items using FIFO?

 

Quickbooks is also using Average costing

Best answer by Mark_R

Hello there, @BernieJ.

 

You'll want to make sure that the starting date of the FIFO is prior to the transaction dates. Let me provide additional information about Average Costing vs FIFO.

 

QuickBooks will depend on the start date you've selected when switching to FIFO. Those items used before the start date of the FIFO will fall under the Average Costing.

 

Any existing balances of items on hand at the date that FIFO is enabled are placed into one costing layer. Also, please know that the report only includes balances and transactions from the date of when FIFO began.

 

For additional information, feel free to check out these articles:

 

You might also want to read this article to know how QuickBooks tracks inventory: Understand inventory assets and cost of goods sold tracking.

 

Please know that you can always get back to here in the Community if you have any other questions. I'll be standing by for your response. Have a great day.

11 replies

Mark_RModeratorAnswer
Moderator
February 25, 2020

Hello there, @BernieJ.

 

You'll want to make sure that the starting date of the FIFO is prior to the transaction dates. Let me provide additional information about Average Costing vs FIFO.

 

QuickBooks will depend on the start date you've selected when switching to FIFO. Those items used before the start date of the FIFO will fall under the Average Costing.

 

Any existing balances of items on hand at the date that FIFO is enabled are placed into one costing layer. Also, please know that the report only includes balances and transactions from the date of when FIFO began.

 

For additional information, feel free to check out these articles:

 

You might also want to read this article to know how QuickBooks tracks inventory: Understand inventory assets and cost of goods sold tracking.

 

Please know that you can always get back to here in the Community if you have any other questions. I'll be standing by for your response. Have a great day.

April 6, 2021

Hi, is it possible to adjust the FIFO date back to the start of the company file and have the FIFO accounting run forward for items assembled and sold? A support rep told me it was and after refreshing the file I see some costs changed but not the ones in future periods I had anticipated. Please help

Level 1
February 8, 2024

I use the average weight for the stock inventory in Quickbook Enterprise 2018, but I recently noticed that the balance has been off for the last three months. What need I do to fix this error?


Thank you for joining this thread, kikoA.

 

I'm here to help you balance your stock inventory.

 

First, let's run an Inventory Valuation Summary report to double-check all the transactions that may have caused the balance to go off.

 

Here's how:

  1. Select Reports, then select Inventory.
  2. Select Inventory Valuation Summary, then set the dates to All.

 

If the transactions show a negative, you may refer to this article:  Fix negative inventory issues in QuickBooks Desktop

 

It's possible, too, that you need to adjust your inventory quantity or value in QuickBooks Desktop.

 

Keep us updated in the comments if you have further questions about your inventory in QuickBooks Desktop. We're just a reply away. Keep safe, and have a good day.