On Hand Product Report

On Hand Product Report

Location: Reports > Inventory & Gift Reports

The On Hand Product Report provides the current inventory value of all products currently on hand within the software. If an accurate inventory value is needed for accounting or year-end reporting purposes, this report should be generated on the LAST day of the fiscal year before any inventory activity occurs in the new fiscal year. This report can be exported or printed for your records.



Warning
The information contained on the On Hand Product report is only as good as the day it is generated.

The information contained within this report is only applicable to the exact date and time the report is generated.

This report can be filtered by:                                      
  • Product Line
  • Inventory Group
  • Product Type
In addition, the report can be scheduled to automatically generate daily, weekly, bi-weekly, monthly, quarterly, or yearly while filtering by specific Product Lines, Inventory Groups, or Product Types.          


You can also choose to hide inactive products when generating the report.        

The report is sorted first by Product Line and then by Inventory Group, with associated products listed above each group.



The report can be sorted by:
  • A to Z — displays products alphabetically within each group
  • SKU — display products within each group in ascending order by SKU
The On Hand Product Report includes the following columns:
Product Name - Displays all products included within the selected filters.
SKU - Displays the SKU number associated with the product.
Size - Displays the size and unit of measurement assigned to the product. If no size or unit of measurement has been assigned, the value will display as zero.
Quantity On Hand - Displays the current inventory count for the product.
Minimum Quantity - Displays the minimum quantity desired to remain in stock for the product.
Average Cost - Displays the current average cost assigned to the product.
On-Hand Cost - Displays the total inventory value currently on hand for that product. (Formula: Quantity On Hand × Standard Cost)
Standard Cost - Displays the traditional cost of the item without discounts.
Set Price - Displays the client retail price assigned to the product.

Within the report, products are grouped by Inventory Group. Each Inventory Group section will display in bold with asterisks and will include:
  • Total quantity count of products within that group
  • Total quantity on hand within that group
  • Total On-Hand Cost within that group



At the bottom of the report, a totals row will display the combined total Quantity On Hand and total On-Hand Cost for all products included within the report filters.






Notes
Note: If multiple SKUs are attached to a single product; Only the first SKU assigned to the product will display in the report.
AlertNote: If the quantity reflects as a negative number, this indicates excessive inventory usage was entered or the product was sold on tickets without the inventory count being properly updated.
IdeaNote: To quickly update Minimum Quantity, go to Setup > Setup Products or Inventory > Manage Inventory.
IdeaNote: To update or manage Standard Cost or Set Price, go to Inventory > Manage Inventory.
AlertNote: If the On-Hand Cost reflects as a negative number, inventory counts were not up to date and the item was either used in inventory usage, moved, or sold on tickets while the inventory count reflected below zero.

    • Related Articles

    • How do I schedule a report?

      This feature will be available in May 2024. Scheduling Reports is available on the following reports: Total Sheet Sales Analysis Report Text Count Report Yearly Dashboard Tab On Hand Product To schedule a report, go to one of the reports listed and ...

    • Product List Report

      Location: Reports > Setup Reports The Product List Report provides a comprehensive view of all products in your system, helping you review and confirm that your product setup is accurate and organized to your preference. This report is especially ...

    • How can I correct an Inventory Usage entry?

      Oh no!  If you created an Inventory Usage entry and need to correct it, follow these simple steps: Go to Reports > Inventory & Gift Reports > Inventory Usage Report Enter the date range for the entry Click Generate Click the (-) to delete the ...

    • Inventory Adjustments Report

      Location: Reports > Inventory & Gift Reports The Inventory Adjustment Report tracks any changes made to your inventory counts by workers in Manage Inventory or Setup Inventory, specifically updates to the On Hand quantities. Overview This is a daily ...

    • Total Sheet Report

      Location: Reports > Transaction Reports The Total Sheet is a great report to run daily, weekly, monthly, or anytime you need a full snapshot of your business. It provides a summary of key data including worker sales, company sales, ticket ...