Inventory Reporting Fix
After reviewing initial findings with the client, PwC’s team ran a walkthrough of the end-to-end inventory process at five stores. We observed that most store managers use manual spreadsheets to track stock, and there's limited enforcement of barcode scanning during check-in/check-out of items.
In addition, store audits revealed that serial number mismatches often occur during returns or internal transfers between stores. Corporate systems rely heavily on store inputs, but controls are inconsistent.
What types of process or system improvements could help the client reduce inventory discrepancies and improve reporting accuracy?
Case Exhibit
To improve inventory reporting accuracy, PwC could recommend the following:
I. Process Improvements
- Enforce mandatory barcode scanning during all stock movements (receiving, selling, returns)
- Standardize daily reconciliation routines between store logs and POS
- Require dual-approval or justification for any manual adjustments
II. Technology Enhancements
- Replace spreadsheets with a centralized inventory management platform
- Integrate POS with financial systems to reduce data sync errors
- Implement serial number validation logic (e.g., alert if missing at time of sale or return)
III. Training & Monitoring
- Conduct refresher training on inventory handling procedures
- Assign inventory compliance scores to each store and share KPIs monthly
- Flag stores with repeat violations for targeted process audits
Candidates should emphasize automation, standardization, and accountability.
