Steel Reconciliation format in excel for construction project

 Introduction

Steel reconciliation is an important activity in construction work. It means checking and comparing the steel received at site with the steel actually used in the work.
The theoretical steel quantity as per drawings or BBS is compared with the actual steel issued diameter-wise to verify consumption and ensure accurate billing & control the wastage of steel. I hope this is help for billing engineer, site engineer, Quantity surveyor.


What is the Steel reconciliation ?

Steel Reconciliation is the process of checking and comparing the theoretical steel quantity with the actual steel used at the construction site.
We compare
Theoretical quantity → Steel required as per drawings / BBS (Bar Bending Schedule)
Actual quantity → Steel issued from the store and used at site
Both quantities are compared diameter wise to find wastage, shortage, or excess consumption. This is help to us control the wastage of steel.
Download steel reconciliation format in excel



Steel Reconciliation format in excel

Step for Steel Reconciliation

Collect the following document.
Theoretical quantity as design / BBS in your R.A Bill quantity.
Joint measurement quantity ( JMR )
Extra steel work quantity
work in progress quantity
If any making of steel quantity available at site.
Any other steel miscellaneous work quantity as client demand.
Actual received quantity from client / store inventory.
Check that all quantities are measured in the same unit (such as kg, ton, or meter)

Basic rules of steel reconciliation

Use the same unit for all steel (kg or ton).
Take steel quantity as per drawing or BBS.
Add permissible wastage + - 2%
Check actual steel issued from store.
Compare theoretical steel with actual steel.
Find difference (extra use or wastage).

 R.A Bill Theoretical quantity
Download steel reconciliation format in excel

Ra Bill

Work in progress quantity  ( Un-Billed )

Download steel reconciliation format in excel
un billed

Actual received quantity from client / store 
Download steel reconciliation format in excel

Steel record



Steel Reconciliation format in Excel

Download steel reconciliation format in excel

COMPANY NAME ONSITE XL

Steel Reconciliation

 

Project :- SUN TOWER GREATER NOIDA

Date :- 11-05-2022

Remarks

Sr. No.

Description

UOM

Qty in MT

A

Total Received Qty

M.T

385.162

Quantity Given By Site Store

B

Bill Quantity

M.T

292.691

Billed Quantity of Ganesh, Hasibul and Satendra

 

NTA Dowells, B/W, Balcony Dowells (unbilled)

M.T

7.200

 

 

WPR (Approx.)

M.T

17.729

Phase 2 upper basement un Bill Quantity

 

Cutting & Making

M.T

4.000

 

 

Column Dowells  (Approx.)

M.T

0.600

 

 

Scrap Sale

M.T

0.000

 

 

Scrap Tentative

M.T

1.756

 

 

Scrap (With length more than 600 mm and useable in balcony, slab top, beams, B/W etc. (Approx.)

M.T

0.800

 

 

Column starter & in column shuttering (in place of tie rods)

M.T

0.450

Also use in Retaining wall Kanda

 

Cutout close  (Approx.)

M.T

0.180

 

 

Loose steel in office/labour colony/ contractor office/ Miscellaneous use  (Approx.)

M.T

0.100

 

 

Site To Site Transfer steel quantity

M.T

0.749

( Transfer steel to other site  )

 

Sorcreting nails steel Quantity

M.T

 

 

 

Total Theoretical quantity

 

326.255

 

 

 

 

 

 

C

Physical at site (Approx.)

M.T

48.100

 

 

 

 

 

 

 

Wastage = (A -B - C ) IN M.T

M.T

10.808

<==Difference

 

Wastage in Percentage

 

2.81%

 

 

Permissible wastage as GCC cluase 38 +- 2%

M.T

2%

Recovery only Final bill

 

Recovery of wastage 2.81% -2% = .81%

M.T

0.81%

Recovery of steel average Rate

 

Difference==> in M.T

M.T

2.630

 

 

 

 

Reconciliation of steel till Date 11-05-2022

Note:

1. Scrap Reinforcement bar above 600 mm will be used in slab top, beam extra etc.

 

2. Right now we are using loose steel/ scrap reinforcement for B/W beam extra, slab top etc.

 

3.Total steel received and executed Variance is due to site internal transfer in need.



Download steel reconciliation format in excel


Steel Reconciliation format in excel



Conclusion


Steel reconciliation is an important process in construction work. It helps to compare theoretical steel quantity with the actual steel used at site. This ensures proper material control, identifies wastage or excess consumption, and supports accurate billing and quantity verification


Post a Comment

0 Comments