AI Blocks › Track your numbers
Retail markdown stock reconciler
A stock cohort reconciliation with sold contribution and cumulative purchase cash recovery
Retail markdown stock reconciler is a free AI skill for the job "Track your numbers". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · Made by AI Blocks · Level: advanced · Thinking: high
What it does
A stock cohort reconciliation with sold-unit contribution, remaining units and cumulative cash after the full cohort purchase. Retail stock cash recovery. Illustrative cohort of100 units purchased for5 each costs500. Selling40 at10 and30 at6 realizes580. Sold purchase cost350 plus clearance10 leaves sold-unit contribution220; this excludes150 purchase cost still held in30 units. Cumulative cash after the full500 original purchase and10 clearance is70. At markdown price4 receipts are520, sold-unit contribution160 and cumulative cohort net cash10. Cumulative cash is across purchase and clearance dates, not a single-period cash-flow claim. Overselling stock is refused.
You give it
- Opening stock cohort units and unit purchase cash cost, full-price and markdown units sold and realized prices, clearance cash expenses; identify the timing of the original cohort purchase.
- Reporting date, currency and scale, fiscal calendar, accounting basis and authorized scope.
- Available spreadsheet tools and required native output format.
You get
- A stock cohort reconciliation with sold-unit contribution, remaining units and cumulative cash after the full cohort purchase.
- An illustrative editable workbook, input schema, executable calculation reference and golden test cases.
- Reconciliation results, unresolved inputs and actual checks completed.
Use it when
- You need a stock cohort reconciliation with sold-unit contribution, remaining units and cumulative cash after the full cohort purchase.
- You work on retail stock cash recovery and need traceable calculations.
- A reviewer needs to trace the result back to inputs and assumptions.
How to use it
- Download the complete pack and read its governing SKILL.md.
- Share the actual sources and the financial question you need answered.
- Ask your AI to follow the methods, preserve original files and stop affected work on missing evidence.
- Review assumptions, reconciliations and CHECKS MISSED before relying on the result.