Skip to content

Deli Inventory Spreadsheet: Meats, Cheese, Open Dates

A free deli inventory spreadsheet: meats and cheeses by the pound, the date each log was opened, house-made salads with a use-by, par levels and reorders.

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

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.

Questions people also ask

How do you do inventory for a deli?

Weigh what's left of each meat and cheese, count bread and supplies, and compare each to its par before the order call. Twice a week, on the mornings before deliveries, works for most.

How long is deli meat good after opening?

For a food business under the Food Code, seven days at 41°F or below, counting the day it was opened as day one.

What is a par level in a deli?

The amount of an item you keep so you don't run out before the next delivery: about what you sell between trucks, and a day more. A full shop's numbers are in sandwich shop business plan.

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.