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.
