Stock register format, free in Excel and Sheets
A stock register format that balances daily: opening, inward, outward, closing, location — free in Excel and Google Sheets, sample and blank included.
The files, first
Free, no forms: a stock register template with a filled sample — a week of realistic godown movements — and a clean blank.
The columns are standard; the discipline notes beside them are where registers usually fail, so read those before deleting them.
What a stock register format must contain
Date — one line per item per day, not one line per movement- Item code and name — readable, under one naming authority, or the register forks into dialects
- Opening balance — carried forward, never re-entered
- Inward with its reference — purchase, return, transfer-in
- Outward with its reference — order number, challan number, transfer-out
- Closing balance — computed, never typed
- Location — the rack — a register that knows quantities but not places sends people hunting
- Remarks — the breakage, the sample given, the honest exits that otherwise surface later as discrepancies
The register's one law: closing = opening + inward − outward, balanced daily, per item. A register balanced weekly is a discrepancy diary; balanced daily, it is a control.
Stock register format in Excel
The Excel version computes the balances, carries closing to the next day's opening, and flags the line where the arithmetic breaks — which is exactly the line worth investigating.
Stock register in Google Sheets
The Sheets version opens as your own copy and lives in the browser — the same register readable from the counter, the godown and the owner's phone at once.
A version for your trade, free
Batch columns for tiles, shade and wattage for lighting, sheet counts for ply — tell us your trade and a fitted register arrives on your email and WhatsApp.
Where the format runs out
A register records what someone remembered to write; the godown does what the day demanded.
The gap between the two is where stock figures become folklore — and no register audits itself. Stock that moves as records — allotted, checked, dispatched — with counts that verify without shutting the godown, is the other way:
Take the register either way — and count one rack against it at a demo.
Ask for a demo