Which Excel inventory template fits your business?
All three inventory templates calculate theoretical stock on hand, include a stock count feature with automated variances and an interactive inventory dashboard.
The difference is how stock moves through your business, and whether you need stock values or only quantities.
Quick answer: which template should you choose?
- Inventory Control - Trade Based Template: choose it if you buy and resell products, for example as a retailer or wholesaler, and need stock values and gross profit per item.
- Inventory Control - Usage Based Template: choose it if you use stock in production or in delivering a service, for example as a restaurant or manufacturer, and need usage and stock count variances.
- Inventory Quantity Control Template: choose it if you only need to track stock quantities, without cost values.
Feature comparison
| Feature | Inventory Control - Trade Based | Inventory Control - Usage Based | Inventory Quantity Control |
|---|---|---|---|
| Theoretical stock on hand | ✓Yes | ✓Yes | ✓Yes |
| Stock values at average cost | ✓Yes | ✓Yes | –No |
| Record purchases and adjustments | ✓Yes | ✓Yes | ✓Yes |
| Record stock usage (issues) | –No | ✓Yes | ✓Yes |
| Stock counts with automated variances | ✓Yes | ✓Yes | ✓Yes |
| Sales, cost of sales and gross profit for any date range | ✓Yes | ✓Yes | –No |
| Interactive inventory dashboard | ✓Yes | ✓Yes | ✓Yes |
The templates in detail
Inventory Control - Trade Based Template
Inventory control for businesses buying & selling products.
- Best for:
- Retailers and wholesalers that buy and sell stock and need average cost values and gross profit per item
- Not suitable for:
- Businesses that consume stock in production (use Inventory Control - Usage Based) or that only track quantities (use Inventory Quantity Control)
View the Inventory Control - Trade Based template
Inventory Control - Usage Based Template
Inventory control with stock usage as cost of sales.
- Best for:
- Restaurants, manufacturers and other businesses that use stock in production and need usage and stock count variances
- Not suitable for:
- Businesses that simply buy and resell stock (use Inventory Control - Trade Based) or that only track quantities (use Inventory Quantity Control)
View the Inventory Control - Usage Based template
Inventory Quantity Control Template
Inventory control for quantities on hand. No average costs.
- Best for:
- Any business that needs to track stock quantities, receipts, issues and stock count variances
- Not suitable for:
- Stock values or cost of sales (use Inventory Control - Trade Based or Usage Based)