Home › Blog › Running the business › Stock Register Format for Shops

Stock Register Format for Shops: Columns, Example and GST Rules

Quick answer

A stock register records, item by item: date, particulars, bill or voucher number, inward quantity, outward quantity, balance quantity, rate, value and remarks. Under GST you must record opening stock, receipts, supplies, goods lost or written off, and closing stock.

Date Particulars In Out Balance
01-11 Opening — — 120
03-11 Purchase 200 — 320
04-11 Sale — 150 170
In this article
  1. Stock register format: columns
  2. What GST requires you to record
  3. Units: count the way you sell
  4. Godown-wise stock
  5. Check the register against physical stock
  6. Paper register vs billing software
  7. Frequently asked questions
  8. Let every bill update your stock automatically

A stock register is the record of every item that comes into and goes out of your shop or godown. It tells you what you should have on hand, so you can reorder on time, find shortages and give your CA correct closing stock. Under GST, a registered person must also keep accounts of stock (Section 35 and Rule 56).

Stock register format: columns

Date Particulars Voucher / bill no. Inward qty Outward qty Balance qty Rate Value Remarks
01-11-2026 Opening stock — — — 120 300 36,000
03-11-2026 Purchase, ABC Cement P-221 200 — 320 300 96,000
04-11-2026 Sale, Sharma Builders MB/0457 — 150 170 300 51,000
05-11-2026 Torn bags written off ADJ-07 — 4 166 300 49,800 Photo on file

Keep one register (or one page) per item: for example "Cement OPC 53, ABC brand, bag". Sizes and grades that sell separately, like 8 mm and 12 mm TMT, need separate pages.

What GST requires you to record

Written-off goods matter because input tax credit on them must be reversed; see damaged cement bags.

Units: count the way you sell

Choose one base unit per item for the register, and convert purchases and sales into it:

Godown-wise stock

If you have more than one godown, add a "Location" column or keep a register per godown. Record transfers between them with a delivery challan; see stock transfer between godowns.

Check the register against physical stock

Count cement and steel weekly and the rest monthly. Investigate differences before you post an adjustment. A full method is in physical stock verification.

Paper register vs billing software

A paper or Excel register only works if every bill and purchase is entered the same day. Billing software updates stock automatically with each bill, purchase and return, warns you on low stock and gives item-wise and godown-wise reports.

Frequently asked questions

Is a stock register mandatory under GST?

Yes. Registered persons must keep accounts of goods received, supplied, lost or written off, with opening and closing balances.

What is the format of a stock register?

Date, particulars, voucher number, inward quantity, outward quantity, balance, rate, value and remarks, maintained item-wise.

How long should I keep stock records?

At least 72 months from the due date of the annual return for that year.

Can I keep the stock register in an app?

Yes. Electronic records are allowed. MaterialBill keeps item-wise and godown-wise stock automatically.

Let every bill update your stock automatically

MaterialBill fills these fields for you: GSTIN, HSN, CGST/SGST or IGST split, invoice number series and total in words. Bills are shared on WhatsApp or printed on A4 or thermal paper.

Download the MaterialBill app from Google Play (free Android billing app) or start free on the web.

Looking for another material? See the full GST rate and HSN code list for building materials.

Related articles

Weighbridge Weight Difference Material Delivery Management for Building Material Shops Contractor and Mistri Commission Advance Booking for Cement and Steel Torn and Damaged Cement Bags Dealer Scheme Accounting All blog posts

Start Free Today

Set up in two minutes. No card required. Leave whenever you like — your data always stays yours.