Inventory Cycle Count Procedure & Interactive Counting Sheet

Inventory Cycle Count Procedure & Interactive Counting Sheet

This checklist provides a simple, repeatable way to keep inventory accurate without doing a full physical count every week. Use the schedule rules, counting rules, reconciliation steps, and the embedded interactive counting sheet. Submit counts to save them in your site history so you can track trends and follow up on investigations.

Purpose

Cycle counts spot shrinkage, receiving or data-entry errors, and yield problems early so you can protect margins and avoid stockouts. This procedure balances accuracy with low operational friction.

Before You Start

• Gather tools: pen or device, calculator, clipboard or mobile device, current inventory list, labels/tags for counted items.
• Confirm count owner and backup counter for the shift.
• Pause activity where practical to avoid simultaneous movement during the count (e.g., pause receiving briefly in the area being counted).
• Use FIFO and standard yields/units from your recipe book when converting units.

Schedule Rules (sample — adapt to your business)

• High-value/high-turn SKUs: daily to twice-weekly.
• Medium-value SKUs: weekly.
• Low-value/slow-moving SKUs: monthly.
• Use a rotating sample so every SKU is counted at least once in the chosen cycle window (e.g., 90 days).
• After a large delivery, prioritize counts on items on that PO in the next scheduled count.

Counting Rules (standardize to reduce variance)

• Count whole units only. If product is sold in different units (case vs each), record conversion used.
• Record yields when counting prepped or partially used products and note the yield % applied.
• Round only when required by your system and document rounding rules.
• Count each storage location separately when items are spread across locations.
• Two-person rule for high-value items: one counter and one verifier when possible.
• Quarantine open, damaged, or past-dated items and remove from available inventory according to waste policy.