Inventory on Hand Report

The Inventory on Hand Report is a sales report that displays the details of your product inventory during the selected date range. You can use this report to manage your inventory by recording the number of units of a product you received during the current time period and how many units you currently have on hand. You can’t modify inventory numbers for past or future time periods.

The summary cards at the top of the page provide an overview of the key information in the report. This article describes how to view the Inventory on Hand Report and provides details of the columns that appear in the report. To learn how to customize and filter the report, see Viewing a report.

You can print barcode labels from this report. For more information, see Printing a barcode label.

In this article:

To view the Inventory on Hand Report:

1. Click the App Drawer button .
2. In the App Drawer, click View All.
3. In the list, click Reports. You can filter the list by entering Reports into the Search field.
4. On the Reports menu, click Sales.
5. On the Sales menu, click Inventory on Hand. The Inventory on Hand Report is displayed.

To manage inventory using the Inventory on Hand Report:

1. Click MODIFY INVENTORY at the bottom of the page. This button will only appear if you are viewing the report for the current time period.
2. Scroll to the product for which you want to modify inventory values.
3. 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.
4. Click SAVE CHANGES.

Summary cards in the Inventory on Hand Report

Summary cards	Description
Total Products	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.

Headings in the Inventory on Hand Report

Heading	Description
Product Name	The name of the product.
Bar Code	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. If you had a product whose starting inventory was 25, and 5 units of the product were sold (the number listed in the Usage column), but you currently have 19 units of the product on hand, the variance for this product would be 1. If you had a product whose starting inventory was 30, and 35 units of the product were currently on hand, but you hadn’t recorded any units being received or sold, then the variance would -5.
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.

Advanced filters in the Inventory on Hand Report

Filter	Description
Products	Use this filter to determine which product(s) 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.