Inventory Kardex Summary

Introduction

The Inventory Kardex Summary report provides a comprehensive overview of inventory movements for each product and store combination. This document explains each field in the report to help you understand and analyze your inventory data effectively.

1. Product & Location Information

Field	Description
Product Name	The name of the inventory item.
Category	The product category for grouping and filtering.
Location (Store)	The warehouse or store where the inventory is located.
Lookup Code	Internal product code used for quick searching.
UPC/SKU	Universal Product Code or Stock Keeping Unit barcode.

2. Quantity Fields

These fields show the physical count of items during the selected period.

Field	Description
Beginning Quantity	Stock count at the START of the selected date range. This is the sum of all transactions before the 'From Date'.
In Quantity	Total quantity RECEIVED during the period. Includes: purchases, returns from customers, transfers in, production output, and positive adjustments.
Out Quantity	Total quantity ISSUED during the period. Includes: sales, returns to suppliers, transfers out, production consumption, and negative adjustments.
Closing Quantity	Stock count at the END of the selected date range. Formula: Beginning + In - Out

3. Amount Fields (Value)

These fields show the monetary value of inventory, useful for financial reporting and asset valuation.

Field	Description
Beginning Amount	Total value of opening inventory. Beginning Qty × Average Cost
In Amount	Total value of items received during the period.
Out Amount	Total cost of items issued during the period (Cost of Goods Sold).
Closing Amount	Total value of ending inventory. Beginning Amount + In Amount - Out Amount

4. Average Cost Fields

These fields show the average unit cost at different stages, helping you track cost changes over time.

Field	Description
Opening Avg Cost	Average unit cost at the beginning of the period. Beginning Amount ÷ Beginning Quantity
Avg In Cost	Average cost of items received (purchases). In Amount ÷ In Quantity
Avg Out CostNEW	Average cost of items issued (sold/consumed). This represents the Cost of Goods Sold (COGS) per unit. Out Amount ÷ Out Quantity Useful for comparing purchase cost vs. actual cost charged to sales.
Closing Avg Cost	Average unit cost at the end of the period. Closing Amount ÷ Closing Quantity

💡 Cost Analysis Tip: Compare these costs to identify trends:

Avg In Cost > Opening Avg Cost: Purchase prices are increasing
Avg Out Cost ≠ Closing Avg Cost: Normal in weighted average costing - older stock layers are being consumed
Avg Out Cost = 0 with Out Qty > 0: Data issue - items sold with zero cost

5. Key Performance Indicators (KPIs)

These analytical fields help you make informed inventory management decisions.

Field	Description
Turnover Ratio	How many times inventory was sold and replaced during the period. Higher = faster moving. Out Quantity ÷ Average Stock Example: Ratio of 4 means stock turned over 4 times.
Days of Stock	Estimated number of days the current stock will last based on the average daily consumption rate. Example: 30 means you have about 1 month of stock remaining.
Days Since Last Activity	Number of days since the last transaction. High values indicate slow-moving or dead stock that may need attention.

6. Transaction Counts

Field	Description
In Transaction Count	Number of receipt transactions (purchases, returns, transfers in).
Out Transaction Count	Number of issue transactions (sales, returns to supplier, transfers out).
Total Transaction Count	Total number of all transactions for this product in the period.

7. Status Indicators

Movement Status

Indicates the activity pattern during the selected period:

NoMovement (0): No transactions at all - item may be obsolete
Received (1): Only receipts, no issues - stock is accumulating
Issued (2): Only issues, no receipts - stock is depleting
Active (3): Both receipts and issues - normal active item

Stock Status

Indicates the health of stock levels based on consumption rate:

OutOfStock (0): Closing quantity is zero or negative - URGENT reorder needed
Critical (1): Less than 7 days of stock remaining - reorder immediately
Low (2): Less than 30 days of stock remaining - plan to reorder soon
Normal (3): More than 30 days of stock - healthy level

8. Data Quality Flags

These flags help identify potential data issues that may need investigation:

Flag	Meaning
Is Negative Closing	Closing quantity is negative. This indicates a data problem - you cannot physically have negative stock. Check for missing purchase entries or incorrect sales.
Has Zero Cost In	Items were received with zero cost. This may indicate missing cost information on purchases or adjustments.

9. Tips for Using This Report

📅 Filter by date range: Select a specific period (month, quarter, year) for meaningful KPIs.

⚠️ Watch for red flags: Items with negative closing or zero costs need immediate attention.

🔍 Review slow movers: High 'Days Since Last Activity' indicates items that may need clearance or write-off.

🚨 Monitor critical stock: Filter by Stock Status = Critical to see items needing urgent reorder.

💰 Analyze cost trends: Compare Avg In Cost vs Avg Out Cost to understand margin impact and cost flow.

📊 Export for analysis: Use the export feature to analyze data in Excel for deeper insights.

📊 Inventory Kardex Summary