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.
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.
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 ID | Spec Section | Category | Material / Equipment Description | Manufacturer / Supplier | Responsible Party | Priority | Required On-Site Date | Overall Status | Notes / Next Action | Last Updated |
|---|---|---|---|---|---|---|---|---|---|---|
| MAT-001 | 03 30 00 | Concrete | Concrete mix design - structural | TBD | Project Team | High | blank | Not Started | ||
| MAT-002 | 40 05 00 | Piping | Process piping and fittings | TBD | Vendor | Critical | blank | Not Started | ||
| MAT-003 | 46 00 00 | Process Equipment | Major process equipment | TBD | Vendor | Critical | blank | Not Started | ||
Simplified rendering of the Material Register. Formatting in Excel differs. Scroll sideways to see all columns.
Descriptions and dates on the other sheets are looked up from the Material Register by Material ID, so you only type them once.
The master list: ID, spec section, category, description, supplier, responsible party, priority, required on-site date, overall status, next action. 500 rows prepared.
Submittal number, status, submitted and approved dates, and review notes.
PO or subcontract number, lead time, planned and actual release, promised ship date, PO value, cost code, procurement status.
Required date, actual ship and delivered dates, ordered vs. delivered quantity, unit, calculated balance, storage location, schedule flag, invoice or packing slip.
Counts of total, active, and critical materials, approved submittals, released or ordered, overdue, due within 14 days, and delivered.
The values behind the dropdowns. Adjust categories and statuses to match how your team works.
Download the file and save a copy per project. Keep the original untouched as your clean template.
Add it to the Material Register with a unique Material ID and its required on-site date. Replace or delete the starter examples.
Enter that ID on Submittals, Procurement, and Delivery Log. Descriptions and dates fill in from the register.
Record submittal, release, and delivery events as they happen, and review overdue and due-soon counts.
Lookup columns and the delivery balance are formulas. Typing over them breaks the link back to the Material Register.
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.
The workbook is published as provided. It can be imported into Google Sheets, but formula and dropdown behavior may vary and is not guaranteed.
Yes. Download and use it on as many projects as you need. No account, email, or payment.
No. It is a standard .xlsx file using formulas, lookups, and data validation lists.
Mostly. It includes three starter example rows (MAT-001 to MAT-003) to show the format. Overwrite or delete them when you start.
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.
Werx Tracker records what arrived, where it landed, and what's still outstanding, with photos and GPS from the job site.