Inventory Summary

The Inventory Summary report gives you a snapshot of your current stock — showing how much of each item you have on hand, what it cost, and what it's worth. It's available for items marked as inventory-tracked.

---

How to View the Inventory Summary

1. Go to Reports
2. Select Inventory Summary
3. Set the As On date (defaults to today)
4. The report loads automatically

---

What It Shows

Each row represents one inventory item:

Column	Description
Item	Product name
In	Total units received (purchased or opening stock)
Out	Total units sold or consumed
Balance	Current stock on hand (In minus Out)
Avg Cost	Weighted average cost per unit
Value	Balance × Avg Cost — total inventory value at cost

---

How Stock Is Tracked

Stock movements are recorded automatically when:

• A bill or purchase order is approved — increases stock (In)
• An invoice or sales order is approved — decreases stock (Out)
• An opening stock is set on the item — adds initial In quantity

---

Inventory Valuation Method

Acusheet uses weighted average cost (WAC) to value inventory:

Avg Cost = Total Cost of Stock Received ÷ Total Units Received

As new stock arrives at different prices, the average cost is recalculated automatically. The value shown is always: Balance Qty × Current Avg Cost.

---

Common Use Cases

• Stock-take verification — compare the report to a physical count to spot discrepancies
• Low stock alerts — identify items where balance is approaching zero
• Inventory valuation — the total value at the bottom of the report is what appears on your Balance Sheet under Inventory
• Period-end reporting — run as-of your financial year end for audit purposes

---

Frequently Asked Questions

An item isn't appearing in the report — why?
Only items with Inventory tracking enabled appear. Check the item settings — the Inventory toggle must be on.

Why does my Balance Sheet Inventory figure differ from this report?
Run the report with the same As On date as your Balance Sheet. If they still differ, check if any inventory accounts have been manually adjusted via journal entries.

Can I see the movement history for a single item?
Not directly in this report. Use Account Transactions filtered to the item's Inventory account, or check the item's stock history via its detail page.

What happens if I sell more than I have in stock?
Acusheet will allow it but your balance will go negative. This indicates a data entry error — likely a missing purchase or incorrectly set opening stock.