SMALL BUSINESS · INVENTORY

How to calculate inventory profit and stock value

A profitable sale is not the same as cash collected. To understand your product margins, you need a consistent method for measuring inventory cost and recording units sold.

1. Count the stock you own

Start with each product's opening quantity, purchases, sales, returns and stock adjustments. Units on hand = opening units + units purchased + customer returns − units sold − units returned to suppliers + net adjustments. Keep a clear record of each movement.

2. Calculate weighted-average unit cost

When the same item is bought at different prices, a weighted-average method can help. Average unit cost = total cost of available units ÷ total available units.

Worked example

You have 10 units costing ₹100 each and buy another 10 at ₹140 each. Total cost is ₹2,400 for 20 units, so the weighted-average unit cost is ₹120.

If you sell 8 units for ₹180 each, sales revenue is ₹1,440. Cost of goods sold is 8 × ₹120 = ₹960. Gross profit is ₹480. The remaining 12 units have an estimated inventory value of ₹1,440 under this method.

3. Separate gross profit from net profit

Gross profit = sales revenue − cost of goods sold. Net profit also accounts for other operating costs, such as rent, shipping, taxes where applicable, payment fees and marketing. Do not describe gross profit as your final take-home profit.

4. Set reorder alerts

Record a minimum quantity for frequently sold items. Review low-stock alerts regularly, taking into account supplier lead times and demand. A low-stock threshold is a reminder to review, not an automatic purchase recommendation.

5. Back up your records

Export a copy of your data before changing devices or browsers. Offline browser-based tools may keep data locally; clearing browser storage can erase records if you have no backup.

Common inventory mistakes

Try the free calculator

Explore a simple stock and profit calculation before choosing a full tracker.

Open free inventory calculator

Need a reusable inventory ledger?

COSTIN Inventory & Profit Manager is a downloadable offline-first browser tool for purchases, sales, returns, stock adjustments, weighted-average costs and gross-profit reports. No subscription; browser compatibility may vary.

Explore Inventory & Profit Manager