Wholesale Distributor Inventory Template
For small distributors buying in pallets and selling cases to retailers and restaurants. Track pallet locations, case quantities and vendor cost to protect thin wholesale margins.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| WD-PAP-TWL-30 | Paper Towel Roll, 30-ct Case | Paper Goods | Rack 12-B | case | 64 | 30 | 21.4 | auto | auto | Midstate Paper Mills |
| WD-CUP-16-HOT | 16 oz Hot Cup, 1000-ct | Disposables | Rack 8-A | case | 40 | 18 | 46 | auto | auto | Allied Foodservice Packaging |
| WD-GLV-NIT-L | Nitrile Gloves L, 10 x 100 | Gloves | Rack 3-C | case | 25 | 12 | 52.5 | auto | auto | SafeHand Supply Co. |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Count in the unit you sell (cases), but record the inner pack so partial-case breaks are visible.
- Rank SKUs by sales volume; count the top 20% weekly and the rest monthly.
- Track landed cost including freight in the unit cost column, not just the vendor invoice price.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template