A walk-in cooler inventory sheet is written in the order the shelves are stacked, top to bottom, so that counting it is a walk down the rack with no hunting. The order isn't arbitrary. The FDA Food Code asks that raw animal foods be kept apart from ready-to-eat food and from each other, and the usual way to do that on a rack is by cooking temperature: ready-to-eat food on top, then dairy and produce, then whole cuts of meat and fish, then ground meat, with raw poultry at the bottom, so nothing raw can drip onto food that won't be cooked. Each row has what's there, its level, and its cost. And everything in the walk-in has a date, listed on a second tab that flags what to use first. Below is a sheet for a made-up restaurant on a Friday, the shelf order, and the file.
The short version
- List the sheet in shelf order, top to bottom. Count in that order.
- Ready-to-eat on top. Raw poultry at the bottom.
- A date on every container: delivered, made, or opened.
- Food made in the kitchen: seven days at most at 41°F, counting the day it was made.
- Use the oldest first. Put new deliveries behind old.
- TaroStack counts on a phone and flags dates before they arrive. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Cooked rice, pans | pan | 3 | 2 | $4.50 | $13.50 | OK |
| Salad greens, washed | lb | 9 | 10 | $3.20 | $28.80 | REORDER |
| House dressing, quarts | quart | 6 | 4 | $2.80 | $16.80 | OK |
| Whole milk | gal | 5 | 4 | $4.10 | $20.50 | OK |
| Cheddar, shredded | lb | 18 | 15 | $3.60 | $64.80 | OK |
| Eggs, large | dozen | 22 | 15 | $4.20 | $92.40 | OK |
Eleven rows in all, $823.20 in the walk-in, with three to reorder: salad greens, fish fillets and chicken.
The shelf order
| Shelf | What goes there | Why there |
|---|---|---|
| 1, top | Ready-to-eat food: cooked rice, washed greens, dressings, desserts | Nothing above it to drip on it |
| 2 | Dairy and eggs | |
| 3 | Whole, uncut produce | Will be washed before use |
| 4 | Raw fish and whole cuts of beef and pork | Cooked to 145°F |
| 5 | Raw ground meat | Cooked to 155°F |
| 6, bottom | Raw poultry | Cooked to 165°F: the highest, so the lowest shelf |
The rule behind the table: whatever is cooked to the highest temperature goes lowest. If chicken juice drips, it lands on the floor tray and not on the salad. Label the shelves themselves, so a delivery put away at six in the morning by someone new goes to the right place.
Other habits that make the sheet easier to keep:
- Everything in a covered container, off the floor.
- New deliveries behind old ones. That alone is most of "first in, first out".
- One place for each item. If the cheddar lives on shelf 2, it's counted once.
- Nothing stored in the box it was delivered in if the box is wet or torn.
A date on everything
| Made or delivered | Item | Left | Use by | Note |
|---|---|---|---|---|
| Nov 19, made | Cooked rice | 3 pans | Nov 25 | Day 7 |
| Nov 18, delivered | Fish fillets | 8 lb | Nov 21 | Use today |
| Nov 17, delivered | Chicken, raw | 40 lb | Nov 24 | |
| Nov 14, made | House dressing | 6 quarts | Nov 20 | Last day: use or discard |
Food made in the kitchen. Under the Food Code, ready-to-eat food that needs temperature control and is kept more than 24 hours is marked with a date, and it's used or thrown away within seven days at 41°F or below. The day it was made is day 1, so rice cooked on the 19th is good through the 25th. An opened commercial container is dated the same way from the day it was opened, and never past the maker's own date. The rule is set out in date marking under the food code.
Raw meat and fish carry the supplier's date, or your own shorter rule. This kitchen uses fish within three days of delivery.
No date, no use. A pan of cooked rice found behind the milk had no label. Nobody could say whether it was two days old or nine, so it went in the bin, and the inspector wrote it up. A roll of day-dot labels and a marker hanging by the door cost less than one pan of rice.
The walk-in's temperature has its own log: see hot and cold holding temperatures. The other rooms are in freezer inventory sheet and dry storage inventory template. This is general information, not legal advice: your local code sets the rules that bind you.
Get the sheet
Download the walk-in cooler inventory sheet. Four sheets: inventory in shelf order with value and REORDER, dated items with days left, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A walk-in changes every hour. Deliveries come at six, prep takes from it all morning, and the line raids it through service. A sheet filled in on Friday afternoon is a photograph. It can't tell the Tuesday cook that the fish at the back is on its last day, because by Tuesday nobody is reading Friday's sheet.
How TaroStack does it
TaroStack keeps the dates and brings them to you.
Each delivery is a lot with its use-by date, scanned from the case label where there is one.
Food you prep is a batch with its own date. Lot labels print with the code and the date, for every pan and container.
An alert comes before a date arrives, in the app and by email, with what the stock is worth.
Oldest first. Stock goes out first-expired-first-out by default.
Count on a phone, in the walk-in, with no signal. A count shows what each difference is worth, and every discard carries a reason.
| The job | Paper sheet | In TaroStack |
|---|---|---|
| What goes out of date tomorrow | Read every label | The expiry alert |
| A date on every pan | Tape and a marker | A printed lot label |
| Which case to open | The one in front | Oldest lot first |
| What was thrown away, and why | Not written down | Adjustments by reason |
TaroStack doesn't read the cooler's temperature or replace your temperature log. Stock, lots and expiry dates are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
