A deli's inventory has two clocks. Unopened, a log of turkey breast is good until the maker's date, weeks away. Opened and on the slicer, it has seven days. So a deli inventory spreadsheet needs a row for each meat and cheese by the pound, with what's on hand, a par to reorder at and the cost a pound, and then a second sheet where an opened log gets its own row and its own date. The same goes for anything you make: potato salad has a use-by from the day it's mixed. The sheet below is filled in for a made-up neighborhood deli and free to download.
The short version
- Meats and cheeses in pounds, bread in eaches, supplies by the case.
- A par for each: what you sell between deliveries, and a day more.
- An opened log gets a new row with the date it was opened and a use-by seven days out.
- House-made salads and spreads get a lot and a use-by the day they're made.
- TaroStack uses the lot that's due first and flags what's about to pass its date. More below.
An example sheet
Six of the example deli's ten rows, on a Tuesday before the distributor's truck:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Turkey breast, oven roasted | lb | 28 | 20 | $5.90 | $165.20 | OK |
| Ham, off the bone | lb | 16 | 20 | $4.75 | $76.00 | REORDER |
| Roast beef, top round | lb | 12 | 10 | $8.40 | $100.80 | OK |
| Genoa salami | lb | 9 | 6 | $6.95 | $62.55 | OK |
| Provolone | lb | 14 | 10 | $4.10 | $57.40 | OK |
| Swiss | lb | 7 | 10 | $5.25 | $36.75 | REORDER |
Hoagie rolls, potato salad made in the back, pickles and deli paper are the other four. The walk-in, the case and the dry shelf hold $709.92. Ham and Swiss are under par, so they go on tomorrow's order.
Setting a par
Par is the amount you want on hand right after a delivery lands, or the level you won't go below; delis use the word both ways. On this sheet it's the reorder level. The deli sells about 5 lb of ham a day and the truck comes twice a week, three or four days apart. Four days of selling is 20 lb. When the count before the order call is under 20, ham goes on the order.
Slow movers want a lower par than feels safe. Nine pounds of salami is a week's worth here. Par it at ten and you'll open a second log just as the first one's seven days run out.
Opened is a different lot
| Date | Item | Lot | Quantity | Use by |
|---|---|---|---|---|
| Nov 9 | Turkey breast, oven roasted | TB-309114 | 40 lb | Dec 20 (unopened) |
| Nov 16 | Turkey breast, oven roasted | TB-309114 | 9 lb | Nov 22 (opened Nov 16) |
| Nov 17 | Potato salad, made here | PS-1117 | 24 lb | Nov 23 (made Nov 17) |
| Nov 10 | Provolone | PV-51702 | 20 lb | Jan 15, 2027 |
The two turkey rows are the same lot from the maker. One is the sealed logs in the walk-in. The other is the log that went on the slicer on November 16. Counting the day it was opened as day one, the seventh day is November 22. The potato salad made on the 17th runs to the 23rd.
That seven-day count is the FDA Food Code's date marking rule for ready-to-eat food that needs refrigeration, held at 41°F or below, and most states use it. Your own health department has the last word, and the details (freezing, mixing old with new) are in date marking under the Food Code.
The sheet counts the days left on each row and says USE FIRST at three days or fewer. Read that column every morning. Anything flagged goes to the front of the case, into today's special, or onto the catering tray.
Keep the maker's lot number, too. It's printed on the case and on the log's label. If a meat recall names lot TB-309114, you'll know in a minute whether it's in your walk-in, and since the slicer touched it, what else was sliced that day.
Get the spreadsheet
Download the deli inventory spreadsheet. Four sheets: the inventory with value and REORDER, lots and open dates with days left, a count sheet that fills itself, 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 deli slices to order all day. Nobody weighs what's left of each log at close and types it in. So the sheet gets a count twice a week at best, and between counts the only thing tracking the turkey is whoever opened it remembering when. Margins on a sandwich are thin enough that the forgotten log is the profit: the arithmetic is in deli profit margin.
How TaroStack does it
TaroStack keeps both clocks.
Each delivery is a lot with its date. Receive the case with the maker's lot and date, typed or scanned from the case label.
What you make is a batch. Potato salad is a recipe. Record a batch of 24 lb and the potatoes, mayonnaise and eggs come off stock, and the batch gets its own lot and a use-by.
Oldest first, flagged early. Stock is used first-expired-first-out by default, and an alert tells you which lots are close to their date and what they're worth, while they can still go in a special.
Counting on a phone. Count the walk-in with no signal and it sends itself later. It suggests what to count first: the costly, fast-moving rows.
Waste with a reason. A write-off says why (expired, spoiled, damaged), so you can see what forgotten logs cost in a month.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which log to use | Whoever remembers | The lot due first |
| What's close to its date | Read the sheet each morning | An alert |
| The order | Compare counts to par by eye | A reorder list |
| What was thrown out | Usually nothing written | Adjustments with reasons |
Lots, expiry, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
