Form

Inventory Cycle Count Plan & Count Sheet

A repeatable, single-item cycle-count submission form plus planner guidance, variance rules, reconciliation workflow, required evidence, and escalation steps. Designed so teams can record counts consistently, capture reasons and evidence, and trigger follow-up when counts exceed thresholds.

Interactive Tool

Inventory Cycle Count Sheet

Purpose

This form captures one cycle-count entry and the evidence and actions needed when results differ from expected inventory. Use one submission per item counted. If you need to count many items at once, submit multiple entries or use a CSV upload process (see Capability Enhancement notes).

How to use

Follow the checklist for consistent counting.
Record the expected quantity from your inventory system or last known PAR.
Enter the counted quantity (physically counted).
If the variance exceeds the threshold for the item's ABC category, complete the reconciliation and escalate as required.

Suggested variance thresholds (adapt to your business)

These are starting points to help you prioritize investigations: A items: 2–3% or $ threshold, B items: 5%, C items: 10%. Customize these values for your operation.

Count date

Enter date (YYYY-MM-DD).

Location / Storage area

Select where the item was counted.

Count performed by

Name of the person who performed the physical count.

ABC category

Classify item by value/importance to determine threshold rules.

Item code / SKU

Internal SKU, PLU, or vendor code.

Item name

Common name or description of the item.

Unit of measure

e.g., each, lb, kg, case.

PAR / expected qty

Quantity expected in the system or the PAR level used for this count. (Enter number only.)

Expected quantity (system)

Quantity pulled from inventory or POS/ERP report at count start. If unavailable, leave blank.

Counted quantity (physical)

Enter the physically counted quantity (number only).

Calculated variance (Counted - Expected)

Optional: enter the numeric variance. If left blank, reconciliation owner will calculate. Use CountedQty - ExpectedQty.

Variance percent

Optional: enter percent variance ((Counted - Expected)/Expected * 100). Helpful for threshold checks.

Primary reason for variance

Choose best-fitting reason. If 'Other', describe in notes.

Evidence reference

Enter photo filename, photo URL, invoice number, or receipt ID that supports this count.

Counting checklist (mark items you completed)

Basic checks to ensure a reliable count.

Scales zeroed / tare applied

Packaging sizes checked (cases vs each)

Lot / best-by / use-by recorded when relevant

Double-checked by second counter when variance suspected

Recommended reconciliation action

Choose the action that should be taken to correct or investigate the variance.

Escalate this variance now?

Choose yes to trigger escalation workflow (owner will be notified).

Escalation level

Who should be notified if escalation is requested.

Follow-up notes / immediate actions taken

Describe any immediate corrections, who was contacted, and next steps.

Sign-off (name)

Name of person approving the recorded count.

I confirm this count and the information above are accurate

Required to submit.

You can explore this tool now. Sign in or create an account to save your responses and return to them later.

Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.

Discuss Ask the Librarian

Discussion

Comments and conversation will live here.