Skip to main content
February 25, 2020
Solved

Inventory Costing (FIFO vs Average Cost)

  • February 25, 2020
  • 1 reply
  • 0 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.

1 reply

Mark_RAnswer
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.

BernieJAuthor
February 26, 2020

Hi Mark,

Yes, I understand FIFO costing versus Average costing in principle.  I'm having a hard time figuring out what Quickbooks is doing and I'm thinking there may be a setup item I don't have set correctly.  I set the FIFO date as 01/01/2020.  

 

When I build an assembly (with a 02/24/2020 date) using inventory items, the new Inventory Assembly Screen will accumulate the cost of the assembly based on the costs of the items used in the assembly.   However, when I use or view the new assembly that is built, is shows an average cost which is what is posting to inventory/COGS.

 

 

 

BernieJAuthor
February 26, 2020

I tried to do a screenshot to show you what I mean, but since we are using Quickbooks Enterprise via cloud-hosting I cannot take a screenshot.  Below is what I see on the Inventory Summary for one of the Assembly Items...

 

Assembly Item:  R-Timmons-Stock

 

    Calculated Average Cost:  63.32

Cost:  141.20

Sales Price:  141.20