A stock register is a running record of every item that comes into and goes out of your stores. Each row records the date, document number, item, quantity in, quantity out and the balance left. That book balance should match what is on the shelf. For a GST-registered factory, Rule 56(2) of the CGST Rules asks for stock accounts. They show opening balance, receipts, supplies, goods lost or written off, free samples, and the balance of raw material, finished goods, scrap and wastage.
The free Excel download has a blank format and a filled example.
What is a stock register?
It is the store's diary: one row per receipt, issue, return, dispatch or write-off. It shows when book and shelf stock drift apart, tells you when to reorder and meets GST law.
A school stock register works the same way for books and lab items. This one is built for factories.
Is a stock register compulsory under GST?
For most registered businesses, yes. Rule 56(2) of the CGST Rules asks every registered person to keep stock accounts. Composition-scheme businesses (section 10) are excluded, so check with your CA.
- Rule 56(8): entries must not be erased or overwritten. Electronic records must keep a log of every edit or deletion.
- Rule 56(12): manufacturers must keep monthly production accounts of raw material used and goods made, including waste and by-products.
Stock register format: every column explained
The download has 12 columns. Examples come from the GRN row in the worked example.
| Column | What to write | Example |
|---|---|---|
| 1. Date | Day the goods moved | 03-11-2026 |
| 2. Doc no. | GRN, issue slip, challan or invoice number | GRN-1042 |
| 3. Movement | Opening, purchase in, issue, floor return, output, scrap, sale, job work out or in, adjustment | Purchase in |
| 4. Category | RM, WIP, FG or Scrap | RM |
| 5. Item (unit) | Code and name with size, then its one fixed unit | RM-001 MS sheet 2 mm (kg) |
| 6. Store · party / WO | Store, bin or location ('At job worker' for job work out), then the supplier, customer, job worker or work order (WO) | Main store · Supplier A |
| 7. Qty in | Quantity received | 1,000 |
| 8. Qty out | Quantity issued, sold or written off | (blank) |
| 9. Balance qty | Last balance + in − out, per item and store | 1,500 |
| 10. Rate (₹) | Purchase rate on receipts; average rate on issues | ₹63 |
| 11. Value (₹) | Last value + value in − value out | ₹93,000 |
| 12. Flag / remarks | REORDER at or below the reorder level; reason for returns or adjustments | New average ₹62/kg |
Raw material, WIP, finished goods and scrap: one register or separate?
A small store can keep one register with a Category column, filtered by it. Bigger stores often keep one sheet per category, with the same columns. Your bill of materials shows how much each work order should draw.
[[IMAGE {"type":"checklist","title":"Month-end register check","items":["Every row has a document number","No balance typed over","Shelf count matches the book balance","Gaps posted as adjustment rows","REORDER items sent to purchase"]}]]
How to fill a stock register, step by step
The best way to keep stock records is one row per movement, a document number on each, and a monthly count. Move to software once entries pile up.
- Set up the item master. One code, unit and reorder level per item.
- Enter opening stock from a shelf count. Our opening stock guide has more.
- Add one row per movement. Use a goods received note for receipts, an issue slip for the floor and a material transfer note between stores.
- Never overwrite. Add a correction row with a remark.
- Count every month. Post any gap as an adjustment row with a reason. See the stock reconciliation guide.
Rather not type every row twice? TranZact connects every movement that affects stock on one system.
Worked example: a small fabrication unit, November 2026
The unit cuts MS sheet into mounting brackets. All numbers are illustrative.
| Date · Doc | Movement | In / out | Balance after |
|---|---|---|---|
| 01-11 · OB/NOV | Opening stock, MS sheet 2 mm | +500 kg @ ₹60 | 500 kg · ₹30,000 |
| 03-11 · GRN-1042 | Purchase in, Supplier A | +1,000 kg @ ₹63 | 1,500 kg · ₹93,000 |
| 06-11 · ISS-201 | Issue to work order WO-55 | −600 kg @ ₹62 | 900 kg · ₹55,800 |
| 10-11 · RET-14 | Return from floor, WO-55 | +50 kg @ ₹62 | 950 kg · ₹58,900 |
| 12-11 · PRD-31 | Production output, bracket MB-2 | +1,100 pcs @ ₹31 | 1,100 pcs · ₹34,100 |
| 12-11 · PRD-31 | Scrap from WO-55 | +45 kg | 45 kg (not valued) |
| 18-11 · ISS-207 | Issue to WO-58 | −450 kg @ ₹62 | 500 kg · ₹31,000 |
| 20-11 · ISS-211 | Issue to WO-60 | −150 kg @ ₹62 | 350 kg · ₹21,700 · REORDER |
| 25-11 · INV-3305 | Sale of brackets, Customer B | −800 pcs @ ₹31 | 300 pcs · ₹9,300 |
| 30-11 · ADJ-03 | Count adjustment, MS sheet | −10 kg @ ₹62 | 340 kg · ₹21,080 |
The average rate. After the GRN, 1,500 kg is worth ₹93,000, or ₹62/kg. Every issue uses ₹62 until the next receipt. The ₹31 bracket rate is material cost only.
The reorder flag. On 20 Nov the balance falls to 350 kg, below the 400 kg reorder level. The flag turns to REORDER.
Month-end stock statement from the same rows
A stock statement is the monthly summary per item: opening, received, issued and closing stock. Banks often ask for it. The download's Monthly summary sheet builds it with SUMIFS on Qty in and Qty out, with adjustments in their own column.
For MS sheet in November: 500 kg opening, 1,050 kg in, 1,200 kg out, 10 kg adjusted, 340 kg closing. That is how to make a stock report in Excel.
Common mistakes in a stock register
- Mixing units: kg in, pieces out.
- No document number on the row.
- Netting in and out in one row instead of two.
- Overwriting cells, which breaks Rule 56(8).
- Posting floor issues only at month-end.
- Skipping small movements: scrap, floor returns, free samples, damage.
- Treating job work as sold. It is still your stock.
- Never counting the shelf.
When an Excel stock register stops working
Excel works for one store keeper and a few hundred rows a month. It breaks when several people share the file and every GRN is typed twice.
| What you need | Paper or Excel register | What to check in software |
|---|---|---|
| Several people entering at once | Copies clash | Many users, one live balance |
| Edit log (Rule 56(8)) | Not kept by itself | A log of edits and deletions |
| Link to purchase and production | Typed again by hand | Stock moves with the GRN, issue and dispatch |
Where TranZact fills the stock register for you
TranZact AI is manufacturing AI software. Its inventory module covers the register's jobs: stock in, bin card, issue, multi-store, reorder and AI stock alerts.
Grow includes inventory ageing and valuation, and Scale+ adds batch-wise stock tracking. See pricing. Accounting stays in Tally, with a one-way sync and no double entry.
TranZact also integrates with Busy, Zoho Books and Excel / Google Sheets. 10,000+ manufacturers run on it, and it goes live in 2–3 weeks.
Two honest limits: TranZact does not replace your accounting software, and your CA still decides your valuation method.
Download the free format and fill it for one month. When you're ready to stop typing it twice, see TranZact with your own items.
Don't be the bottleneck. Become the AI-Run Factory.