Inventory Valuation Report

The Inventory Valuation Report provides an understanding of the cost of the inventory and the potential profits from their sale. Total inventory value is calculated as the average cost of items in inventory multiplied by the stock of those items. 

To generate the Inventory Valuation Report:

1. Click Reports in the left-hand navigation panel.
2. Click Inventory Valuation Report.
3. Enter any desired filters. 
4. Click Run Report.

The following data is included in the report:

• Product Category/Product Name/Short Description: As defined when you setup the product
• Price: The current retail value of the product (how much you are selling this item for in the store)
• Quantity on Hand: The total number of the product item in your inventory
• Current Average Cost: The system will calculate the average cost based on the number of each product and the cost for those items. For example you have the following inventory:
  • 100 items purchased at $5.00 = $500
  • 30 items purchase at $10.00 = $300
  • Calculation total cost of each item/total inventory = average cost. (500 + 300)/30 = $6.15

• Extended Value: Quantity on Hand * Current Average Cost