📍 Location: View reports at /inventory/reports
Available Reports
📦 Stock Valuation Report
Total inventory value at cost and retail prices. Essential for insurance, taxes, and financial statements.
⚠️ Low Stock Alerts
Products below minimum stock levels. Prevent stockouts and lost sales with proactive reordering.
🌟 Best Sellers
Top-selling products by revenue and quantity. Focus marketing and purchasing on proven winners.
🐌 Slow Movers
Products with low turnover. Clear out dead stock with discounts or stop reordering.
📊 Inventory Turnover
How quickly inventory sells. Calculate turnover rate = Cost of Goods Sold / Average Inventory.
📈 Stock Movement History
Track all inventory changes: sales, returns, adjustments, transfers. Full audit trail.
Stock Valuation Report
How to Generate
- Go to /inventory/reports
- Click "Stock Valuation Report"
- Select date range (defaults to current stock)
- Choose categories to include (or all categories)
- Click "Generate Report"
Example Report
| Category | Units | Cost Value | Retail Value |
|---|---|---|---|
| Pool Chemicals | 245 | $8,450 | $12,890 |
| Filters & Parts | 182 | $6,320 | $9,980 |
| Cleaning Tools | 98 | $1,240 | $2,180 |
| TOTAL | 525 | $16,010 | $25,050 |
Use Cases
- Calculate cost of goods sold (COGS) for tax returns
- Determine insurance coverage needed
- Track inventory value over time
- Calculate gross profit margin (retail value - cost value)
Low Stock Alerts
Automatic alerts when products fall below minimum stock levels. Prevent stockouts and lost sales.
Setting Minimum Stock Levels
- Go to /inventory
- Click on product to edit
- Enter "Minimum Stock Level" (e.g., 10 units)
- Save product
- System automatically alerts when stock drops below minimum
⚠️ Low Stock Alert: 15 products are below minimum stock levels. View report at /inventory/reports → Low Stock Alerts.
Best Sellers vs Slow Movers
Best Sellers Report
Identify top-performing products by:
- Revenue: Total dollar amount sold
- Quantity: Number of units sold
- Profit Margin: Highest profit per sale
Slow Movers Report
Products with low turnover (e.g., less than 5 sales in 90 days):
- Filter by date range (last 30, 60, or 90 days)
- Identify dead stock tying up cash
- Run clearance sales to liquidate inventory
- Stop reordering slow-moving items
- Free up shelf space for better sellers
Inventory Turnover
Measure how efficiently you're managing inventory. Higher turnover = less capital tied up in stock.
Formula
Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory Value
Example Calculation
Annual COGS: $180,000
Average Inventory: $30,000
Turnover Ratio: $180,000 / $30,000 = 6×
Interpretation: Inventory turns over 6 times per year (every 2 months)
💡 Good vs Bad: Retail: 4-6× is good. Grocery: 10-20× is normal. Below 2× indicates overstocking.