Physical inventory count: how to do it, step by step

By mise · Updated October 6, 2026

Quick answer: a physical inventory count is a hand count of every item you hold on a given date, used to correct your stock records and calculate cost of goods sold. To do one: set a cutoff so nothing moves, number every area, count in pairs shelf by shelf on a count sheet or in an inventory count app, recount high-value items, value the count at cost and reconcile the differences. With mise you scan each barcode with your phone and the count sheet builds itself as you go.

Whether it is the year-end count your accountant asks for or the monthly count in a restaurant or store, the method is the same: stop the stock moving, count everything once, write it down the same way every time, and explain the differences.

What a physical inventory count is — and when you need one

A physical inventory count (or physical count, or wall-to-wall count) means counting every item on hand on a set date instead of trusting what the system or the spreadsheet says. You need one:

• At least once a year, at the end of the fiscal year, so the ending inventory on your books — and therefore your cost of goods sold — is real.
• Every period, if you use a periodic system. COGS = beginning inventory + purchases − ending inventory, and the ending inventory comes from the count. See beginning and ending inventory.
• Weekly or monthly in food and beverage. Restaurants and bars count often because product spoils and shrinkage moves fast.
• Even with a perpetual system. Records drift: theft, breakage, waste nobody logged, a delivery entered twice. The count resets the figure to reality.

Physical inventory vs cycle count

Most businesses do both: a full count at period end and cycle counts on the A items in between.

Physical inventory count checklist (before count day)

• Date and time — after close or before the first delivery, when nothing moves.
• Cutoff — note the last delivery received and the last sale included; anything that arrives during the count waits, uncounted, until you finish.
• Area map — number every room, rack and shelf (Area 01 stockroom, Area 02 walk-in…). Every area gets counted once and signed off.
• Clean-up — the same item in one place, open cases consolidated, empty boxes out.
• Exclusions — set aside damaged and expired goods (count them separately), and anything that isn't yours: consignment stock, customer orders already paid.
• Units — decide how each item is counted (each, case, lb, bottle in tenths) and keep it the same as last time.
• Teams — pairs of counter + recorder, each with assigned areas; someone else does the recounts.
• Count sheets or the app — set up and tested before the day, items in shelf order.

Physical inventory count procedures (count day)

1. Brief the teams — areas, units, how to record partial units, what to do with damaged stock.
2. Count shelf by shelf, left to right, top to bottom. Never skip around: that is how items get counted twice or not at all.
3. Count blind. Counters should not see the quantity the system expects; they write what is there.
4. Record partial units as decimals — 0.4 of a bottle, 3.2 lb of cheese, 7 loose cans of a 24-pack as 7 units.
5. Recount high-value items and any line that looks off, with a different person, before the area is closed.
6. Sign off each area on the map. No product moves until the last area is done.

Physical inventory count sheet template

One row per item, in shelf order, with a second count column for spot checks. The extended value is already a formula.

Download the free physical inventory count sheet (CSV — opens in Excel and Google Sheets)

After the count: valuation and reconciliation

Multiply each final count by its unit cost — the latest invoice price, or your valuation method (FIFO, weighted average) — and total by category. Then compare:

1. List the variances by item, in units and dollars. See inventory variance.
2. Check the usual suspects first: deliveries not entered, waste not logged, wrong unit (case vs each), the same item under two names.
3. Recount anything still unexplained.
4. Adjust your records to the count and keep the sheets, the cutoff notes and the names of the counters.

Count sheets, count tags or an inventory count app?

Doing a physical inventory count with mise

mise is an inventory count app: open a count, pick the location and scan each barcode with the phone camera (or a Bluetooth scanner). The product comes back complete — name, brand, photo, category and size — because the mise AI finds it from the barcode or a photo; you type the quantity. Several people count different areas at the same time, counting keeps working without signal and syncs later, and when you close the count you see the value, the difference from the last count and your COGS. Export to Excel or PDF for your accountant.

Count it by scanning, not by clipboard

Scan each barcode, type the quantity, close the count: value, variance and COGS are ready. 7-day free trial, no card, then US$33 a month.

Start free

Frequently asked questions

What is a physical inventory count?

It is a hand count of every item a business holds on a given date. The result replaces the figure in your records and gives you the ending inventory used to calculate cost of goods sold.

How often should you do a physical inventory count?

At least once a year at fiscal year-end. Restaurants and bars usually count weekly or monthly, and stores monthly or quarterly, with cycle counts on high-value items in between.

What is the difference between a physical inventory and a cycle count?

A physical inventory counts everything on one date with stock frozen; a cycle count counts a small rotating group of items while the business keeps running.

What is a blind count?

A count where the counter does not see the quantity the system expects. It stops people from "finding" the expected number and makes the variance honest.

How do you reconcile a physical inventory count?

Value the count at cost, compare it item by item with your records, investigate large differences (missed deliveries, unlogged waste, wrong units), recount what is still unexplained and then adjust the records to the count.

Can I do a physical inventory count with my phone?

Yes. With an inventory count app like mise you scan each barcode with the phone camera and type the quantity; the count is split by location, works offline and exports to Excel or PDF.

How much does mise cost?

A 7-day free trial with no card, then US$33 a month (£26 in the UK).