More screenshots
Works with the AI tools you already use
Claude Code
Cursor
Codex CLI
GitHub Copilot
Gemini CLI+20 moreClaude CodeCursorCodex CLIGitHub CopilotGemini CLI
OpenClaw
Manus
Grok+17 agentsyear end inventory reconciliation auditor
Reconcile book stock vs. physical counts, calculate value variances, and generate audit-ready action reports.
$8.99
year end inventory reconciliation auditor
Example session with this skill installed
Reconcile this year-end data. Book: SKU-A1 (100 units, $5/ea), SKU-B2 (50 units, $20/ea). Physical: SKU-A1 (95 units), SKU-B2 (52 units). SKU-C3 (10 units) was found but isn't in the book.
- Read your context and instructions
- Compiled the year end inventory
- Generated the document
I have reconciled the year-end inventory data provided. Three items were analyzed, identifying variances in both quantity and estimated value.
Year-End Inventory Reconciliation Report
Executive Summary
- Count Date: Not provided
- Scope: 3 SKUs analyzed
- Items Matching: 0
- Items with Shortages: 1 (SKU-A1)
- Items with Overages: 2 (SKU-B2, SKU-C3)
- Estimated Value Impact: -$5.00 (Net)
Reconciliation Results
| SKU | Description | Book Qty | Physical Qty | Variance | Unit Cost | Est. Value Impact |
|---|---|---|---|---|---|---|
| SKU-A1 | Product A1 | 100 | 95 | -5 | $5.00 | -$25.00 |
| SKU-B2 | Product B2 | 50 | 52 | +2 | $20.00 | +$40.00 |
| SKU-C3 | Product C3 | 0 | 10 | +10 | UNKNOWN | UNKNOWN |
Highest-Priority Exceptions
SKU-C3 (Physical Only): 10 units found with no corresponding book record.
Priority: High. Action: Verify if SKU is new or mislabeled.
2.
SKU-A1 (Shortage): 5 unit deficiency.
Priority: Medium. Action: Check recent shipping logs for unrecorded dispatches.
Variance Analysis
- Shortages: 1 item, $25.00 estimated loss.
- Overages: 2 items, $40.00 estimated gain (partial calculation).
- Pattern: Discrepancies found across all reported items, suggesting a systemic lag in recording movements.
Missing or Unresolved Evidence
- Unit Cost for SKU-C3: Value impact cannot be calculated for the found stock.
- Count Sheets: Original physical signatures were not provided for verification.
Recommended Actions
- Investigate SKU-C3: Locate the purchase order or receiving report for these 10 units.
- Recount SKU-A1: Perform a secondary count of SKU-A1 to confirm the 5-unit shortage.
- Provide Costs: Supply the unit cost for SKU-C3 to finalize the valuation impact.
Next steps
- Provide the unit cost for SKU-C3 to complete the financial reconciliation.
- Upload recent stock movement logs for SKU-A1 to identify the point of loss.
- Review the Management Questions section before final sign-off.
year-end-inventory-reconciliation-audito.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
The problem
Manual inventory reconciliation is slow and prone to human error. Discrepancies between book stock and physical counts often go unnoticed until they impact the balance sheet or stall production.
What it does
- Identifies quantity and value variances by comparing book stock against physical count sheets.
- Flags normalization issues like duplicate SKUs, inconsistent units of measure, and negative stock values.
- Quantifies the estimated financial impact of shortages and overages based on unit cost data.
- Generates a prioritized action register for material exceptions requiring immediate investigation.
- Produces an audit-ready year-end report with a sign-off checklist and management questions.
Why this beats prompting it yourself
This skill enforces strict evidence discipline, distinguishing between hard facts and inferences to maintain audit integrity. It automates the tedious math of variance calculation across thousands of rows while ensuring neutral, professional language suitable for corporate reporting.
Use cases
- Reconciling warehouse stock counts against ERP exports at year-end.
- Investigating high-value inventory discrepancies across multiple locations.
- Preparing documented evidence and action plans for external auditors.
- Summarizing variance patterns by category or warehouse to identify systemic operational leaks.
Known limitations
Does not perform accounting journal entries or tax treatments. Requires structured data such as SKU, book quantity, and physical quantity to be effective.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 20 days ago
- Passed all security checks, Safe to install