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
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
ConfusedGuy
April 19, 2022
Question

Inventory OH and Quick Report not matching

  • April 19, 2022
  • 9 replies
  • 53 views

Under our inventory item list a part shows 21k OH. 

 

When we run the Inventory Item Quick Report, the OH shows 5,600.

 

A receiving we did yesterday is not showing up on the report, part ordered, paid by check. 

 

All other receiving's are showing for the year. 

9 replies

Rustler
Rustler
Level 15
April 19, 2022

QB listing can be weird at times, give it a minute or two and if it still does not update, close and reopen QB

 

Also check the dates too, set the quick report to ALL dates and refresh

    Kurt_MQuickBooks Team
    QuickBooks Team
    April 19, 2022

    I'm pleased to have you here in the Community today, @ConfusedGuy. I'd be glad to provide information about why OH, and the Quick report doesn't match sometimes.

     

    If you have a specific number of items in your inventory, you'll also have to adjust the scope of the report you're going to generate for them to match with your inventory numbers. To have the correct figures appear in your report, set the reporting period to All Dates.

     

    Other possible reasons why you're on hand inventory doesn't match your Quick report Data:

     

    • Non-posting transactions are listed on the Quick Report.
    • Transaction include different unites of measure.

     

    You can also utilize the Filter feature when running a report to avoid these situations.

     

    Additionally, I've got you these handy articles for future reference:

     

     

    I'd like you to know that you can always get back to me if you need further assistance matching your on-hand inventory numbers to your Quick report. I'll keep an eye on your response. Keep safe, and have a great day!

    Jayson_EQuickBooks Team
    QuickBooks Team
    March 27, 2025

    I'm having the opposite issue. I just discovered that, when in the item list, the Quantity on Hand number for some items is incorrect. If I do a quick report on the item, it shows the correct number. For example, one item had a vendor credit that reduced the quantity on hand. This is reflected correctly in the Quick Report of the item, but it is not reflected in the Quantity on Hand column of the Item List. It is also reflected incorrectly on the Physical Inventory Worksheet, which makes no sense and is obviously very problematic. I also just removed an item from a vendor bill that was on there by mistake. The Quantity on Hand for that item in the Item List is still showing the quantity that was on the invoice! The quick report of that item has the correct number. What on earth is going on here? If anyone has any ideas, I would really appreciate some help. I am the admin and have all the permissions and access. All of the dates are correct.


    Hi there, numbersby. 

    It seems you've posted twice in the Community forum about your concerns with the Quality on Hand number for inventory items in QuickBooks Desktop (QBDT), which my colleague Ivan_G already answered. 

     

    You can take a look at his suggested solution here: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-qb-enterprise-inventory-numbers-not-matching-up/01/1539406/highlight/true#M234725.
     
    Your satisfaction is our top concern. If you have any more questions or require additional help, please feel free to reach out the Community forum. We're here to help you!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement