Inventory Reports
Data-driven decisions are the backbone of efficient inventory management. Sevenledger provides a suite of specialized reports that allow you to track stock movements, audit asset values, and analyze product profitability.
To access these reports, navigate to the Reports section of your dashboard.
1. Inventory Summary
The Inventory Summary is your primary dashboard for current stock status. It provides a real-time snapshot of what you have, what is coming in, and what is committed to customers.
Why use this report? Use this report for daily operations—checking if you have enough stock to fulfill a new order or if you need to reorder.
Key Metrics
| Column | Description |
|---|---|
| Opening Stock | The quantity on hand at the start of the selected date range. |
| Quantity In / Out | The total units added (purchases, returns) or removed (sales, damage) during the period. |
| Adjusted Quantity | Net changes made via manual stock adjustments (e.g., stocktaking corrections). |
| Stock On Hand | The physical count currently sitting in your warehouse. |
| Promised Quantity | Stock that has been sold (on a confirmed Sales Order) but not yet shipped. These items are physically present but legally reserved. |
| Available For Sale | The most critical metric for sales staff. Calculated as: (Stock On Hand - Promised Quantity). |
2. Stock Movement
The Stock Movement report acts as a detailed audit trail for every single inventory transaction. It chronologically lists every time an item entered or left a warehouse.
Why use this report? If your physical count doesn’t match your system count, use this report to investigate discrepancies. You can trace back to the exact date and transaction reference where an error might have occurred.
Key Data Points
- Date: The exact date of the transaction.
- Quantity: Color-coded for clarity. Green indicates stock addition (Purchases, Returns), while Red indicates stock reduction (Sales, Write-offs).
- Stock On Hand: The running balance after that specific transaction occurred.
- Reference: A clickable link to the source document (e.g.,
WH/OUT-1-82/83for a transfer, orOpening Stock).
3. Inventory Valuation
The Inventory Valuation report translates your physical stock into financial value. This is essential for your Balance Sheet and end-of-year accounting.
Why use this report? Use this to determine the total asset value of your inventory for insurance purposes, tax filing, or seeking investment.
Key Metrics
| Column | Description |
|---|---|
| Total Quantity | The total number of units currently held. |
| Average Value | The cost per unit. This is calculated based on your inventory valuation method (typically Weighted Average Cost). |
| Total Value | The aggregate financial worth of that specific item line. Calculated as (Total Quantity × Average Value). |
4. Inventory Aging Report
The Inventory Aging report categorizes your stock based on how long it has been sitting in your warehouse. It groups items into time buckets (0-30 days, 31-60 days, etc.).
Why use this report? This report helps you identify Dead Stock. Items sitting in the “>365 Days” bucket are tying up cash flow and occupying storage space. You should consider running promotions or discounts to clear this inventory.
Understanding the Buckets
- 0-30 Days: Fresh stock, recently purchased or manufactured.
- 31-90 Days: Healthy moving stock.
- 181-365 Days: Slow-moving stock. Investigation recommended.
- >365 Days: Obsolete or dead stock. Immediate action recommended.
5. Profit by Item
The Profit by Item report analyzes the financial performance of your products. It compares the revenue generated against the cost of goods sold (COGS).
Why use this report? Use this to identify your “Star” products (high margin, high volume) and your “Loss Leaders.” It helps you decide which products to push in marketing campaigns and which to potentially discontinue.
Key Metrics
| Column | Description |
|---|---|
| Units Sold | Total quantity sold within the selected date range. |
| Revenue | Total income generated from sales of this item (excluding tax). |
| Cost | The cost of goods sold for these specific units. |
| Gross Profit | Calculated as (Revenue - Cost). A negative number indicates you are selling below cost. |
| Gross Margin % | The profitability percentage. A higher percentage indicates a healthier profit buffer. |