Excel-Skills.com

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?

Feature comparison

Feature Inventory Control - Trade BasedInventory Control - Usage BasedInventory 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)

View the Inventory Quantity Control template

Frequently Asked Questions

What is the difference between the trade based and usage based inventory templates?
The trade based template is for businesses that buy and resell products. The usage based template is for businesses that use stock, for example in a kitchen or a production process, and records that usage. Both value stock at average cost.
Do I need stock values, or only quantities?
If you need stock values or gross profit, use the trade based or usage based template. If you only need to know how many items you have, the Inventory Quantity Control template tracks quantities without cost values.
How are stock count variances calculated?
The template calculates a theoretical stock balance from your recorded transactions. When you enter a stock count, the difference between the counted quantity and the theoretical balance is the variance.
Can I record stock usage weekly instead of daily?
Yes. If daily measurement is impractical, the usage based and quantity templates can also be used to record and analyse weekly stock usage.