How to Do an Inventory Count for a Small Business (Step-by-Step)

Every small business that holds stock eventually discovers the same thing: the number in the spreadsheet or POS and the number on the shelf drift apart. A box gets miscounted at receiving, a return goes back on the wrong shelf, a case breaks and nobody writes it down. An inventory count is how you pull the two numbers back together, and done well it also tells you why they drifted.

This guide walks through the whole process: choosing between a full count and cycle counts, preparing the week before, building a count sheet, running the count, investigating variances and calculating shrinkage. It works whether you track stock in a POS, accounting software or a simple Excel file.

Full physical count vs. cycle counting

There are two basic approaches, and most businesses end up using both.

Full physical inventory

A full count means counting every item in every location at one point in time, usually with sales and receiving paused. It gives you a clean, defensible ending inventory figure, which is why many businesses do one at year end for their books and tax return. The downside is disruption: you may need to close early, bring in extra people or count after hours.

Cycle counting

Cycle counting splits your inventory into small groups and counts a different group every day or week, so every item gets counted several times a year without ever shutting down. The most common way to decide what to count when is ABC classification:

• A items — the small number of SKUs that make up most of your inventory value or sales. Count them most often, for example monthly.
• B items — the middle tier. Count them quarterly.
• C items — the long tail of cheap, slow items. Count them once or twice a year.

There is no universal rule for where to draw the A/B/C lines. A practical starting point is to sort your SKUs by annual cost of goods sold, then mark the top slice that adds up to most of the total as A. Adjust after a few months based on where your variances actually show up.

Step 1: Prepare the week before

Most bad counts are caused by bad prep, not bad counting. Before count day:

1. Pick a cutoff time. Decide the exact moment the count represents, such as close of business Sunday. Any delivery received after that moment is held aside and recorded later.
2. Post all paperwork. Enter every received invoice and packing slip, every customer return and every transfer up to the cutoff. If receiving is behind, your system number is wrong before anyone touches a box.
3. Tidy and consolidate. Put stray items back in their home location, combine half-empty cases and pull damaged goods into a separate, labeled area.
4. Label locations. Give every shelf, bin or zone a short code (for example A-01, A-02, COOLER-1). Count by location, not by item, so nothing gets skipped or counted twice.
5. Print or share count sheets. One sheet per location, listing the items expected there.
6. Assign teams. Counting in pairs — one person counts, one records — is slower per person but catches a lot of mistakes.

Step 2: Build a count sheet

A count sheet should make it easy to record what is physically there and hard to be influenced by what the system says. Two common styles:

• Blind count — the sheet lists location, SKU, description and unit, with an empty column for the counted quantity. Counters cannot see the expected number, so they actually count instead of confirming.
• Guided count — the sheet shows the expected quantity. Faster, but counters tend to write down the number they expect. Use it only for low-value C items, if at all.

A practical layout for a blind count sheet in Excel:

Notice the Unit column. Unit-of-measure confusion — counting individual cups when the system tracks sleeves — is one of the most common sources of huge, fake variances. Spell the unit out on the sheet.

If you do not want to build this from scratch, the small business inventory template and the retail store inventory template already include location, SKU, unit and quantity columns with stock value formulas.

Step 3: Run the count

1. Stop movement at the cutoff. No sales from the counted area, no put-aways. Anything that arrives goes into a holding area.
2. Count location by location. Work top-to-bottom, left-to-right on each shelf so the pattern is the same everywhere.
3. Count in the unit on the sheet. For partial cases, record a decimal (2.5 cases) or count eaches and note it — but be consistent.
4. Tag counted locations. A sticky note or tag on each finished shelf prevents double counting.
5. Write down anything odd. Damaged, expired, unlabeled or misplaced items go in Notes, not in someone's memory.
6. Recount a sample. Have a different person recount a few random locations plus every high-value item. If the recounts differ, recount the whole section.

Step 4: Calculate and investigate variances

Once counts are entered, compare them with the system quantity. You want two numbers per item: the unit variance and the dollar variance. Assuming System Qty in column E, Counted Qty in F and Unit Cost in G:

Unit variance (H2):      =F2-E2
Dollar variance (I2):    =H2*G2
Variance % (J2):         =IF(E2=0,"",H2/E2)
Flag for recount (K2):   =IF(OR(ABS(I2)>=50,ABS(J2)>=0.1),"RECOUNT","")

The thresholds in the flag formula ($50 or 10%) are examples; pick values that make sense for your price points. Sort by the absolute dollar variance so you spend time on the items that matter.

A worked example

The lid shortfall is the one to chase. Before you call it shrinkage, check the usual suspects:

• Unit-of-measure errors — was a case of 1,000 received as 10 sleeves or as 1 case?
• Unposted documents — a delivery or return that missed the cutoff.
• Wrong SKU at receiving — the supplier sent a substitute that was received under a different item. A positive variance on a similar SKU (like the napkins above) is often the other half of the story.
• Items in a second location — overflow stock in the back room or a delivery vehicle.
• Counting mistakes — recount before adjusting.

Only after those checks should you post an adjustment. Record a reason code for each adjustment (damaged, expired, theft suspected, receiving error, unknown) so that over time you can see which cause is costing you the most.

Step 5: Measure shrinkage

Shrinkage is inventory you paid for but can no longer sell: theft, damage, spoilage, vendor short-shipments that were never caught, and administrative errors. Measured at cost, the simplest version is:

Shrinkage $        = Book inventory value − Physical inventory value
Shrinkage % (cost) = Shrinkage $ ÷ Book inventory value

Example: =(B2-C2)/B2   →  book $18,250, physical $17,640  →  3.3%

Retailers often report shrink as a percentage of sales instead of inventory value. Either is fine as long as you use the same method every time so the trend is meaningful. What matters is whether the number is moving up or down from one count to the next.

Step 6: Fix the process, not just the numbers

Adjusting quantities makes the books right today. Fixing the cause keeps them right next month. After each count, look at your reason codes and ask:

• Are receiving errors concentrated with one supplier or one person? Check invoices against packing slips on delivery.
• Are the same few SKUs always off? Move them to the A list and count them more often.
• Is spoilage or expiry a pattern? Add an expiry date column and rotate stock first-in, first-out.
• Are counts slow because locations are messy? Fix the layout before the next count.

If you are just setting up your stock file, start from one of the free inventory templates; they include stock value and reorder alert formulas, so the count feeds straight into purchasing decisions. For deciding when to reorder after the count, see our guide to the reorder point formula in Excel.