Coverage
Compare accepted item-location checks with the checks due in the period. A long list of observations can still miss the difficult locations.
Keep cycle counts on schedule
Give each recurring item-location check a frequency, owner and next date. Follow differences through review before treating the count as accepted.
Sign in to explore the sample and install your own copy.
Plan recurring checks with a ready-to-edit schedule
Cycle count schedule for Excel
Assign item-location checks, choose an interval and track the next due date. Blank and worked-example sheets include overdue and pending-review states. Fictional examples are included.
Set the as-of date when reviewing the workbook. The next due date uses calendar days after the last accepted count, or the first due date if none has been accepted. Seventeen prepared rows per sheet; extend the formulas for a larger plan. The workbook does not send reminders or connect automatically to the app.
Choose the next count from risk and operating experience
A high-value item, a fast-moving consumable and a repeatedly mislocated part may all deserve attention for different reasons.
Swipe horizontally to see all columns →
| Reason to count | What to examine | How to use the result |
|---|---|---|
| Repeated discrepancies | Which SKU-location combination keeps needing a recount? | Temporarily increase frequency and investigate the picking or receiving cause. |
| High consequence of a shortage | Could a missing item stop work even if its unit cost is low? | Give it a count frequency and owner appropriate to that consequence. |
| High movement volume | How often is stock handled, picked or replenished? | Schedule manageable checks around actual work patterns. |
| Stable, low-touch stock | Has the location repeatedly reconciled with little movement? | Review whether a less frequent check is appropriate without silently removing coverage. |
Make the recurring plan specific enough to run
One scheduled check
- Item-location
- Work gloves at A-02
- Frequency
- Every seven days in the fictional example
- Reason
- Repeated location differences during picking
- Completion evidence
- The accepted count line, not a checked calendar box
Keep exceptions visible
A missed date means the check is overdue. A submitted count means someone observed stock. An accepted count means the difference has been resolved. Those three states should not be combined into a single “done” column.
The example retains the latest accepted line with its date. Set the scheduling rule and notification behavior for your operation before rolling it out; the sample does not send a preconfigured email campaign.
Review the plan after several completed cycles
Repeat differences
Group recurring problems by cause and location. More frequent counting alone will not fix a unit mismatch or an unrecorded picking step.
Resolution delay
Measure how long differences remain unexplained. Separately examine time waiting for a recount, evidence or an adjustment decision.
Start with a manageable set of locations
Bring the current SKU-location list and balance source, assign counters, then run the first cycle through acceptance before expanding.
A Jodoo administrator can add a category, change the interval field or give a site its own view without creating a separate disconnected tracker. Keep the common identity and review history when the plan changes. If your main requirement is automated replenishment or large-scale warehouse scanning, assess the wider inventory system as well.
Setting a useful cycle-count routine
How often should A, B and C items be counted?
There is no universal interval. Value is one input; movement volume, repeated discrepancies, lead time and the consequence of a shortage also matter. Record the reason for the selected frequency and review it when the evidence changes.
Should a completed count always advance the next date?
Use an accepted observation, not merely a submitted quantity. A count awaiting a recount or adjustment still has unfinished work. Decide whether your schedule uses fixed calendar dates or an interval after acceptance, and apply that rule consistently.
Can we start with an Excel cycle count list?
Yes. Download the cycle count schedule on this page. Set the as-of date, item-location, owner, interval and first due date; record the last accepted count to calculate the next date. Pending reviews stay visible. Use the separate count sheet for quantities, or Jodoo when counts and approval tasks need to stay linked.
Does this replace a full physical inventory?
Not automatically. Cycle counting provides recurring checks of selected stock. Your operating and reporting requirements determine whether additional full counts are needed. Keep the scope and period of each count explicit.
Continue with the related inventory work
Give recurring counts a clear next date
Inspect the item-location schedule and its accepted history, then choose frequencies that match your stock risks.