Free Excel template
Shop Stock Register
Free inventory Excel sheet for shops, distributors and stores in Pakistan: record stock in and out, see current stock, stock value and which items to reorder.
Download free Excel fileWorks in Excel and Google Sheets. Sheets inside: How to use, Items, Stock In-Out.
How to use it
- 1List each item once in Items with a code, unit, opening stock, cost, selling price and reorder level.
- 2Every purchase or sale goes on one line in Stock In-Out, marked IN or OUT.
- 3Items updates current stock and stock value by itself.
- 4Items at or below the reorder level show REORDER in red.
What it shows
- Current stock per item
- Stock value at cost
- Reorder alerts
- IN/OUT drop-down and item name lookup
Made for: Shops, wholesalers and distributors who still count stock by hand or in a register.
The few rows marked EXAMPLE show how it works. Delete them before adding your own data.
Want this sheet set up with your own data?
Send your file and we adjust the template to your business. Simple Excel changes Rs 900 per file, messy file clean-up Rs 2,000 per file.
Need more than a template? See our Dashboard Development service.
More free templates
Daraz Seller Profit Calculator
See your real profit on every Daraz order after commission, payment fee, shipping and packing.
ViewKhata / Udhaar Ledger
Track udhaar given and payments received, with every customer's balance in one place.
ViewPayment Recovery Tracker
See who owes you, how late each bill is and how much is stuck in each ageing group.
View