Inventory Usage by Product Report
Location: Reports > Inventory & Gift Reports
The Inventory Usage by Product Report allows businesses to track inventory usage within a selected date range and filter results by Product Line, Inventory Group, Company or Worker.
To generate this report, select a Begin Date and End Date. Choose to include all Product Lines or select specific Product Lines. You can also filter by Inventory Groups by selecting all Inventory Groups or only specific Inventory Groups.
Next, select whether to report on all workers within the company or a specific worker, then click Generate. 
Once generated, the report can be printed or exported at any time.
The report can also be sorted by the following columns:
- Product — displays the table in alphabetical order by product name
- Inventory Group — displays the table in alphabetical order by inventory group
- Cost Each — displays the table in ascending order by standard cost
- Qty — displays the table in descending order by quantity used
- Total Cost — displays the table in ascending order by total cost
Within the table, products will be grouped by Product Line. Each Product Line section will be separated by a solid blue bar displaying the Product Line name. Within each Product Line grouping, the report will also display:
- Total quantity of inventory usage for products within that Product Line
- Total cost of all products used within that Product Line
The report includes the following columns:
Product - Displays the products used within the selected date range and filters applied.
Inventory Group - Displays the Inventory Group assigned to the product based on the selected filters and date range.
Cost Each - Displays the standard cost assigned to the product.
Qty - Displays the number of times the product was entered as inventory usage within the selected date range and filters applied.
Total Cost - Displays the total cost of the inventory item based on the selected date range and filters applied. (Formula: Standard Cost × Quantity)
At the bottom of the report, a totals row will display the combined total quantity and total cost for all inventory items included in the report based on the selected filters and date range.
To control whether staff can make inventory adjustments:
Go to Setup → Setup Worker Permissions, then navigate to the Page Category dropdown and select Inventory
Note: To adjust a product’s Standard Cost or update the assigned Product Line or Inventory Group, go to Setup > Setup Products
Note: To quickly update a product’s Standard Cost, go to Inventory > Manage Inventory.Related Articles
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 Usage by Date Report
Location: Reports > Inventory & Gift Reports The Inventory Usage Report lists each product recorded in the Product Usage feature within the Inventory area of the software. This report can be exported or printed at any time. To generate this 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 ...Manage Inventory Guide
Manage inventory by setting up retail and professional products. Inspire tracks what is sold and used, and can produce simple reports on sales, ordering and adjustments. Create a Purchase Order Inspire can create a list of products to order based on ...Why can't I delete a product?
Products once marked used in Inventory Usage, Ordered in Purchase Order or sold in Checkout cannot be deleted. Since these products are displayed in Reporting, the report needs a record of the product to report from. Once you have used, sold or ...