Inventory Report

Inventory Report

Overview

In the Inventory Report, you can view data on all products, including profit and quantity information.

Instructions

  • To access, go to Reporting--->Inventory Report in the left navigation menu. 
  • You can customize which columns you would like displayed in the report by selecting the Set Columns drop-down field and then selecting the checkbox next to each column you would like to include. 
  • The columns in the Inventory Report include: 
    • Cost: Cost per unit to acquire item from vendor
    • ID: Automatically assigned to product when created. It gives the product an identifier. 
    • Item: Product name 
    • Price: Sales price per unit of product
    • Margin: Calculated by the formula ((Price-Cost)/Price) * 100
    • Total Quantity: Current quantity of product in stock
    • Total Cost: Quantity * Cost
    • Total Value: Calculated by the formula ((Price - Cost) / Price) * 100%
    • To easily find info on a specific product, you can search for it in the search box by typing in the item ID, name, or UPC or filter the item by StoreDepartment, Category, or Inventory Type from the respective drop-down filters, and then selecting the Search button.

 

  • Columns IDItem, and Price can be sorted by selecting their respective column headers. 
  • Export the Inventory Report to a .csv file by clicking the Export button and then click on the download to open the report. 

Please note that Inventory Report data older than one year is archived and will not be available for viewing and exporting. Please export and store your reports in timely manner.


    • Related Articles

    • Exporting Reports

      Overview The reports in eHopper that can be exported to a .CSV file are: Tips Report Z Report Product Mix Report Tax Report Time Clock Report Transactions Report Inventory Report Orders Report Instructions To export, click on the Export button on the ...
    • Inventory Aging Report

      Overview This report shows all products with serial numbers that are not sold within the date received (Received column) and the number of days that have passed since an item was added to your inventory, noted in column Age (Days). Instructions ...
    • Inventory Adjustments Report

      Overview In the Adjustment Report, you can view data on all adjustments to items that occurred in a specific time period. Instructions To access, select Reporting--->Adjustment Report in the left navigation menu. You can customize which columns you ...
    • Transactions Report

      Overview This report contains information on all payments processed (including voided and refunded) during a selected time period. Transactions can also be filtered by customer, employee, store, register, and dollar amount. To view the report, you ...
    • Z Report

      Overview In the Z Report, you can view data on all of the transactions completed during specific shifts on each register of a store or stores. A shift represents the time a register was opened to the time it was closed. In the Z Report, you can: ...