How Retail Business Owners Can Track Profit by Product and Stop Losing Money on Dead Stock
📦 Product Pricing · By Fincaly Team · · 8 min read
To track profit by product, record what each item costs you, what you sell it for, how many you sell in a month and the total profit it produces. Then rank your products by profit. This shows which items earn money, which tie it up and which should be repriced or dropped.
If you run a shop, your profit does not live in your total sales figure. It lives at the product level. Two products can bring in the same revenue and have very different margins. A fast seller may lose money on every sale, while a slower line may be your most profitable. Without product-level tracking, you will never know.
The dead stock problem
Dead stock is inventory you bought but cannot sell. It is one of the most common and costly retail problems. It ties up cash, takes shelf and storage space, and is often sold at a loss or written off. The root cause is nearly always the same: buying decisions made without data on what sells profitably.
Why total revenue hides the real story
A shop with ₦3,000,000 in monthly sales can earn less than a shop with ₦2,000,000 if its margins are poor. High revenue with thin margins on key lines creates the illusion of a healthy business. You need to look beneath the top line. See gross profit vs net profit to understand why.
How to track profit by product
For every product, record four things:
- Cost per unit. Purchase price, plus delivery to you, plus any packaging.
- Selling price per unit.
- Units sold in the month.
- Units left in stock.
From these you can calculate:
- Profit per unit = selling price minus cost
- Margin = profit per unit ÷ selling price
- Total profit = profit per unit × units sold
- Months of stock left = units in stock ÷ units sold per month
A worked example
| Product | Cost (₦) | Price (₦) | Units sold | Profit (₦) | Stock left |
|---|---|---|---|---|---|
| A | 3,000 | 4,500 | 100 | 150,000 | 40 |
| B | 8,000 | 9,000 | 120 | 120,000 | 30 |
| C | 5,000 | 7,500 | 20 | 50,000 | 150 |
Product B sells the most units but has the lowest margin, about 11%. Product A earns the most profit. Product C earns a good margin but sells slowly, and 150 units at 20 a month is more than seven months of stock. That is cash sitting on a shelf.
What would you do? Perhaps push Product A harder, try a small price increase on B, discount or bundle C to free cash, and stop reordering C until it clears.
Spot dead and slow stock early
- Flag any item with more than three months of stock at current sales.
- Review stock by age. Items that have not sold in 60 to 90 days need a plan.
- Bundle slow items with fast ones.
- Discount deliberately, and check you still recover your cost.
- Stop reordering until stock clears.
Plan around seasons and events
Many products sell in waves: school resumption, festive periods, rainy season, and the start and end of the month when salaries arrive. Look at last year's sales for each product group and plan:
- Stock up gradually before the peak instead of in one large purchase
- Avoid large orders right after a peak, when demand is about to fall
- Clear leftover seasonal items soon after the season ends, while there is still some demand
- Keep a note of what sold out early, so you buy more next time
Seasonal stock that misses its window is the most common source of dead stock.
Make better buying decisions
Buy based on profit and speed of sale, not on habit or supplier pressure. For each reorder ask:
- How many did I sell last month, and at what profit?
- How much stock do I still have?
- What is the cash I tie up, and what else could that cash do?
Pair this with your cash flow forecast, because buying too much is a cash flow problem as well as a stock problem. For shops in Nigeria, our guide for provision store owners adds practical tips.
Price with the data
When you know which items have thin margins, you can fix them. Read how to price products for profit and how to raise prices without losing customers.
How Fincaly's Unit Economics feature solves this for retail
Log each product with its cost price, selling price and quantity. Fincaly calculates the margin for each product, rates its health, flags poor performers and suggests better pricing. You can filter by month and year to see seasonal items, update quantities as stock moves and see your whole portfolio in one view.
Fincaly feature: Unit Economics. Track profitability per product with automatic margin calculations and pricing suggestions. Explore Unit Economics
Track every product's profitability in one place Start your 3-day free trial →
Next steps
Profitable retail is not about stocking the most. It is about stocking the right products at the right margins. List your top twenty products this week, calculate profit per unit and months of stock, and act on the worst three.
Cover photo by Bruno BD on Unsplash.
Frequently asked questions
What is dead stock?
Dead stock is inventory that you have bought but cannot sell, or that has not sold for a long time. It ties up cash and space.
How do I calculate profit per product?
Subtract the full cost per unit from the selling price, then multiply by the number of units sold in the period.
How often should I review product profitability?
Monthly for your main products, and whenever supplier prices change.