Cycle Counting: How to Do It in a Factory (Step by Step)

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

Cycle counting is a way of checking stock where you count a small group of items on a fixed schedule. You do this instead of counting everything at once in a yearly stock-take. Over the year every item gets counted, and high-value items get counted more often. Because only a few items are counted at a time, the factory keeps running and errors are found within weeks, not at year-end.

What is cycle counting?

Think of it as a stock-take broken into small daily pieces. The stores team counts a short list of items, compares each count with the book figure, and fixes any gap.

Example: in an engineering unit, the stores in-charge counts 7 items today. Tomorrow it is a different 7. By year-end, every item has been counted at least once, and the costly ones several times.

Cycle counting vs year-end stock-take

Both check physical stock against the books. The difference is how much you count at once, and when you find the mistakes.

Question

Cycle counting

Year-end stock-take

Does the plant stop?

No, only the counted items pause

Often, while everything is counted

How often?

Every working day or week

Once a year

When are errors found?

Within weeks

At year-end, months after they happened

Who counts?

Stores in-charge, with a second checker

A large team, often pulled from the shop floor

Effort per day

Light: a few items

Heavy: everything at once

Which items to count and how often

The ABC / 80-20 method: rank items by value × usage

Rank every item by annual consumption value: unit cost × quantity used in a year. The 80/20 rule says a small share of items, roughly 20%, usually carries most of the value, roughly 80%.

Those are your A items. B items sit in the middle, and C items are the many cheap ones. Common schedules run from A monthly, B quarterly and C once or twice a year. Tighter schedules go up to A weekly, B monthly and C quarterly.

Pick the tight end if stock errors keep holding up production. Start at the light end if your team is new to counting.

Count at trigger points too

Some counts should happen because of an event, not a date. In a manufacturing unit, the useful moments are:

  • At GRN, when material arrives.

  • When you issue material to production.

  • When stock hits the reorder level.

  • When job-work material returns from a vendor.

  • When the system shows negative stock.

Counts at these moments are quick, and they catch errors where they start.

Don't skip cheap but critical parts

Pure ABC has a blind spot. A cheap seal or fastener sits in class C, yet running out of it can stop a line. Tag such parts as vital using VED analysis and count them like A items.

Typical cycle count frequency by class
  • A items Weekly to monthly

  • B items Monthly to quarterly

  • C items Quarterly to once or twice a year

  • Vital parts Count like A items

How to do a cycle count, step by step

  1. Post pending entries. Enter every pending GRN, issue and store transfer for today's items first.

  2. Pick today's items. Take the next items due from your ABC list.

  3. Print a blind count sheet. Show item, store and bin, but not the system quantity.

  4. Pause movement. Hold issues and receipts for those items until the count is done.

  5. Count and write the unit. Note kg, nos or metres next to every figure.

  6. Compare and recount. Match counts to the book figure, and recount any item that differs.

  7. Find the cause. Trace the gap to a missing entry, scrap, a unit error or a transfer.

  8. Adjust and log. Post the inventory adjustment with a written reason, and record accuracy.

Who does it? The stores in-charge counts, and a second person checks any variance. The accountant approves adjustments, so counting and approving stay with different people.

Can you do it on spreadsheets? Yes. An Excel list of items, classes and due dates is enough to start. The weak spot is the book figure: if the sheet is updated late, every count shows a false gap.

Where TranZact helps a manufacturer keep counts accurate

A cycle count is only as good as the book figure you count against. TranZact logs every stock in, issue and transfer live, store by store. Each item has a bin card, so you can trace where any gap came from.

Batch tracking, reorder levels and AI stock alerts are built in. Inventory ageing and valuation sit in the same place. Accounting stays in Tally, with a one-way sync and no double entry.

Plans matter here. Stock tracking with ageing and valuation is on Grow and above. Batch-wise stock tracking starts on Scale+. Store-level permissions and Batch Tracking & QC are on Dominate. See pricing for the full list.

One honest limit: you set the ABC list and the counting schedule yourself. TranZact is trusted by 10,000+ manufacturers and goes live in 2–3 weeks. See how the inventory module works.

Counting against a register vs TranZact


Paper register or Excel

TranZact

Book figure

Only as current as the last entry

Stock in, issue, transfer logged live

Where stock sits

Bin cards on paper

Bin card per item, per store

Low stock

Found at the count

Reorder level and AI stock alerts

Accounts

Re-typed into Tally

One-way sync to Tally

Book a demo →

Worked example: a 600-item engineering factory

These numbers are illustrative. Say a unit stocks 600 items and splits them by ABC value.

Class

Items

Counted

Counts per month

A

60

Monthly

60

B

120

Quarterly

40

C

420

Twice a year

70

Total

600

–

170

That is 170 counts a month. Over 26 working days, it comes to about 7 items a day. A small, steady load, with no shutdown.

How to measure cycle count accuracy

Use inventory record accuracy (IRA):

IRA = items matching the system within tolerance ÷ items counted × 100

If you count 170 items and 153 match, your accuracy is 90%. Set a tighter tolerance for A items than for C items. For bulk C items issued by weight, a small allowance is fair. For A items, aim for an exact match.

Why counts don't match in Indian factories

A gap usually means a movement never reached the books. Check these first:

  • Material issued to the shop floor but not entered.

  • Scrap or rejection not booked.

  • Kg and nos mixed up between purchase and issue.

  • GRN entered days after the material arrived.

  • Stock at a job-work vendor counted as missing.

  • Transfers between stores not recorded.

For the full fix, see our guides on stock discrepancy and stock reconciliation. If your records still live in registers, our guide to inventory records compares manual and software options.

Cycle counting and your statutory audit

If CARO 2020 applies to your company, your auditor reports on physical verification of inventory. They check whether its coverage and procedure are appropriate. They also report whether discrepancies of 10% or more, in aggregate for each class, were properly dealt with in the books.

Auditors look for material items covered at least once a year, or under a systematic plan designed by management. A written cycle-count plan with dated count records can support this. Agree the plan with your CA before year-end.

Start counting this week

Pick this week's A items, print a blind sheet and count. If you want to count against a live book figure, see TranZact with your own items.

Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders