Free tool
Stock valuation calculator
List what is on your shelves with its cost and selling price, and see your closing stock valued at cost, at selling price, and at the lower of cost and realisable value that your accountant will use.
Closing stock for the books
₹15,197.00
- Units on hand
- 34
- Value at cost
- ₹16,100.00
- Value at selling price
- ₹27,366.00
- Profit still on the shelf
- ₹11,266.00
- Lower of cost and realisable value
- ₹15,197.00
Runs in your browser. Nothing you type is sent to HindustanBills.
Three values, and which one the books use
At cost is what you paid for the stock you still hold. At selling price is what it would bring in if it all sold today. The gap is the profit still sitting on the shelf.
For the books, stock is valued at the lower of cost and net realisable value (AS 2). Net realisable value is what the item will now sell for, less any cost of selling it.
The comparison is made item by item. Last year's model that will now sell for less than it cost is written down on its own, even if the shelf as a whole is worth more than it cost. Comparing only the totals would hide exactly the stock that is losing money.
Questions
Asked about this
Should cost include GST?
If you claim input tax credit, no: use the cost before GST, since that GST comes back to you. Freight and other costs of bringing the stock to your shop belong in cost.
What if an item has not sold in months?
Enter the price it would realistically fetch now, not the price on the tag. If that is below cost, the item is written down and highlighted.
Is anything I type here saved or sent anywhere?
No. The calculator runs in your browser and makes no request with the figures you enter.
More free tools
For the rest of the counter
- GST calculatorAdd GST to a price or take it out, with the CGST, SGST and IGST split.
- Profit margin calculatorMargin and markup from cost and price, or the price that earns the margin you want.
- Discount calculatorPrice after one discount or a chain of them, and the single discount it adds up to.
- GST invoice generatorA GST tax invoice with HSN, CGST/SGST or IGST and amount in words, as a PDF.
- Purchase order generatorA purchase order for a supplier, with GST, delivery date and terms, as a PDF.
Stop counting the shelf to know what it is worth
HindustanBills keeps stock as you buy and sell, colour by colour and size by size, so the stock value is on the screen whenever you look.