- Home
- Skills
- Agents & Orchestration
- Professional AI Inventory Warehouse Auditor
More screenshots
Works with the AI Agents you already use
Professional AI Inventory Warehouse Auditor
Audit warehouse data to find stock discrepancies, negative balances, and financial leakage before you close the books.
$12
Professional AI Inventory Warehouse Auditor
Example session with this skill installed
Audit the attached 'Inventory_Extract_Q3.csv' and 'Physical_Count_Sept.csv'. Focus on shortages over $500 and identify any negative stock balances blocking the month-end close.
- Read your context and instructions
- Compiled the professional ai inventory
Audit complete for the period ending September 30. Analyzed 1,450 SKUs across two locations. Identified $12,400 in net shortages and 4 blocking issues for period-end close.
Findings Summary
| Finding Type | Count | Affected Value (USD) | Severity |
|---|---|---|---|
| Physical Variance (Shortage) | 18 | $14,200 | Critical |
| Physical Variance (Overage) | 22 | ($1,800) | Medium |
| Negative Stock | 3 | $450 | Critical |
| SKU/Barcode Mismatch | 12 | N/A | Low |
High-Value Physical Variances
| SKU | Location | System Qty | Count Qty | Variance | Unit Cost | Total Impact |
|---|---|---|---|---|---|---|
| ELECT-092 | WH-A | 450 | 380 | -70 | $120.00 | -$8,400 |
| MECH-441 | WH-B | 12 | 0 | -12 | $550.00 | -$6,600 |
| PACK-102 | WH-A | 1,000 | 1,200 | +200 | $4.50 | +$900 |
Negative Stock Analysis
| SKU | Warehouse | Balance | Last Movement Date | Potential Cause |
|---|---|---|---|---|
| COMP-882 | WH-A | -14 | 2023-09-28 | Sales posted before receipt |
| TOOL-009 | WH-B | -2 | 2023-09-25 | Duplicate shipment entry |
Period-End Close Checklist
| Item | Status | Notes |
|---|---|---|
| Negative Stock Resolved | BLOCKING | 3 SKUs still show negative balances. |
| Material Variances | REVIEW | ELECT-092 shortage exceeds $5,000 threshold. |
| Transfer Reconciliation | CLEAR | All in-transit legs matched. |
Next steps
- Recount SKU ELECT-092 in WH-A to verify the 70-unit shortage before posting the adjustment.
- Review the goods-in log for SKU COMP-882; the negative balance suggests a missing purchase receipt.
- Update the barcode mapping for the 12 mismatched items to prevent future counting errors.
Connects securely to your tools. The creator never sees your data.
About this skill
Inventory errors and data mismatches lead to expensive tax problems, missed orders, and period-end closing delays. This skill audits exports from ERP, WMS, and physical count sheets to identify exactly where the money is leaking. It reconciles system stock against physical reality, flags structural data errors, and quantifies the financial impact of every discrepancy.
What it does Inventory Reconciliation compares system quantities against physical counts to isolate shortages and overages with exact financial values. Structural Audit identifies negative stock, duplicate SKU records, barcode mismatches, and unit-of-measure conversion conflicts. Anomaly Detection flags unusual stock movements, repeated adjustments, and large manual write-offs that require management review. Financial Quantification calculates the cost of shrinkage and data errors using specific cost bases such as FIFO or average cost. Accounting Alignment matches warehouse movements against the general ledger to identify unposted receipts and timing differences. How it works Upload Data — Provide CSV or Excel exports from your ERP, WMS, or physical count logs. Automated Mapping — Maps your columns to audit fields such as SKU, quantity, and unit cost. Execution — Performs multi-layer checks across inventory movements, transfers, and balances. Final Report — Delivers a prioritized list of corrections and a period-end close readiness checklist. Frameworks & Tools
Works with exports from SAP, Oracle, NetSuite, Microsoft Dynamics, Shopify, and custom WMS platforms. Supports CSV, XLSX, and JSON data formats.
Why this beats prompting it yourself
Generic prompts often miss unit-of-measure conflicts or fail to properly distinguish shortages from overages, which can hide the true scale of inventory loss.
This skill uses a systematic audit framework designed to separate simple counting discrepancies from structural data problems and high-risk inventory shrinkage indicators.
Use Cases Month-End Close — Verify that warehouse inventory records and accounting records are aligned before the books are closed. Cycle Count Audits — Investigate why specific products or warehouses consistently report inventory variances. ERP Migration — Identify duplicate SKUs, negative balances, and inconsistent inventory data before migrating to a new system. Loss Prevention — Identify unusual patterns in high-value inventory movements that require further investigation. Known Limitations
This skill does not perform forensic accounting or legal fraud investigations. Unit cost data is required to calculate financial impact. Audit accuracy depends on the consistency and quality of the provided SKU identifiers and source data.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Agents & Orchestration.
Requires unit cost data for financial impact. Cannot detect fraud without transaction history. Limited by the quality and cleanliness of SKU identifiers in source files.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago
Permissions
No special permissions declared or detected