Yard report, updated weekly

How to reconcile a material takeoff against what's actually in the yard

Rows of rusty steel pipe joints stacked on dunnage in an outdoor yard under a cloudy sky.

The takeoff says 340 joints of 24-inch pipe. The buyout schedule says 340 were ordered. The invoice says 340 were billed. None of that tells you how many are sitting on dunnage in Row C this week, and that gap is where the money problems start.

A material takeoff is a planning number. It's what the estimator or the engineer calculated the job would need, built off drawings and a BOM, before a single truck rolled. A physical count is what's on the ground right now. The two are supposed to converge over the life of the job, but in practice they drift apart almost immediately, because deliveries come in partial, suppliers substitute lengths, crews pull material for other areas, and nobody updates the spreadsheet in real time.

Why the takeoff and the yard never match

Three things cause most of the variance project controls teams chase down:

Partial deliveries. A PO for 500 rebar bundles might show up as three separate truckloads over six weeks, and the delivery tickets don't always get logged the same day material hits the yard.

Substitutions and overages. A supplier ships 44-foot joints instead of 40-foot to fill an order, or sends extra pipe to round out a truck. The invoice reflects what was billed, not necessarily what matches the original takeoff line item.

Yard movement. Material gets pulled for install, moved to a laydown area for a different phase, or consolidated into a different stack. A count taken in week 3 doesn't describe what's there in week 7.

None of this means anyone did anything wrong. It just means the paper trail (takeoff, PO, delivery ticket, invoice) and the physical yard are two different records that update on two different schedules, and project controls is the group that has to sit in the middle and make them agree.

Material takeoff vs physical count: what each one tells you

The takeoff and the buyout schedule tell you what should be there, based on what was engineered and what was ordered. They're forward-looking documents, built before the material shows up.

A physical count tells you what is there. It's the only number that can catch a short delivery, a supplier billing for quantity that never arrived, or stock that's been double-booked between two phases of work without anyone updating the log.

The standard way to get that count is still a walk-through: someone with a clipboard or a tablet, tallying pipe joints and rebar bundles, eyeballing a stockpile and guessing at cubic yards of aggregate. That works, but it's slow, it depends on who's walking and how careful they're being that day, and a volume estimate on a stockpile from eye alone can be off by enough to matter once you're reconciling against an invoice.

Reconciling against the buyout schedule and invoices

Once you have a count you trust, the reconciliation itself is a comparison exercise:

Line up the count against the buyout schedule by line item, not by total tonnage. A short count on one pipe size and a surplus on another can cancel out in the aggregate and hide a real problem.

Flag anything where delivered quantity on the invoice doesn't match what's physically present. That's either a yard count error, a short delivery that wasn't caught at receiving, or material that moved to another area without a transfer logged.

Carry the variance forward week to week instead of treating each count as a one-off. A stockpile that's slowly shrinking against what the delivery log says should be there is worth catching in week 4, not week 14 when the invoice is already paid.

The weekly part matters more than it sounds like it should. A takeoff and a buyout schedule are static documents. The yard isn't. A count taken once at delivery and never checked again just tells you what was unloaded, not what's still there, what's been consumed, or what quietly went missing between deliveries.

That's the gap a weekly drone flight over the yard is built to close: a counted, measured record of pipe joints, precast units, rebar bundles, and aggregate volumes you can set next to the delivery log and the invoice instead of trusting a hand tally. If you're the one reconciling the yard against what's been paid for, it's worth seeing what a weekly count turns up before the next invoice lands.

Start a pilot

← Back to the blog