63% of warehouses have discrepancies between physical inventory and system, per market estimates. The traditional annual inventory requires stopping operations and can take days.
Cycle counting reduces discrepancies by 95%+ without interrupting operations, maintaining accuracy of 99.5%+ with only 30 daily counts instead of inventoring 1,080 locations at once.
63%
warehouses with physical inventory vs. system discrepancies
95%+
discrepancy reduction with cycle counting
99.5%+
ideal precision with continuous cycle counting
What is Cyclical Inventory?
Definition
He cyclical inventory (also known as cycle counting o rotating inventory) is a method of inventory management that consists of making periodic accounts of specific groups of products instead of waiting once a year to do the complete record.
Unlike the annual inventory that requires stopping operations, cycle counting is carried out continuously and routinely, distributing the effort throughout the year without interrupting activities from the warehouse.
According to the Mexican accounting standards (NIF C-4) of the IMCP, The inventory must reflect the actual condition of the assets. Cycle counting allows this precision to be maintained without the operational and opportunity costs of a full annual inventory.
Objective of Cycle Counting
The main objective is improve the reliability and accuracy of inventory control. beyond To verify the existence of merchandise, cycle counting allows:
Prevent and detect errors before they accumulate
Maintain 99.5%+ accuracy without stopping operations
Facilitate purchasing decision making with updated data
Prevenir quiebres de stock y sobrestock
3 Types of Cycle Inventory
There are three main methods depending on the criteria used to create the counting groups. Click on each one to find out when to use it:
Diagram: ABC Classification of Inventory
Based on the Pareto principle (80/20). A products are counted most frequently because they represent the greatest economic value.
Cyclical vs. Periodic vs. Annual Inventory
Each method has its place depending on the needs of the warehouse. This comparison helps you choose the right one:
| Feature | Cyclic | Newspaper | Anual |
|---|---|---|---|
| Frecuencia | Continuo (diario/semanal) | Several times a year | Once a year |
| Alcance | Grupos de referencias | entire warehouse | entire warehouse |
| Operations interruption | None | Parcial | Total (2-5 days) |
| Error detection | Quick (weeks) | Media (meses) | Slow (full year) |
| Maintained precision | 99.5%+ | 95-98% | 90-95% |
| Operating cost | Distributed in time | Moderado | Alto (personal extra) |
| Complejidad | Medium (requires planning) | Baja | Baja |
| best for | Active warehouses, high turnover | Almacenes medianos | Basic tax compliance |
How to Implement Cycle Inventory: 5 Steps
Implementing cycle counting does not require expensive consultants. These 5 steps are a practical guide that any warehouse can follow:
Clasificar Productos (ABC)
Analyze your references according to the Pareto principle. Identify which 20% generate 80% of sales (A), 30% generate 15% (B) and 50% generate 5% (C).
Calcular Frecuencia de Conteo
Use this formula to determine how many daily counts you need:
Definir Proceso y Responsables
Document who counts, when, how it is recorded, and what to do with discrepancies. Create a standard checklist for each count.
Ejecutar Primer Ciclo Piloto
Start with a small group (10-20 type A referrals) for 1 week. Measure precision before and after.
Medir y Ajustar
Calculates the ERI (Inventory Recording Accuracy) indicator weekly. Adjust frequency if accuracy drops below 99.5%.
Practical Example: Auto Parts Company in Monterrey
An auto parts distribution company in Monterrey with 1,080 locations implemented ABC cycle counting. This is your model:
| Category | Nº Ubicaciones | Frecuencia Conteo | Conteos/Mes | Business Days/Month | Counts/Day |
|---|---|---|---|---|---|
| A (Motores) | 600 | Mensual | 600 | 22 | 27 |
| B (Frenos) | 240 | Semestral | 40 | 22 | 2 |
| C (Cajas cambio) | 240 | Anual | 20 | 22 | 1 |
| TOTAL | 1080 | - | 660 | 22 | 30 |
Resultado
Instead of inventorying 1,080 locations once a year (requiring to stop operations for 2-3 days), now they do 30 conteos diarios without interrupting activities. Accuracy went up of 92% a 99.3% and picking errors decreased 45% en 6 meses.
Advantages and Disadvantages of Cycle Counting
Ventajas
- Maintains 99.5%+ accuracy without stopping operations
- Detect errors quickly (weeks vs months)
- Reduce quiebres de stock y sobrestock
- Distributes operating cost over time
- Facilitates decision making with updated data
- Improves warehouse productivity (fewer picking errors)
Desventajas
- Requires constant planning and discipline
- Need initial team training
- Algunas referencias se cuentan menos frecuentemente (tipo C)
- May require specialized software (WMS) for large volumes
KPIs to Measure Cycle Counting
These indicators allow you to measure the effectiveness of your cycle counting program:
ERI (Accuracy of Inventory Recording)
Formula: (Conteos correctos / Total conteos) × 100
Ideal: 99.5%+ (clase mundial)
Leading Inventory Accuracy Indicator
Tasa de Discrepancias
Formula: (Discrepancias encontradas / Total conteos) × 100
Ideal: < 0.5%
Percentage of counts with differences between physical and system
Cost per Count
Formula: Time × Operator hour cost
Ideal: Minimize without sacrificing precision
Operating cost of each individual count
Tiempo Promedio de Conteo
Formula: Total time / Number of counts
Ideal: < 15 minutes per location
Counting process efficiency
Herramientas: Excel vs WMS vs ERP
Each tool has its advantages depending on the size and complexity of your warehouse:
Excel
Ventajas:
- Gratis y conocido
- Flexible to customize
- Suitable for < 500 SKUs
Desventajas:
- Manual and error prone
- No automatiza frecuencia
- Difficult to climb
Best for: Small warehouses (< 500 references)
WMS
Ventajas:
- Automatiza frecuencia de conteo
- Integrate with picking and reception
- Reportes en tiempo real
Desventajas:
- Implementation cost
- Requires training
- May be excessive for little ones
Best for: Almacenes medianos/grandes (500+ referencias)
ERP
Ventajas:
- Full integration with accounting
- Automatic tax compliance
- 360° view of the business
Desventajas:
- More expensive
- Complex implementation
- Overhead for inventory only
Best for: Companies that need accounting integration
How does OCL Cargo enhance inventory control?
OCL Cargo automates inventory control and invoice auditing, specifically designed for logistics operators in Mexico:
- Centralized Dashboard: Replaces multiple Excel sheets with a single dashboard that consolidates inventory KPIs in real time.
- Automatic Audit: Detects discrepancies between invoices and actual execution. In the 3PL case recovery was 5.7% of audited spend ($3.6M MXN in 6 weeks) after moving from sampling to 100%.
- Digital Documentation: Mobile portal that eliminates manual errors in PODs and Carta Porte.
Key takeaways5 points
- 63% of warehouses have discrepancies between physical inventory and system. Cycle counting reduces errors by 95%+ without stopping operations.
- There are 3 types: ABC (most common, based on Pareto 80/20), Group (for initial implementation) and Random (for similar products).
- ABC cycle counting allows you to maintain 99.5%+ accuracy with only 30 daily counts vs. 1,080 locations that would require a full annual inventory.
- The frequency formula: Counts/day = (Number of locations × Annual frequency) / Business days. Example: 600 type A locations with monthly count = 27 counts/day.
- The ERI indicator (Accuracy of Inventory Recording) must be 99.5%+ for world-class warehouses. Cycle counting is the only way to maintain it without stopping operations.
Frequently Asked Questions
Cycle inventory (also called cycle counting or rotating inventory) is a method of taking periodic counts of specific groups of products instead of waiting once a year to do the complete record. It serves to maintain inventory accuracy of 99.5%+ without stopping operations, detect errors quickly and prevent stockouts.
ABC cycle counting is based on the Pareto principle (80/20). Classify your products: A (20% that generates 80% of sales, monthly count), B (30% that generates 15% of sales, semiannual count), C (50% that generates 5% of sales, annual count). Calculate frequency with the formula: Counts/day = (Locations × Annual Frequency) / Business days. Example: 600 type A locations with monthly count = (600 × 12) / 264 = 27 counts/day.
The cyclical inventory is carried out continuously by reference groups (daily/weekly) without stopping operations. The periodic inventory is carried out several times a year but especially in the warehouse, requiring a partial stoppage of operations. The cyclic maintains 99.5%+ accuracy and detects errors in weeks; the newspaper maintains 95-98% and detects errors in months.
The frequency depends on the type of product according to ABC classification: Products A (high turnover): monthly (27 times/day in a warehouse with 600 locations). Products B (medium rotation): semi-annual (2 times/day). Products C (low rotation): annual (1 time/day). The formula is: Counts/day = (Number of locations × Annual frequency) / Business days.
The main advantages are: (1) Maintains 99.5%+ precision without stopping operations, (2) Detects errors quickly (weeks vs. months), (3) Reduces stock outages and overstocks, (4) Distributes operating costs over time, (5) Facilitates decision making with updated data, (6) Improves warehouse productivity (fewer picking errors).
Use this formula: Counts/day = (Number of locations × Annual frequency) / Business days. Example: 600 type A locations with monthly counting (12 times/year) in 22 business days/month = (600 × 12) / 264 = 27 counts/day. For B products (semi-annual, 2 times/year): (240 × 2) / 264 = 2 counts/day. For C products (annual, 1 time/year): (240 × 1) / 264 = 1 count/day.
The ERI is the primary KPI for measuring inventory accuracy. It is calculated as: ERI = (Correct counts / Total counts) × 100. The world class standard is 99.5%+. A low ERI indicates frequent discrepancies between physical inventory and the system, which causes stockouts, overstocks, and picking errors. Cycle counting is the only way to keep ERI high without stopping operations.
SAP Business One allows you to manage cycle inventory from a single system. Steps: (1) Configure cycle counting groups in the inventory module, (2) Assign frequency (monthly/semi-annual/annual) by ABC category, (3) The system automatically generates count lists according to frequency, (4) Record discrepancies in the inventory module, (5) The system automatically updates the inventory and generates ERI reports.
For Excel: (1) Create a sheet with columns: SKU, Category (A/B/C), Last Count, Next Count, Frequency, Responsible. (2) Use formulas to calculate next date: =Last count + Frequency. (3) Filter by date to generate daily lists. (4) Record results on another sheet. (5) Calculate ERI manually. Limitation: Requires manual discipline and is prone to errors. Recommended only for < 500 SKUs.
Example auto parts company in Monterrey: 1,080 total locations. Category A (engines, 600 locations, 80% sales): monthly count = 27 counts/day. Category B (brakes, 240 locations, 15% sales): semiannual count = 2 counts/day. Category C (cash exchange, 240 locations, 5% sales): annual count = 1 count/day. Total: 30 counts/day vs. full annual inventory that required stopping operations for 2-3 days. Result: accuracy rose from 92% to 99.3%.