Physical inventory count guide

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

Use this page when you need a complete count of stock on hand because cycle counts or spot checks are not enough, with area readiness, cutoff exceptions, supervisor walk-through, recount evidence, and release proof.

Build a movement-cutoff exception log

Local-only review CSV

Import post-cutoff movements, confirm the detected columns, and download one controlled exception log. Rows without closeout evidence stay on hold.

Choose a movement CSV or load the sample.

Accepted
0
Rejected
0
Duplicates
0
Unresolved
0
Over limit
0

Release decision

Hold movement release

Load a movement file to prove what must stay on hold.

Controlled movement preview

0

Accepted movements will appear here.

Issue a count-sheet custody register

Local-only review CSV

Import the sheet issuance roster, confirm the detected columns, and download one returned-or-hold decision per sheet. A sheet stays on hold until assignment, issue, return, counter sign-off, and supervisor receipt are recorded.

Choose a sheet issuance CSV or load the sample.

Returned
0
Hold
0
Duplicates
0
Rejected
0
Over limit
0

Custody decision

Hold reconciliation

Load a sheet issuance roster to prove what must stay on hold.

Custody decision preview

0

Accepted sheets will appear here.

Need to sequence the count controls?Validate movement cutoff, book snapshot, counting, review, and release before sheets are issued.

Prepare a physical-count control timeline

Local-only plan CSV

Set the six control times and three accountable owners. The timeline stays on hold until every control is present and chronological.

Planned control times
Accountable owners

Complete all six times and three owners or load the representative sample.

Controls
0
Owners
0
Blockers
0

Pre-count decision

Timeline incomplete

Add every planned time and named owner before issuing the count controls.

Control timeline preview

0

Six control decisions will appear here.

Need a representative supervisor sample?Compare three observation plans against slow, mixed, damaged, hard-to-reach, and other documented risk.

Plan supervisor observation samples

Local-only plan CSV

Enter count areas, estimated volume, and up to two risk traits per area. Compare three nearby sample sizes before the full count opens.

Enter at least three complete areas or load the representative sample.

Areas
0
Risks
0
Available
3

Observation decision

Plan incomplete

Add at least three areas with a name, positive volume, and one risk trait.

Nearby sample comparison

0

Three nearby observation plans will appear here.

Need to choose the count method?Compare paper, spreadsheet, barcode-app, and reviewed-photo fit before the count pack is issued.

Choose a count method from operating constraints

Local-only comparison CSV

Describe the count conditions to expose method blockers and preparation work. The strongest ready method is a planning recommendation, not a vendor or hardware purchase decision.

Count operating constraints

Complete all six constraints or load the representative sample.

Compared
0
Ready
0
Blocked
0

Method decision

Comparison incomplete

Complete all six constraints before issuing a method decision.

Method readiness comparison

0

Four method decisions will appear here.

Need a count sheet too?Open the CSV, modern .xlsx, and print template builder.

Set up your count

stock-count-template.xlsx XLSX
Populate from an item-list CSVOptional local upload for a ready-to-count workbook

Choose a file to map its fields and audit its rows before download.

Columns
7 selected

Your file is ready to download

Live count sheet preview

Live

Preview focuses on key fields; downloads include every selected column.

Focused stock count template preview; downloads include all selected columns.

Available downloads

  • CSV file
  • Excel worksheet
  • Printable sheet
  • Release checklist

For larger lists, import locations first with zone owners, escalation, and spot-check proof, then load products.

Before the count

Prepare the item list, walk the areas, assign locations, publish the movement cutoff, block or control physical stock movements, record the ERP book-inventory snapshot time when used, and define recount and approval evidence.

  • Clean product list
  • Area readiness packet
  • Location map and labels
  • Counter assignments
  • Movement cutoff and book-inventory snapshot times
  • Cutoff exception list
  • Recount and approval thresholds

Choose physical count when

Use a full physical inventory when the business needs point-in-time proof for all stock, not just a recurring control. If normal transactions can continue and the risk is targeted, use a cycle count or spot check instead.

  • Year-end, audit, acquisition, or system-change proof needs every countable location covered
  • Record accuracy is unknown across many locations, categories, or cost groups
  • Cycle counts show repeated unresolved variances across multiple scopes
  • Cutoff complexity needs one controlled freeze, exception packet, and release owner
  • Management needs a complete baseline before restarting recurring cycle counts

Area readiness packet

Walk every zone before sheets are released. Mark what is countable, what is excluded, who owns cleanup, and what the supervisor must verify before movement restarts.

  • Countable zones with owner and target finish time
  • Non-countable supplies, customer-owned goods, and equipment marked out of scope
  • Quarantine, returns, vendor-hold, damaged, and obsolete stock routed for review
  • Staged orders, received-not-put-away pallets, transfer lanes, floating paperwork, and overflow tagged
  • Empty bins and temporary locations labeled so counters can confirm zero counts

During the count

Keep the issued expected-quantity snapshot and its recorded book-inventory freeze time fixed. A frozen balance does not stop stock movements, so route every after-cutoff movement through the exception packet.

  • Use a count sheet or phone app
  • Keep each item, location or bin, lot, serial, and revision combination on its own row; route wrong-location stock to transfer or reclassification instead of netting it into a quantity adjustment
  • For stock absent from the issued list, use a blank row or tag; record location, item ID or UNKNOWN, quantity, and hold it for supervisor review

After the count

Recount material variances, approve adjustments, clear cutoff exceptions, and keep evidence of who counted, reviewed, approved, and released movement.

  • Recount material differences
  • Add reason codes and approval evidence
  • Clear after-cutoff receipts, shipments, transfers, and staged orders
  • File the variance report, adjustment reference, and release sign-off

Printable cutoff exception SOP checklist

Print this checklist before the count opens. It keeps the physical movement block or controlled-move rule, separate book-inventory snapshot, cutoff exceptions, recount approval, and stock-move release sign-off in one count pack.

Before counters start

  • Publish the count time, movement cutoff, book-inventory snapshot time, counted locations, supervisor walk-through owner, and cutoff exception owner.
  • Block or supervisor-control physical receipts, shipments, picks, putaway, transfers, and production issues. A frozen book balance is a separate quantity snapshot, not a movement block.
  • Attach the area-readiness packet with countable zones, non-countable exclusions, quarantine, returns, vendor-hold, damaged stock, staged shipments, overflow, empty bins, label fixes, and walk-through route.
  • Separate supplier receipts, customer shipments, known shrink, staged moves, and floating paperwork that cross the cutoff boundary.

While counting

  • Count each item, location or bin, lot, serial, and revision combination once, then mark the location counted; never net tracking or location differences together.
  • Keep the issued expected-quantity snapshot and recorded book-inventory freeze time unchanged. Because the snapshot does not stop stock movements, log after-cutoff movements and paperwork gaps on the exception list; never recalculate the count sheet.
  • Use a blank row or tag for stock absent from the issued list; record location, item ID or UNKNOWN, and quantity, then hold it with damaged, expired, active-movement, and walk-through exceptions for supervisor review.
  • Capture counter initials, count time, location confirmation, and supervisor walk-through exceptions with the sheet or phone export.

Release and post

  • Assign independent recounts for material variances and attach reason codes before adjustments are approved.
  • Match the exception list to receiving, shipping, transfer, shrink, staged-order, and paperwork records before stock moves restart.
  • Record who approved the variance report, who cleared cutoff exceptions, who released movement, and when release happened.
  • File the signed checklist, count sheet, exception list, variance export, adjustment reference, and release owner sign-off with the count pack.

Cutoff packet sign-off

Count scope Cutoff / book snapshot times Exception owner Walk-through owner Recount/approval owner Release owner/time Adjustment reference Count pack filed

Use this checklist with the stock count template so physical movement control, book-snapshot timing, walk-through exceptions, material recounts, approval proof, and release-owner sign-off are closed before inventory adjustments are posted.

Workflow

Workflow steps for Physical inventory count guide
Step Action Details
Step1 ActionPlan the count DetailsDefine scope, area readiness, locations, people, movement cutoff, book-inventory snapshot time, walk-through owner, and exception owner.
Step2 ActionPrepare sheets DetailsGenerate the count template with the right columns.
Step3 ActionCount stock DetailsCollect quantities by location or bin.
Step4 ActionReview variances DetailsRecount material differences, clear cutoff exceptions, and record approval evidence.
Step5 ActionPost adjustments DetailsUpdate the inventory system after release owner sign-off and adjustment reference.

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.

When is a full physical count better than cycle counting?

Use a full physical count when you need all locations proven at one point in time, such as year-end, audit support, a system migration, a major location reset, or widespread accuracy doubts. Use cycle counts when the risk is targeted and the team can review smaller scopes regularly.

Should we stop stock movements or freeze book inventory during the count?

Pause, block, or tightly control physical stock movements so the count and transactions match the same point in time. A frozen book-inventory balance only preserves the ERP comparison quantity; it does not stop receipts, shipments, transfers, or putaway. If movement continues, assign exception and release owners.

What columns should a count sheet include?

At minimum: SKU, product name, location, expected quantity when available, counted quantity, variance, and notes. Keep bin, lot, serial, and revision on separate rows when tracked. For controlled counts, add movement cutoff, physical movement-control status, exception owner, recount owner, approval evidence, counter sign-off, and supervisor review fields; keep the separate book-snapshot time in the count pack.

What belongs in the cutoff exception packet?

Include after-cutoff receipts, shipments, transfers, putaway, known shrink, staged orders, supervisor walk-through exceptions, material variance recounts, approval evidence, release owner sign-off, and the adjustment reference.

What belongs in the area readiness packet?

Include countable zones, exclusions, quarantine and returns routes, vendor holds, damaged or obsolete stock, staged shipments, overflow locations, empty-bin labels, cleanup owners, and label fixes before count sheets are released.