Slow-Moving Stock Report: Find Cash Trapped on Retail Shelves
A full shelf can look reassuring, but it may conceal one of a retailer’s most expensive operating problems: products that were paid for months ago and are barely moving. The shop has money tied up in those units, less room for items customers want today, and a growing risk that packaging, fashion, demand or condition will make the stock harder to sell.
A useful slow moving stock report Kenya retailers can act on should do more than list products with a low current quantity. It should show which items have not sold within an agreed period, how many units remain, when stock last moved, what those units cost and who supplied them. This guide explains how to build that review, which decisions to make from it and what to ask during a retail POS demonstration.
Slow-moving stock is a business definition, not a universal number
A product is slow-moving when it sells more slowly than the business expected for its category, season and buying cycle. That definition varies. Thirty days without a sale may be serious for a fast-moving convenience item but normal for a specialised tool. A school-season product can be quiet for months and then become relevant again. Furniture and electronics should not be judged by the same window as snacks or daily household goods.
Start with category-specific review periods. For example, management might examine everyday products after 30 days without a sale, seasonal goods against the same season’s plan, and higher-value durable items after a longer period. These are management thresholds, not accounting rules. Their purpose is to trigger a conversation early enough for the shop to act.
Do not confuse slow-moving with dead stock. Slow-moving items still have some demand or a reasonable recovery path. Dead stock has little realistic prospect of sale under normal conditions. The report should help management distinguish between “watch,” “act now,” and “exception requiring a special decision.”
Why shelf stock becomes slow
The report identifies the symptom, but the business must understand the cause before choosing a remedy. Typical causes include:
- Buying too much: an order was based on hope, a supplier minimum or an outdated sales estimate.
- Wrong assortment: the size, colour, specification or price point does not match local demand.
- Weak visibility: the item is hidden, poorly displayed or unknown to the cashier.
- Pricing mismatch: the selling price is no longer competitive or the margin target ignores market reality.
- Duplicate alternatives: several similar products compete for the same small demand.
- Supplier-led purchasing: discounts encouraged the shop to buy quantities it could not sell quickly.
- Stock-record error: the system shows units that are missing, damaged, returned or incorrectly adjusted.
- Seasonality: the review ignores the period when customers normally need the product.
- Demand change: customers moved to another product, specification, pack size or style.
Each cause suggests a different action. A visibility problem may need a display change. Excess quantity may need a controlled promotion. Wrong system stock needs a count and adjustment, not a discount. A product with seasonal demand may simply need a purchase freeze and a later review.
What the report should contain
Ask for enough detail to make a decision without turning the report into an unreadable data dump. At minimum, include:
- product name or stock code;
- category and, where used, relevant variant;
- current recorded quantity;
- last sale date and days since last sale;
- units sold during the selected review period;
- latest or applicable purchase cost;
- current selling price and margin context;
- supplier or purchase source;
- date or period when stock was received;
- value tied up at cost, based on the business’s chosen costing method;
- owner, action and next review date.
The number of “days since last sale” is useful, but it should not stand alone. An item with no sale for 60 days and one unit remaining is a different decision from an item with no sale for 60 days and 200 units remaining. Quantity and cost exposure determine urgency.
For background on connecting sales and stock activity, review this retail inventory management guide. It explains why purchases, sales, returns and adjustments must be part of one stock story before any ageing analysis is trusted.
Build ageing buckets that lead to action
An ageing view groups stock according to time since the last relevant movement or another defined measure. A simple retailer might use current, watch, slow and critical buckets. The exact day ranges should match each category. Avoid copying a generic 30/60/90-day template without asking whether it reflects how your products sell.
For every bucket, assign a default response:
- Current: continue normal replenishment subject to demand.
- Watch: check shelf visibility, sales trend and outstanding purchase orders.
- Slow: pause or reduce reordering, verify physical quantity and choose a recovery action.
- Critical: escalate for a specific commercial decision and document the reason.
These actions prevent the report from becoming a monthly list that everybody reads and nobody owns. The report should create work: verify, stop buying, reposition, bundle, negotiate, transfer where applicable under the business’s operating model, return to supplier if agreed, or approve a controlled price change.
A weekly slow-stock review process
1. Choose the scope
Do not start with every item if the catalogue is large. Review one category, the highest-value exposure or the oldest bucket. Set a consistent cut-off date so that comparisons from week to week are meaningful.
2. Confirm the stock balance
Before making commercial decisions, count the important flagged items. Slow-moving stock may have been damaged, misplaced or adjusted incorrectly. A discount on units that do not physically exist cannot recover cash. Record authorised corrections with a reason so the report improves.
3. Check the movement history
Look at purchases, sales, customer returns and stock adjustments. Determine whether the product truly has weak demand or whether a recent receipt made the balance look high. A return can place a unit back into stock even when the original purchase was much earlier.
4. Review margin before changing price
A price reduction can move stock, but it can also convert a working-capital problem into a margin problem. Understand purchase cost, current selling price, available margin and any related selling expense before approving a discount. Decide who has authority to set the new price and when it should end.
5. Check supplier history
Review who supplied the item, how often it was purchased and whether more units are already expected. Ask whether the supplier accepts agreed returns, substitutions or revised order quantities. Do not promise a supplier action that was never negotiated; use the history to prepare a specific conversation.
6. Select one clear action
Avoid vague notes such as “push sales.” Choose something measurable: move the item to a higher-visibility shelf, train cashiers on its use, photograph it for an approved sales channel, bundle it with a complementary item, reduce future order quantity, freeze reordering, approve a time-limited price change or investigate physical condition.
7. Assign an owner and review date
Name the person responsible and the date the result will be checked. If the product remains slow, the next review should escalate the decision instead of repeating the same action. Store the reason so future buyers understand why purchasing was changed.
Prioritise by cash exposure, not just item count
A list sorted alphabetically rarely reflects the biggest problem. Prioritise the value tied up at cost, then consider age, quantity, storage space and the likelihood of deterioration or obsolescence. Ten expensive units may deserve more attention than hundreds of low-cost items. Conversely, a low-cost product that occupies a large selling area can still block better use of the shelf.
Create a short management view with the top exposures by category and supplier. Then allow the reviewer to open the underlying product movements. This combination helps an owner see the scale quickly without losing the evidence needed to act.
Sales and stock should also be considered alongside product profitability. The retail analytics guide provides a useful companion perspective on turning operational records into questions managers can answer.
Reorder controls should respond to slow stock
A slow-stock review fails if the purchasing process automatically brings in more units before anyone acts. When an item enters a defined slow category, the buyer should see the warning before approving another purchase. That may mean pausing replenishment, reducing the proposed order or requiring a manager to explain why more stock is necessary.
This does not mean every slow item should be blocked. A seasonal product may need early purchasing. A contractual pack size may force an unusual quantity. A key customer may have a planned order. The control should surface the exception and preserve the reason rather than apply a blind rule.
Use the POS inventory software buyer checklist to examine how product setup, purchasing, sales and adjustments connect. A slow-moving report is only as reliable as the transactions feeding it.
Actions that protect both cash and customer trust
Promotions should be truthful. Do not conceal damage, expired suitability or a known defect. Where product condition matters, inspect it before selling. Explain the offer clearly and keep the price change authorised. A bundle should still make sense to the customer rather than merely hiding an unwanted item beside a popular one.
Consider non-price actions first when they address the true cause. Better placement, staff product knowledge, a smaller reorder or a supplier conversation may preserve more margin than an immediate deep discount. When a markdown is appropriate, set a start, end, approved price and review result. The aim is controlled recovery, not a permanent informal price that nobody remembers authorising.
Common reporting mistakes
- Using only current quantity: quantity does not show sales speed or age.
- Using one threshold for every category: different products have different demand cycles.
- Ignoring returns and adjustments: apparent slow stock may reflect incorrect movements.
- Valuing everything at selling price: this can overstate the cash originally committed.
- Flagging without ownership: a report without actions becomes shelf decoration.
- Discounting before checking margin: units may sell while profit quietly disappears.
- Continuing to reorder: new deliveries can enlarge the problem faster than promotions reduce it.
- Deleting inconvenient products: removing a product record can damage the movement history needed for review.
Questions to ask in a slow-moving stock software demo
- How does the system define days since last sale?
- Can review periods differ by product category?
- Can we see current quantity, recent sales and purchase cost together?
- How are returns and stock adjustments reflected?
- Can the report show the value tied up by product, category and supplier?
- Can a user move from the summary to transaction history?
- How do we identify products that have never sold?
- Can buyers see slow-stock warnings before another purchase?
- Can roles restrict who changes prices or stock quantities?
- Can we record an action, owner, reason and next review date?
- How does the system handle a product with seasonal demand?
- Can the report be filtered without exporting and rebuilding it manually?
For the demo, bring three real examples: one normal fast seller, one slow product with a large quantity, and one expensive item that sells infrequently. Ask the provider to show why each is or is not flagged. This reveals whether the tool supports your decisions rather than simply producing a long list.
Frequently asked questions
How many days make stock slow-moving?
There is no single correct number. Use periods that reflect the category, season and normal purchasing cycle. Review the thresholds over time and document exceptions rather than applying one arbitrary window to every product.
Is slow-moving stock the same as dead stock?
No. Slow stock still moves below expectation or has a reasonable recovery path. Dead stock has little normal demand. Separating the two helps management choose proportionate actions.
Should every slow product be discounted?
No. First confirm the quantity and cause. Visibility, assortment, supplier terms, an excessive reorder or a stock-record error may require a different response. Check margin before approving any price change.
Why include supplier information?
Supplier history helps the buyer understand order frequency, quantities and possible agreed options. It also reveals whether the same buying pattern is repeatedly creating slow stock.
What if an item has never sold?
Use the receipt or product creation date and purchase history to identify it. Verify that the item was available for sale, correctly priced and physically present before deciding that demand is absent.
How often should the report be reviewed?
High-value or fast-changing categories may need frequent review; stable categories may need less. A weekly exception review plus a deeper periodic category review is a practical starting point for many retailers, but the business should set its own rhythm.
Can stock adjustments hide the problem?
Unauthorised or poorly explained adjustments can make history unreliable. Restrict adjustment rights, require a reason and review unusual activity so that corrections improve accuracy without erasing accountability.
What is the most important number on the report?
No single number is enough. Value at cost, days since last sale, quantity on hand and recent unit sales together give a more useful view of exposure and urgency.
Turn the slow-stock list into a weekly decision
Vega connects sales, purchases, returns, stock adjustments, supplier history, product margins and reports so a retailer can investigate why stock is not moving. The best evaluation starts with your real catalogue and your own ageing definitions.
Register your interest in Vega and request an online Vega demonstration, or arrange an appointment-based in-person discussion with Zama Systems at its Karuguru Plaza office along Eastern Bypass. Use actual product scenarios to confirm quantities, trace movements, compare cost exposure and assign an action. The outcome should be a shorter, owned decision list—not another report that sits unopened while cash remains on the shelf.