Grocery Store Inventory Template
For independent grocers and small markets managing perishables, dairy and dry grocery from several distributors. Watch par levels and expiration dates department by department.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Large Grade A Eggs, 15 dozen | Dairy & Eggs | Dairy Cooler | case | 6 | 4 | auto | 33 | auto | Valley Dairy Distributors | 2025-12-22 |
| Organic Bananas, 40 lb | Produce | Produce Cooler | case | 4 | 3 | auto | 28 | auto | Sunfield Organic Produce | 2025-12-05 |
| Canned Chickpeas, 15 oz x 24 | Dry Grocery | Backroom Aisle 2 | case | 5 | 3 | auto | 19.2 | auto | Midwest Grocery Wholesale | 2027-08-31 |
ƒ = 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
- Walk dairy and produce daily for near-dated items and mark them down before they become shrink.
- Set pars by department delivery day, since dairy, bread and dry grocery each come on their own schedule.
- Count high-dollar categories like meat and seafood more often than shelf-stable aisles.
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