Clearance Percentage Calculator

The Clearance Percentage Calculator calculates the proportion cleared by dividing cleared by total items and converting to a percentage.

What Is a Clearance Percentage Calculator?

A clearance percentage calculator is a tool that shows how much of a specific inventory group you cleared during a defined window. It focuses on sell-through driven by clearance pricing, end-of-season markdowns, or liquidation. The result is a single percentage that reflects progress from starting units to final units on hand.

Retailers use this metric to judge promotional strength, optimize markdown cadence, and benchmark performance across stores, channels, or regions. It also helps merchandise planners spot slow movers and decide whether to hold, transfer, or reduce price. In short, it translates many moving parts into a digestible signal that teams can act on.

Because clearance events can vary by duration, assortment, and customer mix, the calculator supports clear inputs and assumptions. It can adjust for returns, transfers, and shrink to keep the math fair. You can also compare clearance outcomes across the distribution of SKUs, sizes, and colors to see where the gaps are.

How to Use Clearance Percentage (Step by Step)

Start by defining which items count as “clearance” and the exact dates you will measure. Confirm how you will treat returns, store transfers, and stockouts. Then gather your inventory and sales data so the result reflects reality, not best guesses.

• Define the assortment: category, season, or list of SKUs you are clearing.
• Set the time window: start date and end date for the clearance period.
• Capture starting units and ending units on hand for that window.
• Record units sold, returns processed, and any transfers or shrink.
• Decide whether to use unit-based, revenue-based, or margin-based calculations.
• Run the calculation and compare results across stores or channels.

Use the result to decide whether to deepen markdowns, extend the event, or stop and reinvest. Track the percentage over time to see how rate of sale evolves as you change price or placement.

Formulas for Clearance Percentage

Different teams prefer different views. Some focus on units, others on revenue or recovered margin. Choose the formula that matches your goal and data quality.

• Unit-based clearance percentage = (Adjusted units sold ÷ Starting units) × 100
• Adjusted units sold = Units sold − Customer returns − Damaged returns + Outbound transfers to clearance (if applicable)
• Revenue-based clearance percentage = (Clearance revenue ÷ Starting retail value) × 100
• Margin recovery percentage = (Gross margin from clearance ÷ Original gross margin at full price) × 100
• Sell-through during clearance = (Units sold in window ÷ (Starting units + Receipts)) × 100

Unit-based is simplest and most common for quick decisions. Use revenue or margin views when you care about profitability, not just emptying racks. If your assortment received mid-event receipts, include those as inputs so the math reflects actual supply.

Inputs and Assumptions for Clearance Percentage

Good results start with clear inputs. Decide what to include and how to treat exceptions before you run the numbers. Document these choices so reports remain consistent across teams.

• Starting units: On-hand units at the beginning of the clearance window.
• Units sold: All units sold within the window at any price point you label as clearance.
• Returns and shrink: Customer returns, damages, and shrink to subtract from sold units.
• Transfers and receipts: Stock moved in or out, and any receipts received mid-window.
• Pricing data: Clearance prices or markdown depth if using revenue or margin formulas.
• Timeframe: The start and end dates that align with your promotion calendar.

Set assumptions about negative values, partial weeks, and stockouts. For example, if a size sells out on day three, your clearance percentage may be capped by supply, not demand. When results vary widely across the distribution of SKUs, segment the analysis to avoid hiding problems in the average.

Using the Clearance Percentage Calculator: A Walkthrough

Here’s a concise overview before we dive into the key points:

1. Select the product group, category, or list of SKUs to include.
2. Enter the start and end dates for the clearance period.
3. Input starting units, units sold, returns, and transfers for the window.
4. Optionally add receipts, markdown prices, and cost if you want revenue or margin views.
5. Choose the calculation method: unit-based, revenue-based, or margin recovery.
6. Run the calculation to view the clearance percentage and supporting metrics.

These points provide quick orientation—use them alongside the full explanations in this page.

Real-World Examples

A footwear retailer runs a four-week clearance on last season’s sneakers. Starting units are 2,400 across 15 SKUs. During the event, they sell 1,860 units, process 60 returns, and transfer 80 units to an outlet. Adjusted units sold are 1,860 − 60 + 80 = 1,880. Clearance percentage equals 1,880 ÷ 2,400 × 100 = 78.3%. What this means: The team cleared most inventory, so deeper markdowns are not required for a fifth week.

An electronics store liquidates an older tablet model. Starting retail value is $300,000 at MSRP. Clearance revenue totals $195,000 after two weeks, with heavy markdowns. Revenue-based clearance percentage is $195,000 ÷ $300,000 × 100 = 65.0%. Unit-based clearance is 520 sold out of 700 starting, or 74.3%. What this means: Units cleared well, but revenue lagged, so margin recovery is lower than target; consider accessory bundles to boost profitability.

Accuracy & Limitations

Clearance percentage is powerful but not perfect. The number depends on data integrity, timing, and the way you define “clearance.” Be aware of these limits when comparing results across teams or time periods.

• Incomplete returns data can inflate results, especially with high return rates online.
• Stockouts constrain demand; low clearance may reflect supply limits, not poor pricing.
• Mid-window receipts distort unit-based math if not included consistently.
• Mix shifts matter; clearing odd sizes can mask poor sell-through in core sizes.
• Revenue and margin views require accurate cost and markdown capture.

Use the metric alongside velocity, weeks of supply, and price elasticity. When you compare stores, align assumptions and timeframes, and control for promotional overlap to avoid false conclusions.

Units and Symbols

Clearance reporting blends unit counts, percentages, currency, and time. Getting units right prevents confusion and helps you interpret results across different inputs, channels, and systems.

Use the table as a quick reference when setting up inputs or interpreting outputs. If you switch currency or time granularity, note it on the report so downstream teams read results correctly.

Troubleshooting

If your results look off, check data alignment first. Most issues come from mismatched time windows, missing returns, or forgetting mid-window receipts. Validate each input against a trusted source such as your POS or inventory ledger.

• Zero or negative clearance? Confirm starting units and ensure returns are not double-counted.
• Unrealistically high clearance? Look for missing returns or transfers out not recorded as sales.
• Store comparisons seem wrong? Align dates, assortment definitions, and price labels.
• Margin recovery too low? Verify cost data and markdown capture for every SKU.

When in doubt, run a spot check at the SKU level. If the SKU math reconciles, roll up to the department or channel. If not, fix the inputs before you trust the percentages.

FAQ about Clearance Percentage Calculator

What is the difference between clearance percentage and sell-through?

Sell-through measures the portion of available inventory sold in any period. Clearance percentage focuses on sell-through driven by clearance pricing or events, often with adjusted inputs for returns and transfers.

Should I include mid-event receipts in the calculation?

Yes, include receipts if you want an accurate view of supply during the window. Excluding them can overstate performance when you add stock mid-event.

How often should I recalculate during a clearance?

Update daily for fast-moving items and at least weekly elsewhere. Frequent reads help tune markdown cadence and avoid over-discounting.

Is a higher clearance percentage always better?

No. High clearance at very low prices may hurt margin. Balance clearance percentage with margin recovery, brand impact, and future demand.

Key Terms in Clearance Percentage

Clearance Percentage

The share of starting inventory you sold during a clearance window, often adjusted for returns, transfers, and shrink.

Sell-Through

The percentage of available units sold in a period, with or without clearance pricing; a baseline for demand.

Markdown

A reduction from original retail price used to accelerate sales and clear inventory, temporary or permanent.

Margin Recovery

The portion of potential gross margin recaptured through clearance sales relative to full-price expectations.

Shrink

Inventory loss due to theft, damage, or administrative error that reduces available units without a sale.

Transfers

Movements of inventory between locations or channels that change on-hand counts in the measured group.

Assortment

The defined group of products included in an analysis, typically by category, season, or specific SKUs.

Distribution of Sales

How units sold spread across SKUs, sizes, colors, stores, or channels; key for understanding gaps masked by averages.

Sources & Further Reading

Here’s a concise overview before we dive into the key points:

• Shopify: What Is Sell-Through Rate and How to Calculate It
• BigCommerce: Understanding Retail Markdowns and Pricing Strategies
• Investopedia: Inventory Turnover Definition and Formula
• National Retail Federation: Retail Security Survey (shrink insights)
• Investopedia: Gross Margin Explained
• SAS Insights: Markdown Optimization and Retail Analytics

These points provide quick orientation—use them alongside the full explanations in this page.