Inventory Report Template

# Inventory Report Template

## Purpose
Review weekly or monthly to optimise stock levels, reduce carrying costs, and prevent lost sales from stockouts.

## When to Use
A stock-level report covering current inventory, slow-moving items, reorder points, stockout risks, and inventory turnover ratios.

## Instructions
1. Review the template below and familiarise yourself with the structure
2. Replace all [bracketed placeholders] with your business details
3. Customise the tone and formatting to match your brand
4. Save in your preferred tool (Shopify or Xero)

---

## Inventory Report

**Period:** [Date Range]
**Prepared by:** [Your Name]
**Date:** [Date]
**Warehouse / Location:** [Location]

---

### Executive Summary

Total inventory on hand is valued at $[Amount] across [X] SKUs. Stock turnover for the period was [X] times, [above / below] our target of [X] times. [X] items are flagged as stockout risks requiring immediate reorder, and [X] items are classified as slow-moving. Key action: [summary of most important action needed].

### Inventory Overview

| Metric | This Period | Last Period | Change | Target |
|--------|-----------|------------|--------|--------|
| Total SKUs | [X] | [X] | [+/-][X] | - |
| Total units on hand | [X] | [X] | [+/-][X] | - |
| Total inventory value | $[Amount] | $[Amount] | [+/-]$[Amount] | - |
| Inventory turnover ratio | [X]x | [X]x | [+/-][X]x | [X]x |
| Days of supply | [X] days | [X] days | [+/-][X] | [X] days |
| Stockout incidents | [X] | [X] | [+/-][X] | 0 |
| Dead stock value | $[Amount] | $[Amount] | [+/-]$[Amount] | <$[Amount] |

### Inventory by Category

| Category | SKUs | Units | Value | % of Total Value | Turnover |
|----------|------|-------|-------|-----------------|----------|
| [Category 1] | [X] | [X] | $[Amount] | [X]% | [X]x |
| [Category 2] | [X] | [X] | $[Amount] | [X]% | [X]x |
| [Category 3] | [X] | [X] | $[Amount] | [X]% | [X]x |
| [Category 4] | [X] | [X] | $[Amount] | [X]% | [X]x |
| [Category 5] | [X] | [X] | $[Amount] | [X]% | [X]x |
| **Total** | **[X]** | **[X]** | **$[Amount]** | **100%** | **[X]x** |

### Stockout Risk Items (Reorder Required)

| SKU | Product Name | Current Stock | Reorder Point | Lead Time | Daily Sales Rate | Days Until Stockout | Action |
|-----|-------------|---------------|---------------|-----------|-----------------|--------------------|---------|
| [SKU] | [Name] | [X] | [X] | [X] days | [X] | [X] days | Reorder immediately |
| [SKU] | [Name] | [X] | [X] | [X] days | [X] | [X] days | Reorder immediately |
| [SKU] | [Name] | [X] | [X] | [X] days | [X] | [X] days | Reorder this week |
| [SKU] | [Name] | [X] | [X] | [X] days | [X] | [X] days | Reorder this week |

### Slow-Moving Inventory (>90 Days on Hand)

| SKU | Product Name | Units | Value | Days on Hand | Last Sale Date | Recommendation |
|-----|-------------|-------|-------|-------------|----------------|----------------|
| [SKU] | [Name] | [X] | $[Amount] | [X] | [Date] | [Discount / Bundle / Write-off] |
| [SKU] | [Name] | [X] | $[Amount] | [X] | [Date] | [Discount / Bundle / Write-off] |
| [SKU] | [Name] | [X] | $[Amount] | [X] | [Date] | [Discount / Bundle / Write-off] |

**Total slow-moving inventory value: $[Amount] ([X]% of total)**

### Top Sellers (By Units Sold This Period)

| Rank | SKU | Product Name | Units Sold | Revenue | Margin | Current Stock | Weeks of Supply |
|------|-----|-------------|-----------|---------|--------|---------------|-----------------|
| 1 | [SKU] | [Name] | [X] | $[Amount] | [X]% | [X] | [X] |
| 2 | [SKU] | [Name] | [X] | $[Amount] | [X]% | [X] | [X] |
| 3 | [SKU] | [Name] | [X] | $[Amount] | [X]% | [X] | [X] |
| 4 | [SKU] | [Name] | [X] | $[Amount] | [X]% | [X] | [X] |
| 5 | [SKU] | [Name] | [X] | $[Amount] | [X]% | [X] | [X] |

### Incoming Stock (On Order)

| PO # | Supplier | Items | Expected Delivery | Value | Status |
|------|----------|-------|-------------------|-------|--------|
| [PO#] | [Supplier] | [X] SKUs, [X] units | [Date] | $[Amount] | [Ordered / Shipped / In Transit] |
| [PO#] | [Supplier] | [X] SKUs, [X] units | [Date] | $[Amount] | [Ordered / Shipped / In Transit] |

### Inventory Accuracy

| Metric | Result |
|--------|--------|
| Last stocktake date | [Date] |
| Counted accuracy rate | [X]% |
| Value variance | $[Amount] ([X]%) |
| SKUs with discrepancies | [X] |
| Next scheduled stocktake | [Date] |

### Recommendations

1. [Recommendation 1, e.g. Place immediate reorders for [X] items at risk of stockout]
2. [Recommendation 2, e.g. Run a clearance promotion on $[Amount] of slow-moving stock]
3. [Recommendation 3, e.g. Review reorder points for top 10 sellers to prevent future stockouts]
4. [Recommendation 4, e.g. Schedule stocktake for [Date] to verify system accuracy]

---

**Complexity:** intermediate | **Setup time:** 20 minutes | **Tools:** Shopify, Xero, Airtable