Cycle count planner

Plan the next warehouse count by SKU and location. Set ABC intervals, workdays and daily capacity; export the schedule and workload CSV without uploading stock data.

Free to useNo signupMade for daily work

Cycle count planner

Plan each SKU/location’s next count, within your daily capacity.

ABC intervals · calendar days

Synthetic example · click Create plan. Up to 2,000 rows; XLSX first worksheet, 5 MB file limit. Data stays in your browser.

Useful? Share this tool.

Share the tool address. Your entered values are not included.

Due dates, priorities and capacity

Due date = last count date + your class interval. Blank dates are due from the planning start. The oldest due date is planned first, then A/B/C and input order. Each SKU/location appears once. A day’s capacity counts tasks, not units or labour hours.

The selected week excludes regular non-working days only. No public holidays, travel times or SKU complexity are assumed. Dates use YYYY-MM-DD. Rows outside the window or over capacity stay visible in the export.

Prepare your input

Use SKU, Location, Class and LastCountDate. A SKU may repeat in different locations; the same SKU/location pair cannot repeat. Class must be A, B or C. Last-count dates cannot be after the planning start.

Read the cycle counting workflow

Worked example

Illustrative inputs and outputs to help you check your own task.

Spread the workload

Inputs
Four never-counted SKU/location pairs, two counts per day, starting Monday 2026-10-19.
Output
Two tasks fall on 19 October; two on 20 October.

Each SKU/location pair appears once; this is a next-count plan, not a recurring calendar.

Keep capacity limits visible

Inputs
Four due tasks, one planning workday, capacity two.
Output
Two tasks are scheduled and two show Capacity full.

Unscheduled rows stay in the export so they can be reviewed.

Keep the count results with your stock records

Try the free Excel sample for product setup, stock balances and pack-rounded reorder suggestions. The full AUD29 kit adds the overview and stocktake, with 200 product rows and 2,000 movement rows.

No email required. The sample is a working file with synthetic data. The full kit is a blank template; applicable taxes are included in AUD29.

Put the tools into a working process

Reorder points, MOQ and pack sizesA practical cycle counting workflow

Your work stays yours.

These tools run in your browser. They do not upload your entries or store them after you leave. Downloads are created on your device. Hosting providers may process standard access logs.

Find your next tool