BBQ Restaurant Inventory Spreadsheet
For barbecue joints smoking brisket, ribs and pork shoulder plus sides, rubs and wood. Plan the overnight smoke around what's in the walk-in and track the wood pile too.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| Whole Packer Brisket, ~14 lb | Protein | Walk-in Cooler | each | 12 | 8 | auto | 66 | auto | Lone Star Meat Purveyors | 2025-12-14 |
| Pork Spare Ribs, St. Louis Cut | Protein | Walk-in Cooler | case of 12 | 3 | 2 | auto | 104 | auto | Lone Star Meat Purveyors | 2025-12-12 |
| Post Oak Splits | Wood & Fuel | Wood Shed | cord | 2 | 1 | auto | 340 | auto | Hill Country Firewood |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Track raw meat weight and cooked yield; brisket can lose a large share of its weight in the smoker, which changes true cost per pound.
- Set brisket and rib pars by day of week and sell-out history, since most smokers can't be restarted mid-service.
- Count wood by the cord or bag and reorder before it runs low; damp or green wood can't be swapped in last minute.
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 TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateBrewery Inventory SpreadsheetFood Pantry Inventory TemplatePizza Shop Inventory TemplateWinery Inventory Spreadsheet