Mera Hisab
How to use the stock calculator
- Add each item you keep in stock, with its unit, cost price and selling price.
- Enter the opening stock (what you had at the start of the period), the quantity purchased and the quantity sold.
- The tool shows each item's closing stock, its stock value at cost, your sales and your gross profit, and adds them up at the top.
- Set "Alert at" for items you must not run out of. When the closing stock falls to that level, the item is marked "Low stock". Use the "Low stock" filter to see what to reorder.
- At the end of the month (or any period), press Start new period. Each closing stock becomes the next opening stock, purchases and sales go back to zero, and the period's totals are kept under "Past periods".
The formulas
| What | Formula |
|---|---|
| Closing stock | Opening stock + purchased − sold |
| Stock value | Closing stock × cost price |
| Sales | Quantity sold × selling price |
| Gross profit | Quantity sold × (selling price − cost price) |
Example
A kirana shop keeps 25 kg bags of rice. It buys at ₹1,150 a bag and sells at ₹1,300.
- Opening stock 12 bags + purchased 40 − sold 45 = 7 bags in stock
- Stock value: 7 × ₹1,150 = ₹8,050
- Sales: 45 × ₹1,300 = ₹58,500
- Gross profit: 45 × (₹1,300 − ₹1,150) = ₹6,750
If "Alert at" is 10 bags, rice shows as low stock, a reminder to order more.
Why stock value matters
- Accounts and income tax: closing stock is part of your profit calculation. For accounts it is valued at cost, or at market value if that is lower.
- Bank loans: banks ask for a stock statement for cash-credit (CC) and overdraft limits. The PDF here lists every item with its quantity and value.
- Money stuck in stock: a high stock value with low sales means cash sitting on the shelf. Sell slow items first and buy less of them.
Gross profit here is before shop rent, salaries, electricity and other expenses, so your actual (net) profit is lower.
Frequently asked questions
What is closing stock?
The quantity left at the end of a period: opening stock plus purchases minus sales. Its value at cost price is your closing stock value.
Should stock be valued at cost price or selling price?
At cost price, or at market value if that is lower (for example for damaged or outdated goods). Valuing stock at selling price would count profit you haven't earned yet.
Why does an item show a negative stock?
You entered more sold than you had in stock. Check the opening stock and purchases, perhaps a purchase was not entered.
Where is my stock data saved?
Only in this browser on this device. Nothing is uploaded. Download a backup regularly, and use "Export to Excel" for a spreadsheet of all items.
Can I use it for more than one shop?
Each device and browser keeps one stock list. For a second shop, use another browser or keep separate backups and restore the one you need.