Skip to content

Dry Storage Inventory Template: A Shelf Map and a Count

A dry storage inventory template for a restaurant: items in shelf order with pars, lots and best-by dates, the Food Code's storage rule, and a count sheet.

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 20, 2026 · 6 min read

A dry storage inventory is a list of everything in the storeroom in the order it sits on the shelves. That order is the point. A list in shelf order can be counted in fifteen minutes by walking the room once, and a list in alphabetical order can't. Each row has the item in the unit you order it by, where it's kept, how many are on hand, the level to reorder at, and what it costs. A second sheet keeps the lot and best-by date of anything that goes stale, so the older bag gets opened first. The storeroom itself has a rule: under the FDA Food Code, food is stored in a clean, dry place, protected from splash and dust, and at least six inches above the floor. Below is a sheet for a made-up restaurant, and the file.

The short version

  • List items in the order you walk the room: rack, then shelf.
  • Count in the unit you order: bags, cases, jugs.
  • One place for each item, labeled on the shelf.
  • New stock behind old. Write the date received on the case.
  • Six inches off the floor, away from chemicals, allergens low and contained.
  • TaroStack keeps stock by place and lot, and builds the order from what's below par. More below.

An example sheet

Item Where kept On hand Reorder at Unit cost Value Status
All-purpose flour, 50 lb bag Rack A, shelf 1 6 4 $21.50 $129.00 OK
Penne, 20 lb case Rack A, shelf 2 2 2 $24.00 $48.00 REORDER
Crushed tomatoes, #10, case of 6 Rack B, shelf 1 5 4 $31.20 $156.00 OK
Canola oil, 35 lb jug Rack B, floor rack 3 2 $38.00 $114.00 OK
Black peppercorns, 5 lb Rack C, shelf 1 1 1 $42.00 $42.00 REORDER
Walnut halves, 5 lb Rack C, bottom shelf, bin 2 2 $31.00 $62.00 REORDER

Twelve rows in all, $1,067.10 of stock, with four to reorder: penne, chickpeas, peppercorns and walnuts.

Setting up the room

Rule Why
At least 6 inches off the floor The Food Code's storage rule; it also lets you mop under the racks
A clean, dry place, away from splash and dust The same section. Not under a leaking pipe or beside the mop sink
Chemicals in a different place entirely Never above or beside food
Heavy items low, light items high Fifty-pound bags at knee to waist height
Allergens on the bottom shelf, in closed bins So a spill of walnuts can't fall into the flour
One labeled place for each item An item with two homes gets ordered twice
Open bags into labeled, lidded bins With the product's name and the date opened

The code has exceptions to the six inches: packaged food on case-lot dollies or pallets, and cased cans, bottles and milk crates on a clean, dry floor. Your own code may differ in detail; FDA's adoption page showed 14 states on the 2022 edition when I read it. This is general information, not legal advice.

Dates: the older bag first

Received Item Lot Quantity Best by Note
Oct 13 All-purpose flour FL-25261 4 bags Mar 20, 2027 Use first
Nov 10 All-purpose flour FL-25304 6 bags May 1, 2027 Behind FL-25261
Sep 2 Walnut halves WN-25229 4 bags Dec 15, 2026 Short date: nuts go rancid
Aug 25 Olive oil, 3 L tin OO-L2511 6 tins Aug 1, 2027 Away from the dish machine's heat

"Dry" doesn't mean it keeps for ever. Nuts, whole-grain flours, oils and ground spices all go off, and the walnuts here have four weeks left. The sheet flags anything inside 45 days as USE FIRST.

The habit that makes it work is physical: when a delivery comes in, the new cases go behind the old ones, and somebody writes the date received on each case in marker. The sheet records it. The shelf enforces it.

Counting it

Walk the room in the sheet's order with the count sheet from the file. Count full units, and open ones as halves or quarters. Do it on the same day each week, before the order goes in. A full count with values, once a month, is what your food cost is worked from.

Two people are faster and more accurate than one: one counts and calls, one writes. Count what's there, not what should be.

From the count, the order is par less on hand: see restaurant order guide template. The walk-in and freezer have their own sheets, in freezer inventory sheet, and the whole kitchen in one file is commercial kitchen inventory template.

Get the template

Download the dry storage inventory template. Four sheets: inventory with value and REORDER, lots with days left, a count sheet in shelf order, 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

The sheet is right on count day. Between counts, the kitchen takes a bag of flour here and a case of tomatoes there, and nothing records it. By Thursday the "on hand" column is Monday's, and the order is placed from a glance at the shelf, which is how the walnuts got ordered twice.

How TaroStack does it

TaroStack keeps the storeroom's count moving between counts.

Stock by place. Rack A shelf 1 is a place. Each item's stock is held where it is, and the count sheet follows the places in order.

Receiving records the lot and the date. The oldest lot is used first by default, and an alert flags lots close to their best-by, with their value.

Making things takes stock off. Record a batch of soup or dough and the flour, tomatoes and oil it used come off, from the right lots. Units convert: bought by the 50 lb bag, used by the gram.

Counting on a phone, with no signal. In the storeroom, offline, catching up afterwards. TaroStack suggests what to count: what would cost most to get wrong, and what's had the most happen since anyone looked.

A reorder list in days of cover, ready when the order is due.

The job Count sheet In TaroStack
On hand between counts Monday's number Current, as batches are recorded
Which bag to open Whoever reads the dates First expired, first out
Walnuts going rancid Found too late An alert
What to order Par less a glance The reorder list

Stock, lots, counting and the reorder list 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

How should dry storage be organized?

Items in fixed, labeled places; heavy things low; new stock behind old; allergens low and contained; chemicals elsewhere; and food at least six inches off the floor.

How high off the floor does food have to be stored?

At least six inches under the FDA Food Code, with exceptions for packaged food on dollies or pallets and for cased cans and bottles on a clean, dry floor.

How often should dry storage be counted?

Weekly before ordering is common, with a full valued count each month. Your own food cost reporting sets the rhythm.

Sources

  1. FDA Food Code 2026, 3-305.11: food storage (a clean, dry location; not exposed to splash or dust; at least 6 inches above the floor) and 3-305.12 (prohibited areas) · read November 20, 2026
  2. FDA, Adoption of the FDA Food Code by State and Territorial Agencies (content current as of 10/29/2026) · read November 19, 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.