Inventory count sheet

Count stock by location, record quantities and compare with the system to find differences.

Use it on screen
Inventory count sheetHeaderEach itemReviewDate and time.📋
How to use itCount by location in a fixed order, record what you see, then compare with the system and investigate large differences.

Where the inventory count sheet fits

Regular counts keep stock records accurate and show shrinkage early. A fixed route and two counters for high-value items improve accuracy.

Count when stock is not moving, such as before opening or after closing.

12 items. Fill it in on screen or print a copy.

Header

Each item

Review

How to use the inventory count sheet step by step

  1. Freeze movement during the count.
  2. Count shelf by shelf.
  3. Recount large differences.
  4. Approve adjustments.
  5. Track shrinkage over time.

How one manager uses the inventory count sheet

A convenience store counts tobacco weekly. The count shows 12 packs fewer than the system; a recount confirms it, and a review of receiving finds a short delivery that was not recorded.

Why an inventory count sheet matters

An accurate count is what ties the stock records to the balance sheet and cost of goods sold, and it is the only way to measure shrinkage. Approved adjustments with a signature also leave an audit trail showing nobody quietly changed system quantities.

What a completed inventory count sheet looks like

Store and date Quick Stop Market, Louisville, Sunday 6 am
Counters Sam and Elena, blind count
Item and SKU Energy drink 16 oz, SKU 4471
Unit Each
Counted quantity 58
System quantity 64
Difference and review -6; recount confirmed; receiving log checked

Because it was a blind count, the -6 is not the result of counters rounding to the expected number, and the receiving log is checked before writing it off.

Mistakes we see most often

Make the inventory count sheet fit your setup

Bars and restaurantsMeasure open bottles by tenths or weigh them, so pour cost reflects partial stock, not just full bottles.
Parts rooms and hardware storesCount bins of small fasteners by weight on a scale instead of piece by piece.
Worth knowingTag each shelf as it is counted with a colored sticky note. Anyone walking the floor can see which sections are done and nothing gets skipped.

Questions about the inventory count sheet

How often to count?

High-value items weekly, everything else monthly or quarterly.

Who should count?

Two people for high-value items.

What is shrinkage?

Stock lost to theft, damage or errors.

Should counters see the system quantity?

Blind counts are more accurate.

What is a blind count?

In a blind count the counter’s sheet has no system quantity on it, so they write what they find instead of confirming an expected number. The system figure is added afterward to work out the difference. It gives more honest numbers, especially on items prone to theft.

How big a difference should trigger a recount?

Set a threshold by value, such as any variance over 2 units or $25, and use a tighter one for high-theft items like tobacco or energy drinks. Print it on the sheet header. A recount before adjusting keeps a miscount from being booked as shrink.

Related resources

More for the same job

Keep reading

Less chasing, more doing

Once the inventory count sheet is in place, the next question is usually about shifts and hours. Book a demo to see how EZTime handles scheduling and time tracking.

General information to adapt to your business. Examples on this page are fictional.