Stock Register Format — Free Excel and App
A stock register tracks each item you hold, the quantity received and issued, and the balance left.
Shops and godowns use a stock register to know what is in hand, spot shortages early and reduce losses.
Stock Register format preview
| Date | Item name | Item code | Quantity in | Quantity out | Balance | Reorder level | Remarks |
|---|---|---|---|---|---|---|---|
| 12-Nov-2026 | Basmati rice 25 kg | RICE-25 | 40 | 12 | 128 | 50 | Reorder not needed |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Item name
Example: Basmati rice 25 kg
Item code
Example: RICE-25
Quantity in
Example: 40
Quantity out
Example: 12
Balance
Example: 128
Reorder level
Example: 50
Remarks
Example: Reorder not needed
Stock Register FAQs
What is a stock register?
A record of every item in stock with quantities received, issued and the balance.
How do I set a reorder level?
Pick the quantity at which you want to reorder, based on how fast the item sells and how long supply takes, and note it per item.
Can I track stock from my phone?
Yes. Recordbook works on Android and the web so staff can update stock in and out on the spot.
Stock register in Excel or app?
Excel works for one person. An app is better when several people update stock or when you need alerts and permissions.
Related registers
Material Inward Register
Format and sample
Material Outward Register
Format and sample
Daily Sales Register
Format and sample
Running a retail & inventory business? See Recordbook for retail & inventory · Recordbook vs Excel