Construction punch list and deficiency list template
Excel / Google Sheets compatible · blank sheet, filled example and instructions · no sign-up required
One row per item, from the walkthrough to the sign-off. Who is responsible, when it is due, whether it has been done, and separately whether you have checked it yourself. Overdue flags itself, and stops flagging the moment the work is complete, so the list shows what is actually outstanding rather than what is waiting on your paperwork. The preview below is the filled example in the file.
Template and page last reviewed November 4, 2026.
What is in the file
| Item | Location | Issue | Responsible | Due | Status | Overdue on 29 Sep 2026 |
|---|---|---|---|---|---|---|
| PL-001 | Kitchen | Cabinet door misaligned, rubs frame on close | Millwork - T. Okafor | 20 Aug 2026 | Verified - closed | |
| PL-002 | Ensuite | Grout haze on shower floor tile | Tile - Bolt Trades | 24 Aug 2026 | Ready to verify | |
| PL-003 | Main floor hall | Drywall corner bead dented beside light switch | Drywall - Sparks Ltd | 21 Aug 2026 | Open | Overdue |
| PL-004 | Garage | Exterior door does not latch without lifting | Carpentry - in house | 18 Aug 2026 | In progress | Overdue |
| PL-005 | Rear deck | Two deck boards cupping at the north end | Carpentry - in house | No date set | Open | |
| PL-006 | Basement | Paint touch-up at stair stringer | Painting - Pacific Finish | 30 Sep 2026 | Open | |
| PL-007 | Front entry | Client asked about a storm door - not in contract | n/a | No date set | Not applicable |
| Item | Items |
|---|---|
| Logged | 7 |
| Still open (includes in progress and ready to verify) | 5 |
| Done by the trade, waiting on your verification | 1 |
| Overdue: past due and the trade has not finished | 2 |
| Closed (verified, or not applicable) | 2 |
Three steps to a working document
Log it where you find it
One item, one row, one location. A row that says "various snags upstairs" is a row nobody can close.
Give it a name and a date
A responsible trade and a due date. Leave the due date blank where there genuinely is not one: the overdue column ignores blanks rather than flagging them.
Complete and verify are two columns
The trade filling a completion date and you confirming it on a later walk are different facts. The template keeps them apart, and only your sign-off closes the row.
This is a working document, not a legal one. Closing every row does not by itself establish substantial completion, occupancy or a holdback release. Those are set by your contract and your province's construction legislation, so confirm both before you treat a clear list as a milestone.
When the spreadsheet stops scaling
In BuildersBridge, walkthrough notes go in the job's daily log and photos are saved to the job with the date they were taken. There is no dedicated punch list module: this template is the tool for that job.
See how it works in BuildersBridgeCommon questions
What is a construction punch list?
The list of outstanding and defective items found near the end of a job, each assigned to whoever has to fix it, worked through until the owner accepts the work. It is the closeout document, raised at a walkthrough rather than during the build.
Is a deficiency list the same thing?
Yes. Deficiency list is the usual term on Canadian residential contracts and punch list is the American usage, but they describe the same document and the same walkthrough. If your contract uses one word, use that word on the list you hand over.
How is this different from a QC checklist?
A quality control checklist is verification planned in advance, stage by stage, before work gets covered. A punch list is what you find at the end and have to put right. The checklist is meant to shrink the punch list: if yours is long, the hold points were not being checked.
Why are completion and verification separate columns?
Because "the trade says it is done" and "I have looked at it" are different claims, and a list that collapses them into one status quietly closes items nobody checked. In the example, PL-002 was finished before its due date and is waiting on your walk, so it is not flagged overdue, but it stays open until you sign it.
Does a clear punch list mean the job is complete?
Not by itself. Substantial performance, or substantial completion in US usage, and the release of holdback or retainage are set by your contract and the legislation where the job is. Keep the signed list with the job's other closeout records, but do not treat it as the legal milestone.
Does BuildersBridge have a punch list feature?
No. There is no punch list module in the product today, which is why this is a standalone template. Daily logs and dated job photos are there, so the notes and pictures from a walkthrough stay with the job.
Can I use it in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Sheets. The status dropdowns, filters and the overdue formula carry over.