Inventory Valuation Reports
Inventory Valuation reports help you understand the monetary value of your stock and the cost methods driving that value. Go to Reports from the left sidebar, then select Inventory Valuation from the Report Category list.
Inventory Valuation Summary
The Inventory Valuation Summary report shows the stock on hand and total asset value of each item as of the current date. The inventory asset value is calculated based on the costing method assigned to the item:
- FIFO (First In, First Out): Inventory Asset Value = Stock on Hand × Cost Price Per Unit (earliest purchase).
- Weighted Average Costing (WAC): Inventory Asset Value = Stock on Hand × Average Cost Price Per Unit.
Scenario: Zylker Manufacturing is preparing its end-of-quarter financial statements. Bailey generates the Inventory Valuation Summary to get the total inventory asset value for the balance sheet, grouped by item and costing method.
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click Inventory Valuation Summary.
- Use the As of dropdown to set the date, add filters if needed, and click Run Report.
This report includes the following columns:
- ITEM NAME: Name of the inventory item.
- SKU: Stock Keeping Unit of the item.
- STOCK ON HAND: Current physical stock quantity across all warehouses.
- INVENTORY ASSET VALUE: Total monetary value of stock on hand, calculated using the costing method assigned to the item (FIFO or Weighted Average Costing).
FIFO Cost Lot Tracking
The FIFO Cost Lot Tracking report shows every inward and outward stock movement for each item matched according to the First In First Out principle. Use it to verify that stock consumed matches the earliest purchase lots in the correct cost order.
Scenario: Zylker Inc purchased 20 units of a storage unit at £10 each (opening stock), then bought 10 more at £12 each against a bill. When Bailey from Zylker invoices 25 units, FIFO matches the first 20 at £10 (£200) and the remaining 5 from the second lot at £12 (£60), leaving 5 units at £12 available.
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click FIFO Cost Lot Tracking.
- Set a Date Range and any additional filters (item name), then click Run Report.
This report includes the following columns:
- DATE (Product In): Date on which the stock lot was received.
- TRANSACTIONS (Product In): Reference number and type of the inward transaction (e.g., Bill, Opening Stock).
- RECEIVED FROM: Vendor or source from which the lot was received.
- ITEM NAME: Name of the item.
- QUANTITY (Product In): Quantity received in the lot.
- COST PER UNIT: Purchase cost per unit for this lot.
- TOTAL (Product In): Total purchase cost of the lot (Quantity × Cost Per Unit).
- DATE (Product Out): Date on which stock from this lot was consumed.
- TRANSACTIONS (Product Out): Reference number of the outward transaction (e.g., Invoice).
- DISPERSED TO: Customer or destination to which the lot was despatched.
- QTY DISPERSED: Quantity consumed from this lot in the outward transaction.
ABC Classification
The ABC Classification report categorises your items into three classes - A, B, and C - based on their revenue contribution. Use it to prioritise stocking decisions and allocate resources to your most valuable items.
| Class | Description |
|---|---|
| A | Highest revenue-generating items. Critical to maintain stock - never let these run out. |
| B | Moderate contributors. Can shift to A or C depending on demand changes. |
| C | Lowest contributors. Typically surplus stock with high holding costs. |
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click ABC Classification.
- Set the Classify Based on option and Date Range using the filter bar, then click Run Report.
Customise the Report
| Option | Description |
|---|---|
| Date Range | The period for which item sales are evaluated. |
| Classify Based on | Usage Value (quantity sold × cost per unit) or Quantity (units sold). |
| Percentages | Set the percentage threshold for each class. The three values must not exceed 100 in total. |
Export and Import
Export the report in PDF, XLS, or CSV format. Re-import a previously exported report to compare historical and current class assignments - items that improved from C to B or A are highlighted under PREVIOUS CLASS.
Note: Before importing, ensure the Previous Class column is moved to Selected Columns under Customize Report Columns > Show / Hide Columns.
Note: If your organisation has more than 1,000 items, you cannot view this report within Zoho Inventory - export it to view it.
Landed Cost Summary
The Landed Cost Summary report shows the total landed cost incurred per vendor, and the amount allocated to each item in your bills. Use it to understand the full cost of goods received, including freight, duties, and other charges.
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click Landed Cost Summary.
- Set a Date Range and any additional filters, then click Run Report.
This report includes the following columns:
- BILL DATE: Date of the vendor bill to which the landed cost applies.
- BILL#: Reference number of the bill.
- VENDOR NAME: Name of the vendor from whom the bill was received.
- DESCRIPTION FOR THE ITEM: Description of the landed cost charge (e.g., Freight, Insurance, Import Duty).
- BILL TOTAL(BCY): Total amount of the bill in your base currency.
- ALLOCATED AMOUNT(BCY): Portion of the landed cost allocated to items, in base currency.
- UNALLOCATED AMOUNT(BCY): Portion of the landed cost not yet allocated to any item.
Inventory Turnover By Amount
The Inventory Turnover By Amount report shows how efficiently your inventory is being sold, measured by the total value of stock sold relative to the average inventory value during a period. Use it alongside Inventory Turnover By Quantity to compare volume and value perspectives.
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click Inventory Turnover By Amount.
- Set a Date Range and any additional filters, then click Run Report.
This report includes the following columns:
- ITEM NAME: Name of the inventory item.
- SKU: Stock Keeping Unit of the item.
- OPENING BALANCE: Total stock value at the start of the selected period.
- CLOSING BALANCE: Total stock value at the end of the selected period.
- COST OF GOODS SOLD: Total cost of goods sold during the period.
- AVERAGE PRICE: Average cost of goods, based on opening and closing balance.
- TURN OVER RATIO: Number of times the total inventory value was replaced (Cost of Goods Sold ÷ Average Price).
- AVERAGE TURNOVER DAYS: Average number of days to turn over one full inventory cycle by value.
Weighted Average Costing Summary
The Weighted Average Costing Summary report shows the weighted average cost per unit for each item, calculated across all purchase lots. Use it to review how the average cost changes as new stock is received at different prices.
To generate this report:
- Go to Reports from the left sidebar.
- Select Inventory Valuation from the Report Category list.
- Click Weighted Average Costing Summary.
- Set filters as needed, then click Run Report.
This report includes the following columns:
- ITEM NAME: Name of the inventory item.
- OPENING STOCK: Stock quantity at the start of the selected period.
- OPENING STOCK AMOUNT: Total value of opening stock, based on the weighted average cost.
- OPENING WAC: Weighted average cost per unit at the start of the period.
- CLOSING STOCK: Stock quantity at the end of the selected period.
- CLOSING STOCK AMOUNT: Total value of closing stock at the weighted average cost.
- CLOSING WAC: Weighted average cost per unit at the end of the period.