punch list template excel free download

Project Construction and Quality Assurance Punch List

This document serves as a standardized tracking system for identifying, assigning, and resolving outstanding work items before project closeout. It is designed for use by project managers, site supervisors, and contractors.

Update Cadence: Review and update status daily during the final 30 days of the project phase; update weekly during the initial construction phase.

Column Definitions

• Item ID: [Unique alphanumeric identifier] (Text).
• Task Description: [Specific, actionable description of the defect or remaining work] (Text).
• Assigned To: [Name of the responsible party or firm] (Text/Dropdown).
• Priority: [High/Medium/Low] (Dropdown).
• Status: [Not Started/In Progress/Completed/On Hold] (Dropdown).
• Due Date: [Target date for resolution] (Date).
• Completion Date: [Actual date of verification] (Date).

Essential Formulas

Calculate Days Remaining (Place in a helper column):

=IF(ISBLANK([@[Completion Date]]), [@[Due Date]]-TODAY(), "Closed")

Count Total Open Items:

=COUNTIF(E2:E100, "<>Completed")

Calculate Percentage Completion:

=COUNTIF(E2:E100, "Completed") / COUNTA(E2:E100)

Data Validation and Formatting Rules

1. Status Dropdown (Data Validation): Select the Status column, go to Data > Data Validation > List. Enter: Not Started, In Progress, Completed, On Hold.

2. Priority Color Coding (Conditional Formatting): Select the Priority column. Create a New Rule: "Format only cells that contain" > "Equal to" > High. Set fill color to Light Red. Repeat for Medium (Yellow) and Low (Green).

3. Overdue Alert (Conditional Formatting): Select the Due Date column. Use the formula: =AND(F2<TODAY(), E2<>"Completed"). Set fill color to Bold Red text with a light background to highlight items requiring immediate attention.