A monthly inventory audit turns unsold stock from a vague concern into a set of measurable decisions. This workflow shows how to sort aging listings, check whether the problem is visibility or price, estimate the cash tied up in inventory, and choose between relisting, markdowns, bundling, repair, return, donation, or removal.
Overview
Slow-moving inventory is not automatically a bad investment. Some items need better photos, more accurate keywords, or a seasonal relaunch. Others are priced above what comparable buyers will pay, have hidden condition issues, or no longer justify the storage and attention they consume.
The purpose of a reseller inventory audit is to evaluate each item using the same questions:
- How long has the item been available?
- What cash is still tied up in it?
- Is the listing reaching the right buyers?
- What would a realistic sale produce after fees, shipping, supplies, and discounts?
- What is the best next action for cash flow and total profit?
Review inventory at least once each month, using one worksheet or spreadsheet as the source of truth. Record the item SKU, purchase date, cost, current listing price, platform, estimated fees, storage location, condition, and next action. For a broader look at profit, break-even price, and return on investment, use the resale profit calculator guide.
How to estimate
Begin by placing every unsold item into an aging bucket. The exact thresholds can vary by category and selling platform, so treat these as a practical starting framework rather than a universal rule:
| Age since listing | Primary review | Typical next step |
|---|---|---|
| 0–30 days | Is the listing complete and visible? | Improve presentation before cutting price. |
| 31–60 days | Are views, saves, messages, or offers weak? | Test a modest price change, refresh the listing, or cross-list. |
| 61–90 days | Does demand support the current price? | Run a structured markdown or create a bundle. |
| More than 90 days | What is the recovery value of the item? | Choose a final sale, wholesale-style bundle, local clearance, donation, or removal. |
Next, calculate the minimum acceptable sale price. A simple estimate is:
Break-even price = item cost + preparation costs + packaging + shipping paid by seller + fixed selling costs + variable selling fees
Then calculate the expected net proceeds:
Expected net proceeds = sale price − platform fees − payment fees − shipping − packaging − discounts − other direct costs
Compare expected net proceeds with your original cost and with the value of freeing the cash today. A markdown can be sensible even when it produces little profit if it releases capital that can be used for stronger inventory. Conversely, a small discount may be wasteful if a listing has a fixable visibility problem.
Use this decision sequence for each stale listing:
- Verify the item. Confirm that it is still in stock, accurately described, complete, and easy to locate.
- Check listing quality. Review the first image, title, measurements, brand or model details, condition notes, category, shipping settings, and pickup information.
- Compare realistic alternatives. Look at comparable sold or completed listings where available, not only active asking prices. Adjust for condition, accessories, season, and local demand.
- Select one test. Change one major variable at a time when possible: price, lead image, title, shipping offer, or bundle format.
- Set a review date. Record when you will judge the test rather than changing the listing repeatedly without learning from the result.
Inputs and assumptions
A useful audit depends on consistent inputs. Separate known amounts from estimates so a hopeful sale price does not hide a weak outcome.
Direct financial inputs
- Original purchase cost, including any sourcing-related allocation you use consistently.
- Cleaning, repair, alteration, or refurbishment costs already paid.
- Packaging materials and expected shipping cost.
- Platform, payment, listing, or promotion fees that apply to the sale.
- Discounts, refunds, or buyer incentives you expect to offer.
Operational inputs
- Days since purchase and days since the current listing was published.
- Storage space used and whether the item is difficult to access.
- Time required to photograph, test, pack, deliver, or meet a buyer.
- Whether the item is seasonal, fragile, incomplete, oversized, or restricted to local pickup.
Do not treat estimated market value as guaranteed revenue. Build at least three scenarios in your worksheet: a full-price outcome, a realistic discounted outcome, and a recovery outcome. The recovery outcome might represent a quick local sale, a bundle, a parts sale, or another lower-effort exit.
For pricing context, the guide on how to price used items can help you separate condition adjustments from arbitrary markdowns. If shipping is the problem, review category-specific packaging and cost considerations in how to ship resale items.
Worked examples
Example 1: A listing that needs better presentation
Assume a small home-goods item cost $18. Preparation and packaging add $2, and estimated selling and payment fees total $5 at the intended sale price. The current listing price is $35, producing an estimated net of $10 before considering your time. The item has been listed for 24 days with limited buyer activity.
Because it is still in the early aging bucket, a markdown may be premature. First replace the unclear lead image, add dimensions, state the condition plainly, and verify the category and search terms. Recheck after the review period you set. If activity improves, the listing problem was likely more important than the price. If activity remains weak, move to a controlled price test.
Example 2: A stale item with a markdown decision
Assume a clothing item cost $12, preparation and packaging total $3, and expected fees are $6 at a sale price of $30. The estimated net is $9, below the combined direct cost of $15. At 75 days, you might test a lower price, but the decision should account for the likely sale probability and the cash tied up in the item.
Possible actions include improving measurements and condition details, bundling it with a complementary item, moving it to a platform with a better buyer fit, or setting a final clearance price. If a $22 sale produces an estimated net of $4, that is not a profitable outcome on the original transaction. It may still be preferable to continued storage if it clears space and returns cash for a better purchase. Record it as a loss or reduced recovery rather than calling it profit.
Example 3: Furniture with repair costs
For a furniture flip, include materials, transport, hardware, cleaning, and your chosen labor value before deciding on another repair. If the projected sale price does not cover the revised total cost plus a reasonable return for the work, stop adding features and choose an exit plan. The furniture flipping project planner can support this type of item-level review.
When to recalculate
Recalculate your inventory decisions at the start or end of every month, and sooner when an important input changes. Review immediately when platform fees, shipping costs, payment processing, return exposure, or promotion costs change. Also revisit an item when comparable listings shift, the season changes, a product becomes incomplete or damaged, or you move it to another marketplace.
Use this closing checklist:
- Export or update every active and unsold item.
- Assign an aging bucket and confirm the physical item is available.
- Record current price, likely sale price, direct costs, and expected net proceeds.
- Choose one action: improve, reprice, relist, cross-list, bundle, repair, sell locally, donate, or remove.
- Set the next review date and write the markdown floor before emotions enter the decision.
- Summarize total cash tied up, expected recoverable cash, and inventory that should not be replenished.
Keep the worksheet alongside your bookkeeping records so realized sales and losses update future buying decisions. For a monthly recordkeeping structure, see reseller bookkeeping for beginners. A consistent audit will not make every item profitable, but it will make slow-moving inventory visible, comparable, and easier to act on.
