Restaurant Inventory

Restaurant Inventory Shrinkage: How to Find Where the Missing Product Went

Why is your inventory off? Work out usage per item from your counts and invoices, compare it with what you sold, and trace the gap to receiving, portioning, waste, counting errors, or theft, with a worked example.

Proteus Kitchen22 min read
An empty stainless steel hotel pan sitting in a commercial kitchen

When your inventory is off, start with one item at a time. Take what you had at the last count, add what actually came in since, and subtract what's on the shelf now:

Usage = beginning count + received − ending count

That's how much of the item left the shelf. Compare it with how much should have left, based on what you sold and what you logged as waste or staff meals. The difference is your variance. Shrinkage is the part of that variance nobody can account for: product you paid for that left without being sold or written down.

Most of the time the missing product isn't missing at all. It's a counting mistake, a unit mix up, or an invoice that doesn't match the truck. Those are worth ruling out first, because they're fast to check and they're the most common. Then come the slower causes: heavy portioning, waste nobody logged, staff meals and comps, product moved to the bar, and, sometimes, theft.

Variance tracking sits at the end of the weekly loop in our complete guide to restaurant purchasing and inventory management. It uses the counts and receiving records you already keep for ordering, and asks one more question of them: where did it go?

In this guide

The example in this guide is illustrative. The items, counts, pack sizes, prices, and sales are made up to show the method. They aren't typical figures for any restaurant or distributor.

Shrinkage vs variance

People use these words loosely, so here's how this guide uses them:

  • Usage is how much of an item left the shelf between two counts, from the formula above.
  • Expected usage is how much should have left, based on what you sold plus anything you recorded on purpose: waste, staff meals, comps, transfers.
  • Variance is usage minus expected usage. It can be positive (more left than should have) or negative (less left than should have, which usually means a counting or receiving error).
  • Shrinkage is the unexplained loss that's left after you've fixed the errors and accounted for everything you logged.

The distinction matters because a big variance on Monday morning doesn't mean you lost that much product. Most of it often turns out to be paperwork. The goal of an investigation is to shrink the unexplained part down to something small and steady, and to know what's in it.

How to work out usage for one item

You need three numbers per item, all in the same unit.

NumberWhere it comes fromWhat to watch
Beginning countYour last count of this itemSame unit, same storage areas as today's count
ReceivedWhat actually came in the back door, from the invoices, checked against your purchase ordersBilled isn't the same as delivered. Subtract shorts and refused product
Ending countToday's countCount before the day's deliveries, the same time each period

Then work out expected usage. There are three ways to do it, from simplest to most work:

  1. Compare with recent weeks. If you used 78, 82, and 75 lb of chicken thighs the last three weeks and sales were steady, 112 lb this week needs an explanation. This needs nothing but your counts.
  2. Use units sold for one to one items. Some items map straight onto a menu item: one patty per burger, one portion cut steak per steak entrée. Pull the number sold from your POS product mix report and add what you logged as waste, staff meals, and comps.
  3. Use recipes for everything else. Multiply each dish sold by the amount of the item in its recipe. This is the item level version of theoretical food cost, covered in our guide to actual vs theoretical food cost. It's the most accurate and the most work, so most kitchens start with methods 1 and 2.

To compare items of different sizes, look at the variance both ways:

Variance (units)  = usage − expected usage
Variance (%)      = variance ÷ expected usage × 100
Variance ($)      = variance × cost per count unit

The dollar figure is what tells you where to spend your time. Ten missing heads of lettuce and five missing ribeyes are both "off," but they're not the same problem.

Which items to track

You don't need a variance for every item in the building. Pick the ones where a gap costs real money or keeps happening:

  • The most expensive proteins, especially portion cut steaks, seafood, and anything sold by the piece.
  • Items that are easy to walk out with or eat on shift: shrimp, cheese, high end charcuterie, and anything that comes individually wrapped.
  • Items you keep running out of even though the order didn't change.
  • Items the bar shares with the kitchen, like citrus, cream, and juices.

Ten to twenty items is plenty to start. Most kitchens already count these at every order, so the beginning and ending counts are on the sheet. If you need a sheet built around your shelves, our guide to doing a restaurant inventory count walks through setting one up, and there's a free inventory count sheet template you can download and adapt.

The six places missing product usually goes

Each cause leaves a different trace in the numbers. Knowing the trace helps you check the right thing first.

CauseHow it usually shows upWhere to check
Receiving errorsA one time jump in usage the week of a particular deliveryInvoice vs purchase order vs what was signed for
Count errors and unit mix upsA spike one week and an opposite swing the next, or usage that's impossibly lowThe count sheet units and last period's count
PortioningA steady gap every week that grows with salesPortion specs, scales on the line, yield
Unlogged waste and spoilageGaps on perishables, often after slow days or a cooler problemWaste log, trash, the back of the walk in
Staff meals, comps, and transfersGaps that line up with family meal days, events, or bar usageStaff meal log, POS comp report, transfer sheet
TheftA steady gap on a few high value, portable items, with the other causes ruled outAccess, receiving, and closing routines

1. Receiving errors

If the invoice says 3 cases and 2 came off the truck, your "received" number is 1 case too high, and that case looks like it vanished from the shelf. The same goes for shorts that never got credited, substitutions in a different pack size, and catch weight items that came in lighter than billed. Anything that slips past the back door turns into a variance later. Our guide to handling shorted deliveries and substitutions covers how to catch and credit these at the door.

2. Count errors and unit mix ups

A count error can push the variance either way. Write down 3 cases on a line that counts bags, and the beginning count is too low, so usage looks impossibly small. Miss a case on the bottom shelf of the reach in, and the ending count is too low, so usage looks too high. Count errors are usually the easiest cause to spot, because they make the numbers jump in one week and swing back the next.

3. Portioning

A steak that's portion cut by the vendor can't be over portioned, but shrimp, cheese, fries, and anything scooped or weighed on the line can. An extra half ounce per plate doesn't show up on any single ticket. Over a week it adds up to a steady gap that grows when you're busy. If you trim in house, a drop in trim yield looks the same way. Our yield guide shows how much a few ounces of extra trim per piece costs over a year.

4. Unlogged waste and spoilage

Dropped plates, refires, burnt sheet trays, a case of berries that went soft, the end of a sauce that got tossed at close. All of that is real usage. If nobody writes it down, it looks the same in the numbers as product that walked out the door. Spoilage is also the easiest of these to prevent: dating product and rotating stock first in, first out keeps old cases from dying in the back of the walk in.

5. Staff meals, comps, and transfers

Family meal, the burger the dish crew gets at the end of the night, a comped dessert, cream sent to the bar for a cocktail, product lent to a sister location. None of these are losses, but if they aren't recorded they show up as shrinkage.

6. Theft

Theft does happen, and it tends to show up as a steady gap on a few items that are valuable and easy to carry. But it's the last cause to conclude, not the first. Rule out the other five before you treat a variance as theft, and focus your response on controls (who receives, who has keys, what's locked, how often it's counted) rather than on accusing anyone from a spreadsheet. If you suspect a specific person, talk to your HR advisor or attorney before acting.

How to investigate a variance, step by step

Work from the cheapest, most likely explanation to the most expensive one. Most variances are solved by step 3.

  1. Recount the item. Check every place it could be: walk in, reach ins on the line, the freezer, the dry storage overflow, prep containers, the bar. If the recount is different, use it and redo the math.
  2. Check the units on both counts. Look at last period's line as well as this one. A count written in cases on a sheet that counts bags, or a partial case written as a whole, explains a lot of "missing" product.
  3. Check what was received. For each delivery in the period, put the purchase order, the invoice, and the signed delivery side by side. Use what actually arrived as your "received" number, and chase a credit for anything billed but not delivered. Our guide to tracking restaurant purchase orders shows how to reconcile an order against the delivery and invoice.
  4. Add up what was logged. Waste log, staff meal log, POS comps, and transfers to the bar or another location. Add them to expected usage. Check whether your POS product mix report already includes comped items, so you don't count them twice.
  5. Spot check portioning. For items portioned on the line, weigh ten portions during a normal service. If they average 6.5 oz on a 6 oz spec, that's an 8% gap on its own.
  6. Tighten receiving. If step 3 found anything, the fix is at the back door: count cases and check weights before signing, mark shorts on the invoice, and have one trained person sign for each delivery.
  7. Count high risk items more often. For any item with a variance you can't explain, count it daily, or at every shift change, for two weeks. Daily counts narrow the gap down to a day, and often a shift, which usually points straight at the cause.
  8. Review access and storage. If a gap on a valuable item survives all of the above, look at who receives, who closes, where the item is stored, and whether it needs to be locked or kept only in the walk in.

Worked example: four items, one week

A neighborhood restaurant counts its high value items every Monday at 9:00 AM, before deliveries. The kitchen manager runs the variance on four of them.

ItemCount unitPack sizeCost per count unit
Burger patties, 6 ozeachcase of 40$1.60
Chicken thighs, bonelesslb40 lb case$3.10
Shrimp, 16/202 lb bagcase of 5 bags$22.00
Ribeye, 14 oz portion cuteachcase of 12$16.50

Step 1: usage from the counts and invoices

ItemBeginning countReceived (per invoices)Ending countUsage
Burger patties6280 (2 cases)38104
Chicken thighs22 lb120 lb (3 cases)30 lb112 lb
Shrimp3 bags10 bags (2 cases)11 bags2 bags
Ribeye1824 (2 cases)1230

Each row is beginning + received − ending. For patties: 62 + 80 − 38 = 104.

Step 2: compare with expected usage

ItemUsageExpectedVarianceVariance %Variance $
Burger patties10488 burgers sold+16+18.2%$25.60
Chicken thighs112 lb78.3 lb (average of last 3 weeks: 78, 82, 75)+33.7 lb+43.0%$104.37
Shrimp2 bagsabout 14 bags (last 3 weeks: 13, 15, 14)−12 bags−85.7%n/a
Ribeye3024 sold + 1 refire on the waste log = 25+5+20.0%$82.50

The chicken figures use the unrounded three week average (78.33 lb), so 33.67 lb × $3.10 = $104.37.

All four look bad. Here's what the investigation found.

Shrimp: a unit mix up on last week's count

Usage of 2 bags in a week when the kitchen normally goes through about 14 is impossible, so the kitchen manager started with the count sheet. Last Monday's line said "3." The person counting had counted cases, not bags. Three cases is 3 × 5 = 15 bags.

Corrected usage:  15 + 10 − 11 = 14 bags   (right in line with recent weeks)

Nothing was missing. This is also why the next week's shrimp variance would have looked huge in the other direction if nobody had caught it.

Chicken thighs: billed for a case that never came

The order log showed 2 cases ordered for Thursday. The invoice billed 3, and the receiver had signed it without counting. The walk in and the prep records only ever had 2 cases.

Actual received:   2 cases = 80 lb
Corrected usage:   22 + 80 − 30 = 72 lb   (a little under recent weeks)
Credit to request: 40 lb × $3.10 = $124.00

The variance wasn't lost chicken. It was $124 the restaurant would have paid for nothing if nobody had checked.

Burger patties: staff meals nobody wrote down

The POS showed 88 burgers sold, and comps were already included in that number on this restaurant's report. Asking around turned up a Thursday family meal that used 10 patties, and the waste log had 2 that were dropped.

Expected with logs:  88 + 10 + 2 = 100
Usage:               104
Unexplained:         4 patties × $1.60 = $6.40

Four patties in a week, about 4% over expected, is the kind of small, steady gap most kitchens live with. The fix is to log family meal going forward so next week's number is cleaner, then keep watching it.

Ribeye: five steaks nobody can account for

The kitchen manager recounted the ribeye and got the same 12. The invoices matched the purchase orders, and the receiver had counted both cases at the door. The steaks are portion cut, so portioning isn't the issue. There was one refire on the waste log and no staff meal used ribeye.

Unexplained:          5 steaks × $16.50 = $82.50 this week
If it kept up a year: $82.50 × 52 = $4,290

This is the one to act on. The kitchen manager:

  • Counts ribeye at open and close every day for the next two weeks, to narrow the gap to a day or a shift.
  • Asks the line to log every refire and every steak that goes on a comp, even if the POS records the comp.
  • Moves ribeye out of the line reach in at close, so the only overnight stock is in the walk in.
  • Checks the previous four weeks of counts to see whether the gap is new or has been there all along.

If daily counts show the gap is on specific shifts, that's information for the next conversation, not a conclusion.

What the week actually looked like

ItemFirst varianceAfter the investigation
Burger patties+16 ($25.60)+4 unexplained ($6.40)
Chicken thighs+33.7 lb ($104.37)none, plus a $124.00 credit to chase
Shrimp−12 bagsnone, count corrected
Ribeye+5 ($82.50)+5 unexplained ($82.50), under review

Four alarming numbers turned into one real problem, one small one, and a credit. That's a typical shape for a variance check. If you calculate food cost from your counts and invoices, the same fixes (the corrected shrimp count and the chicken credit) change that number too.

The logs that explain most of the gap

You can't account for product nobody wrote down. Three short logs cover most of it, and they can live on a clipboard by the walk in.

LogWhat to recordWho fills it in
Waste logDate, item, quantity and unit, reason (dropped, burnt, spoiled, expired, refire), initialsWhoever throws it out, at the time
Staff meal logDate, items and quantities used, initialsWhoever cooks family meal
Transfer sheetDate, item, quantity, where it went (bar, another location, event)Whoever moves it

Keep the reason column honest. "Spoiled" on the same item every week points to an order quantity that's too big, and our guide to inventory turnover and slow movers covers how to fix the par behind it. "Refire" every weekend points to a training or ticket problem. Either way, a log that explains the variance is also telling you what to fix next.

What cooks and chefs can do

Variance work usually lands on a manager's desk, but most of the fixes happen on the line.

  • Write it down when you toss it. A five second note on the waste log saves an hour of guessing on Monday.
  • Use the scale. Portion shrimp, cheese, and proteins by weight, not by eye, especially when it's busy.
  • Count what you said you counted. If the sheet says bags, count bags. If something's somewhere unusual, say so on the sheet.
  • Check the delivery before you sign. Count the cases, look at the weights on catch weight items, and write any shorts on the invoice.
  • Say something when product looks wrong. Smaller steaks, wet shrimp, or a case that's lighter than usual is worth flagging the same day.

Common mistakes

  • Using billed quantities as "received." Use what came in the door, and chase the credit for the difference.
  • Jumping to theft. Recount, check units, and check invoices first. Most gaps are paperwork.
  • Investigating every item. Start with the ten to twenty items where a gap costs real money.
  • Comparing periods that don't match. Counts on different days, or before one delivery and after the next, make usage swing for no real reason.
  • Ignoring negative variances. Usage that's too low is a count or receiving error, and it usually means next week will look too high.
  • Counting comps twice. Check whether your POS product mix already includes comped items before adding them again.
  • Logging waste only when it's convenient. A waste log that's half filled in is worse than useless, because it makes the unexplained gap look like theft.
  • Judging from one week. Look for gaps that repeat before changing anything big.

FAQ

What is inventory shrinkage in a restaurant?

It's product you paid for that left your shelves without being sold or recorded, like unlogged waste, over portioning, untracked staff meals, or theft. You find it by comparing each item's usage from your counts and invoices with how much should have been used, then removing anything you can explain.

How do I calculate inventory variance for one item?

Work out usage first: beginning count plus what you received minus ending count. Then subtract expected usage, which is the amount sold plus anything you logged as waste, staff meals, comps, or transfers. Divide the difference by expected usage for a percentage, and multiply it by the cost per count unit for a dollar figure.

Why is my inventory off when nothing seems missing?

The most common reasons are a counting mistake, a count written in the wrong unit, a delivery that was billed but not fully delivered, and a count taken at a different point in the delivery cycle than last time. Recount, check the units on both counts, and compare each invoice with the purchase order and what actually arrived.

What's an acceptable inventory variance?

There isn't a single standard that fits every kitchen. Track your own high value items for a few weeks and see what a normal week looks like. A small gap that stays steady is usually waste and portioning. A gap that suddenly grows, or one on an expensive item that never goes away, is worth investigating.

How often should I check variance?

Weekly on your highest value items is a good starting point, using the counts you already take for ordering. For any item with a gap you can't explain, count it daily for a couple of weeks to narrow down when it's happening.

Is variance the same as food cost?

No, but they're related. Food cost totals everything you used across all items and divides it by sales. Variance looks at one item at a time and compares what you used with what you should have used. Fixing variances, like a miscounted line or a missing credit, also makes your food cost number more accurate.

Keeping the counts and receiving records straight with Proteus Kitchen

Proteus Kitchen doesn't calculate variance or shrinkage, and it doesn't connect to your POS, so units sold still come from your POS reports. What it does is keep the records a variance check depends on in one place.

Each inventory item has its vendor, category, storage location, order unit, and, if you count it differently, its count unit and the conversion between them, which is exactly where the shrimp mix up above started. Each item also has a notes field, a good place to record a portion spec or a note to count it daily. Your purchase orders and purchasing history live in Proteus too, and you can filter past orders by vendor, status, and date range when you're checking an invoice against what you ordered.

If your item list and vendors already live in a spreadsheet, Free Restaurant Setup covers bringing them into Proteus, and there's a 30 day free trial below.

Next step: run a variance on five items this week

  1. Pick your five most expensive items, or the five that keep running out. Our guide to why restaurants run out of ingredients covers the ordering side if that's the problem.
  2. Make sure each one has a single count unit on the count sheet.
  3. At your next count, work out usage for each: beginning count plus received minus ending count.
  4. Compare it with what you sold, plus anything on the waste and staff meal logs.
  5. For any item that's off, go through the investigation steps above in order, and start counting it daily if the gap survives step 4.