How do I calculate inventory shrinkage for my retail business?
Inventory shrinkage is the gap between what your records say you should have in stock and what you actually have on the shelves. The formula is straightforward: subtract your physical inventory from your book inventory, divide by book inventory, then multiply by 100 to get a percentage.
Book inventory is what your accounting system shows based on purchases minus recorded sales. If you bought 500 units this quarter and your POS shows you sold 350, your book inventory says 150 should remain. Physical inventory is what you actually count when you walk the store and tally every item on the floor and in storage.
Here’s a practical example. Your records show $45,000 in merchandise should be on hand. You conduct a physical count and find $42,750 worth of inventory. The difference is $2,250. Divide $2,250 by $45,000, multiply by 100, and your shrinkage rate is 5%.
That 5% number should concern you. The National Retail Federation reports average retail shrinkage around 1.4% to 1.6% annually. Anything consistently above 2% deserves investigation.
Shrinkage comes from four primary sources: employee theft, shoplifting, administrative errors, and vendor fraud. Administrative errors often surprise business owners because they aren’t actual theft. Receiving shipments without verifying quantities, scanning the wrong item at checkout, or miscounting during inventory all create phantom shrinkage that looks like loss but is really just bad data.
To calculate shrinkage accurately, your book inventory needs to be right. That means recording every purchase at actual cost, tracking markdowns and damaged goods, and reconciling sales daily. If your book inventory is already wrong, your shrinkage calculation won’t tell you much. A Scottsdale bookkeeper who understands retail can help you get your records in order so your numbers mean something.
Physical counts should happen at least annually, though quarterly or monthly cycle counts catch problems faster. Waiting a full year to discover shrinkage means you’ve been bleeding money without realizing it.
Track shrinkage by category if you can. Your overall rate might be 2%, but if most losses come from one product line, that’s where you focus. High-value small items typically have the highest shrinkage rates because they’re easy to pocket and hard to notice missing.
Once you know your shrinkage rate, you can weigh prevention options against actual losses. Better security cameras, improved receiving procedures, or more frequent counts all cost money. Compare those costs to what shrinkage is actually costing you before investing.
Proper inventory accounting makes shrinkage calculation reliable. When your books accurately reflect what you’ve purchased, sold, and have on hand, the physical count becomes a meaningful comparison instead of a guess.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I account for food waste and spoilage?
Food waste and spoilage flow through your cost of goods sold, not as a separate expense. Track waste daily by category so you can see how much of your food cost comes from loss versus productive use.
Read answerHow do I track inventory for my online store?
Connect your sales platforms to accounting software, track cost of goods sold accurately, and reconcile physical counts regularly. The challenge isn't the tracking itself but getting all systems to sync reliably.
Read answerMy previous bookkeeper made errors, how do I fix them?
Start by reconciling your bank accounts to identify missing or duplicate transactions. Prioritize errors that affect your tax return or cash flow over minor categorization mistakes. Complex cleanups often benefit from professional help.
Read answerHow do I account for Shopify payouts and transaction fees?
Record your gross sales as revenue and Shopify fees as a separate expense. Don't just book the net payout amount to income or you'll underreport revenue and miss tracking what you're actually paying in fees.
Read answerWhy are my restaurant margins so thin?
Restaurant margins are naturally thin, typically 3% to 9% net profit. If yours are even tighter, the problem is usually hiding in food costs, labor efficiency, menu pricing, or a combination of all three made worse by poor financial visibility.
Read answerHow do I value inventory for my online retail business?
Most e-commerce businesses use FIFO (First In, First Out) to value inventory. This method assumes you sell your oldest inventory first, which typically matches how online retail works and simplifies compliance.
Read answer