A grocery stock count: the expiry date and shelf of each item.
A grocery count is a chance to spot what is close to expiring before it spoils, and to know where each item stands. This template adds expiry date and shelf, so you walk the shop shelf by shelf and write the nearest date for each item. It has sample rows for common grocery items with no brands, and the quantities are illustrations only.
Sample rows: Grocery stores
Examples only; prices are blank for you to fill.
| Item | Expiry date | Shelf | Expected | Counted | Difference |
|---|---|---|---|---|---|
| Long-life milk 1 L | 2027-02-10 | R1 | 48 | ||
| Yoghurt 500 g | 2026-11-12 | Fridge 2 | 30 | ||
| White cheese | 2026-12-05 | Fridge 2 | 20 | ||
| Cooking oil 1.8 L | 2027-09-01 | R3 | 36 | ||
| Pasta 500 g | 2028-01-15 | R4 | 60 | ||
| Canned beans | 2028-03-20 | R5 | 44 | ||
| Juice 1 L | 2027-01-30 | R6 | 40 | ||
| Biscuits | 2026-12-20 | R7 | 55 | ||
| Black tea 250 g | 2028-05-10 | R4 | 28 |
Common questions
How do I use expiry dates during the count?
Write the nearest date for each item, then sort out those expiring within a month or two and move them to the front or reduce the price. That costs less than throwing them out later.In Dashing items have batches with expiry dates and the oldest sells first.
What size of difference is normal in a grocery?
Loose items sold by weight shift a little through drying and trimming, but packed items should not differ: a gap means a counting or sales error, or theft. Investigate every packed-item difference, however small.
Do I count the fridges with the shelves?
Count them on the same day but in a separate pass, and write the fridge in the shelf column. Do not leave the door open for long or the chilled goods spoil.
More free tools
- Grocery & supermarketA grocery and supermarket cashier: carton and piece with a barcode each, typed weights, batches sold nearest-expiry first, a reorder point per item, and it works offline.
- Stock count sheetA ready stock-count sheet in Arabic, Kurdish and English: code, item, expected, counted, and the difference with its dinar value computed for you. Excel and CSV, free.
- Purchase orderA ready purchase order for a supplier: item, unit, quantity, unit cost, totals computed, and a Received column for what actually arrived. Arabic, Kurdish, English. Free.