Free Excel template · Inventory

Stock Register Format for Manufacturers (Free Excel)

A free stock register format in Excel for manufacturers. It has 12 columns for raw material, finished goods and scrap, each one explained, plus a filled November example and the GST Rule 56 basics.

Download the Excel template

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.

ColumnWhat to writeExample
1. DateDay the goods moved03-11-2026
2. Doc no.GRN, issue slip, challan or invoice numberGRN-1042
3. MovementOpening, purchase in, issue, floor return, output, scrap, sale, job work out or in, adjustmentPurchase in
4. CategoryRM, WIP, FG or ScrapRM
5. Item (unit)Code and name with size, then its one fixed unitRM-001 MS sheet 2 mm (kg)
6. Store · party / WOStore, 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 inQuantity received1,000
8. Qty outQuantity issued, sold or written off(blank)
9. Balance qtyLast balance + in − out, per item and store1,500
10. Rate (₹)Purchase rate on receipts; average rate on issues₹63
11. Value (₹)Last value + value in − value out₹93,000
12. Flag / remarksREORDER at or below the reorder level; reason for returns or adjustmentsNew 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.

  1. Set up the item master. One code, unit and reorder level per item.
  2. Enter opening stock from a shelf count. Our opening stock guide has more.
  3. 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.
  4. Never overwrite. Add a correction row with a remark.
  5. 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.

Book a demo →

Worked example: a small fabrication unit, November 2026

The unit cuts MS sheet into mounting brackets. All numbers are illustrative.

Date · DocMovementIn / outBalance after
01-11 · OB/NOVOpening stock, MS sheet 2 mm+500 kg @ ₹60500 kg · ₹30,000
03-11 · GRN-1042Purchase in, Supplier A+1,000 kg @ ₹631,500 kg · ₹93,000
06-11 · ISS-201Issue to work order WO-55−600 kg @ ₹62900 kg · ₹55,800
10-11 · RET-14Return from floor, WO-55+50 kg @ ₹62950 kg · ₹58,900
12-11 · PRD-31Production output, bracket MB-2+1,100 pcs @ ₹311,100 pcs · ₹34,100
12-11 · PRD-31Scrap from WO-55+45 kg45 kg (not valued)
18-11 · ISS-207Issue to WO-58−450 kg @ ₹62500 kg · ₹31,000
20-11 · ISS-211Issue to WO-60−150 kg @ ₹62350 kg · ₹21,700 · REORDER
25-11 · INV-3305Sale of brackets, Customer B−800 pcs @ ₹31300 pcs · ₹9,300
30-11 · ADJ-03Count adjustment, MS sheet−10 kg @ ₹62340 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 needPaper or Excel registerWhat to check in software
Several people entering at onceCopies clashMany users, one live balance
Edit log (Rule 56(8))Not kept by itselfA log of edits and deletions
Link to purchase and productionTyped again by handStock 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.

Book a demo →

Frequently asked questions

Should raw material and finished goods be in the same stock register?

They can share one register: add a Category column and filter by it. Larger stores often keep a separate sheet per category with the same columns.

How do I record material sent to a job worker?

Post it as 'Job work out' against the job work challan and move it to an 'At job worker' location. Don't treat it as sold. When it comes back, post 'Job work in'.

Which rate should I use for issues: purchase rate or average?

Pick one method and stick to it. The example uses weighted average: total value ÷ total quantity after each receipt. Confirm the method with your CA.

How often should I match the register with a physical count?

At least monthly for fast-moving raw material. Post any difference as an adjustment row with a reason, never by overwriting the balance.

Can I keep the stock register in Excel for GST?

Yes. Rule 56(8) says electronic records must keep a log of every edit or deletion, and a shared Excel file doesn't do that by itself. That gap is a common reason factories move the register into software.

Can I bring my existing Excel stock register into TranZact?

TranZact integrates with Excel / Google Sheets. Book a demo with your current register in hand to see TranZact with your own items.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.