On Hand Product Report

On Hand Product Report

Location: Reports > Inventory & Gift Reports

The On Hand Product Report gives the total value of all products currently on hand. If you need an accurate value for your accountant at year-end, you will need to print this on the LAST day of the year, before there is any inventory activity in the new fiscal year.

On Hand Product Report includes:
  1. Average Cost column which is the current average cost of each product listed
  2. On Hand Cost column which is the average cost multiplied by the quantity on hand
  3. Total at the bottom of the report which is the total value of the On Hand Cost column
The information on this report is only applicable to the date and time it is generated.

The report is sorted first by Product Line, then each Inventory Group with associated products underneath. The information contained on the On Hand Product report is only as good as the day it is generated. Be sure to generate the report on the day where an accurate inventory value is needed.


    • 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 ...
    • Refund Report

      Location: Reports > Transaction Reports  ​ The Inspire Refund Report can be generated to show businesses the tickets that were refunded and additional details about the ticket, such as if the product was restocked or if the refund was selected to be ...
    • How do I count my product?

      To update your current on hand count for your products: Click on the Inventory icon Select Inventory Physical Checklist Select any filters regarding Product Lines, Supplier and/or Type Click Generate Enter the current count of your product in the ...
    • 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 ...
    • Product List Report

      Location: Reports > Setup Reports The Product List Report will generate a list of products that can be filtered by Product Line, Professional or Retail, Inventory Group and Active or Inactive.  This report is great for confirming all your product ...