Skip to content
Inventory

Restaurant Inventory Shrinkage Calculator

Compare expected versus actual restaurant inventory to calculate shrinkage quantity, shrinkage value, shrinkage percentage, inventory accuracy, and adjusted loss after recovery — with optional cause breakdown for waste, spoilage, damage, and theft.

Inventory shrinkage formulas

Formula
Count mode:
  Shrinkage Qty = Expected Qty − Actual Qty
  Expected Value = Expected Qty × Average Unit Cost
  Actual Value = Actual Qty × Average Unit Cost
  Shrinkage Value = Shrinkage Qty × Average Unit Cost

Value mode:
  Shrinkage Value = Expected Value − Actual Value

Shared:
  Shrinkage % = max(0, Shrinkage Value) ÷ Expected Value × 100
  Adjusted Shrinkage = max(0, Shrinkage Value − Investigation Recovery)
  Inventory Accuracy = Actual Value ÷ Expected Value × 100

What it means

Shrinkage is the gap between what your records say should be on the shelf and what the count finds. Count mode is the right choice for a single SKU or category where you know units and average cost. Value mode is faster when you already reconciled dollars from a valuation or theoretical depletion report. Shrinkage percentage uses only positive loss for the benchmark — if the count finds more than expected, the signed shrinkage value goes negative but the percentage stays at 0% so overages do not look like a win on the loss bands. Optional cause fields split documented loss into waste, spoilage, damage, theft, and counting error; whatever remains is unexplained. Benchmark bands: excellent under 1%, good 1–2%, average 2–3%, high 3–5%, critical above 5% of expected inventory value.

Good to know

  • Expected and actual are measured for the same item, category, location, and count date.
  • Average unit cost reflects the same valuation method used for expected quantity.
  • Cause values are dollar amounts for the same period as the variance — they explain shrinkage, not replace it.

Ideal range

  • Expected inventory from theoretical recipes alone ignores real portion drift until you reconcile to a count.
  • Cause breakdown percentages assume cause dollars do not exceed positive shrinkage; unexplained is the remainder.
  • Benchmark bands are operational guidance — bar, retail packaged goods, and scratch kitchens run different norms.

Variables

ExpectedExpected inventory
The on-hand target from theoretical usage, perpetual inventory, or last count plus net receipts.
ActualActual inventory
The result of a physical count at the same point in time and the same unit or valuation basis.
Average Unit CostAverage unit cost
Weighted average cost per unit — converts quantity variance into dollars in count mode.
RecoveryInvestigation recovery
Product or cash recovered after a loss review. Subtracted before adjusted shrinkage is reported.

Assumptions

  • Inventory period is a reporting label; it does not change the core shrinkage math.

Limitations

  • A count overage (negative shrinkage) keeps the signed value but benchmarks as excellent with 0% loss.

Worked examples

Real numbers through the same formula this tool uses.

  1. 1
    Restaurant scenarioExample 1

    Weekly protein count — 5% shrinkage

    Expected 100 cases, actual 95, average cost $10 → shrinkage quantity 5, shrinkage value $50 on expected value $1,000 — 5% shrinkage, inventory accuracy 95%, high band.

  2. 2
    Restaurant scenarioExample 2

    Tight storeroom control — 0.5% shrinkage

    Expected 1,000 units, actual 995, unit cost $2 → $10 loss on $2,000 expected — 0.5%, excellent band, highly accurate.

  3. 3
    Restaurant scenarioExample 3

    Monthly dollar reconciliation — 3% average

    Expected inventory value $5,000, actual $4,850 → shrinkage value $150 — 3% of expected, average band, accuracy 97%.

  4. 4
    Restaurant scenarioExample 4

    Cause breakdown with partial recovery

    Expected $1,000, actual $800 → $200 shrinkage. Waste $40, spoilage $30, damage $20, theft $50, counting error $10 explains 75%; $50 remains unexplained. Recovery $50 → adjusted shrinkage $150.

How to use this calculator

Turn an expected-versus-actual count into shrinkage dollars, a percentage, and a cause split you can act on.

  1. Choose count or value mode

    Use Count when you have expected quantity, actual quantity, and average unit cost for one item or category. Use Value when you already have expected and actual inventory dollars from a valuation or depletion report.

  2. Enter expected and actual

    Expected is what the system or last reconciliation says should be on hand. Actual is what the physical count found. Both must cover the same SKU set and count window.

  3. Tag known loss causes (optional)

    Enter documented waste, spoilage, damage, and theft in dollars. Add counting error adjustments when a re-count explains part of the gap. Unexplained shrinkage is whatever is left.

  4. Subtract investigation recovery (optional)

    If staff or cameras recovered product or cash, enter the recovery amount. Adjusted shrinkage shows the net loss after that recovery.

  5. Read shrinkage %, accuracy, and benchmark

    Shrinkage percentage compares loss to expected inventory value. Inventory accuracy shows how close the count landed to the book figure. The benchmark band tells you whether to maintain routine controls or escalate.

  6. Follow the loss to the next tool

    High unexplained variance → tighten counts and compare to Stock Usage. Documented waste → Food Waste Calculator. Dollar impact on margin → Food Cost Percentage and Prime Cost.

What is inventory shrinkage?

Inventory shrinkage is the gap between what your records say should be on the shelf and what a physical count actually finds — the operational name for stock variance, loss, and count discrepancy.

  • Expected minus actual — nothing more complicated

    If the books expect 100 cases and the count finds 95, shrinkage is five cases. In dollars, that is five times average unit cost. Shrinkage does not assume theft or spoilage until you tag causes — it simply measures the variance you must explain or accept.

  • Why restaurants experience inventory shrinkage

    Kitchens move product through receiving, prep, line service, staff meals, and waste bins — often without scanning every ounce. Portion sizes drift, invoices do not match what arrived, coolers fail, and high-value items attract theft. Multi-unit transfers and partial cases make counts harder. Shrinkage is the scoreboard for how much slips through those cracks in a period.

  • Theft vs waste vs spoilage

    Waste is product you used or discarded in normal operations — trim, mistakes, plate returns. Spoilage is product that expired or was unfit before use. Damage covers breakage and equipment failure. Theft is intentional removal without payment. Counting error is a paperwork or count mistake, not real loss. This calculator keeps them separate so unexplained shrinkage — the gap none of those explain — stays visible.

  • Formula in plain terms

    Count mode: subtract actual quantity from expected, multiply by average unit cost for shrinkage value. Value mode: subtract actual dollars from expected dollars. Shrinkage percentage divides positive loss by expected value. Inventory accuracy divides actual by expected. Adjusted shrinkage subtracts any recovery from investigations.

  • Shrinkage vs stock usage

    Stock usage measures total consumption between counts — everything that left the shelf. Shrinkage compares a point-in-time expected balance to a physical count. Usage answers how much you burned through; shrinkage answers how much of what should remain is missing. Run Stock Usage for the period flow, then Shrinkage when theoretical and actual counts disagree.

  • Restaurant inventory control strategies

    Cycle counts on high-value SKUs, locked storage for spirits, receiving logs matched to invoices, standardized prep yields, daily waste sheets, and theoretical-versus-actual recipe reports. Pair physical discipline with software where it helps, but the count date and consistent units matter more than the tool brand.

How to reduce inventory losses

Shrinkage falls when expected inventory is honest, counts are disciplined, and causes are logged before they disappear into unexplained variance.

  • Inventory audit best practices — count on a rhythm

    Count high-shrink categories weekly — spirits, proteins, prep proteins — and full storeroom monthly. Use the same day of week, before deliveries, with two counters on high-value lines. Blind counts reduce bias. Reconcile to expected the same day; aging a count sheet lets shrinkage hide in daily usage noise.

  • Build expected from receipts and depletion, not hope

    Expected inventory should be last verified count plus net purchases minus POS-linked depletion or recipe theoretical usage. If expected is stale, shrinkage looks artificially high or low. Update expected when you receive, transfer, or 86 an item mid-period.

  • Split bar and kitchen shrinkage

    Blending bar spirits with dry storage averages away the category that usually leaks fastest. Run separate calculations — bottles and kegs count quickly and deserve their own benchmark trend.

  • Log waste and spoilage at the source

    A bin sheet at prep and a cooler walk before close turn shrinkage from a mystery into tagged causes. When waste and spoilage explain most of the gap, fix ordering and prep. When unexplained dominates, escalate security and portion checks.

  • Treat unexplained shrinkage as a project, not noise

    Unexplained above a few points of expected value warrants camera review, re-count, vendor credit checks, and recipe re-costing. Adjusted shrinkage after recovery shows whether the investigation returned product — if not, the net loss stays on the P&L.

  • Close the loop with food cost and prime cost

    Shrinkage is invisible on the menu but shows up in food cost percentage and prime cost. After each count cycle, feed dollar variance into those calculators so owners see margin impact, not just case counts.

Common mistakes

Errors that inflate, hide, or misread inventory shrinkage in restaurant operations.

  • Using an outdated expected balance

    Expected from last month while purchases kept flowing makes shrinkage look catastrophic. Rebuild expected to the count date or run value mode from a fresh depletion report.

  • Mixing cases, eaches, and weight in one count

    Entering expected in cases and actual in eaches doubles or halves shrinkage instantly. Pick one unit per calculation and convert invoices to match.

  • Subtracting waste from actual and again in causes

    Actual inventory is what is physically there — already net of waste removed from the shelf. Tagging waste in causes explains shrinkage; do not reduce the count by waste twice.

  • Ignoring negative shrinkage (overages)

    Finding more than expected is not free inventory — it usually means an unlogged delivery or count error on expected. Investigate overages; do not skip them because the benchmark shows excellent.

  • Applying invoice price instead of average cost

    Average unit cost should reflect weighted cost for the period, especially when prices moved mid-cycle. A single latest invoice price distorts shrinkage value on slow-moving SKUs.

  • Accepting high shrinkage because the neighbor runs worse

    Benchmark bands are guidelines for your own trend, not permission to leak. A move from good to high in two months is the signal — not whether you beat a competitor anecdote.

People also ask

Related operator questions about inventory variance and loss — angles beyond the core FAQ.

  • Is inventory shrinkage the same as inventory variance?

    In restaurant operations the terms are often used interchangeably: both describe expected minus actual. Variance sometimes emphasizes the count discrepancy; shrinkage emphasizes loss. This calculator reports both unit or dollar variance and shrinkage percentage.

  • How do I get theoretical inventory for a count?

    Start from your last verified count, add purchases and transfers in, subtract POS depletion or recipe-based theoretical usage and transfers out. Inventory systems with recipe mapping produce a theoretical on-hand report — export that as expected and compare to the physical count.

  • What shrinkage rate is normal for bar liquor?

    Bars typically tolerate less absolute dollars on beer kegs but watch spirits closely — partial bottles and pour variance add up fast. Run spirits as their own count mode calculation rather than blending with kitchen dry goods; your trend line is more useful than a generic rule.

  • Do staff meals count as shrinkage?

    If staff meals are not depleting inventory in your expected figure, they will appear as shrinkage at count. Either deduct meals in theoretical usage or log them as documented waste so they land in a cause line instead of unexplained.

  • Can recipe cost help explain shrinkage?

    Yes. Theoretical usage from scaled recipes shows what you should have consumed given sales. The gap between theoretical and actual depletion is a form of variance analysis. Recipe Cost Calculator builds the per-portion math; this tool measures what the count found against what you expected on hand.

  • How often should I cycle-count high-risk items?

    Weekly for spirits, proteins, and other high-value or high-theft SKUs; monthly for the full storeroom is a common baseline. Increase frequency after a shrinkage spike or menu change. Each cycle should use the same counting rules so results compare cleanly.

  • When should I enter investigation recovery?

    Enter recovery when product or cash is returned after a deliberate review — not when you hope to recover later. Partial paybacks from staff, vendor credits for shorts, or product found in a secondary storage area all reduce adjusted shrinkage. Recovery cannot exceed total shrinkage value.

  • Should counting errors reduce my shrinkage benchmark?

    Tag counting error separately when a re-count proves the first pass was wrong. It explains part of the gap but does not erase the need for count discipline — repeated counting error is a process failure, not a free pass on the benchmark.

  • Does shrinkage affect food cost percentage?

    Yes. Unrecorded loss inflates consumption relative to sales when counts feed COGS. Shrinkage dollars that never hit a waste log still raise food cost when ending inventory is lower than expected. After calculating shrinkage, run Food Cost Percentage to see the margin effect.

  • Why does an overage show 0% shrinkage but excellent benchmark?

    The tool uses max(0, shrinkage value) for the percentage so overages do not look like negative loss. Signed shrinkage value stays negative so you can investigate. Benchmark excellent on 0% loss does not mean ignore the overage — fix expected or receiving records.

  • How do multi-unit operators track shrinkage?

    Calculate per location with the same period label. Compare shrinkage percentage and unexplained share across sites with similar menus — one outlier usually points to local receiving, security, or portioning issues rather than brand-wide supplier problems.

  • Should I value inventory before calculating shrinkage?

    In value mode, expected and actual should share the same valuation basis — average cost, FIFO layer, or count-sheet extension. The Inventory Valuation Calculator helps put defensible dollars on ending counts before you reconcile variance.

  • Does shrinkage change how much safety stock I need?

    Shrinkage is loss, not demand variability — it should not inflate safety stock buffers. Fix the loss first. Safety Stock and Reorder Point calculators size buffers from usage and lead time; use Stock Usage for demand, not shrinkage percentage.

References & further reading

Related RestaurantMetric tools for measuring consumption, valuing stock, and closing margin — not third-party citations.

  • Shrinkage as the variance scoreboard

    Expected versus actual is the checkpoint that tells you whether usage, waste logs, and purchasing records tell a consistent story. Everything downstream — food cost, prime cost, ordering — inherits count honesty.

  • Restaurant Stock Usage Calculator

    Measure total consumption between counts and compare usage methods when shrinkage and purchases disagree.

  • Restaurant Inventory Valuation Calculator

    Put consistent dollar values on ending inventory before value-mode shrinkage reconciliation.

  • Restaurant Food Waste Calculator

    Quantify documented waste cost and reduction targets when waste cause lines dominate shrinkage.

  • Restaurant Purchase Order Calculator

    Right-size orders once usage and shrinkage trends show true demand.

  • Restaurant EOQ Calculator

    Balance order frequency and holding cost using reliable usage inputs.

  • Restaurant Safety Stock Calculator

    Size buffers from demand variability after shrinkage investigations stabilize loss.

  • Restaurant Reorder Point Calculator

    Set reorder triggers from daily usage, not from unexplained shrinkage spikes.

  • Restaurant Inventory Turnover Calculator

    Check how fast inventory cycles once accuracy improves on counts.

  • Restaurant Inventory Days Calculator

    Translate on-hand dollars into days of cover at current usage rates.

  • Food Cost Percentage Calculator

    See how shrinkage and consumption dollars flow into menu margin.

  • Prime Cost Calculator

    Combine food and labor cost to judge overall margin after inventory loss.

Frequently asked questions

You may also need

Complementary calculators that often pair with this workflow.

Continue exploring

More tools to browse after you finish this calculation.