Free receiving log · Excel

Free Material Receiving Log Template

Check every delivery against the PO and packing slip. Qty ordered vs. received with a variance formula, damage, backorders, storage location, and photos — plus a delivery schedule with crane and forklift needs and days late.

  • Date, PO #, supplier, packing slip / BOL #
  • Qty ordered vs. received with variance formula
  • Condition, damage notes, backorder qty and date
  • Storage location, received by, photo reference
  • Auto receipt status: Complete / Short / Backorder / Over / Exception
  • Delivery schedule: crane / forklift, gate / laydown, days late
  • Print-ready landscape layout with repeating headers

Material Receiving Log

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Receiving Log

One line per item per delivery: ordered vs. received, variance, condition, backorders, storage, photos, and an automatic receipt status with a summary strip.

02

Delivery Schedule

Expected date and window, supplier, item, PO, crane / forklift needed, gate / laydown, status, and a Days Late formula. Crane picks and unconfirmed deliveries are highlighted.

03

Instructions

How to receive a load, note exceptions on the BOL, handle backorders, and plan crane picks.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What is a material receiving log in construction?

It is the field record of every delivery: date, PO number, supplier, packing slip or bill of lading number, what was ordered versus what actually arrived, condition, backorders, where it was stored, and who received it. It backs up invoice approval, damage claims, stored-materials billing, and delay claims.

How does the variance column work?

Variance = quantity received − quantity ordered. Negative means short, positive means over-shipped, zero means it matches. A Receipt Status formula then labels each line Complete, Short, Backorder, Over, or Exception (damaged, wrong item, or rejected) so you can filter what needs follow-up.

What should I do if a delivery arrives damaged?

Note the damage and any shortage on the driver's copy of the bill of lading or delivery ticket before you sign, have the driver sign it, and photograph the damage, the labels, and the packing slip. Then log it and notify the PM or buyer the same day. Check your PO terms for the claim deadline.

How is Days Late calculated on the delivery schedule?

Once a delivery arrives, Days Late = actual date − expected date (zero if early or on time). If it has not arrived and is not cancelled, it counts from the expected date to today. Late deliveries turn red and are counted at the top of the sheet.

Why track crane and forklift needs on the delivery schedule?

Offload equipment is what turns a late or unannounced delivery into lost production. Crane picks need the crane, a qualified rigger and signal person, a lift plan, and sometimes a street-use permit booked days ahead. The schedule highlights crane deliveries and flags any delivery in the next 7 days that hasn't been confirmed.

Catch it at the tailgate, not in the budget

A material receiving log is the field record of what actually arrived on site: how much, in what condition, what is still on backorder, and where it was stored. It is what the PM needs to approve supplier invoices, file damage claims, bill stored materials, and document late deliveries.

This free template pairs the receiving log with a delivery schedule so the super can see what is coming, what it takes to offload, and what is late. Bring it to the subcontractor coordination meeting to plan gates, laydown, and crane time.

In Field PM, material is received against each PO line with partial receipts tracked, so the PM sees what is still open on every order.

Why a receiving log pays for itself

Material problems rarely show up the day the truck arrives. They show up three weeks later when the crew opens a carton and finds the wrong fixture, when the supplier invoices for 24 floor boxes and only 16 ever came, or when the switchgear shows up two weeks late and nobody wrote down when it was promised. A material receiving log is how you catch those problems at the tailgate instead of in the budget. The free template above logs every delivery line by line and adds a delivery schedule so you can see what's coming, what it takes to offload, and what's late.

How to receive a delivery

  1. Know it's coming. Every expected delivery belongs on the Delivery Schedule with a date, time window, gate, laydown area, and offload equipment. Confirm it the day before.
  2. Have the PO in hand. Suppliers ship what's on the packing slip, which isn't always what you ordered. Count against both.
  3. Count and inspect before the driver leaves. Open cartons that look crushed. Check sizes, voltages, finishes, and part numbers on the labels — not just the carton count.
  4. Note exceptions on the BOL. Write shortages and visible damage on the driver's copy of the bill of lading or delivery ticket and have the driver sign it. Freight damage claims usually depend on that note; a clean signature generally means you accepted the load as delivered.
  5. Photograph it. Damaged cartons, labels, and the packing slip. Put the photo number in the log.
  6. Store it where people can find it. Record the Conex, room, or laydown area. Material nobody can find gets ordered twice.
  7. Send exceptions the same day. Filter the Receipt Status column for Short, Backorder, Over, and Exception and send those lines to the PM or buyer.

Column-by-column: the receiving log

ColumnWhat to enter
Date Received / PO # / SupplierTies the line to the purchase order and invoice.
Packing Slip / BOL #The document number you'll match to the supplier's invoice.
Item / UnitOne line per item per delivery, in the PO's unit (EA, FT, CY, LBS).
Qty Ordered / Qty ReceivedOrdered from the PO; received from your own count.
VarianceFormula: received − ordered. Negative = short, positive = over.
ConditionGood, Damaged, Wrong Item, or Rejected.
Backorder Qty / BO ExpectedWhat the slip says is coming later, and when. Past-due backorder dates turn red.
Storage Location / Received By / Photo RefWhere it went, who signed, and the photo number.
Receipt StatusFormula: Complete, Short, Backorder, Over, or Exception.

A summary strip at the top counts lines logged, complete, short or backordered, over-shipped, exceptions, and total backorder quantity still open.

The delivery schedule

The second tab is the look-ahead for material. Each row has the expected date and time window, supplier, item, PO, quantity or number of loads, crane / forklift needed, gate / laydown area, site contact, status, actual date, and a Days Late formula. It highlights:

  • Crane picks — plan the crane, qualified rigger and signal person, lift plan, and power-line clearance (see our crane power line clearance chart), and any street-use permit or flaggers.
  • Unconfirmed deliveries in the next 7 days — call the supplier and confirm truck type (flatbed, box truck, boom truck), window, and who offloads.
  • Late deliveries — anything past its expected date and not delivered, counted at the top of the sheet.

Bring the Delivery Schedule to the weekly subcontractor coordination meeting — deliveries, laydown space, and crane time are shared resources on any site.

What the log protects

  • Invoice approval. Pay for what arrived, not what was invoiced. Match slip numbers and quantities before approving.
  • Stored materials billing. Many contracts let you bill for materials stored on site if you can document them — the storage location and photo columns are that documentation. Check your contract's requirements.
  • Damage and backcharges. Dated, photographed exceptions noted on the BOL.
  • Delay claims. Expected versus actual dates on long-lead equipment, recorded when they happened. This template isn't legal advice — follow the notice terms in your contract and PO.

Common receiving mistakes

  1. Signing the ticket without counting. The most expensive signature on the job.
  2. Counting cartons, not contents. A full pallet of the wrong color temperature is still wrong.
  3. No storage record. Material gets reordered because nobody knows it's already in Conex #2.
  4. Backorders nobody chases. Log the promised date and review past-due backorders weekly.
  5. Surprise deliveries. A flatbed at the gate with no forklift and no laydown space costs a crew hour or a redelivery fee.

When to move beyond a spreadsheet

A spreadsheet log works when one person receives and one PM reviews. It gets harder when receipts need to match POs and invoices automatically across several jobs. In Field PM, POs live with the job and material is received against each PO line — partial receipts are tracked automatically, so the PM and whoever approves the supplier invoice see what actually arrived. Start a free 30-day trial.

Related construction templates

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice