In this guide 6 sections
Compare three numbers for every item on every site: issued from the store, installed according to the site log, and returned or scrapped. The gap is what is left over. For cable it usually sits in cut-length offcuts, for breakers in untracked spares, and for panels in transfers between sites that nobody recorded.
Why the gap hides for months
Material leaves the store on a gate pass or a handwritten slip that says 500 metres of 4 core armoured cable, and the foreman signs it. The drum goes to site. The paper goes into a file.
Nobody compares that slip with what the crew actually pulled. The installed quantity lives in a daily progress sheet, a measurement book or a client billing sheet. Each is kept by a different person who never sees the others.
The gap appears at handover. The client’s measurement comes in lower than your issue total. By then the crew has moved on and the store has forgotten which drum went where.
Three numbers per item per site
Reconciliation needs three columns. Issued, installed and returned. A fourth column, scrapped, catches offcuts and damaged units, and whatever remains after subtracting the last three from the first is the unexplained quantity.
Do it per site and per item. Never use a company total. A surplus of breakers on one job can hide a shortage of the same breakers on another, and the total makes both look fine.
Take the installed figure from a source other than the store, such as the site engineer’s weekly measurement or the as-built drawing. If the store grades its own homework, the numbers always agree.
- Cable by drum number, with start and end meter marks
- Breakers by rating, pole count and make
- Panels by serial number or tag
- Lugs, glands and trunking by pack count
Where the missing quantity usually goes
Cable loses length three ways. Pulls run longer than the drawing shows, offcuts under a few metres get binned, and a part drum is lent to the next site without a slip. Metre marks printed on the sheath expose each one, if someone writes them down.
Breakers and small fittings walk away as spares. A crew keeps two extra of each rating to avoid a trip back. Across a dozen sites that habit builds a shelf of stock that no ledger knows about.
Panels rarely vanish, but they move. A distribution board meant for site A is installed at site B because it was closer. Both jobs now show the wrong cost and the wrong stock.
Make the paperwork do the matching
Give every issue slip a site code and a job stage. Give every return slip the same. A return with no reference to the original issue is the commonest reason a reconciliation fails.
Ask the site engineer to close each stage with a short material statement. It lists what was fitted, what is left on site and what came back. Two minutes of writing saves two days of arguing later.
A spreadsheet can hold this for a handful of sites. Beyond that, the matching needs a system that links issue, installation entry and return to the same job. It should flag any item where the unexplained quantity passes a limit you set.
- Issue slip with site code, stage and drum or serial numbers
- Weekly installed quantity signed by the site engineer
- Return slip that cites the original issue
- Stage close statement with leftover quantity
A weekly routine to start with
Pick your three costliest items. Run the three-number check on every live site each Friday, look only at the largest gaps and ask the foreman what happened.
Most answers are ordinary. A drum is still in the van. A board was moved. Write each answer on the sheet and watch for the pattern, because the same two or three causes keep repeating.
After a month, set a tolerance per item. Cable may allow a small wastage allowance, breakers should allow none. Anything beyond the allowance goes to the project manager before the next issue is approved.
Site material reconciliation sheet
Use one sheet per site, one row per item. Columns: item and rating, drum or serial numbers, issued quantity, installed quantity, returned quantity, scrapped quantity, unexplained gap, allowed wastage, reason and checked by. The top of the sheet carries site code, stage and week. A second block records each transfer between sites, naming who approved it and when.
Open a blank worksheet to printQuestions owners ask
How often should site material be reconciled?
Weekly for high-value items such as cable and panels, and at every stage close for the rest. Waiting for handover turns a small question into a dispute.
Who should own the reconciliation?
The project manager owns it, the store keeper supplies issues and returns, and the site engineer supplies installed quantities. Splitting the three sources keeps the check honest.
What is an acceptable gap on cable?
It depends on the cable size, the routes and your contract. Set an allowance per item from your own past jobs, then review it each quarter.
Can this be done in a spreadsheet?
Yes, for a few sites. Once issue slips, returns and transfers come from several people, a linked record is easier to keep complete.