7 Fatal Mistakes in Periodic Inventory Counting: Lessons from a 10-Year Warehouse Manager and Complete Solutions

Inventory counting is the most critical activity in warehouse management, but it's also where the most errors occur. After 10 years working in Vietnam's logistics sector, I've witnessed countless cases where businesses lost millions of dong, or even had to halt operations due to seemingly simple inventory counting mistakes. This article will share the 7 most common mistakes and complete solutions based on real warehouse operations in Vietnam.

Why is periodic inventory counting so important?

Periodic inventory counting is not just about counting stock. It's a core activity that helps businesses firmly grasp asset status, detect losses, optimize cash flow, and ensure accurate data for the entire inventory control system.

In Vietnam's logistics environment with diverse goods characteristics, multiple transportation methods, and different storage approaches, periodic counting also helps:

• Early detection of discrepancies: Differences between system data and actual warehouse stock often stem from errors in import/export processes, transportation, or even losses. Early detection minimizes damage.

• Optimizing business decisions: Accurate inventory data is the foundation for demand forecasting, purchase planning, and effective cash flow management.

• Regulatory compliance: Many industries require periodic inventory reporting. Consult and check current regulations applicable to your specific business sector.

• Enhancing credibility: Customers and partners trust businesses more when working with companies that have strict and transparent warehouse management systems.

However, for periodic counting to be effective, businesses need to avoid the following common inventory mistakes.

Mistake 1: Not freezing import/export documents during counting

This is the most common and dangerous mistake in counting procedures. Many warehouses continue import/export operations while counting, causing data to constantly change and making counting results completely meaningless.

Specific consequences

• Uncontrollable discrepancies: You count 100 boxes at location A at 9 AM, but by 10 AM, 20 boxes are exported. When reconciling at day's end, no one knows where the discrepancy originated.

• Multiple recounts required: Wastes effort, time, and demoralizes staff.

• Loss of confidence in results: When counting results are unreliable, all efforts become meaningless.

Solutions

Before counting:

• Notify all related departments (import/export, transportation, sales) about the document freeze time.
• Process all pending import/export documents before cutoff.
• Lock the function to create new documents in TMS or warehouse management software.

During counting:

• Absolutely no import/export transactions allowed, except special emergencies requiring senior management signature and separate documentation.
• If emergency import/export is mandatory, document in detail and adjust counting results immediately.

After counting:

• Only unlock documents after completing reconciliation, confirming results, and updating the system.

Mistake 2: Unsynchronized counting across work shifts

Many warehouses operate 2-3 shifts/day, but periodic counting is only performed by one shift, or shifts count separately without strict handover and reconciliation.

Specific consequences

• Duplication or omission: Shift 1 counts area A, shift 2 also recounts area A due to unclear handover. Or conversely, both shifts think the other counted, so skip an area.

• Lack of accountability: When errors occur, it's impossible to determine which shift is responsible.

• Extended counting time: Due to multiple rechecks required.

Solutions

Detailed planning:

• Clearly divide counting areas for each work shift.
• Use warehouse maps, color-code each counted/uncounted area.
• Each area has a unique code, specifically assigned to each team/person.

Handover between shifts:

• The next shift's team leader must sign acceptance from the previous shift.
• Randomly check at least 10% of areas counted by the previous shift to ensure quality.
• Use detailed handover reports, clearly noting progress and pending issues.

Use technology:

• Modern TMS systems allow real-time counting progress updates.
• Staff scan barcodes or enter data on-site, avoiding easily lost paper records.

Mistake 3: Lack of independent supervision during counting

Many businesses let warehouse staff count the very areas they manage daily without independent supervision. This is a major gap in counting procedures.

Specific consequences

• Fraud risk: Staff may intentionally adjust figures to hide previous losses or errors.

• Lack of objectivity: Even without bad intentions, counters familiar with areas may "estimate" rather than count accurately.

• Difficult to detect systemic errors: Insiders may not recognize issues that outsiders easily spot.

Solutions

Cross-assignment:

• Staff from area A counts area B and vice versa.
• Rotate counting areas between periodic counts.

Appoint independent supervisors:

• At least 1 person from another department (accounting, internal control) participates in supervising the entire process.
• Supervisors have the right to randomly check and request recounts of any location.

Double-check counting:

• Each location is counted by 2 independent people.
• Only accept results when 2 counts match or discrepancies are within tolerance (e.g., < 0.5%).
• If discrepancy is large, have a third person verify.

For large warehouses:

• Consider hiring independent third parties to perform periodic counts (at least 1-2 times/year).
• Organize surprise counts to assess ongoing inventory control quality.

Mistake 4: Inaccurate recording of defective/damaged goods locations

During inventory counting, many teams only focus on counting quantities but forget to record product conditions, especially defective, damaged, expired, or items requiring special handling.

Specific consequences

• Inaccurate inventory value: Damaged goods are still counted as good stock, distorting financial reports.

• Difficulty handling dead stock: Don't know where damaged goods are or how much to develop timely solutions.

• Risk of wrong shipments: Defective goods mixed with good stock, warehouse staff export incorrectly, causing customer complaints.

• Warehouse space waste: Damaged goods occupy space, reducing warehouse efficiency.

Solutions

Clear classification during counting:

• Good stock (ready to ship)
• Stock requiring additional inspection (quality check)
• Slightly defective goods (can be liquidated)
• Heavily damaged goods (must be destroyed)
• Expired or near-expiry goods
• Customer returns requiring processing

Detailed recording:

• Exact location (shelf, level, slot)
• SKU code, production lot code
• Quantity and specific condition description
• Photos if necessary (especially for high-value goods)
• Damage cause if identifiable (mold, breakage, expiration...)

Process immediately after counting:

• Separate damaged goods to a dedicated area, clearly labeled
• Prepare damaged goods report with manager confirmation
• Adjust inventory figures in warehouse management system
• Plan for liquidation, destruction, or supplier returns

Prevention:

• Train staff thoroughly on import/export procedures
• Improve warehouse management system, use barcodes, RFID to reduce manual errors
• Increase supervision, cycle counting instead of only periodic counting
• Clear disciplinary action for discrepancies caused by negligence or intent

Mistake 5: Overlooking goods on vehicles about to leave the warehouse

One of the most common inventory mistakes is only counting goods in the warehouse while forgetting goods already loaded on vehicles about to depart, goods on vehicles just arrived but not yet unloaded, or goods in the staging area (pre-export staging).

Specific consequences

• Significant discrepancies: For large warehouses, goods on vehicles can account for 5-10% of total inventory at counting time.

• Accountability disputes: Goods exported on paper but haven't physically left the warehouse - who owns them? Many cases lead to disputes between warehouse and transportation departments.

• Undetected losses: Goods "disappearing" during this transition phase are very difficult to trace.

Solutions

Clear cutoff rules:

• When is stock confirmed as exported? (when creating document, when loading on vehicle, or when vehicle leaves warehouse?)
• When is stock confirmed as imported? (when vehicle arrives, when unloading, or after counting?)
• Unify these rules throughout the system and clearly state in counting procedures

Comprehensive counting:

• List ALL vehicles in warehouse/parking lot at counting time
• Count goods on each vehicle, reconcile with import/export documents
• Count staging areas, assembly areas, temporary defective goods areas

Close coordination with transportation department:

• Notify counting schedule so transportation can arrange vehicle schedules accordingly
• Ideally: no vehicles waiting to import/export during counting
• If vehicles must wait, document in detail and have dedicated staff supervise

Use TMS system:

• Good TMS systems tightly link warehouse management and transportation management
• Real-time status updates: goods loaded on vehicle, vehicle waiting, vehicle departed
• Automatic reports on goods "in transition" at counting time

Mistake 6: Not reconciling with orders in process

Many warehouses conduct inventory counting without considering orders in process - orders received but goods not yet picked, orders prepared but not exported, or return orders awaiting warehouse receipt.

Specific consequences

• Conflicting data: TMS system shows orders with allocated stock but counting still finds those goods in warehouse, causing confusion.

• Unable to fulfill orders: Think stock is available but it's actually reserved for another order, leading to shortages during delivery.

• Delayed problem detection: Orders "stuck" due to system errors or process issues aren't detected timely.

Solutions

Before counting:

• Export reports of ALL in-process orders from inventory control system or TMS
• Classify: confirmed orders, picked orders, packed orders, awaiting export orders, return orders awaiting processing
• Decide on handling: complete all orders before counting or count with list of in-process orders

During counting:

• Clearly mark goods already reserved for specific orders
• Separate or have detailed list of areas currently picking/packing
• Reconcile immediately: actual quantity = inventory + goods reserved for in-process orders

After counting:

• Review "stuck" orders with unclear status
• Process cases where goods were picked for orders but orders not exported (customer cancellation, awaiting fees...)
• Update system to ensure consistency

System integration:

• Use warehouse management software or TMS capable of managing order status in real-time
• System automatically reconciles available inventory vs. allocated inventory
• Automatic alerts when detecting conflicts

Mistake 7: Lack of discrepancy handling procedures after counting

This is a serious but often overlooked mistake: after counting discovers discrepancies, many businesses simply adjust system figures without investigating causes and building standard handling procedures.

Specific consequences

• Repeated mistakes: Without knowing causes, discrepancies keep recurring each count.

• Uncontrolled losses: If discrepancies are due to losses or fraud without investigation, problems will worsen.

• Loss of trust: Staff don't take counting seriously when seeing results aren't handled seriously.

• Legal and financial risks: For listed companies or those under audit, adjusting inventory figures without clear justification can cause major problems.

Solutions

Establish acceptable thresholds:

• Determine acceptable discrepancy levels (e.g., < 0.5% by quantity, < 1% by value)
• Hierarchical handling: small discrepancies handled by warehouse manager, large discrepancies require reporting to higher management

Discrepancy investigation procedures:

1. Immediate recheck:

   • Recount areas with discrepancies
   • Review import/export documents from past 1-2 weeks
   • Check for location errors, SKU confusion

2. Analyze causes:

   • Import/export recording errors
   • Counting confusion
   • Defective/damaged goods not recorded
   • Goods on vehicles/in transition not updated
   • Losses, damage during storage
   • Fraud (serious cases)

3. Prepare reports:

   • Clearly note location, SKU, discrepancy quantity
   • Describe cause (if identified)
   • Discoverer, verifier, adjustment approver
   • Corrective and preventive measures
   • Individual accountability (if applicable)

4. System adjustment:

   • Only adjust after approved report
   • Fully retain adjustment documentation
   • Notify related departments (accounting, sales...)

Build analysis reports:

• Summarize discrepancy cases for each counting period
• Analyze trends: are discrepancies increasing, concentrated in which product groups, which areas
• Evaluate effectiveness of corrective measures
• Propose inventory control process improvements

Preventive measures:

• Train staff thoroughly on import/export procedures
• Improve warehouse management system, use barcodes, RFID to reduce manual errors
• Increase supervision, cycle counting instead of only periodic counting
• Clear disciplinary action for discrepancies caused by negligence or intent

Standard counting procedures applied in practice at Vietnam transportation warehouses

After understanding 7 common inventory mistakes, below is a standard periodic counting procedure compiled from practical experience at many transportation and logistics warehouses in Vietnam.

Phase 1: Preparation (1-2 weeks before counting)

Planning:

• Determine counting time (usually end of month/quarter/year, choose time with least transactions)
• Form counting committee, clearly assign tasks
• Prepare tools: forms, barcode scanners, tablets, pens, colored tape...

Notification and coordination:

• Notify all related departments
• Request sales department to limit orders during counting
• Arrange delivery/receipt schedule with suppliers and customers

Warehouse organization:

• Clean, rearrange goods neatly in correct positions
• Clearly label each area, shelf, slot
• Process all goods without fixed positions
• Update warehouse map if changes occurred

Data preparation:

• Export inventory report from warehouse management system/TMS
• Print inventory list by area
• Prepare list of in-process orders
• Backup system data

Phase 2: Execute counting (1-2 days)

Counting day morning:

• Meet all participating staff, review procedures, assign specifically
• LOCK all import/export documents in system
• Recheck vehicles, staging areas, ensure nothing is missed

Counting process:

• Each team/pair of staff counts assigned areas
• Fully record: SKU, quantity, location, goods condition
• Apply tape/labels to mark counted areas
• Supervisors patrol, randomly check

Preliminary reconciliation:

• Enter counting data into system (or temporary Excel file)
• Compare with book figures
• Mark locations with large discrepancies
• Immediately recount these locations

Handle arising issues:

• Goods not in system but physically present: check carefully, may be imports not yet entered
• Goods in system but not found: search thoroughly, check recent export documents
• Damaged goods: separate, document in detail
• Goods on vehicles: reconcile with import/export documents

Phase 3: Summarize and handle discrepancies (2-3 days after counting)

Summarize results:

• Fully enter counting data into inventory control system
• Export comparison report: book figures vs. actual counting
• Classify discrepancies: by area, by product group, by severity

Investigate and explain:

• Review each discrepancy case in detail
• Request related departments to explain
• Determine cause and accountability

Prepare reports:

• Overall counting report
• Discrepancy report (if any)
• Damaged goods report (if any)
• Related parties sign confirmation

System adjustment:

• Adjust inventory figures according to approved counting results
• Update inventory value
• Synchronize with accounting system

UNLOCK documents:

• Reopen import/export function in system
• Notify departments to resume normal operations

Phase 4: Evaluation and improvement (1 week after counting)

Evaluation meeting:

• Analyze counting results
• Learn lessons: strengths, weaknesses, takeaways
• Recognize individual and team contributions

Management report:

• Report counting results to leadership
• Propose corrective measures for arising issues
• Propose process improvements, system upgrades if needed

Improvement actions:

• Update counting procedures based on lessons learned
• Provide supplementary training for staff if weaknesses discovered
• Improve infrastructure, technology supporting counting
• Increase cycle counting between periodic counts

Some specific notes for Vietnam logistics warehouses

• Weather: Avoid counting during rainy/stormy seasons or intense heat due to impacts on staff health and goods safety.

• Holidays: Consider counting before/after long holidays (Tet, April 30...) to ensure adequate staffing.

• Goods specifics: For frozen goods, goods with short shelf life, prioritize quick counting to avoid quality impact.

• Outsourced warehouses: If using third-party warehouses, coordinate closely, clearly define responsibility for discrepancies.

• Consignment goods: Clearly separate owned goods and consigned/processing goods for accurate counting.

---

Periodic inventory counting is not easy work, but if executed with proper procedures and avoiding common inventory mistakes, it will become a powerful inventory control tool, helping businesses save costs, optimize operations, and enhance business efficiency.

With 10 years of experience in Vietnam's logistics sector, I believe that investing time to build standard counting procedures and continuously improving them will bring long-term value to any warehouse business. Modern warehouse management systems combined with TMS will provide strong support, but human factors and processes remain the foundation determining success.