stock-reconciliation

What problem does it solve?

This Skill automates the process of comparing physical stock counts against inventory management system records, identifying discrepancies, and generating actionable reports for adjustments and shrinkage analysis.

Core Features & Use Cases

• Variance Identification: Pinpoints differences between physical counts and system records by SKU and location.
• Shrinkage Calculation: Quantifies stock loss and provides breakdown by category and location.
• Exception Reporting: Generates reports for variances exceeding defined thresholds, suggesting probable causes and recommended actions.
• Traceability Support: Ensures batch-level traceability is maintained in food manufacturing environments.
• Use Case: A retail store completes its quarterly stocktake. This Skill will ingest the count data and system extract, highlight any SKUs with significant variances, calculate the overall shrinkage, and provide a list of recommended adjustments for the inventory manager.

Quick Start

Use the stock-reconciliation skill to compare the physical count data in 'physical_stock.csv' against the system inventory extract in 'system_inventory.csv' and generate a variance report.