Cycle Count Sheet & Frequency Planner

Use this worksheet to plan and run targeted cycle counts

This interactive worksheet helps you decide which SKUs to count, how often to count them, and gives a simple way to record count batches. It favors targeted cycle counting (high-value and high-velocity SKUs more often) over full physical inventories. Follow the three steps below:

1. Plan: set sampling percentages and choose a frequency mapping for high/medium/low SKUs.
2. Count: paste or type count rows for each counted SKU using the CSV box or use the printable table below for paper counts.
3. Reconcile: use the variance prompts to investigate and assign follow-up actions.

Printable count sheet — copy the HTML table below into a simple page to print for on-floor counting:

<table border=1 cellpadding=6 style=border-collapse:collapse;width:100%> <thead><tr><th>SKU</th><th>Description</th><th>Location</th><th>Expected Qty</th><th>Counted Qty</th><th>Variance</th><th>Notes</th></tr></thead><tbody><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><!-- Copy additional rows as needed --></tbody></table>

Quick heuristic (starter): high-velocity SKUs — count weekly or twice weekly; medium — weekly to biweekly; low — monthly to quarterly. Adjust frequencies based on observed variance, cost impact, and business risk.