Your inventory management and purchasing departments will find the "Inventory Stock Status Report" to be quite helpful.
Easily accessed by clicking on Reports > Inventory > Inventory Stock Status by Item (a Stock Status by Vendor report is also available), you can pull up a report that looks like this:
This report contains the following facts and figures:
- Part number
- Preferred vendor
- Reorder point
- On hand quantity
- On sales orders
- Reserved for assemblies
- Quantity available
- Reorder flag
- Quantity on purchase orders
- Next expected delivery date (from purchase orders)
- Average sales/week of the item
REMEMBER: You can double-click on any value within the report for even more supporting details.
EXTRA BONUS TIP...
Let's say you want to only see those items with the reorder flag (check mark) within the report.
Unfortunately, you can't filter like this directly in QuickBooks. Instead, export the Inventory Stock Status Report into Excel, and then create a custom filter for just those items with a check mark!
HOW WOULD YOU IMPROVE THIS REPORT?
Do you have a suggestion on how to make this report even better? Feel free to post a comment in the box below - your feedback is welcome.
RELATED INFORMATION:
- Are gross profit margins by item important in your business? Gross Profit Wizard is just for you.
- See the current availability of an inventory item in QuickBooks
- A great tool for analyzing overstocks, understocks and other inventory trends in QuickBooks
______________________________________________________________________________








