Stock Register Format

Your stock register should be able to answer one question at any moment: how many of this item should be on the shelf right now, and how did we get to that number? The stock register format below does that with one sheet per item, a line for every receipt and issue, and a running balance. A valued version adds rates so you know what the stock is worth, which is what your accountant needs for closing stock and cost of goods sold.

We will walk through the columns, a fully worked example using weighted average cost, how to set it up in Excel, the record-keeping angle under GST, and the mistakes that make registers disagree with the physical count.

What a stock register records

A stock register (also called a stock book, stock ledger or bin card when kept at the shelf) records every movement of a stock item:

• Receipts: purchases recorded on a goods received note, customer returns, transfers in, production output.
• Issues: sales, issues to production or departments, returns to suppliers, transfers out.
• Adjustments: damage, expiry, theft and count differences.

Each movement references a source document, so the register can be checked against your purchase register for supplier bills and your sales register for invoices.

Stock register format: columns

Header (one per item): item name, item code, unit of measure, location or bin, minimum and reorder level, valuation method.

Column	What goes in it
Date	Date of movement
Reference	GRN, invoice, issue slip, return note or adjustment number
Particulars	Supplier, customer, department or reason
Received: qty, rate, amount	Quantities coming in, at cost
Issued: qty, rate, amount	Quantities going out, at cost (not selling price)
Balance: qty, rate, amount	Running stock after the entry
Initials	Who made the entry

For a quantity-only register, drop the rate and amount columns. That is often enough for a small shop or a store room, with values worked out at year end.

Stock register example with weighted average cost

Item: A4 copier paper 80gsm, code PAP-A4-80, unit ream, valuation method weighted average. November 2026.

Date	Ref	Particulars	In qty	In rate	In amt	Out qty	Out rate	Out amt	Bal qty	Bal amt	Avg rate
01-11		Opening balance							120	480.00	4.00
03-11	GRN-0311	Northgate Supplies	80	4.25	340.00				200	820.00	4.10
05-11	ISS-091	Issued to admin office				50	4.10	205.00	150	615.00	4.10
12-11	INV-1046	Sale to Kessler Interiors				60	4.10	246.00	90	369.00	4.10
20-11	GRN-0327	Northgate Supplies	110	4.60	506.00				200	875.00	4.375
25-11	ISS-097	Issued to warehouse				40	4.375	175.00	160	700.00	4.375

How the averages work:

• After the 3 Nov receipt: 480.00 + 340.00 = 820.00 for 120 + 80 = 200 reams, so 820.00 / 200 = 4.10 per ream.
• Issues on 5 and 12 Nov go out at 4.10: 50 x 4.10 = 205.00 and 60 x 4.10 = 246.00.
• After the 20 Nov receipt: 369.00 + 506.00 = 875.00 for 90 + 110 = 200 reams, so 875.00 / 200 = 4.375.
• Closing: 160 reams worth 700.00 (160 x 4.375).

Note the sale on 12 November is recorded at cost (4.10), not at the selling price on the invoice. The cost figure feeds cost of goods sold; the selling price belongs in the sales register. If you use FIFO instead of weighted average, issues are costed from the oldest batch first; our guide to FIFO, LIFO and weighted average compares the methods.

How to keep a stock register step by step

1. Create one sheet per item with the header details and opening balance from a physical count.
2. Post receipts only from accepted quantities on GRNs, not from supplier invoices.
3. Post issues from issue slips, delivery notes or invoices, on the day goods leave.
4. Post returns both ways: customer returns as receipts, returns to suppliers as issues.
5. Recalculate the balance after each line.
6. Count and reconcile periodically; record differences as adjustments with a reason and approval.
7. Review reorder levels when the balance drops below the minimum.

Reconciling the register with a physical count

A stock register is a claim about what should be on the shelf. The physical count tests that claim. Using the paper example, the register shows 160 reams worth 700.00 at 30 November. Suppose the count finds 154 reams.

1. Recount first. Have a second person count the item. Many differences are counting errors, such as a carton of five reams counted as one.
2. Check cut-off. Was a delivery received on 30 November but not yet posted? Was an issue made but the slip not handed in? Here, an issue slip for 6 reams to the reception desk on 28 November turns up in a drawer.
3. Post the missing entry with its real date: 6 reams out at 4.375 = 26.25. The balance becomes 154 reams worth 673.75, which agrees with the count.
4. If no explanation is found, post a stock adjustment with a reason ("count difference, unexplained"), approved by a manager. Track these adjustments over time; repeated losses on the same items point to theft, damage or a process gap.

Count values flow into your accounts. Closing stock reduces cost of goods sold, so an overstated register overstates profit. That is why accountants ask for count sheets and the register at year end, and why an inventory turnover ratio calculated from a wrong register gives misleading answers.

Bin cards vs central stock register

A bin card is a small record kept at the shelf, showing quantities only, updated by the storekeeper each time stock moves. The central stock register is kept by accounts or the inventory system and includes values. Comparing the two is a quick internal check: if the bin card says 154 and the register says 160, something has not been posted. Small businesses can combine them, but businesses with a separate store and accounts function benefit from keeping both.

Stock register in Excel

A stock register format in Excel is easiest as a single transaction table rather than one tab per item: columns for date, item code, reference, type (In/Out/Adj), quantity, rate and amount. Then:

• Current quantity per item: SUMIFS on quantity where type is In, minus the same for Out.
• Running balance per item: sort by item and date, and use a formula that resets when the item code changes.
• A pivot table by item gives a stock summary for any date.

Our inventory management spreadsheet guide shows a fuller setup with reorder alerts. Once you have hundreds of items or several locations, inventory software usually becomes worth it.

Stock register formats by business type

• Retail shop: quantity-only registers for fast movers are common, with a full valuation at year end using purchase invoices. Track sizes and colours as separate items.
• Manufacturer: keep separate registers for raw materials, work in progress and finished goods. Issues to production move cost from raw materials into work in progress.
• Restaurant or cafe: a weekly count of key ingredients against purchases often replaces a line-by-line register, but high-value items such as meat and beverages deserve a proper register.
• Service business with spares: a technician's van stock register, with issues linked to job sheets, shows which parts were used on which job and should be billed.

Stock register under GST and tax rules

In India, GST law requires registered persons to maintain accounts of stock of goods. The CGST Rules (Rule 56) describe records such as opening balance, receipt, supply, goods lost, stolen, destroyed, written off or disposed of as gifts or free samples, and the balance of stock; you can read the text in the CGST Rules published by CBIC, and check for later amendments. Manufacturers usually also track raw materials, work in progress and finished goods separately.

Elsewhere, tax authorities generally expect you to support closing stock figures in your accounts. In the US, IRS Publication 583 covers keeping business records. This section is general information, not tax or legal advice; confirm the requirements that apply to your business.

Common mistakes

• Posting from supplier invoices instead of GRNs, so short deliveries inflate stock.
• Using selling price for issues, which overstates cost of sales.
• Mixing units, such as boxes on receipt and pieces on issue.
• Silent corrections instead of documented adjustments.
• Forgetting free samples, damage and internal use, which then show up as unexplained shortages at the count.
• No opening count, so the register starts from a guess.

Every sale in your stock register should point to an invoice. If you need clean, numbered invoices to reference, create them in our free invoice generator, with no sign-up, and save each one as a PDF for your records.