Issue log template
A free issue log template in Excel and CSV — issue, type, priority, owner, due date, status, an automatic overdue flag and days open, what it blocks, actions, escalation and resolution.
What's inside
| Column | What goes in it |
|---|---|
| ID | ISS-001, ISS-002 … |
| Issue | What is happening now, and its effect |
| Type | drop-down Technical, Resource, Supplier, Stakeholder, Quality, Schedule, Cost |
| Priority | drop-down Critical, High, Medium, Low |
| Raised by | |
| Date raised | |
| Owner | One person who will resolve it |
| Due date | |
| Status | drop-down Open, In progress, Escalated, Resolved, Closed |
| Overdue? | Past the due date and not resolved · calculated |
| Days open | calculated |
| Blocks (task or deliverable) | |
| Actions taken | |
| Escalated to | |
| Resolution | What fixed it; fill in before closing |
The Excel file has three sheets: the blank register, a filled example from the Coral Ridge Resort sample project, and how to use each column. The CSV is the blank header row only.
What an issue log is
An issue is a problem that is happening now; a risk is one that might. The issue log lists the current problems, who owns each one, when it must be fixed, and what has been done about it, so nothing is left waiting for someone else.
When to use it
Every day of delivery. Review open issues at each team meeting and escalate the ones that are past their due date or beyond the team's authority.
How to fill it in
- Describe the issue and its effect in one sentence.
- Set the priority and give it one owner with a due date.
- Record what it blocks: the task or deliverable that can't move until it is fixed.
- Log the actions as they happen. The Overdue? and Days open columns update themselves.
- Escalate when it is beyond the owner's authority, and record who to.
- Write the resolution before closing: what fixed it. That is where lessons come from.
Common mistakes
- Risks and issues in the same list. Keep threats that might happen in the risk register.
- Issues owned by "the team", so nobody owns them.
- Closed with no resolution recorded.
See it used on a real project: B4 · Remove impediments and manage issues