Dead stock markdown audit checklist and change log
Last updated: 2026-07-31
Written and reviewed by Seller Profit Guard Editorial Team.
Audit the markdown packet from source evidence through execution and restoration. Reconcile inventory, condition, cost basis, price event, sell-through definition, fee and fulfillment mappings, storage allocation, disposal recovery, formula, sensitivity, threshold, approvals, monitoring, privacy, and change history. Any unresolved population, price, evidence, or duplication conflict blocks sign-off.
Audit inventory scope
Trace on-hand units, location, condition, age, commitments, and exclusions. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Sample private rows through protected pointers. At checkpoint 1, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit cost basis
Reconcile unit cost method, period, currency, adjustments, and ownership. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Separate accounting policy. At checkpoint 2, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit price event
Verify current price, proposed price, markdown rate, event type, timing, and channel. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Check execution evidence. At checkpoint 3, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit sell-through
Reperform numerator, denominator, window, availability, season, promotions, and processing delay. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Test comparability. At checkpoint 4, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit selling costs
Trace fee base, fulfillment, packaging, shipping, returns, and exclusions. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Search for duplicates. At checkpoint 5, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit storage
Validate allocation key, decision window, avoidability, and relation to carrying cost. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Reject unsupported annualization. At checkpoint 6, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit disposal recovery
Inspect quotes, rights, condition, fees, timing, restrictions, and negative costs. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Confirm fallback. At checkpoint 7, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit formula
Reperform expected units, price, sold recovery, residual recovery, storage, net recovery, cost basis, and rate. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Preserve precision. At checkpoint 8, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit decision and monitoring
Verify threshold, sensitivity, approvals, constraints, actual results, stop rules, and restoration. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Record exceptions. At checkpoint 9, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Audit privacy and access
Confirm least privilege, protected pointers, no public raw rows, and controlled change history. The markdown audit file records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for an independently reviewable decision trail.
Remove exposed data. At checkpoint 10, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.
Dead Stock Markdown Audit Template: population integrity control
Keep one SKU-location, condition state, availability rule, unit count, and cost basis. Control 1 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Mixed inventory blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: probability lineage control
Record sell-through definition, window, price, season, placement, availability, and source delay. Control 2 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Unsupported probability requires Review. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: cost separation control
Map fees, fulfillment, storage, disposal, and cost basis once. Control 3 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Duplicate or missing cost blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: three seller thresholds control
Compare expected recovery rate, cost-basis shortfall rate, and evidence days with three separately entered seller controls. Control 4 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
One passing threshold cannot override another. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: dated evidence governance control
Record a real source-review date and seller-policy effective date, with policy no later than the reviewed evidence. Control 5 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Impossible or reversed dates block. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: nine confirmations control
Confirm SKU-location grain, on-hand and cost basis, price and fees, sell-through, storage and fulfillment, residual recovery, condition, privacy, and accounting boundaries. Control 6 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Any missing confirmation blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: distinct scenarios control
Change at least one markdown, probability, selling cost, residual recovery, age, or evidence-window assumption between the two cases. Control 7 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
A copied scenario is not a comparison. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: output masking control
Mask derived money, rates, units, preference, and threshold gaps whenever structural validation returns Block. Control 8 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Never act on partial invalid arithmetic. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: decision boundary control
Separate scenario recovery from forecasting, accounting, tax, pricing authority, promotion setup, and disposal approval. Control 9 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Arithmetic cannot authorize action. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Dead Stock Markdown Audit Template: privacy and recovery control
Use aggregates, protect source rows, retain prior values, monitor variance, and preserve restoration. Control 10 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the markdown audit file can support an independently reviewable decision trail.
Public buyer or order data is prohibited. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.
Audit inventory scope: recovery lab 1
Recalculate the relevant output from both fixtures. Trace on-hand units, location, condition, age, commitments, and exclusions. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Sample private rows through protected pointers. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit cost basis: recovery lab 2
Recalculate the relevant output from both fixtures. Reconcile unit cost method, period, currency, adjustments, and ownership. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Separate accounting policy. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit price event: recovery lab 3
Recalculate the relevant output from both fixtures. Verify current price, proposed price, markdown rate, event type, timing, and channel. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Check execution evidence. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit sell-through: recovery lab 4
Recalculate the relevant output from both fixtures. Reperform numerator, denominator, window, availability, season, promotions, and processing delay. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Test comparability. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit selling costs: recovery lab 5
Recalculate the relevant output from both fixtures. Trace fee base, fulfillment, packaging, shipping, returns, and exclusions. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Search for duplicates. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit storage: recovery lab 6
Recalculate the relevant output from both fixtures. Validate allocation key, decision window, avoidability, and relation to carrying cost. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Reject unsupported annualization. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit disposal recovery: recovery lab 7
Recalculate the relevant output from both fixtures. Inspect quotes, rights, condition, fees, timing, restrictions, and negative costs. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Confirm fallback. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit formula: recovery lab 8
Recalculate the relevant output from both fixtures. Reperform expected units, price, sold recovery, residual recovery, storage, net recovery, cost basis, and rate. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Preserve precision. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit decision and monitoring: recovery lab 9
Recalculate the relevant output from both fixtures. Verify threshold, sensitivity, approvals, constraints, actual results, stop rules, and restoration. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Record exceptions. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Audit privacy and access: recovery lab 10
Recalculate the relevant output from both fixtures. Confirm least privilege, protected pointers, no public raw rows, and controlled change history. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.
Remove exposed data. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.
Dead Stock Markdown Audit Template: intent-specific implementation walkthrough
markdown audit file checkpoint 1 addresses audit inventory scope as a distinct requirement for an independently reviewable decision trail. Trace on-hand units, location, condition, age, commitments, and exclusions. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Sample private rows through protected pointers.
markdown audit file checkpoint 2 addresses audit cost basis as a distinct requirement for an independently reviewable decision trail. Reconcile unit cost method, period, currency, adjustments, and ownership. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Separate accounting policy.
markdown audit file checkpoint 3 addresses audit price event as a distinct requirement for an independently reviewable decision trail. Verify current price, proposed price, markdown rate, event type, timing, and channel. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Check execution evidence.
markdown audit file checkpoint 4 addresses audit sell-through as a distinct requirement for an independently reviewable decision trail. Reperform numerator, denominator, window, availability, season, promotions, and processing delay. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Test comparability.
markdown audit file checkpoint 5 addresses audit selling costs as a distinct requirement for an independently reviewable decision trail. Trace fee base, fulfillment, packaging, shipping, returns, and exclusions. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Search for duplicates.
markdown audit file checkpoint 6 addresses audit storage as a distinct requirement for an independently reviewable decision trail. Validate allocation key, decision window, avoidability, and relation to carrying cost. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Reject unsupported annualization.
markdown audit file checkpoint 7 addresses audit disposal recovery as a distinct requirement for an independently reviewable decision trail. Inspect quotes, rights, condition, fees, timing, restrictions, and negative costs. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Confirm fallback.
markdown audit file checkpoint 8 addresses audit formula as a distinct requirement for an independently reviewable decision trail. Reperform expected units, price, sold recovery, residual recovery, storage, net recovery, cost basis, and rate. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Preserve precision.
markdown audit file checkpoint 9 addresses audit decision and monitoring as a distinct requirement for an independently reviewable decision trail. Verify threshold, sensitivity, approvals, constraints, actual results, stop rules, and restoration. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Record exceptions.
markdown audit file checkpoint 10 addresses audit privacy and access as a distinct requirement for an independently reviewable decision trail. Confirm least privilege, protected pointers, no public raw rows, and controlled change history. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Remove exposed data.
Evidence boundary for an independently reviewable decision trail
The moderate fixture uses 100 units, USD 12 unit cost, USD 30 current price, a 30 percent markdown, 55 percent expected sell-through, 10 percent selling fees, USD 4 fulfillment per sold unit, USD 1.50 storage per on-hand unit, and USD 2 disposal recovery per unsold unit. Expected net recovery is USD 759.50, or 63.29 percent of cost basis. The clearance fixture uses the same inventory and cost basis, a 50 percent markdown, 90 percent expected sell-through, 10 percent selling fees, USD 4 fulfillment per sold unit, USD 0.25 storage per on-hand unit, and USD 2 disposal recovery per unsold unit. Expected net recovery is USD 850, or 70.83 percent of cost basis.
The enhanced packet also displays cost-basis shortfall rates of 36.71 and 29.17 percent, expected net recovery per opening unit of USD 7.60 and USD 8.50, and recovery-floor gaps of negative 6.71 and positive 0.83 percentage points. It can demonstrate entered arithmetic and sensitivity, but it cannot prove future demand, optimal price, incrementality, accounting value, tax treatment, cash timing, policy compliance, buyer response, disposal eligibility, or the correct business action.
Release, monitor, and restore the markdown audit file
Block invalid or non-finite units, costs, prices, rates, dates, evidence, scope, currency, confirmations, duplicated scenarios, privacy, or conflicts, and mask every derived output. Review short evidence, very old inventory, negative sold-unit recovery, recovery below the seller floor, or shortfall above the seller ceiling. Ready clears only the three entered thresholds, nine confirmations, and the rest of the entered worksheet.
Before indexing or operational use, preserve evidence and rollback artifacts; run typecheck, unit, integration, build, content, similarity, SEO, image, link, mobile, strict-route, deployment, and live checks; then compare later evidence without claiming same-period causality.
Dead Stock Markdown Audit Template: concrete working record
The audit file records scope, evidence inventory, source hashes or protected pointers, sample method, recalculation, variance, duplicates, access history, approvals, execution evidence, actual-versus-expected comparison, exceptions, correction owner, deadline, retest, accepted limitation, monitoring, stop event, rollback proof, final reviewer, and append-only change log.
Sources and further reading
- Seller Profit Guard methodology: Evidence, formula, privacy, correction, release, monitoring, and rollback rules.
- Seller Profit Guard data privacy: Local-first boundaries for inventory, supplier, customer, order, and raw export data.
- Shopify Help: Product analytics overview: Official definitions for product sell-through, days of inventory remaining, and inventory value context.
- Shopify Help: Inventory reports: Official reporting periods, month-end inventory snapshots, sell-through, ending quantity, and days-remaining boundaries.
- Square Support: Run an aging inventory report: Official weighted age, last-received date, age bands, on-hand quantity, value, and location filters.
- Microsoft Learn: Item Age Composition by Quantity and Value: Current official receipt-date aging report for on-hand quantity and value with item and location filters.
- Oracle Retail: Markdown data requirements: Official treatment of permanent, clearance, and promotional markdown data.
- Oracle Retail Markdown Optimization User Guide: Official lifecycle context for markdown timing, depth, profitability, and inventory targets.
Related Seller Profit Guard tools
- Dead Stock Markdown Calculator: Compare moderate and clearance scenarios using expected net recovery and cost-basis recovery rate.
- Inventory Carrying Cost Calculator: Estimate the annual holding burden separately from a markdown decision window.
- Maximum Discount Calculator: Calculate a contribution-based discount ceiling for ordinary retained orders.
- Contribution Margin Calculator: Measure retained order contribution separately from inventory disposition.
- Methodology: Review evidence, formula, privacy, correction, release, and rollback.
- Data Privacy: Protect inventory, supplier, customer, order, and raw export data.
- Dead Stock Markdown Formula and Inputs: Define markdown price, sell-through probability, selling costs, storage, disposal recovery, cost basis, and expected net recovery.
- Dead Stock Markdown Worked Example: Reperform a moderate markdown example from aged inventory through expected units, selling costs, storage, disposal, and recovery rate.
- Clearance Markdown Recovery Scenario: Reperform a clearance markdown example with higher expected sell-through, lower storage, deeper price reduction, and unsold-unit recovery.
- Dead Stock Markdown Modeling Mistakes: Find population, probability, fee, storage, disposal, cost-basis, accounting, privacy, and decision errors in markdown recovery models.
- Dead Stock Markdown Data Sources: Map inventory age, on-hand units, cost, price, sell-through, fees, fulfillment, storage, and disposal recovery to controlled evidence.
- Dead Stock Markdown Decision Threshold: Set a seller-owned recovery threshold, evidence floor, sensitivity range, approval boundary, stop rule, and restoration trigger.
- Moderate vs Clearance Markdown: Compare moderate and clearance markdowns across price, expected units, costs, storage, disposal, recovery, uncertainty, and reversibility.
- Weekly Dead Stock Markdown Routine: Run a weekly age review, source reconciliation, scenario comparison, approval, monitoring, exception, and restoration routine.
- Interpret Markdown Recovery Results: Interpret expected units, recovery, rate, threshold, uncertainty, operating boundaries, and actual-versus-expected results without false precision.
Next step: Open Seller Profit Guard.
This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.