Material Stock Register Format in Excel for Construction Sites (Free Download)
Every site keeps a stock register. On most sites it is a long notebook in the store room with cement on one page, steel on another, and a balance column that was last correct some time in the second week. When the owner asks how many bags of cement are on site, the storekeeper goes and counts.
A stock register is supposed to answer that question without anyone walking to the store. This guide gives you a free Excel format that keeps a running balance on its own, shows how to fill it, and explains the handful of habits that decide whether the numbers can be trusted.
Two sheets: an item list with automatic received, issued and balance quantities, and an entry sheet for every receipt and issue. Low stock is flagged for reorder. No sign-up needed.
What a material stock register is
A material stock register records three things for every material on site: how much came in, how much went out, and how much should be left. The third number is the point of the whole exercise. If the register says 120 bags and the store has 95, you have found a 25 bag problem on the day it happened, not at the final audit.
The format: two sheets, not one
The usual mistake is to keep one page per material with receipts and issues mixed into a running balance typed by hand. One wrong subtraction and every balance after it is wrong. The format here separates the two jobs.
Sheet 1: Items
| Column | What goes in it |
|---|---|
| Code | A short code for each material, such as M01 for cement |
| Material and unit | Cement OPC 53 in bags, TMT 12 mm in kg, sand in cum |
| Opening stock | Physical count on the day you start the register |
| Total received, total issued | Added up from the entry sheet, automatic |
| Balance | Opening + received – issued, automatic |
| Minimum level | The quantity below which you must reorder |
| Status | Shows OK, REORDER, or CHECK ENTRIES if the balance has gone negative |
Sheet 2: Entries
One row for every receipt and every issue, in the order they happen.
| Column | What goes in it |
|---|---|
| Date | Date of receipt or issue |
| Code | Picked from a dropdown of your item codes. The material name and unit fill in on their own. |
| Type | Received or Issued |
| Qty | Quantity in the item’s unit |
| Supplier / issued to | Vendor name for a receipt, contractor or mistri name for an issue |
| Challan / gate pass no. | The paper that proves the entry |
| Used where | Activity and floor, for example “slab shuttering, 3rd floor” |
| Entered by / remarks | Who made the entry |
A simple example
Stop juggling WhatsApp groups, Excel sheets, and paper registers
Trackovo runs every part of your construction site in one app — materials, attendance, finance, vendor payments. 14-day free trial. No card needed.
Start your free trial →You start the register with 10 bags of cement in the store and set the minimum level at 20 bags.
- A truck delivers 100 bags. Entry: M01, Received, 100, challan number.
- Over the week 95 bags are issued for slab work. Entry: M01, Issued, 95, used where.
- The Items sheet now shows received 100, issued 95, balance 15.
- 15 is below the minimum of 20, so the status turns to REORDER.
Nobody subtracted anything by hand, and the reorder warning appeared before the store ran dry.
Six habits that keep the register honest
- Enter the receipt before the truck leaves. Count, check against the challan, then enter. A receipt entered from the bill three days later records what was billed, not what arrived.
- No issue without a name and a place. “Issued 20 bags” is useless. “Issued 20 bags to Suresh for 3rd floor slab” can be checked against the work done.
- Never edit an old row. If an entry was wrong, add a correcting row and say why. A register where old rows change is a register nobody will believe.
- Count physically once a week. Pick five materials every Saturday, count them, and compare with the balance. Write the difference down even when it is zero.
- Treat a negative balance as an alarm. If the sheet shows CHECK ENTRIES, a receipt was missed or an issue was entered twice. Find it the same day.
- Keep the storekeeper and the checker separate. The person who issues material should not be the only person who counts it.
Where Excel runs out
For a single store on a single site this format is enough. It struggles in three situations.
- Material moves between sites. A transfer is an issue in one file and a receipt in another, and the two rarely get entered on the same day.
- Entries need proof. A challan number in a cell is not the same as a photo of the challan and the unloaded truck.
- The office needs today’s balance. A file on the storekeeper’s phone does not help a purchase manager deciding what to order this afternoon.
This is what Trackovo’s material management is built for: requests, approvals, receipts with photos, issues against a person and a place, and store and site balances that the office can see at any time. For the wider problem of material going missing, read our field guide on how to stop material theft on construction sites.
Common questions
What is the difference between a stock register and a material reconciliation?
The stock register tells you what should be in the store. Reconciliation compares what was issued with what the completed work should have consumed. You need the register first. Without it there is nothing to reconcile.
How many materials can the template hold?
Forty items and three hundred entries as downloaded. To add more, copy the last row down. The formulas copy with it.
Should steel be tracked in kg or in number of bars?
In kg, because that is how it is bought and billed. If the site issues by bars, note the bar count in the remarks column and enter the weight as the quantity.
Can several people fill it at once?
Yes, if you upload it to Google Drive and open it in Google Sheets. Keep one person responsible for each store, even when several people can open the file.
More free formats: DPR, BOQ and labour attendance templates.
Ready to stop the WhatsApp chaos? Try Trackovo free for 14 days.
Start free trial →