Your billing software says you have 820 bags of cement, 2.8 tonnes of 12 mm sariya and 7 brass of sand. The yard may say something else. Physical stock verification is how you find out, and how you find out early, before a small gap becomes a large loss.
A building material yard is harder to count than a normal shop. Steel is counted in bars but valued in kg. Sand sits in heaps that change shape every day. Hardware runs into thousands of small items. This guide gives a practical method for each, with a worked reconciliation at the end.
Why stock in the yard and stock in the books drift apart
Before counting, know what you are looking for. Common causes of a stock mismatch:
- Billing errors. Wrong item, wrong size or wrong unit selected on a bill. Selling 12 mm but billing 10 mm leaves both sizes wrong.
- Unrecorded damage. Torn cement bags, rusted or bent bars, broken tiles that were thrown away without an entry.
- Weight differences. Steel billed on theoretical weight but bought on weighbridge weight, or the other way round.
- Volume loss. Sand and gitti settle, get washed away by rain or spread during loading.
- Deliveries without bills. Material sent to a site on a phone call, with the bill "to be made later".
- Theft and leakage. Uncomfortable, but real. See our guide on preventing theft in the shop.
A good audit finds the cause, not just the gap.
Full count vs cycle counting
Full stock count: everything counted on one day, often at year-end. Accurate but disruptive; dispatch may stop for a few hours.
Cycle counting: a few categories counted every week, so every item is covered over a month or a quarter. Less disruptive, and errors are caught sooner.
Many yards combine the two: a weekly cycle count of high-value, fast-moving items, and a full count once or twice a year.
| Category | Suggested frequency | Why |
|---|---|---|
| Cement | Weekly | High value, fast moving, damage-prone |
| TMT / steel | Weekly or fortnightly | High value per unit |
| Sand, gitti | Monthly | Hard to measure, volume loss |
| Fast hardware items | Monthly | Many SKUs, small theft risk |
| Slow hardware, fittings | Quarterly | Low movement |
These are suggestions; set frequencies by your own sales value and loss history.
Counting cement
Cement is the easiest to count but the easiest to lose track of.
- Freeze movement for the stack being counted, or count before opening and after closing.
- Count by stack. Multiply bags per layer by the number of layers, then check the top layer separately if incomplete.
- Count each brand and grade separately. OPC 43, OPC 53 and PPC are different items.
- Count torn bags separately and move them to a damaged location in your records.
- Note manufacture dates. Cement is best used within about three months of manufacture. Old lots found during the count should be sold first.
Counting steel: bars, bundles and weight
Steel is counted by size and converted to weight using the IS 1786 nominal weights, which are close to the formula kg per metre = d² ÷ 162 (d in mm).
| Size | kg per metre | kg per 12 m bar |
|---|---|---|
| 8 mm | 0.395 | 4.74 |
| 10 mm | 0.617 | 7.40 |
| 12 mm | 0.888 | 10.656 |
| 16 mm | 1.58 | 18.96 |
| 20 mm | 2.47 | 29.64 |
| 25 mm | 3.85 | 46.20 |
| 32 mm | 6.31 | 75.72 |
How to count:
- Count bars by size, keeping full-length bars and cut pieces apart.
- Convert to kg with the table. For example, 260 bars of 12 mm × 10.656 kg = 2,770.6 kg.
- Weigh cut pieces if you have a scale, rather than estimating.
- If you buy on weighbridge weight and sell on theoretical weight, expect some difference between book and calculated weight. Track it as a separate line so it does not hide other losses.
Size-wise stock in your records (8 mm to 32 mm as separate items) makes this count fast; a single "TMT" item makes it nearly impossible.
Measuring sand and gitti heaps
Sand and aggregate are counted by volume. 1 brass = 100 cubic feet (CFT), and 1 cubic metre ≈ 35.31 CFT.
Cone-shaped heap
For a roughly conical heap: volume = π × r² × h ÷ 3.
Example: radius 10 ft, height 6 ft. Volume = 3.1416 × 100 × 6 ÷ 3 = 628.3 CFT ≈ 6.28 brass.
Long heap with sloping sides
For a heap shaped like a long ridge with a flat top, use the prismoid formula: volume = h ÷ 6 × (bottom area + 4 × middle area + top area).
Example: bottom 30 ft × 12 ft, top 20 ft × 4 ft, height 5 ft. The middle section is 25 ft × 8 ft.
- Bottom area = 360 sq ft
- Middle area = 200 sq ft
- Top area = 80 sq ft
- Volume = 5 ÷ 6 × (360 + 800 + 80) = 1,033.3 CFT ≈ 10.33 brass
Heaps are rarely perfect shapes, so treat this as an estimate. Measure at several points, average, and use the same method every month so changes are meaningful. If you sell in brass but buy by the tonne or truck, multi-unit billing keeps both units on one item.
Counting hardware without losing a week
Hardware has the most items and the smallest values. Make it manageable:
- Count one rack or category at a time, using a printed or on-screen list from your software in rack order.
- Two-person method: one counts, one records. Swap roles for a second check on high-value items.
- Count in the unit you sell in. If you buy screws by box but sell by piece, decide which unit you count in and stick to it.
- Use barcode scanning where items are labelled, to avoid picking the wrong item name.
Physical stock verification: reconciling with the books
Once counted, compare with book stock on the same date and time.
Worked example: monthly reconciliation
Example figures only.
| Item | Book stock | Physical | Difference | % |
|---|---|---|---|---|
| Cement OPC 43 (bags) | 820 | 806 | −14 | −1.71% |
| TMT 12 mm (kg) | 2,800 | 2,770.6 | −29.4 | −1.05% |
| Sand (brass) | 7.00 | 6.28 | −0.72 | −10.29% |
Reading this:
- Cement, −14 bags. Check unbilled deliveries and torn bags first. Fourteen bags at an example cost of ₹320 is ₹4,480 before GST.
- Steel, −29.4 kg. About 1%. Check whether purchases were booked on weighbridge weight while sales went out on theoretical weight.
- Sand, −10%. A big percentage, but heap measurement is imprecise. Re-measure, check for rain loss, and compare with truck-wise sales records before drawing conclusions.
Steps after reconciliation
- Investigate before adjusting. Look at the last few days' bills, challans and purchase entries for the items with gaps.
- Correct genuine errors at source, such as a wrong-size bill, rather than with a blanket adjustment.
- Post a stock adjustment only for the unexplained balance, with a reason noted.
- Talk to your CA about write-offs. Under GST, input tax credit is not available on goods lost, stolen, destroyed or written off, so credit claimed on such stock may need to be reversed.
- Track the trend. A 1% gap every month is a pattern; a one-time gap may be an error.
GST rates and rules change; check the latest CBIC notification or ask your CA before filing.
Making audits easier with software
Audits are only as good as your records. MaterialBill keeps size-wise stock for steel, item-wise stock with a history of every purchase, sale and adjustment, multi-unit billing so tonnes, kg and bars stay consistent, and low-stock alerts. Barcode billing reduces wrong-item errors at the counter, which is where many mismatches begin. For yard layout and godown practices, see godown management.
Frequently asked questions
How often should a building material yard do a physical stock count?
A common approach is weekly cycle counts for cement and steel, monthly for sand and fast hardware, and a full count once or twice a year. Adjust based on your stock value and losses.
What is an acceptable stock difference?
There is no fixed rule. Track your own gap item by item over several months. Sudden jumps matter more than one month's figure.
How do I measure a sand heap accurately?
Use the cone formula for round heaps and the prismoid formula for long heaps, measured at several points. It is an estimate, so use the same method every time.
Should I adjust stock immediately after a count?
Investigate first. Correct billing and entry errors at source, then adjust only the unexplained balance with a written reason.
Does writing off missing stock affect GST?
Yes. ITC is not available on goods lost, stolen, destroyed or written off, so credit already claimed may need to be reversed. Ask your CA how to report it.
A regular stock audit turns a vague worry into specific, fixable problems. If you want size-wise stock that is easy to count against, you can start free with MaterialBill and run your first cycle count on cement and steel.