Buying wholesale inventory is only the beginning of the inventory
cycle. After merchandise arrives, a retailer still needs to know how
quickly it is selling, how much cash remains tied up in it, and which
units require attention before they become harder to move.
A wholesale inventory aging report organizes products according to
how long they have been held. When that report is combined with
turnover, sell-through, and weeks-of-supply calculations, discount
stores, independent retailers, eBay sellers, Walmart Marketplace
sellers, Whatnot sellers, exporters, and other resellers can make more
consistent decisions about replenishment, pricing, promotion, and future
purchases.
The objective is not to force every product to sell at the same
speed. Different categories, seasons, margins, and sales channels behave
differently. The objective is to recognize slow movement early enough to
make a deliberate decision.
Why Inventory Age Matters
Inventory is a business asset, but it also represents cash that
cannot be used elsewhere until the product sells. The U.S. Small
Business Administration notes that a business can appear profitable
while its working capital remains tied up in inventory. The SBA also
recommends monitoring inventory turnover and reviewing which products
sell quickly and which remain on the shelf. SBA
cash-flow guidance, SBA
inventory-turnover guidance
Aging merchandise can create additional exposure to:
- Storage and handling costs
- Packaging wear or damage
- Expiration or best-before deadlines
- Seasonal demand changes
- New models or competing substitutes
- Repeated markdowns
- Marketplace fees and advertising costs
- Cash-flow pressure when new buying opportunities appear
Age alone does not prove that an item is unprofitable. A high-margin
specialty product may sell slowly and still meet the retailer’s plan. A
fast-moving product may generate little contribution after freight,
selling fees, returns, and advertising. Inventory age should therefore
be reviewed with margin, demand, condition, and channel eligibility—not
by itself.
Build an Inventory Aging
Report
Start with one row for each SKU, UPC, model, or clearly defined
product variation. Do not combine different sizes, colors, pack counts,
conditions, or expiration dates when those differences affect
saleability.
At minimum, record:
- SKU, UPC, or model number
- Product name and variation
- Condition
- Date received
- Units received
- Units currently sellable
- Units sold
- Landed cost per sellable unit
- Current selling price
- Sales channel or store location
- Lot number or expiration date, when applicable
- Current inventory value at cost
- Age band
A basic age calculation is:
Inventory age in days = report date − receiving
date
For example, inventory received on June 15 and reviewed on August 27
is 73 days old.
Place each line into an age band. A practical starting structure
is:
| Age band | Purpose |
|---|---|
| 0–30 days | New inventory; verify listings, placement, and early sales signals |
| 31–60 days | Compare actual sales pace with the original forecast |
| 61–90 days | Investigate slow movement and test corrective action |
| 91–180 days | Make a documented keep, reposition, bundle, or markdown decision |
| More than 180 days | Escalate for management review and a specific exit or hold plan |
These ranges are management choices, not universal accounting or
marketplace rules. Perishable, seasonal, trend-driven, or
model-sensitive products may need much shorter bands. Durable specialty
merchandise may justify longer ones.
Use the Oldest Relevant Date
The receiving date is normally the clearest starting point, but one
product can have multiple deliveries. Use a consistent method that
preserves the age of the remaining units.
For example:
- 100 units received May 1
- 100 more units received July 1
- 120 units remain on August 1
Treating all 120 units as July inventory would hide the older stock.
A first-in, first-out operational record or lot-level report can show
which receipt dates are still represented. Your accountant should
determine the inventory-identification and valuation method used for
financial statements and tax reporting.
The IRS Taxpayer Advocate Service stated in May 2026 that
small-business records should track inventory as well as gross receipts
and expenses. Taxpayer
Advocate Service recordkeeping guidance
Calculate Sell-Through Rate
Sell-through measures the portion of available units sold during a
defined period.
Sell-through rate = units sold ÷ units available for sale ×
100
Suppose a retailer received 240 sellable units and sold 72 during the
first 30 days:
72 ÷ 240 × 100 = 30% sell-through
That result becomes useful only when compared with the original plan.
If the buyer expected to sell 60 units in the first month, 72 units is
ahead of plan. If the forecast was 120, the same result requires
investigation.
Always label the measurement period. A 30-day sell-through rate
cannot be compared directly with a 90-day rate without adjustment. Also
separate customer returns that re-enter sellable inventory from units
that become damaged or unsellable.
Calculate Weeks of Supply
Weeks of supply estimates how long the current inventory may last at
the recent sales pace.
Weeks of supply = current sellable units ÷ average weekly
unit sales
Example:
- Current sellable inventory: 168 units
- Units sold during the last four weeks: 72
- Average weekly sales: 72 ÷ 4 = 18 units
- Weeks of supply: 168 ÷ 18 = 9.3 weeks
This estimate assumes the recent pace continues. It should be
adjusted when the product is seasonal, newly launched, affected by a
promotion, temporarily out of stock, or exposed to changing
competition.
Run at least two scenarios:
- Current-pace scenario: Uses the recent average
weekly sales - Slower scenario: Reduces the expected weekly sales
rate by a reasonable amount based on the product’s uncertainty
If the slower scenario extends beyond the selling season, expiration
buffer, storage capacity, or available cash-flow window, the buyer has a
reason to act earlier.
Calculate Inventory
Turnover Carefully
Inventory turnover measures how many times inventory is sold and
replaced during a period. A commonly used cost-based calculation is:
Inventory turnover = cost of goods sold ÷ average inventory
at cost
Average inventory = (beginning inventory + ending inventory)
÷ 2
Example for a 12-month period:
- Beginning inventory at cost: $60,000
- Ending inventory at cost: $80,000
- Average inventory: ($60,000 + $80,000) ÷ 2 =
$70,000 - Cost of goods sold: $210,000
- Inventory turnover: $210,000 ÷ $70,000 = 3.0
times
This means the calculated average inventory turned over three times
during that period. It does not mean that every SKU sold three times.
Product-level aging and sell-through reports are still necessary because
fast sellers can hide slow sellers in a company-wide average.
Use cost with cost. Dividing sales revenue by inventory valued at
cost mixes two different bases and can distort the result. A business
with substantial seasonal swings may also use monthly average inventory
instead of only the beginning and ending balances.
There is no single “good” turnover number for every reseller. Compare
the result with the business’s own historical performance, product
categories, margins, seasonality, and cash requirements.
Do Not Use
National Data as a Product Benchmark
The U.S. Census Bureau publishes monthly wholesale sales,
inventories, and inventories-to-sales ratios. Its report released August
6, 2026 showed a seasonally adjusted June 2026 inventories-to-sales
ratio of 1.19 for merchant wholesalers, compared with 1.30 in June 2025.
U.S.
Census Bureau Monthly Wholesale Trade Report
That national figure describes a broad population of merchant
wholesalers and is not a target for one retailer, SKU, or category. It
can provide economic context, but a reseller should rely primarily on
its own product-level sales, cost, age, and demand evidence.
Review
Inventory by Value, Not Only by Unit Count
One hundred old units costing $2 each create a different capital
exposure than 100 units costing $50 each.
Calculate the cost value of each age band:
Inventory value at cost = sellable units on hand × landed
cost per sellable unit
Example:
| Age band | Sellable units | Cost per unit | Inventory value at cost |
|---|---|---|---|
| 0–30 days | 300 | $8.00 | $2,400 |
| 31–60 days | 180 | $8.00 | $1,440 |
| 61–90 days | 120 | $8.00 | $960 |
| 91+ days | 100 | $8.00 | $800 |
Total inventory value is $2,400 + $1,440 + $960 + $800 = $5,600. The 91+ day band represents $800 ÷ $5,600 × 100 = 14.3% of the inventory value in this example.
This view helps management focus on older inventory that has the
greatest cash impact.
Diagnose the Reason
Before Marking Down
A markdown may help when price is the barrier, but it will not fix
every problem. Review the likely cause first.
Product-data problem
Check the UPC, model, variation, pack count, condition, title,
photographs, and description. A listing connected to the wrong variation
or unclear condition can reduce conversion even when demand exists.
Visibility problem
Confirm that the product is active, searchable, in stock, correctly
categorized, and available to the intended customer. For a physical
store, check placement, signage, and staff awareness.
Price or cost problem
Compare a conservative selling price with the adjusted landed cost,
selling fees, packaging, advertising, expected returns, and markdown
allowance. Do not reduce the price without calculating the resulting
contribution.
Demand problem
Recheck completed sales, recent customer behavior, seasonality,
competing offers, and substitute products. Views, watchers, impressions,
or live-show reactions are signals—not completed purchases.
Channel-fit problem
A product can move slowly on one channel but fit another customer
base, store location, export market, or live-sale format. Confirm
current legal, marketplace, brand, category, safety, and destination
requirements before moving it.
Quantity problem
The item may be selling, but the original purchase quantity may have
exceeded the realistic sales window. This is why weeks of supply should
be calculated before reordering.
Create an Aging Action
Ladder
Assign a written action to each age band instead of waiting for an
undefined “old inventory” date.
An example ladder is:
- 0–30 days: Verify receipt, product data, condition,
listing status, and initial placement. - 31–60 days: Compare actual sell-through with
forecast; correct data and visibility problems. - 61–90 days: Test one controlled change, such as
price, bundle, placement, promotion, or channel. - 91–180 days: Decide whether to keep, transfer,
bundle, mark down, or stop replenishing. - More than 180 days: Require a documented hold
reason or exit plan approved by the person responsible for
inventory.
Change one major variable at a time when practical. If the price,
advertising, title, bundle, and channel all change simultaneously, it
becomes harder to identify what improved the result.
Document:
- Action date
- Previous and new price
- Promotion or placement change
- Channel change
- Units sold before and after the test
- Gross proceeds
- Selling and preparation costs
- Remaining units
- Next review date
Set Reorder Rules
That Use Remaining Supply
Do not reorder only because a product sold recently. Reordering
should consider inventory already on hand and the supplier’s lead
time.
A practical calculation is:
Reorder point in units = expected weekly sales ×
replenishment lead time in weeks + safety stock
Example:
- Expected weekly sales: 18 units
- Lead time: 3 weeks
- Safety stock: 18 units
- Reorder point: 18 × 3 + 18 = 72 units
If 168 sellable units remain, the product has not reached this
example’s reorder point. Before using any formula, adjust for
seasonality, supplier availability, minimum order quantity, cash flow,
storage, and changes in demand.
Apply the Process to
NexDeal Purchases
Buyers can begin with NexDeal’s Newest Daily
Deals and record the product identifier, condition, listed MOQ,
available quantity, and unit price shown on the specific offer.
Before ordering, review How NexDeal Works. As
reviewed on August 27, 2026, that page states that buyers must meet the
listed MOQ to receive the displayed Daily Deals price, buyers are
responsible for shipping and customs costs, and all sales are final with
no cancellations or exchanges after an order is placed. It also states
that NexDeal is not an authorized distributor and cannot provide
manufacturer or distributor authorization documents beyond its invoice.
Buyers should perform their own product, marketplace, compliance,
documentation, demand, and profitability research before ordering.
After receiving the merchandise, add each product to the aging report
with its receipt date, sellable quantity, landed cost, and planned sales
window. Review it on a consistent schedule—weekly for time-sensitive
products and at least monthly for the rest of the inventory.
New buyers can complete the NexDeal customer
application before reviewing offers for their stores or sales
channels.
Wholesale Inventory Aging
Checklist
Frequently Asked Questions
What is wholesale inventory
aging?
It is a method of grouping wholesale merchandise according to the
amount of time it has been held. The report helps a reseller identify
new, maturing, slow-moving, and long-held inventory.
When does inventory become
old?
There is no universal number of days. The appropriate threshold
depends on the category, margin, season, expiration date, model cycle,
storage cost, sales channel, and original forecast. Each business should
define and document its own age bands.
What
is the difference between sell-through and turnover?
Sell-through measures the percentage of available units sold during a
stated period. Inventory turnover compares cost of goods sold with
average inventory at cost over a period. They answer related but
different questions.
Should
I automatically mark down inventory after 90 days?
No. First determine why the product is moving slowly. The cause may
be incorrect product data, poor visibility, channel mismatch,
seasonality, excessive quantity, or price. Calculate the financial
result before changing the price.
Can fast turnover still
be unprofitable?
Yes. Inventory can sell quickly while generating insufficient
proceeds after merchandise cost, freight, selling fees, advertising,
preparation, returns, and other expenses. Review turnover together with
contribution and cash flow.
Where can I
review NexDeal’s current inventory?
Visit NexDeal’s
Newest Daily Deals. Product details, prices, quantities, condition,
and availability can change, so evaluate the live listing and current
terms before ordering.
This article provides general business information and does not
constitute accounting, tax, legal, financial, marketplace, or regulatory
advice.
Sources Used
- U.S.
Small Business Administration: Check Your Business KPIs Before the
Holiday Season Starts — reviewed August 27, 2026 - U.S.
Small Business Administration: 5 Things Business Owners Do Better With
Lean Business Planning — reviewed August 27, 2026 - U.S.
Census Bureau: Monthly Wholesale Trade Report, June 2026 — released
August 6, 2026 and reviewed August 27, 2026 - Taxpayer
Advocate Service: Small Business Filing and Recordkeeping
Requirements — published May 1, 2026 and reviewed August 27,
2026 - NexDeal: Newest
Daily Deals — reviewed August 27, 2026 - NexDeal: How
NexDeal Works — reviewed August 27, 2026 - NexDeal: New
Customer Application — reviewed August 27, 2026