Guides

Inventory Shrinkage: Causes, Calculation & 7 Fixes

Guides · Basics

Inventory Shrinkage: Find the Causes and Reduce It

Your inventory system says there are 48 units on the shelf, but you counted 41. That gap is inventory shrinkage. Once you know the causes, you can usually reduce it significantly.

Key takeaways

  • Inventory shrinkage is the difference between your book inventory (expected) and your counted inventory (actual), when the count comes up short.
  • Shortages (actual lower than expected) are often caused by theft, breakage, spoilage or unrecorded withdrawals. Overages usually point to recording errors.
  • A large share of variances aren’t real losses but recording and data entry errors: during receiving, at checkout or in the count itself.
  • After the count, the book inventory is adjusted to the actual quantity. Unusual variances should be investigated and documented.

What is inventory shrinkage?

Every inventory count compares two numbers: the book inventory your inventory system calculates from receipts and issues, and the actual inventory you physically count. If they don’t match, you have a variance; a shortfall is called shrinkage or shrink. Your financial statements are always based on the counted quantity.

Variances show up with both counting methods: once a year with a physical inventory count, and continuously with every partial count under perpetual inventory and cycle counting.

How to calculate inventory shrinkage

The formula is simple: Variance = actual inventory − expected inventory. A negative result is a shortage (shrinkage), a positive one an overage. To value it, multiply the quantity difference by the item’s unit cost.

ItemExpectedCountedVarianceUnit costValue
USB-C cable 3 ft4841−7$2.10−$14.70
Cordless drill X12120$89.00$0.00
Screws #8 × 1-1/2 in (box of 100)3033+3$3.50+$10.50

To calculate your shrinkage rate, divide the total value of shortages by sales (or by inventory value). Industry surveys put retail shrink at roughly 1–2% of sales. Tracking your own rate shows whether things improve year over year.

Reconciling expected vs. counted in Excel

  1. Export the book inventory from your inventory system (e.g. Shopify, Square or QuickBooks) as a CSV with UPC and quantity columns.
  2. Capture the actual inventory, for example with a photo scan in Scan2List: Inventory Scanner, and export the count list as a CSV, too.
  3. Put both lists into one Excel file on two separate sheets.
  4. On the expected sheet, pull in the counted quantity with XLOOKUP (or VLOOKUP) on the UPC from the counted sheet. Set items that aren’t found to 0.
  5. In a new column, calculate counted minus expected and sort by the largest variance. Also check which counted UPCs don’t appear in the expected list at all; those are often items set up incorrectly.

Tip: You can skip the spreadsheet reconciliation if you load the list into the Inventory mode of Scan2List first. Then the app compares while you take photos and shows you what is missing, where the quantity is off and what is not on the list. How the inventory count works with the app ›

The most common causes

Real inventory losses

  • Shoplifting and employee theft
  • Breakage, damage, spoilage, expired products
  • Internal use and samples that weren’t recorded
  • Losses from evaporation, drying out or pouring (e.g. beverages, bulk goods)

Recording and data entry errors

  • Receiving posted without checking: the packing slip says 50, but 45 were delivered
  • Wrong item scanned at checkout (variant, color, size)
  • Returns, transfers or replacement shipments not recorded
  • Duplicate items in the system or mixed-up units (each vs. pack)
  • Counting errors: areas counted twice, goods overlooked, numbers copied wrong

7 ways to reduce inventory shrinkage

  1. Check receiving: Count the delivered quantity against the packing slip before you post it.
  2. Barcodes instead of handwriting: Copying item numbers by hand leads to errors. Capture them by scanning; multiple codes per photo save time on large deliveries.
  3. Clear units: Define for each item whether it’s counted by the each, pack or case.
  4. Document withdrawals: Record internal use, samples and breakage right away.
  5. Separate areas clearly: During the count, define each area clearly and check it off. Ideally: one list per area.
  6. Count more often: Short cycle counts for fast-moving or theft-prone items uncover problems sooner.
  7. Analyze variances: Don’t just correct them; break them down by item, category and area. If variances cluster in one spot, that’s usually where the cause is.

How is inventory shrinkage recorded?

After the count, the book inventory is adjusted to the actual quantity. Depending on your chart of accounts and accounting method, this is recorded as an inventory adjustment, often through cost of goods sold or a separate shrinkage expense account. Set up the right treatment for your business with your CPA or accountant. This article is not tax advice.

Frequently asked questions

What’s a normal inventory shrinkage rate?

It depends heavily on the industry. Industry surveys put retail shrink at roughly 1–2% of sales; in grocery and food service, spoilage can push it higher. More important than an industry benchmark is the trend in your own business.

Are inventory overages good?

Not necessarily. More stock than recorded usually points to errors, such as unrecorded receipts or mis-scanned items. Overages and shortages on similar items often cancel each other out and indicate a mix-up.

How do I find the cause of a variance?

Check the item’s recent movements: receipts, sales, returns and transfers. Recount the item while the count is still fresh, and compare it with similar variants.

Can an app prevent inventory shrinkage?

An app doesn’t stop theft, but it reduces counting and transcription errors. That makes your shrinkage figure more meaningful, because it reflects real losses rather than recording mistakes.

Step by step: Use case: inventory with your iPhone, with a free template and a picture for every step.

Last updated:

Note: We put this guide together with care, but it is not legal or tax advice and is not legally binding. Deadlines, obligations, prices and calculation methods change. Please verify any information yourself or with your accountant before relying on it.

Free template

Set up the list on your computer, check it with your iPhone

Download a free CSV template, create labels in the generator for everything without a barcode and load the list into the app. Then you see right away what is missing when you take photos.

More guides

All guides ›