Home › Free formats › Stock Register Format

Stock Register Format (Free Download)

A simple stock register to record opening stock, stock received and stock sold for each item. The Excel version calculates closing stock for you.

Pick a design. Each one is free to download in PDF, Word and Excel, blank and ready for your details.

FREEStock Register Format, Classic design

Classic design

FREEStock Register Format, Bold design
FREEStock Register Format, Elegant design

Elegant design

See a filled-in example (Classic design)
Sharma Footwear & Garments
Shop 12, MG Road, Hyderabad, Telangana 500001 · +91 98765 43210
GSTIN: 36ABCDE1234F1Z5
STOCK REGISTER
Month: November 2026
Branch / Location: MG Road store
DateItem Name / CodeOpening StockReceived (In)Sold / Issued (Out)Closing StockRemarks
01/11School shoes, size 71224927
01/11Sports shoes, size 98035
02/11Slippers, size 83006242 damaged
Closing stock of one entry becomes the opening stock of the next entry for the same item.
Count physical stock at least once a month and note any difference in Remarks.
For Sharma Footwear & Garments


Checked By
Free format from runkarobar.com

How to use this stock register format

  1. Download the format in Excel, Word or PDF, in the design you like.
  2. Add your shop name, address and phone at the top. In Excel, the yellow cells are the ones to fill.
  3. Enter the date, item, opening stock, stock received and stock sold. In the Excel version, closing stock calculates automatically.
  4. Save, print or share it as a PDF on WhatsApp or email.

What to include in a stock register

Tip: make the closing stock of one entry the opening stock of the next entry for the same item. Count physical stock at least once a month and note any difference in Remarks. Items that haven't moved for 90 days are dead stock and worth clearing.

Skip the templates altogether

RunKarobar creates bills, tracks stock and manages staff from one app, with every total calculated for you. First month ₹1.

Start your ₹1 monthSee all features

Frequently asked questions

What is a stock register?

A stock register is a record of the goods a business holds, showing opening stock, goods received, goods sold or issued, and closing stock for each item.

How do I calculate closing stock?

Closing stock = opening stock + stock received − stock sold or issued. The Excel template does this automatically for each row.

How often should I update the stock register?

Ideally every day, or whenever stock comes in or goes out. At minimum, count and update it once a month.

Is a stock register the same as a dead stock register?

No. In India, a 'dead stock register' usually means a register of fixed assets like furniture and equipment. This template is for goods you buy and sell.

More free formats: Bill Format, GST Invoice Format, Cash Memo Format, Quotation Format.

These free formats are provided for convenience. Please check GST rates, tax rules and document details with your accountant before relying on them.