Werx Tracker logoWerx Tracker
Free Excel template

Material Tracking Log for construction projects

One Excel workbook that follows each material from spec section to submittal, purchase order, and delivery. Enter a material once, reuse its ID on every sheet, and see what's still outstanding on the dashboard.

Workbook preview

The Material Register is where every item starts. Below are the real headers and the three starter example rows that ship in the file.

READ-ONLY PREVIEW · ILLUSTRATIVE
Material Register starter rows from the workbook
Material IDSpec SectionCategoryMaterial / Equipment DescriptionManufacturer / SupplierResponsible PartyPriorityRequired On-Site DateOverall StatusNotes / Next ActionLast Updated
MAT-00103 30 00ConcreteConcrete mix design - structuralTBDProject TeamHighblankNot Started
MAT-00240 05 00PipingProcess piping and fittingsTBDVendorCriticalblankNot Started
MAT-00346 00 00Process EquipmentMajor process equipmentTBDVendorCriticalblankNot Started
 
 

Simplified rendering of the Material Register. Formatting in Excel differs. Scroll sideways to see all columns.

Six sheets, one material ID

Descriptions and dates on the other sheets are looked up from the Material Register by Material ID, so you only type them once.

01

Material Register

The master list: ID, spec section, category, description, supplier, responsible party, priority, required on-site date, overall status, next action. 500 rows prepared.

02

Submittals

Submittal number, status, submitted and approved dates, and review notes.

03

Procurement

PO or subcontract number, lead time, planned and actual release, promised ship date, PO value, cost code, procurement status.

04

Delivery Log

Required date, actual ship and delivered dates, ordered vs. delivered quantity, unit, calculated balance, storage location, schedule flag, invoice or packing slip.

05

Dashboard

Counts of total, active, and critical materials, approved submittals, released or ordered, overdue, due within 14 days, and delivered.

06

Lists

The values behind the dropdowns. Adjust categories and statuses to match how your team works.

How to use it

  1. Save a working copy

    Download the file and save a copy per project. Keep the original untouched as your clean template.

  2. Register each material once

    Add it to the Material Register with a unique Material ID and its required on-site date. Replace or delete the starter examples.

  3. Reuse the same ID everywhere

    Enter that ID on Submittals, Procurement, and Delivery Log. Descriptions and dates fill in from the register.

  4. Log events, then check the Dashboard

    Record submittal, release, and delivery events as they happen, and review overdue and due-soon counts.

Before you rely on it

Do not overwrite formula cells

Lookup columns and the delivery balance are formulas. Typing over them breaks the link back to the Material Register.

Set required on-site dates first

Schedule flags and overdue counts depend on those dates. In the supplied workbook, starter rows with a blank date may initially show as overdue. Fill in real dates, or remove the examples, before trusting the flags.

Made for Excel

The workbook is published as provided. It can be imported into Google Sheets, but formula and dropdown behavior may vary and is not guaranteed.

Common questions

Is it really free?

Yes. Download and use it on as many projects as you need. No account, email, or payment.

Does it contain macros?

No. It is a standard .xlsx file using formulas, lookups, and data validation lists.

Is the workbook blank?

Mostly. It includes three starter example rows (MAT-001 to MAT-003) to show the format. Overwrite or delete them when you start.

How does this relate to Werx Tracker?

The spreadsheet is a standalone tool. Werx Tracker is our app for logging deliveries from the field with photos, GPS location, and ticket scans, matched against releases. Use either, or both.

Logging deliveries from the field?

Werx Tracker records what arrived, where it landed, and what's still outstanding, with photos and GPS from the job site.