How to Do a Physical Inventory Count (Step by Step)
Practice · 9 min read
Nothing you paste is stored.
The scan could not run.
A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. The full product connects to your POS and store and runs this continuously.
To do a physical inventory count, freeze stock movement, count every location in teams using a clear map and count sheets, then reconcile the tally against your recorded stock, investigate the variances, and adjust the books to match reality. The goal is not just a number. It is finding where and why your records drifted from what is actually on the shelf, so you can fix the process, not just the count.
A physical inventory count is the periodic full check where you physically count everything you have and reconcile it against what your system says you should have. Done well, it corrects your records, surfaces shrinkage and gives your accountant a real inventory value. Done badly, it eats a weekend, produces numbers nobody trusts, and changes nothing. Here is the step-by-step process that keeps it useful.
1. Prepare before count day
Most counting failures are set the day before. Tidy and organize the stock area so every item has a clear location. Make sure everything is labeled with a readable SKU or barcode. Print count sheets or load your scanning app, and split the space into zones so two people never count the same shelf or miss one between them. Decide who counts what, and brief the team on how to record units, cases and partial packs consistently.
2. Freeze movement during the count
You cannot count a moving target. Stop receiving and shipping while you count, or the same unit gets counted twice or slips through uncounted. Most businesses count outside trading hours or block off a clear window. If stock genuinely has to move, quarantine anything received or picked mid-count in a marked holding area and record it separately, so it does not corrupt the tally.
3. Count in teams, ideally twice
Count zone by zone against the map. The strongest method is a blind double count: two people count the same zone independently without seeing each other's numbers, and you only investigate where the two disagree. It costs more time but catches the miscounts that a single pass hides. Scanning beats writing where you can, because a scanned SKU removes the transcription errors that creep into handwritten sheets.
4. Reconcile the count against your records
Now compare what you counted to what your system expected, line by line. Every SKU where the two differ is a variance. This is the whole point of the exercise: the variances are a map of where your process leaks. A SKU that reads 8 short is not just a number to overwrite; it is a question about where those 8 went. The discipline here is the same one data teams use to catch when a recorded number has quietly drifted away from reality, you do not just patch the figure, you find out why it moved.
5. Investigate the variances before you adjust
Resist the urge to instantly overwrite your records with the count. First look for the cause of the big variances: a receiving error, a miscount, units in a second location, theft or damage. Recounting the worst offenders often reveals a simple mistake rather than a real loss. What is left after you have explained the honest errors is your inventory shrinkage, the real gap between recorded and actual stock, and that number tells you where to tighten process, security or receiving.
6. Adjust the books and value the inventory
Once variances are explained, update your system so recorded stock matches the count. Those adjustments flow into your inventory value and, through shrinkage, into cost of goods sold, so the count is also what gives your accounts an accurate stock figure. If you are unsure how the valuation works, our guide to calculating inventory value covers FIFO, LIFO and weighted average. Record the count date and results so you have a baseline to measure against next time.
How often should you do a full physical count?
Traditionally once a year, often at year end for the accounts. The problem is that an annual count means you run all year on records that drift, then take one painful weekend to fix them. Most operations that care about accuracy have moved to cycle counting: counting a small slice of SKUs every day or week on a rolling schedule, weighted so high-value A-class items get counted more often. Cycle counting keeps records accurate year-round and usually removes the need for the big annual shutdown entirely.
| Annual physical count | Cycle counting | |
|---|---|---|
| Disruption | Whole operation stops for a day or more | A few SKUs counted daily, no shutdown |
| Accuracy between counts | Drifts all year until the next count | Stays high year-round |
| Finds the cause | Hard; the trail is months cold | Easy; errors are recent and traceable |
Turn an accurate count into better decisions
An accurate count is worth most when it feeds the decisions that follow it. Once your on-hand numbers are trustworthy, the next question is what to reorder and what to clear, and that is where per-SKU forecasting and live reorder points come in. Accurate stock is the input; deciding what to do with it is the job Storekeeper is being built for, on top of the counting your inventory control software already handles.
After your next count, paste your corrected stock and recent sales into the live stock scan at the top of the site. It reads the demand signal per SKU and flags which of your freshly counted lines are about to run out or pile up.
See this math run itself
The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.
Run the stock scanMore from the stockroom
- Working capital GMROI: Formula, Benchmarks and How to Improve It
- Practice ABC vs XYZ Analysis: The Difference and How to Combine Them
- Working capital How to Value Inventory for Taxes: Methods, Rules and COGS
- Practice Consignment Inventory: How It Works, Pros and Cons, and the Accounting
- Practice Par Level Inventory: What It Is and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT): How It Works and When to Use It
- Practice Min/Max Inventory: How the System Works and How to Set Levels
- Lost sales How to Avoid Stockouts: 7 Ways to Stop Running Out of Stock
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How to Forecast Inventory Demand (Methods and a Practical Process)
- Metrics How to Calculate Inventory Turnover (Formula, Example, Days)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Metrics How to Calculate Inventory Value: FIFO, LIFO and Weighted Average
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Inventory KPIs: The 7 Metrics That Actually Matter
- Metrics Days of Inventory on Hand (DIO): Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization: Techniques to Cut Stock Without Stocking Out
- Practice Perpetual vs Periodic Inventory: Which System to Use and How COGS Differs
- Working capital Inventory Shrinkage: Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost: Formula, Percentage and How to Lower It
- Practice Cycle Counting: What It Is, Methods and How Often to Count
- Metrics ABC Analysis in Inventory Management: Formula, Classes and a Worked Example
- Metrics Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ): The Formula and When to Trust It
- Practice Inventory Management in Excel: How to Build It, and When to Stop
- Formulas Safety Stock: What It Is and How to Calculate It
- Formulas Reorder Point Formula: How to Calculate When to Reorder
- Working capital Dead Stock: Why It Happens and How to Clear It
- Lost sales Stockouts: The True Cost of Running Out