Closing stock is the value of the goods still on your shelves at the end of a period, usually the last day of the month. Opening stock is the same figure at the start of the period, so this month's closing stock becomes next month's opening stock. To work it out, count what is physically there, put a cost on each item using one method, and write the total down with the date.
What are opening stock and closing stock?
Think of stock as a snapshot of your shelves. On the 1st of the month you had some goods; during the month you bought more and sold some; on the last day you had whatever was left. The first snapshot is opening stock, the last is closing stock. Both are valued at what the goods cost you, not at the price you hope to sell them for.
The two numbers matter because they let you work out how much stock was actually used up in sales. Without them, a big purchase before a festival looks like a huge expense, even though most of the goods are still unsold on the shelf.
How do you count closing stock at month end?
- Pick a quiet hour, ideally after closing time on the last day, so sales do not change the shelves while you count.
- Walk the shop in one direction, shelf by shelf, so nothing is counted twice or skipped.
- Write each item, its pack size and the quantity on a sheet. Count loose items in the unit you buy them in, such as kilograms, dozens or cartons.
- Note damaged, expired or returned-to-supplier items separately instead of mixing them with saleable goods.
- Next to each line, write the cost per unit from your latest purchase bill, then multiply and add up.
What does a simple stock-count sheet look like?
Here is a hypothetical sheet for a small provision shop on 30 June. The costs are made up for illustration; use the figures from your own bills.
| Item | Quantity | Cost per unit | Value |
|---|---|---|---|
| Rice, 25 kg bags | 12 | ₹1,350 | ₹16,200 |
| Cooking oil, 1 litre pouches | 60 | ₹140 | ₹8,400 |
| Tea, 500 g packs | 24 | ₹260 | ₹6,240 |
| Biscuits, cartons | 10 | ₹480 | ₹4,800 |
| Bathing soap, pieces | 40 | ₹36 | ₹1,440 |
| Closing stock, 30 June | Total | All items | ₹37,080 |
Add the five values: 16,200 plus 8,400 is 24,600; plus 6,240 is 30,840; plus 4,800 is 35,640; plus 1,440 is 37,080. That figure goes in your records as closing stock at 30 June and is copied to the top of next month's sheet as opening stock.
How should you value the stock?
For a small shop the simplest approach is to use what the goods cost you, taken from your purchase bills. Prices move, so you may have the same item bought at two different costs. Choose one way of handling that, for example always using the most recent bill, and write the method at the top of the sheet. The point is to use the same method every month so the numbers can be compared.
Which method is acceptable for your tax filing or a bank loan is a question for your CA. Rules change, so confirm the current position with them or the official source rather than relying on a blog.
What do you do with the closing stock figure?
It feeds the cost of goods sold: opening stock plus purchases minus closing stock. Say opening stock was ₹31,500 and purchases for June were ₹52,000. Then 31,500 plus 52,000 is 83,500; minus the closing stock of 37,080 leaves 46,420 as the cost of the goods you sold. Compare that with your June sales to see the gross margin.
The purchases figure is easier to trust when every supplier payment is in one place. If you pay suppliers from a bank account or card, importing the statement into SpendixAI and adding cash purchases by hand gives you the purchase total; the shelf count itself still has to come from your own sheet.
Why does your count not match what you expected?
- A purchase bill was never entered, so stock exists on the shelf but not in the records.
- Goods were taken for home use or given as samples and not noted.
- Items were damaged, expired or stolen and written off in your head but not on paper.
- Units were mixed up, for example counting cartons in one month and pieces the next.
- A customer return came back to the shelf without being logged.
A month-end checklist
- Count after closing, shelf by shelf, in one direction.
- Record damaged or expired goods on a separate line.
- Value everything by the same stated method.
- Total the sheet, date it and sign it.
- Copy the total into next month's opening stock cell.
- Keep the sheet with that month's purchase bills.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
