Skip to main content
All CollectionsReportsSales Reports
Inventory on Hand Report
Inventory on Hand Report
Updated over 4 months ago

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:

  1. 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.

  2. Scroll to the product you want to modify inventory values for.

  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 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.

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

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.

Did this answer your question?