How to Do a Physical Inventory Count (And Cycle Counts)
Learn how to do a physical inventory count with a clean cutoff and POS reconciliation, then keep records accurate with cycle counts.
Photo: Pixabay
On this page 6 sections
- Full Physical Count vs. Cycle Counting: Which One You Need
- How to Do a Physical Inventory Count: Start With the Cutoff
- Scanners or an Inventory Count Sheet: Pick by Barcode Quality
- Reconcile Counts Against Your POS Before You Adjust Anything
- Set up an ABC Cycle Counting Schedule That Fits Before Opening
- Investigate Variances Before You Write Them Off
Key takeaways
- Most bad counts fail at the cutoff or the reconciliation. The counting itself is rarely the problem.
- Before you book a variance as shrink, check for offsetting pairs and for case-versus-unit errors.
- An ABC cycle count schedule spreads the work thin enough that one person can do the daily counts before opening.
- Ask your CPA, and any lender that holds your inventory as collateral, whether a documented cycle count program can replace a year-end full count.
To do a physical inventory count, set a cutoff time that freezes your records. Divide the store into numbered zones, and send two-person teams to count every item without letting them see the expected quantities. Compare their totals against your POS before you post a single adjustment. Counting is the easy part. Most bad counts fail at the cutoff or at the reconciliation.
Once your records are clean, cycle counting keeps them that way. You count a small slice of inventory on a set schedule, so you don't have to close the doors for a full count again.
Full Physical Count vs. Cycle Counting: Which One You Need
A full physical count covers every item in every location at a single moment, usually after hours or during a closure. It gives you a complete baseline, and it is often the year-end inventory count your accountant uses to calculate cost of goods sold. The cost is a night of paid labor plus any selling time you lose. Accuracy also drops as the hours wear on, so schedule your hardest zones first, while counters are fresh.
Cycle counting splits the store into subsets and counts each subset on a rotation. High-value items get counted most often. The main advantage is timing. A cycle count finds a problem within weeks, while the receiving invoice is still on the desk and the camera footage still exists. A full count can find the same problem up to a year later.
Most independent retailers do best with a hybrid. Do one full count to set a baseline you can trust, then cycle count from there. Whether a documented cycle count program can replace the annual full count for your financial statements or tax return is a question for your CPA. If you have an inventory-backed credit line, ask your lender too, because some lenders set their own count requirements. If you are still choosing how to track stock in the first place, start with our guide to inventory management methods for small businesses.
How to Do a Physical Inventory Count: Start With the Cutoff
Set a hard cutoff. Choose an exact moment, such as close of business on a Saturday. Everything received before that moment must be entered in the POS, and nothing received after it gets counted. Move deliveries so none arrive during the count.
Grocery stores also have to plan for direct-store-delivery vendors, the route drivers who stock their own bread and soda shelves. Ask them to stay away during the count window, or count their product as a separate pass afterward.
Before cutoff, clear these out of the count areas or tag them:
- Goods waiting to go back to vendors
- Customer special orders that are already paid for
- Consignment pieces you don't own
- Damaged or expired stock, which goes to its own area and is counted separately
Layaway and customer holds need a consistent rule. Ask your accountant which side of the ledger they belong on.
Build two-person teams. One person counts and the other records, and they swap roles every zone or two. Where you can, assign staff to departments they don't normally work, so nobody counts shelves they stocked themselves. This setup catches honest assumptions and makes concealment harder. The manager shouldn't count. Instead, the manager hands out zones and tracks every sheet or scanner session. When a team finishes a zone, a different team recounts a sample of it.
Map and number every zone. Walk the store with a floor plan and give every fixture a number. Teams tend to skip top stock and window displays, so number those too, along with each cooler door and backroom rack. Teams count left to right and top to bottom, then hang a "counted" tag on each finished fixture.
Category Rules That Prevent Recounts
Liquor stores should count full cases and loose bottles on separate lines and write the unit of measure beside every number. A lone "1" with no unit could mean one bottle or twelve, and nobody will remember which by Monday.
In apparel, count by size within each style. Before cutoff, sweep the fitting rooms and the returns rack back onto the floor. Pull anything waiting at the steamer as well.
Grocery's hardest departments are the random-weight ones, such as deli and meat. Use whatever method your accountant approves and keep it the same from year to year so the results stay comparable.
Scanners or an Inventory Count Sheet: Pick by Barcode Quality
Handheld scanners and mobile count apps tied to your POS or inventory software are faster on large SKU lists, and they eliminate transcription errors. They have their own failure modes. A common one is a counter who scans one bottle and keys "12" when they meant to scan each bottle. In grocery and liquor, the case barcode and the unit barcode are usually different codes, so scanning the outside of a case can record the wrong item entirely. Items with no barcode stall the count, and so do apparel tags whose style code doesn't separate sizes.
Check barcode coverage a week before count day and fix the gaps then. If you are pricing scanners or a POS system with built-in inventory, test the count workflow on a real shelf before you buy. Once you know what the software supports, browse compatible POS accessories.
Paper still works for small stores and as a backup. A good inventory count sheet is prenumbered and assigned to one zone, with these columns:
| Column | What goes in it |
|---|---|
| Sheet # and zone | Prenumbered; matches the fixture tag |
| SKU or UPC | Pre-printed if possible |
| Description | Include size or color for variants |
| Unit of measure | Each, case, six-pack, pound |
| Quantity counted | Written in ink |
| Counter / recorder initials | Both people, every sheet |
| Recount quantity | Filled in only by the audit team |
Leave the expected on-hand quantity off the sheet. A blind sheet forces people to count instead of confirming the number in front of them. Corrections get crossed out and initialed, never erased. Log every sheet you issue and every sheet that comes back, because a missing sheet means a missing zone. Many stores scan most of the floor and use paper only for exceptions.
Reconcile Counts Against Your POS Before You Adjust Anything
Pull an on-hand snapshot from the POS at the exact cutoff time. If you reopen before the reconciliation is done, sales made after cutoff must not distort the comparison. Some POS inventory modules handle this with a count session. If yours doesn't, export the snapshot at cutoff and work from that file. Our comparison of inventory software and your POS covers when a separate tool is worth paying for.
Build a variance report that lists expected units, counted units, unit difference and cost difference, sorted by the size of the dollar variance. Set your recount thresholds before you look at the numbers, so nobody argues about them afterward.
Here is an illustrative report from a hypothetical liquor store. Every quantity and unit cost below is invented for the example.
| Item | POS on hand | Counted | Unit variance | Unit cost | Cost variance |
|---|---|---|---|---|---|
| Bourbon, 750 ml | 24 | 21 | −3 | $28 | −$84 |
| Hard seltzer 12-pack, lime | 40 | 46 | +6 | $14 | +$84 |
| Hard seltzer 12-pack, mango | 30 | 24 | −6 | $14 | −$84 |
| Cabernet, 750 ml | 18 | 7 | −11 | $9 | −$99 |
The cost column adds up to a net loss of $183 in this example. Only one of the four lines is likely to be a real loss.
The two seltzer lines offset exactly. A cashier probably rang up lime when customers bought mango, so the total units are right and only the split between flavors is wrong. That calls for a correcting adjustment and a word with the register staff, not a shrink entry.
The cabernet line is short by exactly 11. That fits a team counting 6 loose bottles plus one sealed 12-bottle case as "7." A recount finds 18, and the variance disappears.
That leaves the bourbon. After the other lines are cleared, the example store's real exposure is $84 on a single SKU, and that is where the investigation should focus.
Set up an ABC Cycle Counting Schedule That Fits Before Opening
Rank your SKUs by annual cost of goods sold, meaning units sold times unit cost. The small group at the top that carries most of your dollars becomes your A items. B is the middle tier, and the long tail is C.
Your own variance history overrides the ranking. Anything that keeps going missing moves to A, whatever its sales volume. For a liquor store, that usually means premium spirits and small, pocketable bottles. Grocery A lists tend to include fresh meat plus whatever sits behind the counter. In apparel, high-ticket pieces such as outerwear and premium denim belong in A.
Here is an illustrative schedule for a store with 3,000 SKUs. The tier sizes and frequencies are assumptions for the example, not a rule. Set yours from your own sales data.
| Tier | SKUs | Count frequency | Counts per year |
|---|---|---|---|
| A | 300 | Monthly | 3,600 |
| B | 600 | Quarterly | 2,400 |
| C | 2,100 | Twice a year | 4,200 |
| Total | 3,000 | 10,200 |
Spread over 260 counting days (five days a week), that works out to about 39 SKUs a day. One person can usually finish that before opening or during the first slow hour.
Count a location when no one is selling from it, and check whether any sales posted between your snapshot and the count. Rotate counters so the person who receives a category isn't the only one who counts it. To make sure the daily count actually happens, add it as a line on your retail opening and closing checklist.
Investigate Variances Before You Write Them Off
Written inventory count procedures should list the causes to check in order, starting with the cheapest:
- Recount the location.
- Look for receiving that was keyed but never shelved, or shelved but never keyed. Check for vendor shortages and unposted transfers.
- Check whether returns were restocked without being processed, or processed without being restocked.
- Scan sales history for mis-rings and offsetting pairs.
- Check for unit-of-measure errors.
- Look for breakage and spoilage that was thrown out but never written off.
Treat a variance as possible shrink only after you have ruled out all of those.
Give every adjustment a reason code, such as receiving error, mis-ring, damage, spoilage, suspected theft or unknown. Require manager sign-off above a set dollar amount, and make sure the approver isn't the person who counted. If "unknown" becomes your biggest category, your process has a gap. Your next step is to review POS exception reports that flag voids and no-sale drawer openings.
Repeat losses on the same SKUs or shifts call for the controls in our guide to preventing employee theft in a retail store. File the count sheets with the variance report and its signed approvals, because your accountant will ask for them at year end. Inventory valuation affects your taxes, so treat this article as general information and confirm your method with a qualified professional.
This week, count a few dozen of your highest-dollar SKUs before opening and compare the results to your POS. If most variances turn out to be mis-rings or case errors, the full count can wait while you fix receiving and checkout habits. If your POS can't produce a clean on-hand snapshot or a variance report, fix that first. MannyPay works with retail stores, grocery markets, liquor stores and apparel shops. You can request a free quote to compare POS options that fit how you count.
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.
