Physical inventory count guide

A full physical inventory count works best when the count window, people, locations, and variance review are planned before counting starts.

Use this page when you need a complete count of stock on hand, not just a spot check.

Stock Count Template Generator

stock-count-template.csv CSV
Column presets
Columns
7 selected

CSV file ready to download

Live count sheet preview

Live

Your starter kit output

  1. 1CSV import file
  2. 2Excel-compatible worksheet
  3. 3Printable count sheet
  4. 4Variance review columns

If this list is large, import it into Mobile Inventory and scan instead of typing.

Before the count

Prepare the item list, assign locations, freeze or control stock movements, and decide how variances will be reviewed.

  • Clean product list
  • Location map
  • Counter assignments
  • Cutoff time
  • Variance thresholds

During the count

Count one area at a time. Record the physical quantity, mark counted locations, and keep unclear rows separate for review.

  • Use a count sheet or phone app
  • Do not mix locations in one row
  • Flag damaged, expired, or unknown items

After the count

Recount important variances, approve adjustments, and keep an audit trail of who counted and who approved.

  • Recount high-value differences
  • Add reason codes
  • Export a variance report

Workflow

Step Action Details
1 Plan the count Define scope, locations, people, and cutoff time.
2 Prepare sheets Generate the count template with the right columns.
3 Count stock Collect quantities by location or bin.
4 Review variances Recount and approve differences.
5 Post adjustments Update the inventory system after approval.

Stock count glossary

SKU

A stock keeping unit: the internal item code used to identify one product or variant.

Barcode

A scannable code such as UPC, EAN, or GTIN that should point to one item or package.

Variance

The difference between expected quantity and counted quantity after a stock count.

Cycle count

A recurring count of selected items, locations, or categories instead of the whole inventory.

Blind count

A count where counters do not see the expected quantity while entering the physical quantity.

Cutoff time

The point when stock movements are paused or controlled so the count matches system data.

Download tools

FAQ

What is a physical inventory count?

It is a count of stock physically on hand, usually compared with system quantities to find variances.

Should we stop sales during the count?

For a full count, many businesses pause or tightly control stock movements so the count and system data match the same point in time.

What columns should a count sheet include?

At minimum: SKU, product name, location, expected quantity when available, counted quantity, variance, and notes.