Metrics for Monitoring Business Health – Part 3: Inventory Value

How is Inventory Value Calculated?

Inventory value can either be evaluated on:
  1. Cost – What items cost to purchase
  2. Retail Value – The value of your items if they were sold at retail price
To calculate the inventory value based on Cost:
To calculate the inventory value based on Retail Price:
Profit margins can also be affected by:
  • Special offers from vendors
  • Free items from vendors

Why is Inventory Value Important?

You can use inventory value reporting to:
  • Plan sales for categories with too high value
  • Monitor your current stock value
  • Set categorical target values for buyers

Reporting on Inventory Value

Overall Valuation

The Valuation Report is a report used to show all items in your inventory and the associated retail and cost values. As a result, the report can be very long, especially when you have thousands of item records. The best practice to preview the report before printing is especially true with the Valuation Report.
To run the Valuation Report:
  1. Select Inventory → Reports → Valuation Report
  2. Select a Report type from the Report drop-down:
    • Summary – Values and quantities will be summarized, if you have multiple locations, values and quantities will be added to get a total
    • Detail – Values and quantities will be displayed for each location if you have multiple locations and also totaled.
      NOTE: Selecting Detail will make the already long report even longer.
  1. Select an Order by method from the Order by drop-down
  1. Use the Item and Inventory/Price tab to filter
    • SUGGESTED FILTERS:
    • Use the Inventory/Price tab to filter for a specific location or multiple locations – this will allow you to view the report for either one or multiple locations
    • Use the Inventory/Price tab to filter for Qty on hand not equal to 0 – this will allow you to only see items with positive or negative quantity on hand and skip 0s
  1. Click Preview

Inventory Value by Category

While the Valuation Report is a great resource for understanding how individual inventory values contribute to the total valuation, it cannot give you a breakdown of the inventory value by category. The Inventory Analysis by Category Summary Report is a report to show you how the Inventory Value is spread across your item categories.
To run the Inventory Analysis by Category Summary Report:
  1. Select Inventory → Reports → Inventory Analysis Report
  2. From the Report drop-down, select Inventory Analysis by Category (Summary)
  1. From the Print in order by drop-down, select Inventory value
  1. Select a number of records to Print
  1. Choose a Location or click All locations
  1. (Optional) Use the Item tab to filter the report
  2. Click Preview

Inventory Value by Item Grouped by Category

You can take the Inventory Analysis Report and have it display items and category totals as well.
To run the Inventory Analysis by Category Report:
  1. Select Inventory → Reports → Inventory Analysis Report
  2. From the Report drop-down, select Inventory Analysis by Category
  1. From the Print in order by drop-down, select Inventory value
  1. Select a number of records to print
  1. Choose a Location or click All locations
  1. (Optional) Use the Item tab to filter the report
  2. Click Preview

Recent Posts

Unsure of your version? Click this article for instructions or reach out to [email protected] for help.
Learn how to run reporting on overstock, understock, and deficiencies in your product line.
Learn how to run a report to locate items that have sold into the negative.
Keeping your hardware PCI compliant and up to date is essential for a secure business. Check out these resources on how to keep your business safe. 

i3 Verticals, LLC is a registered ISO of Wells Fargo Bank, N.A., Concord, CA | i3 Verticals, LLC is a registered ISO of RBS Worldpay | i3 Verticals, LLC is a registered ISO of Deutsche Bank, USA, New York, NY i3 Verticals, LLC is a registered ISO/MSP of Merrick Bank, South Jordan, UT | i3 Verticals, LLC is a registered ISO of Harris NA, Chicago, IL | i3 Verticals, LLC is a registered ISO of Fifth Third Bank, Cincinnati, OH Copyright i3 Verticals, LLC © 2019. All Rights Reserved.