A simple stock register you can start using today
A stock register (also called a stock ledger or stock movement register) is the running record of what you hold: how much came in, how much went out, and what is left. This free Excel template gives you exactly that in a clean, ready-to-use sheet — no formatting to build, no formulas to write. Enter your items and their opening quantities, log each goods receipt and each issue, and the Balance column keeps the closing figure right on its own.
It suits a small manufacturer's raw-material or finished-goods store, a distributor's warehouse, a spare-parts counter, a workshop or any office that needs to know its stock without buying software first. It is a genuinely useful starting point — and when your store outgrows a spreadsheet, the same columns carry straight into Fast Inventory with no retyping.
Ungated download. No email, no sign-up. Opens in Excel, Google Sheets, LibreOffice Calc and WPS Office. Auto-calculating balance and a marked sample row included.
This is a standard, non-proprietary business format — free to use, edit and share inside your business. The one sample row is clearly marked; delete it before you start.
What is inside the template
Eleven columns, laid out for a real stock ledger. The header is bold and frozen so it stays visible as you scroll, and the goods-in and goods-out groups each carry their own date, quantity and reference.
| Column | What it holds |
|---|---|
| Item Code | Your unique code for the item (SKU / part number). Keeps each item distinct even if names are similar. |
| Item Name | Plain description of the item so anyone reading the register knows what it is. |
| Unit | Unit of measure — Nos, Kg, Ltr, Mtr, Box — so quantities are never ambiguous. |
| Opening Qty | The quantity in hand when you start the register (or at the start of the period). |
| In — Date, Qty, GRN No | Every goods receipt: the date, quantity received, and the goods receipt note (GRN) number for traceability. |
| Out — Date, Qty, Ref | Every issue or sale: the date, quantity out, and a reference (issue slip, invoice or job number). |
| Balance | A formula, not typed — Opening + In − Out. Updates itself as you add rows. |
| Reorder Level | The stock point that should trigger a purchase. Watch any item whose balance falls to or below it. |
| Location | Where the stock physically sits — store, rack, bin or godown. |
| Remarks | Free notes — supplier, batch, damage, or anything worth recording against the line. |
How to use it — in four steps
- 1. Download and open. Open the file in Excel, Google Sheets or LibreOffice Calc, then delete the marked sample row.
- 2. Enter each item. Fill Item Code, Item Name, Unit, Opening Qty, Reorder Level and Location.
- 3. Record movements. On a receipt, fill the In columns (Date, Qty, GRN No); on an issue or sale, fill the Out columns (Date, Qty, Ref).
- 4. Read the balance. The Balance column updates itself — do not type over it. Act when an item's balance reaches its reorder level.
To learn the ideas behind it in plain language, see our guides on what a stock ledger is, reorder point and min-max levels and physical stock taking and cycle counting.
Where a spreadsheet stops
A stock register in Excel is a fine place to begin, and for a single small store it may be all you need for a while. But every spreadsheet hits the same walls as your business grows — and it is worth knowing them before they cost you.
Want this automatic instead of a spreadsheet?
When the register above starts to creak, Fast Inventory does the same job automatically — and far more. The columns you already keep map straight across, so moving over is a data import, not a fresh start.
An automatic, immutable ledger
Every goods receipt (GRN), issue, return, transfer and adjustment writes a tamper-evident ledger row on its own — no overtyping, and a full history you can trace forward and backward.
Reorder alerts, not eyeballing
Each item carries a minimum (reorder point) and maximum level, and a reorder dashboard flags anything at or below minimum, so lines never starve and cash is not stuck on the shelf.
Lot, batch, expiry & FEFO
Track batches with production and expiry dates and issue nearest-expiry-first — the control pharma, food, chemical and dairy stores need and a spreadsheet cannot give.
Multi-store & multi-user
Separate valued stock across as many stores as you run, with several users working at once — one accurate picture, not drifting spreadsheet copies.
Keeps your Tally & imports your sheet
Integrates with the systems you already run, including Tally, and imports your existing stock sheet so day-one reports are correct — no retyping.
On-site India support
Built in Pune (Nigdi) by Improsys; the same team sets it up, imports your opening balances and trains your storekeepers — hands-on, in your time zone, cloud or on-premise.
Best for Indian manufacturing and distribution SMEs that have outgrown a stock-register spreadsheet and want an automatic ledger, reorder alerts and batch depth — with on-site support at an affordable, scoped price.
Proof, without the marketing
Fast Inventory is a Fast Technology product, built in Pune (Nigdi) by Improsys — a company whose name is short for “improvement in systems,” which began as a systems-improvement consultancy for SME manufacturers across Pune and Maharashtra. It is one of 12 products on a single shared platform, and Improsys carries ISO 9001:2015, ISO 27001:2013 and CMMI Level 5. The same stock engine serves manufacturing, chemical, food and beverage, pharma, dairy, spare-parts and 3PL / warehousing operations across India and worldwide, cloud and on-premise. Pricing is scoped for Indian SMEs — per user, per store, or a flat fee — with an itemised written quote within 48 hours of a scoping call.