Article

What Is Cycle Counting? How to Run It Without Stopping Sales

Warehouse staff checking stock on the racks during a cycle count
On this page

Cycle counting is a method of continuously counting part of your stock on a repeating schedule through the year, rather than closing the whole warehouse for a single periodic full count. It keeps book accuracy above 98%, surfaces the causes of stock loss early, and lets selling and goods movements carry on without interruption.

For retailers, e-commerce sellers and distributors holding thousands of SKUs, halting dispatch for a full count costs a great deal in revenue and customer experience. This article examines what cycle counting really is, how to classify stock under the ABC model, how to set up a standardised seven-step counting process, and provides a practical stock reconciliation record template.

1. What Is Cycle Counting?

Cycle counting is an inventory auditing technique carried out progressively each day or week on specific product groups, so that the entire catalogue is reviewed several times within a year. Unlike a full count, which ties up the whole team and freezes goods movements, cycle counting runs alongside normal transactions, keeping the warehouse stable and delivery promises intact.

How Cycle Counting Works

The mechanism rests on breaking the count into small portions that are easy to control and keep going:

  • Divide the catalogue into small sets: Instead of counting tens of thousands of items at once, the warehouse splits stock into small groups by rack location, by product code or by turnover value.
  • Set a fixed counting schedule: Each day, or at the start of each shift, the counter only has to check 10 to 30 items assigned by the system, taking 30 to 45 minutes.
  • Reconcile the figures the same day: The quantity actually counted on the shelf is compared immediately with the quantity in the software, so discrepancies show up at once.
  • Look for the root cause: When there is a discrepancy, the investigation starts the same day while the most recent goods documents are still fresh, making verification quick and accurate.

Cycle Counting Compared With a Full Count

The table below sets out the core differences between the two approaches to stock control:

CriteriaCycle countingFull physical inventory
Scope of the countA small part of the catalogue each round.100% of the goods in the warehouse.
FrequencyDaily, weekly or monthly.Every six months or once a year.
Effect on sellingNo interruption at all; the warehouse runs normally.Goods movements stop for one to three days.
Data accuracyContinuously high (usually above 98%).Accurate only at the moment of the count.
Pressure on resourcesSpread evenly, taking little time each day.The whole team mobilised, with heavy overtime.
Ability to fix errorsProcess errors spotted and corrected immediately.Discrepancies found far too late, hard to trace.

When should a business adopt it?

Move to cycle counting when these practical operating needs appear:

  • A multichannel retailer or marketplace seller that cannot stop taking and packing orders each day.
  • A large number of SKUs with continuous, high-intensity goods movements.
  • The software regularly shows stock available when the shelf is already empty, leading to a high order-cancellation rate.
  • The business holds many high-value, perishable or loss-prone product groups that need close supervision.

2. How to Schedule Counts by Product Group

Scheduling a cycle count does not mean mechanically dividing the catalogue into equal portions; it has to follow the risk and the value each item contributes. Applying the Pareto principle and ABC classification lets a business concentrate control on the 20% of items that matter most, protecting more than 80% of the asset value in the warehouse.

A warehouse with rows of pallet racking and clearly marked locations
Clear location labels on every rack row are the prerequisite for scheduling counts by ABC group.

Classifying Stock With the ABC Method

ABC analysis is the foundation for allocating the right counting frequency to each product group:

  • Group A (highest value): Around 10% to 20% of all SKUs but 70% to 80% of total consumption or stock value. These are the items that bring in most of the revenue or carry a high unit price.
  • Group B (medium value): Around 20% to 30% of SKUs, representing roughly 15% to 20% of the warehouse's total turnover value.
  • Group C (low value): Up to 50% of all SKUs but only around 5% of stock value, typically small accessories, packing materials or slow movers.

How to classify goods into A, B and C in logistics is covered in more detail in a dedicated article.

A note on judgement:

Classification should not rest on selling price alone. Combine it with practical criteria such as turnover speed, scarcity of supply, shelf life and the history of past discrepancies to group items accurately.

Setting the Frequency and the Counting Schedule

From the ABC results, build a specific counting schedule for each cycle:

  • Counting cycle for group A: Count once a month, or even once a week for items with very high movement.
  • Counting cycle for group B: Count once a quarter (every three months) to review stock movements.
  • Counting cycle for group C: Count every six months, or spot-check when there are signs of a discrepancy.

An illustrative counting plan for a warehouse holding 1,000 SKUs:

Product groupNumber of SKUsCounting frequencyCounts per yearSKUs to count per day (250 working days)
Group A200 SKUsOnce a month (12 times a year)2,400 countsAbout 10 SKUs a day
Group B300 SKUsOnce a quarter (4 times a year)1,200 countsAbout 5 SKUs a day
Group C500 SKUsTwice a year1,000 countsAbout 4 SKUs a day
Total1,000 SKUsOn a rotating cycle4,600 countsAbout 19 SKUs a day

Counting Without Interrupting Sales

To keep selling undisturbed while counting, apply the following practical measures:

  • Pick the right window to count: Do it at the start of the morning shift before picking begins, or at the end of the afternoon shift once the delivery vehicles have left.
  • Local location freeze: While a counter is working on a particular bin, the management software temporarily locks picking at that exact bin for 10 to 15 minutes; the rest of the warehouse dispatches as normal.
  • A clear cut-off time: If goods must go out while counting is under way, the storekeeper has to establish whether that order was deducted in the system before or after the counter recorded the physical figure, to avoid double-counting or omission.

3. The Counting Process and Handling Discrepancies

A standardised cycle counting process demands transparency, independence and real discipline, from taking the figures through to reconciling the paperwork. Every discrepancy, whether surplus or shortfall, must be treated as a warning sign of an operational problem; never adjust the figure in the software before the root cause is clear.

The Standardised Seven-Step Counting Process

Apply a closed-loop cycle counting process following these standard steps:

  • Step 1: Generate the day's count list: The software or the warehouse manager produces the list of SKUs to count under the ABC schedule. The list shows only the product code and the rack location, never the book quantity, so the count stays objective (blind counting).
  • Step 2: Count physically at the rack: The counter goes to the location, scans the location code, counts the actual quantity, checks the condition of the packaging and the expiry date, and records the figure on the sheet or handheld terminal.
  • Step 3: Enter and reconcile automatically: The physical data goes into the system to be compared with the book balance at the cut-off moment.
  • Step 4: Independent recount: For any SKU with a discrepancy beyond the tolerance threshold (usually more than one unit, or a value difference above 200,000 VND), a different member of staff is sent to count it a second time.
  • Step 5: Investigate the cause: Review all goods-in and goods-out notes, returns not yet booked in, damaged stock not yet written off, or check neighbouring bins in case the item has been misplaced.
  • Step 6: Submit the adjustment for approval: Prepare a report explaining the discrepancy with documentary evidence and pass it to the authorised level for approval.
  • Step 7: Adjust the stock and file the record: The warehouse accountant posts the stock adjustment in the system exactly as approved and keeps the transaction history.

This whole cycle should be written down as a standard alongside the seven-step standard warehouse operating process so every department follows it.

Analysing and Handling Each Type of Discrepancy

Each form of discrepancy reflects a specific gap in warehouse operations:

  • Physical stock lower than the books (shortfall): Usually because goods went out to a customer but nobody created the dispatch note, items were broken and discarded without being reported, stock was misplaced elsewhere, or there has been theft.
  • Physical stock higher than the books (surplus): Usually because returns from customers reached the warehouse but were never booked back in, a supplier over-delivered, or items were short-picked when packing an order.
  • Discrepancies from confusion over pack sizes: Very common when staff mix up units of each, box and carton (for example, dispatching one carton of 12 but only deducting one unit in the software).

Many discrepancies start with goods being put in the wrong place, so a methodical warehouse organisation system prevents more than repeated recounting ever will.

Metrics for Measuring Stock Accuracy

To track whether the process is improving, quantify it with core performance indicators (KPIs):

  • SKU accuracy rate:

SKU accuracy (%) = (Number of SKUs whose physical quantity matches exactly ÷ Total SKUs counted in the period) × 100%

The international benchmark for warehouses running cycle counting is above 97% to 99%.

  • Net dollar accuracy:

Value accuracy (%) = 100% − (Total absolute value of discrepancies ÷ Total stock value in the system) × 100%

This indicator shows how far stock discrepancies affect the company's financial reporting.

Figures from the Association for Supply Chain Management (ASCM):

Businesses running cycle counting successfully can hold stock data accuracy at 98.5% to 99.5% throughout the year. This cuts the annual cost of counting labour by up to 65% and removes revenue loss from broken orders entirely.

4. Responsibilities and a Count Record Template

Counting is only transparent when there is a clear separation between the person holding the goods, the person counting them and the person approving adjustments. A solid internal control system removes any possibility of collusion or of quietly adjusting figures to hide operational failures.

Staff operating forklifts while the warehouse keeps running as normal
Only the bin being counted is locked for 10 to 15 minutes; the rest of the warehouse moves goods as normal.

Responsibilities by Role

Set clear boundaries of responsibility for everyone involved:

  • Independent counter: Responsible for counting the physical quantity at the rack and signing the raw count sheet; must not also pick or act as storekeeper for that area.
  • Area storekeeper: Helps point out locations and explains issues with recent goods documents, but must not write down the counted quantity.
  • Warehouse accountant or reconciler: Receives the raw count, enters it into the system to compare with the book balance, and orders a recount where there is a discrepancy.
  • Warehouse manager: Leads the investigation into the cause, decides whether the fault is in the process or with a person, and proposes how to resolve it.
  • Operations director or finance director: The only person authorised to sign off a record adjusting stock quantities up or down in the software.

A Standard Cycle Count Record Template

A complete cycle count record needs to capture all of the following reconciliation fields:

Count reference: CC-2026-10-22Date: 22/10/2026Time window: 07:30 – 08:30
Counted by: Nguyen Van AReconciled by: Tran Thi BApproved by warehouse manager: Le Van C

Detailed reconciliation of the goods counted:

SKUProduct nameUnitRack locationBook quantityPhysical quantityDifferenceValue of difference (VND)Cause establishedProposed action
AO-POLO-TR-MWhite polo shirt, size MEachA1-02-03454500Exact matchNo action needed
GIAY-SNK-DEN-40Black sneakers, size 40PairB2-01-011210-2-900,000Wrong size 41 dispatched, note not correctedDeduct size 40, add back size 41
SON-KEM-DO-01Red matte lip cream, shade 01UnitC1-04-028083+3+450,000Customer return not booked back inAdd 3 units back into stock

Signatures: counter (sign) – warehouse accountant (sign) – approving manager (sign)

Rules That Must Be Followed When Adjusting Stock

Following these rules strictly protects the integrity of the accounting data:

  • Never adjust by netting off: Do not use a surplus to cover a shortfall arbitrarily without a clear written explanation for each SKU.
  • Every adjustment needs a reason code: When working in the software, select the correct adjustment reason (goods returned, damaged stock written off, count adjustment).
  • Keep a permanent audit trail: The system must automatically record who made the adjustment, on what date and time, and by how much.

5. Optimising Cycle Counting for Lasting Accuracy

Cycle counting is not a destination but a tool for improving operational quality continuously. If you count regularly yet the same discrepancies keep recurring in the same product group, it shows the goods-in and goods-out process, or the way stock is stored, has a serious problem that needs restructuring.

Mistakes That Make Counting Ineffective

Many warehouses run cycle counting without results because of these common mistakes:

  • Counting for show: Staff read the book quantity and copy it onto the count sheet without actually climbing to the rack and counting each carton.
  • No clear cut-off moment: Counting while goods go out without noting the time, so the physical figures and the software are permanently out of step.
  • Fixing the number but not the process: On finding stock missing, simply writing it off in the software without asking why it went missing, so the loss keeps repeating.

Using Excel and a WMS for Counting

Choosing a management tool that fits your scale automates the scheduling and the reconciliation:

  • Using an Excel spreadsheet: Suitable for warehouses under 500 SKUs, using automatic functions such as XLOOKUP and SUMIF to compare the physical count column with the book quantity column. How to build the tracking file is covered in warehouse management with Excel.
  • Using a WMS: Essential for large warehouses, a WMS automatically generates the daily count list using the ABC algorithm, sends the count instruction straight to the handheld terminal, and locks the rack location in an instant.

For small online shops, managing inventory for an online shop run from home sets out a simpler process that still keeps the figures accurate.

When should you reassess the warehouse process?

Review the whole operational design when:

  • The stock discrepancy rate has not fallen after three months of continuous cycle counting.
  • Goods are stacked haphazardly with no clear location labels, so staff spend far too long finding the items to count.
  • The warehouse is so cramped that goods spill into the aisles and block access to the bins inside.

If the cause lies in how goods are stacked, storage pallets and the warehouse security system are two things worth reviewing at the same time.

Not sure how many cubic metres the goods you need to move to a satellite warehouse come to? Photograph your packages and let MyStorage's AI Size Estimator work it out for you:

MyStorage: Space Solutions That Support Your Business

When the main warehouse is overloaded and arranging and counting goods becomes difficult, renting a satellite storage space is an effective way to clear the bottleneck:

  • Independent, orderly storage space: MyStorage provides air-conditioned self-storage rooms from 10m² to 40m² in Ho Chi Minh City, so a business can easily move reserve stock and long-term inventory out of the main warehouse to create operating room. Preview the mini storage sizes to picture the capacity.
  • An air-conditioned environment built to standard: Temperature held below 25°C and humidity under 60%, protecting high-value goods such as an online shop's cosmetics, keeping packaging and labels intact so barcode scanning during a count goes quickly.
  • Control and count on your own terms: Customers have their own lock and can come and go to count stock at any time, without their goods being mixed up with anyone else's. Details of the facilities are on the locations page.

Reference Prices for Storage Services

Below are reference prices for flexible storage space that helps a business take the load off its main warehouse in Ho Chi Minh City:

Type of spaceSizeReference priceBest suited to
Mini storage cube2 – 4 m³800,000 – 1,400,000 VND / monthSamples, small accessories, accounting and count records.
Small air-conditioned self-storage room6 – 10 m²2,800,000 – 4,500,000 VND / monthE-commerce stock and high-value goods needing close control.
Standard self-storage room15 – 25 m²6,500,000 – 9,500,000 VND / monthA satellite warehouse holding reserve stock for a retail chain.
Shared storage charged by the cartonPer carton35,000 – 60,000 VND / carton / monthDocuments and long-term records rarely retrieved individually.

Please note: the prices above are indicative for the Ho Chi Minh City market in late 2026. Actual unit prices vary with the location of the facility, the climate-control package and the contract term chosen. See also storage costs in Ho Chi Minh City for comparison.

Pick a storage type, size and temperature option to see today's MyStorage price instantly and book with an offer:

Keeping Stock Accurate to Lift Your Operation

Cycle counting is not simply recounting each item; it is the magnifying glass that lets a manager see the operational health of the whole supply chain. By classifying stock methodically with ABC, building a rigorous seven-step counting process and dealing thoroughly with the root causes of discrepancies, a business builds stock figures it can genuinely rely on.

Make counting a light daily habit rather than a nightmare every year end. If you are still weighing up storing goods yourself against renting outside, the article on renting storage versus keeping things at home helps you balance the total cost.

If your business needs clean self-storage space with proper air conditioning to separate goods and streamline counting in Ho Chi Minh City, get in touch with MyStorage for advice on the storage solution that fits best.

Frequently Asked Questions

Can cycle counting replace a full physical inventory entirely?

It can replace it entirely if the business can show the cycle counting process holds data accuracy continuously above 98% and the independent auditor accepts this in the internal accounting policy.

How many times a month should a warehouse cycle count?

The frequency depends on the number of SKUs. Typically counting happens every working day, covering 10 to 30 SKUs a day, so that all group A items are counted monthly and group B quarterly.

Does cycle counting require goods movements to stop?

There is no need to stop the whole warehouse. You only lock movements at the exact bin being counted for 10 to 15 minutes; the rest of the warehouse carries on as normal.

When a discrepancy is found, who may approve the adjustment?

Only the warehouse manager, chief accountant or operations director has authority to sign off a stock adjustment in the system; the storekeeper must never change the figure alone.

Can a small business run cycle counting in Excel?

Absolutely. Set up a tracking sheet grouping products by ABC, schedule the counts by day, and use lookup functions to reconcile the physical quantity against the book balance.

How do you measure stock accuracy after each count?

Accuracy is measured as the percentage of SKUs matching exactly, divided by the total SKUs counted in that round, together with the absolute value discrepancy as a share of total stock value.

Does a WMS automate the cycle counting process?

Yes. Modern WMS software classifies stock by ABC automatically, issues the day's count list to each worker's PDA, and locks the rack location automatically when a count is ordered.

What is blind counting in cycle counting?

Blind counting means giving staff the count list with the book quantity hidden, so they have to count physically at the rack and record the most honest figure.

What discrepancy tolerance is acceptable in a warehouse count?

It depends on the industry. For high-value group A items the tolerance is usually 0% (an exact match); for screws and minor supplies in group C it may range from 1% to 2%.

What should you do if one SKU is out by the same amount three counts running?

Isolate that SKU, review the packing camera footage for recent orders, check back with the supplier, and interview the staff responsible for that rack area directly to find the gap in the process.

Should staff be rewarded or penalised on cycle count results?

Reward against a stock accuracy KPI for the area each person manages, to encourage responsibility, while holding people to account where fraud or carelessness is found.

How long should a daily cycle count take?

Ideally 30 to 45 minutes at the start or end of each shift, so it does not hold up the warehouse's picking and packing.

Is counting supported for goods stored at MyStorage self-storage?

Customers renting self-storage at MyStorage manage their own goods entirely and can come to count them at any time; MyStorage provides secure space and trolleys so counting is as convenient as possible.

How should misplaced goods be recorded on the count sheet?

Record the SKU as short at rack A and as surplus at rack B, then raise a location transfer note to bring the item back to the right coordinates in the software, rather than posting a fictitious goods movement.

Why not wait until year end and count the whole warehouse once?

Waiting until year end makes it impossible to trace the cause of discrepancies that arose months earlier, and the business takes a heavy loss from closing and halting trade for several days.

Need space?

Find the right storage size in under a minute

Climate-controlled units from 1 m³ in District 2 and District 7, 24/7 access, and a team that can pick your things up for you.

PricesBookWhatsAppZalo