To access the Inventory on Hand Report, click the App Drawer button then click View All > Reports > Sales > Inventory on Hand.
The Inventory on Hand Report is a sales report that displays the details of your product inventory for a selected date range. You can use this report to manage your inventory by recording the number of units of a product you received and how many units you currently have on hand.
Note: You can print barcode labels from this report. For more information, see Printing a barcode label.
Manage inventory using the Inventory on Hand Report
To manage your inventory using the Inventory on Hand Report, follow these steps:
Click MODIFY INVENTORY at the bottom of the page.
This button won’t appear if you’re viewing the report for dates in the past or future.
Scroll to the product you want to modify inventory values for.
Make any required changes:
In the Received column, enter the number of units of the product you received during the current time period.
In the On Hand column, enter the number of units of the product you currently have.
Click SAVE CHANGES.
Summary cards in the Inventory on Hand Report
Summary cards | Description |
Total Quantity in Stock | The total number of different types of products in different business locations on hand during the selected date range. |
On Hand Value | The total value of products on hand during the selected date range. |
Total Net Sales | The total value of the transaction before taxes, surcharges, and tips but after any applied discounts during the selected date range. |
Total Cost | The total wholesale price for all products in your inventory during the selected date range. |
Total Retail Value | The sum of the Retail Value column for the selected date range. |
Headings in the Inventory on Hand Report
Heading | Description |
Product Name | The name of the product. |
Product Option | The available options for the product. For example, sizes for a t-shirt. |
Online Store Category | The store category that each product belongs to. |
Barcode | The barcode associated with the product. |
Supplier | The name of the supplier of the product. |
Location Name | The location at which the inventory on hand is stored. If you store the same product at multiple locations, there will be a separate entry in the report for the inventory at each location. |
Cost | The cost to your business for one unit of the product. |
Retail Price | The selling price of one unit of the product. |
Reorder Level | The number of units of the product you must have on hand to prompt contacting the supplier to order more units. |
Starting Inventory | The number of units of a product on hand at the beginning of the selected date range.
For example, if you are looking at the report for the month of March, this column displays the number of units on hand on March 1st. |
Received | The number of units of the product added to your inventory during the selected date range. |
Usage | The number of units of the product sold during the selected date range.
Clicking the number will bring you to the Cost of Goods Sold Report filtered by the associated product for the selected date range. |
Subtotal | The total value of product sales before discounts during the selected date range. |
Total Net Sales | The total value of the transaction before taxes, surcharges, and tips but after any applied discounts during the selected date range. |
On Hand | The current number of units of the product held in inventory. |
Variance | The number of units of a product not accounted for. The variance number will be positive if you have lost unaccounted for units and negative if you have gained unaccounted for units.
This number is calculated by taking into account the numbers listed in the Starting Inventory, Received, Usage, and On Hand columns.
|
Variance Cost | The total cost of the variance. This number is calculated using the retail price of the product, not the cost. |
On Hand Value | The total cost to your business for the units of a product held in inventory at the location. This number is calculated using the cost of the product, not the retail price. |
Retail Value | The retail price of a product multiplied by the number of that product currently on hand. |
Advanced filters in the Inventory on Hand Report
Filter | Description |
Products | Use this filter to determine which product(s) to include in the report. |
Online Store Category | Use this filter to determine which store categories to include in the report. |
Location | Use this filter to determine which locations to include in the report. |
Suppliers | Use this filter to determine which supplier(s) to include in the report. |