Skip to content

Walk-In Cooler Inventory Sheet: Shelf by Shelf

A walk-in cooler inventory sheet in shelf order: ready-to-eat on top, raw poultry at the bottom, a date on everything, what to use first, and a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

Questions people also ask

What is the correct order for storing food in a walk-in cooler?

Ready-to-eat food on the top shelf, then dairy and whole produce, then raw fish and whole cuts of meat, then ground meat, with raw poultry on the bottom. The order follows cooking temperature.

How long can prepared food stay in a walk-in cooler?

Under the FDA Food Code, ready-to-eat food made in the kitchen and held more than 24 hours is date marked and kept seven days at most at 41°F or below, with the day it was made as day 1.

How do you keep a walk-in cooler organized?

Label the shelves, give each item one place, put new deliveries behind old ones, date every container, and write the inventory sheet in shelf order so counting is a walk down the rack.

Sources

  1. FDA Food Code 2026, 3-302.11: raw animal foods separated from ready-to-eat food and from each other during storage · read November 20, 2026
  2. FDA Food Code 2026, 3-501.16 (cold holding at 41°F or below) and 3-501.17 (ready-to-eat food held more than 24 hours is date marked: 7 days at most at 41°F, the day it was made being day 1) · read November 21, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.