Free inventory count sheet

Download a cycle count template for Excel and a printable blind count sheet. Record physical counts, check discrepancies and keep a record of the review.

Free downloads. No email or account required.

See the worked recount example

Blind inventory count sheet

Batch CC-014 · Zone A · 06 Nov 2026

Site MIA-01 · Counter assigned at kickoff

BinSKUUOMCount
A-01-02TB-104EA⎯⎯
A-01-03CL-208EA⎯⎯
A-02-01PK-310EA⎯⎯

Counted at __________   Initials ______

Record 0 for an empty bin. Leave unchecked rows blank.

Preview of the floor copy with sample item details

Choose a format

Excel workbook preview

Plan each batch, preserve both count observations and record the review in the same workbook.

Start here · Count plan · Reconciliation · Movement log · ABC schedule

Blank reconciliation fields

Batch, site, owner, bin, SKU, lot and UOM. Keep the book quantity at cutoff alongside the first count and independent recount, with a counter and time for each.

Record the confirmed quantity, unit cost, reason, reviewer, decision and sign-off. The workbook calculates quantity and value variances.

Example reconciliation · TB-104

BookFirstRecountConfirmed
120116118118

Quantity variance −2 EA · Value variance −$17.00

Blind count PDF preview

Blind inventory count sheet

Batch __________ · Date __________

Site or zone __________ · Counter __________

BinSKUUOMCount

Counted at __________   Initials ______

Record 0 for an empty bin. Leave unchecked rows blank.

Print and issue the sheet

Print at actual size on US Letter. Fill in the batch, site and zone before issuing a copy. Give a different counter a fresh copy for an independent recount.

Download blind count PDF

How to run a cycle count

  1. Set the scope and cutoff

    Choose a site, owner, bins and SKU units. Capture the book balance at the cutoff.

  2. Issue a blind floor copy

    Count the units physically present. Enter zero only when the bin was checked and is empty.

  3. Check movements and recount

    Record one count time per sheet. Log movements separately and review their timing before confirming a discrepancy.

  4. Reconcile and sign off

    Keep both observations. Record the reason, confirmation, reviewer and approval decision.

Worked example · An independent recount

Batch CC-014 counts TB-104 in A-01-02 at MIA-01. All quantities use EA.

StepTimeQuantity
Book balance at cutoff09:00120 EA
First count09:08116 EA
Independent recount09:24118 EA
Reviewer confirms09:35118 EA

The first observation is 4 units short. With no movements across the cutoff, the reviewer confirms the independent recount.

Quantity variance = 118 − 120 = −2 EA. Value variance = −2 × $8.50 = −$17.00. The reviewer routes the adjustment for approval.

Schedule counts by ABC class

Multiply annual units used by unit cost in the same UOM. Sort by annual usage value, choose thresholds appropriate to your site and adjust for repeated discrepancies or fast-moving SKUs.

For example, A items might be counted monthly, B items quarterly and C items twice a year.

CSV worksheet preview

Use the interchange worksheet when you need plain count and review fields.

SiteBinOwnerSKUUnitCountRecountReasonReviewer
MiamiA-04Northline GoodsCT-200cases6060

Inventory count sheet questions

What is a blind count?

The counter receives the item and location information and records a physical count without seeing the expected stock balance.

What happens if a bin is empty?

Write 0 for a checked empty bin. Leave the count blank when it has not been checked.

When should I use an independent recount?

Follow your variance rules and issue a fresh floor sheet to a different counter. Keep the first observation, recount and review together.

How do I calculate the quantity and value variance?

Subtract the book quantity at cutoff from the confirmed count. Multiply the signed result by cost per unit when cost is available.

Can I use it for a full physical inventory?

Yes. Issue one sheet per zone or batch and reconcile each location, SKU, lot and unit consistently.