skills.rest
garethdaine
garethdaineCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

stock-reconciliation

Compare physical stock counts against system inventory records to identify variances.

Updated Feb 20, 2026
Search Tags:#reporting#reconciliation#inventory#stock#variance#shrinkage
One-click install
npx skills add https://github.com/garethdaine/agent --skill stock-reconciliation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: stock-reconciliation
Source: https://github.com/garethdaine/agent/tree/main/skill-library/skills/stock-reconciliation
Command: npx skills add https://github.com/garethdaine/agent --skill stock-reconciliation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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.

Frequently Asked Questions about stock-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile physical inventory counts against system records to find variances?▼

Stock reconciliation compares physical count data against system inventory extracts to identify variances by SKU and location, calculates shrinkage rates, and generates exception reports for adjustment entries.

What is the best way to calculate inventory shrinkage and generate exception reports after a stocktake?▼

Inventory shrinkage is calculated by quantifying stock loss differences between physical counts and system records, generating exception reports for variances exceeding defined thresholds with probable causes and recommended actions.

How do I match SKUs and locations when comparing physical stock counts to system inventory data?▼

SKU and location matching is performed by ingesting physical count data alongside system inventory extracts, comparing records to pinpoint discrepancies, and suggesting adjustment entries for identified variances.

Can I use stock reconciliation for batch-level traceability in food manufacturing environments?▼

Batch-level traceability is supported in food manufacturing environments during stock reconciliation, ensuring traceability is maintained while comparing physical inventory counts against system records.

What data do I need to perform stock reconciliation and identify inventory shrinkage?▼

Stock reconciliation requires physical count data and system inventory extracts as input, matching SKUs and locations to calculate variances, quantify shrinkage rates, and generate detailed exception reports.

When should I generate variance reports for inventory adjustments in retail operations?▼

Variance reports for inventory adjustments should be generated after completing a physical stocktake in retail or manufacturing operations, highlighting significant SKU variances and recommending adjustments for inventory managers.

Related Skills

Explore More Finance & Accounting Skills→
40RTY-ai40RTY-ai
174

shopify-admin-inventory-adjustment

Adjust Shopify inventory quantities for specific variants and locations.

Official
Advanced
usecompaiusecompai
24

restock-trigger

Detects high-velocity, low-stock SKUs and generates restock proposals with forecasts.

Official
Advanced
GoldenZeroGoldenZero
1

sku-rationalization-advisor

Analyzes SKU data and recommends keep, delist, consolidate, or replace actions.

Community
Advanced
LerianStudioLerianStudio
205

financial-analysis

Analyze financial statements with ratio, trend, and variance analysis.

Official
Advanced