Inventory Valuation by Departments Report

What This Report Is

This report shows how much inventory you have and how much it’s worth, broken down by Departments, Subdepartments, or Suppliers. You can filter by date, category, supplier, or department to see detailed inventory levels, pricing, sales, margins, and days of supply.

Why It Matters

• Avoid stockouts or overstocking: Know exactly how much inventory you have on hand.
• Watch your profit margins: See which items make the most money and which don’t.
• Spot slow sellers: Identify products that aren’t moving so you can take action.
• Make better buying decisions: Know what and when to reorder.

What to Look For

• QOH (Units): Quantity on hand — how many units you have.
• Days of Supply (Days): How long your current stock will last.
• Margin Percentage: How much profit you’re making on each item.
• Average Sales (Daily/Weekly): Sales speed — how quickly items are selling.
• Extended Values (Price, Cost, Margin): The total value of inventory based on price and cost.

What to Do

• Reorder fast sellers: If days of supply are low and sales are strong, place reorders.
• Watch low margins: Review items with low or negative margins and check costs or pricing.
• Handle slow movers: Consider discounts or promotions for products with low sales and high inventory.
• Use filters to focus: Filter by department, subdepartment, or supplier to narrow your focus and make decisions faster.

Tip: Use the settings menu to hide inactive products or negative QOH to simplify your view.