How To Calculate And Report Inventory Markdowns

A reduction in the selling price, often used to accelerate sales of aging, seasonal, or excess inventory.

Markdown A reduction in the selling price, often used to accelerate sales of aging, seasonal, or excess inventory. Accurate calculation and reporting of markdowns inform merchandising decisions, accounting adjustments, and KPIs like gross margin and sell-through rate.

Calculating markdowns is straightforward in concept but requires consistent methods across merchandising, finance, and operations to produce useful reports. A markdown affects retail price, realized revenue, gross margin, and potentially inventory valuation. Best practice ties markdown reporting to SKU-level records in the WMS or inventory management system so actions are auditable and comparable over time.

What To Measure

Key metrics to capture for each markdown event:

• Markdown Amount: The dollar difference between original retail price and new price per unit.
• Markdown Percentage: The percentage reduction from original retail price.
• Units Affected: Number of units priced at the markdown level.
• Revenue Impact: Lost revenue compared to selling at original price (Markdown Amount x Units Sold).
• GMROI Impact: Change in gross margin return on inventory due to the markdown.

How To Calculate Basic Markdown Metrics

Use these simple formulas for SKU-level calculations:

• Markdown Amount: Original Price - New Price.
• Markdown %: (Markdown Amount / Original Price) x 100.
• Revenue Loss: Markdown Amount x Units Sold At Marked Price.
• Net Revenue: (New Price x Units Sold) - (COGS x Units Sold) to compute gross margin after markdown.

Reporting Structure And Frequency

Reports should be available at SKU, category, and store/channel levels. Frequency depends on business cadence—weekly for fast fashion, monthly for general merchandise. Include snapshots of inventory age to correlate markdowns with holding periods. Use dashboards that show cumulative markdowns by period and the resulting sell-through and GMROI changes.

• Weekly Dashboards: Track active markdowns and short-term sell-through.
• Monthly Reports: Analyze markdown spend, margin erosion, and inventory write-downs.
• Quarterly Reviews: Inform buy plans and allocation strategy to reduce future markdowns.

Accounting And Inventory Valuation Implications

From an accounting standpoint, markdowns reduce expected realizable value of inventory. When markdowns are expected and incremental, record them as adjustments to inventory valuation or a markdown reserve depending on accounting policies. For unexpected or deep markdowns, recognize an inventory write-down. Coordinate with finance to set thresholds for when markdowns move from operational actions to accounting entries.

Operationalizing In Systems

To ensure accurate reporting, implement the following in your WMS and pricing channels:

• SKU-Level Flags: Tag items with markdown events and effective dates in inventory systems.
• Price Audit Trail: Keep records of price changes, reason codes, and approving manager to support analysis and compliance.
• Integration: Sync markdown data with e-commerce platforms and POS to capture actual sell-through at discounted prices.

Practical Example And KPI Calculation

Example: A SKU has an original price of $100, COGS $50, and 200 units on hand. A 30% markdown reduces price to $70. Markdown Amount = $30. If 150 units sell at $70, Revenue Loss = $30 x 150 = $4,500. Gross margin after markdown per unit is $70 - $50 = $20; total gross margin = $3,000. Compare that to full-price margin of $50 x 150 = $7,500 to evaluate trade-off. Use GMROI and sell-through to judge whether the markdown achieved inventory objectives.

In short, the Markdown should be calculated and reported with consistent formulas, tied to SKU-level inventory data, and integrated into both operational dashboards and accounting processes so merchants can measure the trade-offs between faster turns and margin impact.