Construction Materials Inventory Template
For general contractors and remodelers tracking lumber, drywall, concrete mix and fasteners between the yard and job sites. Know what's left over from the last job before you buy for the next.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| CM-DRY-12-4x8 | Drywall 1/2 in. 4x8 Sheet | Drywall | Yard / Covered Bay | sheet | 48 | 20 | 13.6 | auto | auto | Summit Building Supply |
| CM-CON-80 | Concrete Mix, 80 lb | Concrete | Yard / Pallet 3 | bag | 35 | 15 | 5.9 | auto | auto | Summit Building Supply |
| CM-OSB-716 | OSB Sheathing 7/16 in. 4x8 | Sheathing | Maple St. Job Site | sheet | 22 | 0 | 16.4 | auto | auto | Timberline Lumber Yard |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Use the job site name as the location so leftover material can be moved to the next job instead of re-purchased.
- Keep bagged concrete and mortar off the ground and count them monthly; damp bags harden and should be written off.
- Note supplier delivery minimums so small top-up orders get combined into one truck drop.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template