How to Calculate Inventory Shrinkage and Cut Losses
Merchant Education & Growth

How to Calculate Inventory Shrinkage and Trace Where the Stock Went

Learn how to calculate inventory shrinkage with a worked example, then sort theft from receiving and POS errors so you fix the right problem.

Gloved hand holding a handheld barcode scanner beside stacked boxes in a warehouse aisle

Photo: Pixabay

On this page 7 sections
  1. How to Calculate Inventory Shrinkage in Three Steps
  2. The Average Shrinkage Rate Is Old Data From Big Chains
  3. Retail Shrinkage Causes: Theft Is Only Part of the Count
  4. Read the Pattern Before You Blame Theft
  5. Catching Vendor and Receiving Errors at the Back Door
  6. Fixing Admin and Pricing Mistakes in Your POS
  7. Reduce Inventory Shrink One Category at a Time

Key takeaways

  • Value the shortfall on the same basis as sales. In the example, dividing a cost shortfall by retail sales cut the store's shrink rate in half.
  • The 1.6% average people still quote is fiscal 2022 data from large chains. NRF has since stopped publishing its shrink survey.
  • Large retailers blamed 27% of their shrink on process and control failures. Check receiving and POS records before you assume theft.
  • Rank categories by shrink dollars at cost, fix one at a time, and recount after each change.

Inventory shrinkage is the difference between the stock your records say you have and the stock you actually count. To calculate inventory shrinkage, subtract the physical count from your book inventory to get the shortfall. Value that shortfall at retail, divide it by net sales for the same period, and multiply by 100. The result is your shrink rate. It covers every item that left the store without being paid for or without being recorded correctly.

Doing the math takes about ten minutes. Finding the cause takes longer, and the cause decides the fix. A missing bottle of bourbon might be shoplifting. It might also be a distributor short-ship, or a cashier who rang the bottle under a generic liquor key. Each of those needs a different response, and a camera fixes only one of them.

How to Calculate Inventory Shrinkage in Three Steps

  1. Establish book inventory. This is what your records say should be on hand: beginning inventory, plus purchases received, minus the cost of goods sold. If you keep your books at retail, subtract net sales and recorded markdowns instead. A retail POS with inventory tracking can produce this figure, but only if every delivery was received into the system and every markdown was entered.
  2. Count what is physically there, both on the sales floor and in the back room. Book inventory minus the count is your shrink in dollars.
  3. Convert the dollars into a rate using the formula below.

Shrink rate formula: (book inventory − physical count, valued at retail) ÷ net sales for the period × 100

Most mistakes come from mixing bases. Sales are recorded at retail, so the shortfall has to be at retail as well. The supplier-education firm 8th & Walton puts the rule simply: calculate the loss and the sales both at cost or both at retail. If your inventory is valued at cost, convert the shortfall by dividing it by your cost ratio, which is cost as a share of the selling price. If you divide a cost figure by a retail figure, the rate comes out too low.

Some retailers use a different formula: shrink divided by book inventory rather than by sales. That convention is also valid, but it measures something else. It tells you what share of your stock disappeared, while the sales-based rate tells you how big the loss is compared with your business. Pick one, use it every period, and remember that published industry averages are stated as a percentage of sales.

Worked Example: One Boutique, One Quarter

Every number in this example is illustrative. An apparel boutique closes its quarter and posts all sales and receiving. The physical count comes in $900 short of book inventory at cost. The store prices at keystone (double its cost), so its cost ratio is 50%. Net sales for the quarter were $100,000, and the net profit margin is 5%.

StepCalculationResult
Shortfall at retail$900 ÷ 0.50$1,800
Shrink rate (correct basis)$1,800 ÷ $100,000 × 1001.8%
Shrink rate (wrong basis: cost over retail)$900 ÷ $100,000 × 1000.9%
Sales needed to earn back the lost profit$900 ÷ 0.05$18,000
Same loss every quarter for a year$3,600 ÷ 0.05$72,000 in sales

The wrong-basis rate is exactly half the true rate, so a growing problem looks like a small one. The profit impact uses the cost figure because cost is what the store actually paid for goods it can no longer sell. At a 5% margin, a $900 quarterly loss means the store has to bring in $72,000 of extra sales each year just to stay even. A tighter receiving routine or a fitting-room tag count usually costs far less than that.

All of this depends on an accurate count. If you don't have a routine yet, start with our guide to running a physical inventory count and cycle counts.

The Average Shrinkage Rate Is Old Data From Big Chains

The figure most people quote comes from the National Retail Federation. Its National Retail Security Survey 2023 found that the average shrink rate rose to 1.6% in fiscal 2022, up from 1.4% in fiscal 2021. Today, that is the most recent number available. In 2024, NRF announced it would not publish its annual shrink report after more than three decades of producing it. The group's newer retail-theft research doesn't estimate theft- or fraud-related losses at the retailers surveyed. So a "current average" quoted today is either fiscal 2022 data or somebody else's estimate.

It also matters who answered the survey. According to the Loss Prevention Research Council's summary, senior loss-prevention and security executives completed the 2023 edition. They represented 177 retail brands with $1.6 trillion in annual sales and more than 97,000 locations. That average tells you very little about a single-location liquor store or a two-person boutique.

Your own trend is a better benchmark. If your rate climbs from one count to the next, look into it, even if it sits below 1.6%. Break the number down by category, too. A grocer's store-wide rate can look fine while fresh meat or razor blades run far worse, and the fixes come from that category view. Margin also changes the stakes. Grocery and beer-and-spirits stores run on thin margins, so each point of shrink costs them more in sales to recover than it costs a boutique pricing at keystone.

Keep known loss separate from unknown loss. Spoiled produce and expired dairy are known losses when you record them as waste in the POS with a reason code. If you don't record them, they turn up as unexplained shrink at the next count, and you end up chasing a thief who doesn't exist.

Retail Shrinkage Causes: Theft Is Only Part of the Count

In fiscal 2022, retailers in the NRF survey blamed 36% of shrink on external theft and 29% on employee theft. Another 27% came from process and control failures and errors, 6% from unknown sources and 1% from other sources, per the LPRC summary. These were chains with loss-prevention departments, and more than a quarter of their losses still came from their own processes. No comparable figure exists for small stores. Treat paperwork as a suspect from the start.

External Theft

This bucket covers shoplifting by individuals and organized crews, plus return fraud. Each store format loses goods in its own way. Apparel stores lose garments in fitting rooms and to tag switching. Liquor stores lose small, high-value bottles from end caps near the door. Grocers tend to lose health-and-beauty items and infant formula.

Fixes should follow the product. Count garments into and out of fitting rooms, and cap how many items a shopper can take in. Keep the costliest bottles behind the counter or in locked cases where the cashier can see them. For returns, require a receipt or a lookup by the original card, and refund to the original payment method. A refund going to a different card than the one used for the purchase deserves a manager's review. Our guide to processing post-holiday returns without a chargeback spike covers the refund side in more detail.

Internal Theft

Employee theft takes several forms. In sweethearting, a cashier rings up a friend's items at a discount or doesn't ring them at all. Other employees process fake refunds or void a sale after the customer has paid, and some product simply leaves through the back door. Accountability is what stops it: give every employee a unique login, require manager approval for refunds and voids, and have someone read the reports every week. Our walkthrough of POS exception reports that flag void and discount abuse shows what normal activity looks like. Cash shortages are a separate problem from inventory shrink, and dual-control cash handling procedures address them.

Vendor and Administrative Errors

Vendor errors include short shipments, wrong items, invoice prices that don't match the purchase order, and credits that never arrive. Administrative errors are mistakes inside your own systems, such as deliveries never received into the POS or items rung under the wrong SKU. Both create paper shrink: a count shortage where no merchandise actually left the store. A short count does not prove theft. An overage, where you count more than the books show, is also worth tracing, because it often means a sale was rung against the wrong item.

Read the Pattern Before You Blame Theft

Where a shortage shows up usually points to its cause. Use this table to decide what to check before you buy a camera or confront an employee.

What the count showsLikely sourceCheck first
Shortages concentrated in one vendor's itemsReceiving or vendor errorDelivery receipts against invoices and the POS receiving log
A shortage in one item with a matching overage in a similar item or sizeWrong SKU, variant or PLU at checkoutItem-level sales history for both items
Small, high-value items missing near exits or fitting roomsExternal theftMerchandise placement and fitting-room counts
Losses clustered on shifts with heavy voids, refunds or open-key useInternal theft or keying errorsException reports by employee login
Perishables short, with little waste recordedUnrecorded known lossWaste log and reason codes
A store-wide shortage after a month when receiving fell behindPaper shrinkInvoices not yet received into the POS

Catching Vendor and Receiving Errors at the Back Door

In many stores, whoever happens to be free signs for the delivery, and that is where control slips. Check every delivery against the purchase order and the invoice before anyone signs. Count the cases, then open a sample to confirm the item and quantity inside. Schedule receiving hours so trucks don't arrive during a rush. If something is short, note it on the delivery receipt and have the driver sign the correction before leaving. Getting credit for a shortage found after the truck is gone is much harder.

Receive each invoice into the POS the same day. When merchandise sits unreceived in the back room, book inventory is wrong in both directions. Shelves look short until the paperwork catches up, and if two people later enter the same invoice, the stock gets counted twice. Compare invoice costs with your agreed costs while you're at it. An increase of a few cents per unit never shows up as missing stock, but it erodes margin the same way shrink does.

Grocery and convenience stores have an extra exposure in direct store delivery (DSD), where vendors such as bread and beverage suppliers stock their own shelves and pull stale product. Count what each DSD vendor brings in and takes out, then reconcile their credit memos against your own log of stales. Liquor stores should watch for case-versus-bottle confusion on distributor invoices. A quantity of six can mean six bottles or six cases, and receiving in the wrong unit throws book inventory off by dozens of bottles on a single line.

Fixing Admin and Pricing Mistakes in Your POS

Open-department and open-price keys are the biggest source of setup-driven shrink. When a cashier rings a bottle as a generic item at a typed-in price, the sale is recorded but that bottle's inventory never goes down, so it shows up missing at the count. Limit who can use those keys, and review how often they're used each week.

Unit-of-measure errors come next. If a product is set up as a multipack but you sell singles, or the other way around, every count of that item will be off. Variant mistakes do similar damage in apparel: ring a medium sweater as a large, and one size shows an overage while the other shows a shortage. Produce lookup (PLU) codes cause the grocery version of the problem, for example when a cashier keys conventional bananas for an organic bunch. Two quieter errors also add up. Out-of-date costs in the POS make shrink at cost wrong even when unit counts are right. Damaged returns put back on the shelf as sellable become shrink later, so inspect returns before restocking them.

If your system can't track inventory by SKU and variant, or can't restrict open keys by employee, compare the POS systems MannyPay offers against those two requirements.

Reduce Inventory Shrink One Category at a Time

Trying to fix everything at once usually fixes nothing. This sequence works for most single-location stores and small chains:

  1. Set a baseline. Run a full count and calculate shrink by department with the formula above.
  2. Rank categories by shrink dollars at cost, not by percentage, so you start with what costs the most.
  3. Diagnose the top two using the pattern table. If receiving records or POS setup explain the gap, fix the process. If they don't, apply the theft controls that fit the category.
  4. Cycle-count the problem categories every week or two instead of waiting for the next full count.
  5. Recount after each change to confirm it worked, then move to the next category.

Record waste and damage with reason codes when they happen. If a liquor store logs broken bottles and a grocer logs expired dairy, the unknown number shrinks to the part that actually needs investigating. For setup ideas by store type, see our pages for retail stores, grocery markets, liquor stores and apparel boutiques.

This week, pull your last two counts and calculate shrink for your largest categories. Then check whether every delivery from the past month was received into the POS. That one check often explains more of the gap than a new camera would. If your current system makes the job harder than it should be, request a free quote and a MannyPay specialist will respond within one business day.

Sources

  1. National Retail Federation, National Retail Security Survey 2023
  2. Loss Prevention Research Council, 2023 NRSS Release
  3. Retail Dive, After More Than 3 Decades, NRF Won't Publish Its Annual Shrink Report This Year
  4. Retail Dive, NRF Finds Shoplifting Stabilizing as Online Fraud Grows
  5. 8th & Walton, Walmart Shrinkage: What Retail Shrink Means for Suppliers

About the author

Isabella Cruz

Isabella Cruz is Business Growth & Commerce Editor for Beyond the Swipe, writing for small businesses, restaurants, retailers, entertainment venues and e-commerce sellers.

This article is for general educational purposes and is not legal, tax or financial advice. Card network rules and state laws change; confirm current requirements for your business.

Related reading