Inventory quantities and dates on invoices

snsmile · ‎January 02, 2024

If I enter an invoice dated Dec 31 for a customer that gets invoiced monthly, but take physical inventory on Dec 30, will the quantity on hand include all items on all invoices including the Dec 31 invoice? Or will I need to add back into my Dec 30 physical inventory the items from the Dec 31 invoice for an accurate count? I thought inventory on hand went by date, but recently discovered that it seems like it instead reads all invoices, even those in the future for an accurate count. Anyone else figure this out?

Rainflurry · ‎January 02, 2024

@snsmile

It depends on which report you're using for inventory. If you're using the Physical Inventory Worksheet, the items will be removed when the invoice is created, regardless of the date of the invoice. If you're using the Inventory Valuation Detail or Inventory Valuation Summary reports, the items will be removed as of the invoice date, not the date the invoice was created.

View solution in original post

ZackE · ‎January 02, 2024

Thanks for getting in touch with the Community, snsmile. I appreciate your detailed information.

When an invoice is created in QuickBooks, the amount on hand for each inventory product included on your invoice is decreased by the amount you specified on your sales form.

What you're seeing is the accurate count for your quantity on hand amount. The product is taken out of your inventory when the invoice is created.

You can learn more about tracking inventory in our Set up & track your inventory article.

Please don't hesitate to send a reply if there's any additional questions. Have a great Tuesday!

Rainflurry · ‎January 02, 2024

@snsmile

It depends on which report you're using for inventory. If you're using the Physical Inventory Worksheet, the items will be removed when the invoice is created, regardless of the date of the invoice. If you're using the Inventory Valuation Detail or Inventory Valuation Summary reports, the items will be removed as of the invoice date, not the date the invoice was created.

snsmile · ‎January 02, 2024

This was exactly what I was looking for. Thanks!

AlcaeusF · ‎January 11, 2024

Hello Rainflurry,

Thank you for sharing your input to help address the issue. We love to see members supporting one another. Have a great day.

Topics

Training

Community

Resources

Inventory quantities and dates on invoices