Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 15, 2025
Question

Invoice Qty versus Inventory Valuation Detail Qty

  • July 15, 2025
  • 1 reply
  • 2 views

My inventory valuation detail report always splits some items and not on others and I can't figure out why or how to turn it off.  

 

For example,

 

I sold 28 units to a customer today, but on the Inventory Valuation Detail it shows 13 and 15 units, same invoice number.  I cant figure out why it does it to some customers and not others.  I have attached a picture of a few so you can see what I mean.  One customer is showing 18 sold, then the next should show 28 but instead it splits it for some reason.  Any guidance would be appreciated.

 

1 reply

QuickBooks Team
July 15, 2025

The way the quantity (Qty) is displayed in the Inventory Valuation Detail report is based on QuickBooks Online First In, First Out (FIFO) inventory costing method, Renee.

 

Firstly, I want to thank you for providing detailed information as well as a screenshot.

 

FIFO means that the oldest inventory you purchased is assumed to sell first, and newer inventory remains in stock.

 

When you restock a stock item, QuickBooks will first deduct the items that were already in stock, followed by the recently acquired items. This is the reason why your report is displaying a split.

 

Thus , QuickBooks is designed to operate this way, ensuring accurate inventory tracking, and there isn’t an option to change this setting.

 

For more details about FIFO and its impact on inventory tracking, check out the article: What is FIFO and how is it used for inventory cost accounting.

 

We offer personalized assistance to streamline your bookkeeping, enabling you to focus on business development. Our QuickBooks Live Expert Assisted team can help automate tasks, categorize transactions, reconcile accounts, and generate financial reports.

 

If you have any additional questions, feel free to reach out.