Skip to content

Steel Register and Steel Reconciliation Format

Steel receipts by diameter with a weighbridge check, issues against the bar bending schedule, and reconciliation by diameter.

  • Excel (.xlsx)
  • 6 sheets
  • Free
  • Updated

What is in the file

  • Instructions
  • Project Details
  • Receipts
  • Issues
  • Reconciliation
  • Filled Sample

What is a steel register in construction?

A steel register records reinforcement steel by diameter: every delivery with its weight, heat number and test certificate, every issue against the member and bar bending schedule it was cut for, and the balance in the yard. Reconciled against the bar bending schedule, it shows whether more steel was used than the work needed.

What is in the steel register workbook?

  • Project Details — project particulars, the period and the permissible variation in consumption from your contract.
  • Receipts — one row per diameter per delivery: grade, heat number, test certificate, bars, length, theoretical and weighbridge weight, and the mass check.
  • Issues — one row per issue slip by diameter, against the member and bar bending schedule.
  • Reconciliation — per diameter: opening, received, issued, book balance, physical count, the bar bending schedule requirement and the variation.
  • Filled Sample — four diameters through a month of receipts and issues.

How does the steel register sheet calculate?

  • Theoretical weight = number of bars × bar length (m) × d²/162 kg per metre, with d in mm.
  • Weighed vs theoretical = (weighbridge − theoretical) ÷ theoretical, checked against the tolerance for the diameter: ±7% up to 10 mm, ±5% over 10 up to 16 mm, ±3% over 16 mm — the batch tolerances in IS 1786:2008 Table 2, editable.
  • Stock is taken on the weighbridge weight; a delivery counted but not weighed uses the theoretical weight and is marked.
  • Book balance = opening + received − issued, per diameter, compared with the physical count.
  • Variation = (steel issued − steel required by the bar bending schedule) ÷ the requirement, judged against the permissible variation you enter.

Worked example from the sample sheet: 330 bars of 12 mm × 12 m should weigh 3,520 kg; the weighbridge gave 3,485 kg, 1.0% light and inside the 5% tolerance. The 8 mm delivery is 8.0% light, outside its 7% tolerance, so it is flagged. 900 kg of 8 mm was issued against 870 kg in the bar bending schedule — 3.4%, over the 3% allowance set for the sample.

How do you use the steel register template?

  1. Fill in Project Details, including the permissible variation in consumption from your contract.
  2. On Reconciliation, check the mass tolerances and enter the opening stock of each diameter.
  3. Enter each delivery on Receipts, one row per diameter, with the heat number, test certificate, bars, length and weighbridge weight.
  4. Book every issue on Issues against the member and bar bending schedule, with usable returns as a negative quantity.
  5. At the end of the period, enter the physical stock and the bar bending schedule requirement for the work done.
  6. Read the Check, Status and Stock Check columns.

What should you check before relying on the steel register?

  • Confirm the mass tolerances against the edition of IS 1786 your contract refers to.
  • No permissible variation is supplied; until you enter your contract's figure, the reconciliation says so instead of passing anything.
  • The bar bending schedule requirement must be for the work actually done in the period, not the whole job.
  • Weigh deliveries wherever possible. A delivery received by count is held at its theoretical weight until it is weighed.

What does each column mean?

ColumnWhat goes in it
Grade / Dia / Heat No. / Test Cert. Ref.What was delivered, and the heat number and manufacturer's test certificate that trace it.
No. of Bars / Length of BarThe bar count and length, where the delivery is counted.
Theoretical Weight (kg)Auto-calculated. Bars × length × d²/162, d in mm.
Weighbridge Weight (kg)The weighbridge figure for the diameter. Stock is taken on this weight.
Weighed vs Theoretical / ToleranceAuto-calculated. The difference as a percentage, against the tolerance for that diameter.
Check (receipts)Auto-calculated. OK, weighed with no bar count, received by count (theoretical weight used), or outside the mass tolerance.
Issues: Dia / Qty / Member / BBS Ref.Each issue in kg by diameter, against the member and the bar bending schedule it was cut for. Returns are negative.
Reconciliation: Opening / Received / Issued / Book BalanceAuto-calculated per diameter from the receipts and issues, with the opening stock you enter.
Physical Stock / DifferenceThe count at the end of the period, and its difference from the book balance.
Required as per BBS / Variation %The steel the bar bending schedule needs for the work done, and how far the issued steel differs from it, judged against your permissible variation.

Steel issued is reconciled against the steel the work needed, and that figure comes from the bar bending schedule for the members built. For cement, sand and the other materials, the material reconciliation statement does the same job.

Get the quantities from your drawings

These records only mean something against an accurate bill of the work. Upload your drawings and InstaBOQ produces the measured, itemised BOQ your consumption norms and reconciliations are checked against.

Questions

How do you calculate the theoretical weight of steel bars?

Weight per metre = d squared / 162 kg, with d in mm. Multiply it by the bar length and the number of bars. For example, 330 bars of 12 mm, each 12 m long, weigh 330 x 12 x 144 / 162 = 3,520 kg.

What is the permissible weight variation for TMT bars?

IS 1786:2008 Table 2 sets the tolerance on nominal mass for a batch at plus or minus 7% for bars up to 10 mm, 5% for bars over 10 mm up to 16 mm, and 3% for bars over 16 mm. Check the edition your contract refers to.

How is steel reconciliation done on a construction site?

For each diameter, compare the steel issued from the store, net of usable pieces returned, with the steel the bar bending schedule requires for the work done. The difference as a percentage of the requirement is checked against the variation the contract permits.

Should steel be received by weight or by number of bars?

By weighbridge weight wherever possible, with the bar count recorded too, so the weight can be checked against the theoretical weight. A delivery received only by count is taken at its theoretical weight until it is weighed.

Why record the heat number and test certificate?

They trace each lot of steel to the manufacturer's test certificate and to any samples you send for testing, so a bad result can be tied to the bars it came from and the members they went into.

Next in your work

Fill a BOQ item by item in your browser and export it to Excel. Free to start.