Inventory Reports

The Reports section provides detailed views into stock movements, valuations, ageing, and purchase and sales activity. Open Inventory > Reports to access all available reports.

Available Reports

Stock Balance

Shows the current quantity and valuation for every item across all warehouses.

• Columns: Item Code, Item Name, Warehouse, Quantity, Valuation Rate, Total Value.
• Use this to answer: How much of each item do we have, and what is it worth?

Stock Ledger

A chronological log of every stock transaction — receipts, issues, transfers, and adjustments.

• Columns: Date, Item, Warehouse, Transaction Type, Quantity In, Quantity Out, Balance Quantity.
• Use this to answer: What happened to this item's stock over time?

Stock Ageing

Shows how long current stock has been sitting in each warehouse, based on the date it was received.

• Columns: Item, Warehouse, Quantity, Age (days), Age Bracket (0-30, 31-60, 61-90, 90+).
• Use this to answer: Which items have been in stock the longest and may need attention?

Purchase Register

Summarizes all purchase invoices and receipts over a given period.

• Columns: Date, Supplier, Item, Quantity, Rate, Total Amount.
• Use this to answer: How much did we buy, from whom, and at what cost?

Sales Register

Summarizes all sales invoices and deliveries over a given period.

• Columns: Date, Customer, Item, Quantity, Rate, Total Amount.
• Use this to answer: How much did we sell, to whom, and at what revenue?

Filtering Reports

All reports support the following filters:

Filter	Description
Date Range	Set a start and end date to limit the report period.
Warehouse	Restrict results to a specific warehouse or warehouse group.
Item Group	Show only items belonging to a particular category.
Item	Focus the report on a single item by name or code.

Apply one or more filters and click Generate to refresh the report. Filters can be cleared individually or all at once with the Reset button.

Reading Report Data

• Column headers can be clicked to sort ascending or descending.
• Totals row at the bottom summarizes numeric columns (quantity, value, amount).
• Drill-down: Click any item name or transaction reference to navigate directly to that record's detail view.
• Reports with large datasets are paginated. Use the page controls at the bottom to navigate.

Exporting Reports

Click the Export CSV button at the top of any report to download the current view (with all active filters applied) as a CSV file. The export includes all rows, not just the current page.

Use exported data for:

• Sharing with clients or team members who do not have Kraal access.
• Loading into spreadsheets for custom analysis.
• Archiving periodic snapshots for compliance.

Connection to Financial Reporting

Inventory reports tie directly into your financial statements:

• Cost of Goods Sold (COGS) — The Stock Ledger and Purchase Register provide the data behind your COGS calculations. Material issues and deliveries reduce inventory value and flow into cost of goods sold.
• Inventory Valuation — The Stock Balance report reflects the same valuation that appears on your balance sheet under current assets. Keeping stock entries accurate ensures your balance sheet is correct.
• Revenue and Purchasing — The Sales Register and Purchase Register align with your income statement line items for revenue and cost of purchases.

When inventory transactions are recorded properly, financial reports in Kraal and ERPNext automatically reflect the correct figures — no manual journal entries required.