Inventory On Hand Report

The Inventory On Hand Report is a sales report that displays all your products. 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 cannot modify inventory numbers for past or future time periods.

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 Reports.
    3. On the Reports menu, click Sales.
    4. 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 not 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.

    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 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.
    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 cost of the product, not the retail price.
    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 business location(s) to include in the report.
    Suppliers Use this filter to determine which supplier(s) to include in the report.
    Was this article helpful?
    (103 out of 104 people found this article helpful)
    Still need help? Contact us
    Cancel