Choose the count scope
Decide what one task means before choosing a daily capacity. In the free planner, a task is one SKU at one location. A product stored in two bins creates two tasks. Neither item quantity nor carton count determines how long a task takes.
ABC analysis can help set priorities, but value is only one factor. Operational criticality, past errors and handling difficulty may justify a different count interval. Choose your own A, B and C intervals rather than treating the example values as a warehouse standard.
Build the next-count schedule
Keep SKU, Location, Class and LastCountDate in the input file. The planner adds the selected class interval to the last count date. A blank last-count date is due from the start of the plan. It then fills the oldest due tasks first, subject to the daily limit and selected working week.
| Input | Plan |
|---|---|
| Four never-counted SKU/location pairs | Four tasks, each scheduled once |
| Start Monday 2026-10-19; capacity 2/day | Two on Monday, two on Tuesday |
| Reduce the window to one workday | Two scheduled; two show Capacity full |
This is a next-count plan. It schedules each input pair once, even when a short class interval would fall due again within the window. Run a fresh plan after recording completed counts. Holiday closures must be checked separately.
Count and reconcile
- Record the book quantity and its timestamp before counting. Use the same unit as the physical count.
- Control or separately record stock movements while counting. A later receipt can otherwise look like a count error.
- Recount unexpected differences, check the SKU and location, then document the reason.
- Post an adjustment only through your authorized stock process. These website tools never update ERP balances.
Before you rely on the plan
- Use one unique SKU/location pair per row and real ISO dates.
- Review unscheduled tasks and overdue items; a full calendar does not mean every due task fitted.
- Check whether your daily capacity is realistic for the chosen bins and products.
Background: Oracle describes ABC-based count frequency and the role of workday calendars. The free Warelium tool uses the simpler next-count rules explained above. Oracle cycle count criteria
Continue your stock workflow
Reorder points, MOQ and pack sizes
Want to keep product setup, stock movements and reorder records in one file? Try the free Excel sample and compare the full kit.