Free Issue Log Template
Excel Download
Problems happen on every project. What separates good PMs from the rest is not avoiding issues — it's tracking them systematically so nothing gets forgotten, priorities are clear, owners are accountable and resolution is confirmed. This structured Excel template makes that easy from day one.
No email required. Instant Excel download.
What's in the Template — 10 Columns Explained
The Issue Log is a single-sheet Excel file with a violet branded header, project metadata row and 50 pre-formatted issue entries. Three columns — Category, Priority and Status — use validated drop-downs to keep the log filterable and consistent.
| Column | Field | Notes |
|---|---|---|
| ID | Issue Number | Pre-filled ISS-001 to ISS-050. Extend by copying the last row. The ID links this log entry to any associated change requests or action items. |
| Date Raised | Date | When the issue was first formally raised — not when it was first noticed. Entering it in the log is the act of raising it formally. |
| Issue Description | What the issue is | A clear, specific description. State the problem, its current impact and what is at risk if it is not resolved. Avoid vague entries like "system issue" — be specific enough that someone unfamiliar with the project can understand it. |
| Category | Drop-down | Technical / Resource / Schedule / Budget / Scope / External / Other. Validated drop-down — use to filter by type for reporting or root cause analysis. |
| Priority | Drop-down | Critical / High / Medium / Low. Set based on the impact on project baselines and the urgency of resolution required. See the priority guide below. |
| Status | Drop-down | Open / In Progress / Escalated / Resolved / Closed. Use Escalated when the issue has been formally raised above the PM's authority for resolution. |
| Raised By | Name | Who identified and raised the issue. Not necessarily the person responsible for resolving it. |
| Owner | Name | The single person accountable for driving resolution. One name only. If the issue requires escalation, the owner is the PM until a senior owner formally accepts it. |
| Resolution | What was done | How the issue was resolved — the specific action taken. Only complete when the issue is Resolved or Closed. This column is what makes a good issue log genuinely useful for lessons learned. |
| Date Closed | Date | When resolution was confirmed and verified. An issue is not closed because the owner says they have fixed it — it is closed when the PM confirms the fix is working and the impact has been removed. |
How to Set Issue Priority — The Four Levels
Priority determines how quickly an issue needs a response and how much management attention it receives. Use these definitions consistently across the project team so that "High" means the same thing to everyone.
Priority Can Change — Review It Every Meeting
A Medium issue that is not resolved in two weeks may become High. A High issue that blocks a critical path task may become Critical. Priority is not a static field — review it at every project meeting and update it if the situation has changed. An issue that appears to be improving can also be downgraded — this shows the log is being actively managed, not just maintained as a record.
Issue Status — From Open to Closed
The Status drop-down has five options. Each represents a distinct stage in the issue lifecycle. Understanding when to use each — and the difference between Resolved and Closed — prevents issues being marked complete before they really are.
Resolved vs Closed — an Important Distinction
Resolved means the fix has been applied and the owner believes the issue is no longer active. Closed means the PM has verified independently that the resolution is working and the issue impact has been removed. This distinction matters: an owner may mark a technical issue as Resolved after applying a patch, but if the system is still experiencing the same problem, it should remain Resolved — not Closed — until the PM confirms it is fixed.
Never let owners close their own issues. The PM (or a designated quality reviewer) should always be the one who moves status from Resolved to Closed, having confirmed the resolution is effective.
Issues, Risks and Actions — Keeping the Registers Clear
Three registers work together during project execution. Understanding the boundaries between them keeps each one clean and useful.
| Dimension | Issue Log | Risk Register | Action Tracker |
|---|---|---|---|
| What it records | Problems that have occurred and need resolving | Uncertain future events that might affect the project | Tasks committed by someone to someone by a date |
| Tense | Present — happening now | Future — may or may not happen | Future — will be done by a date |
| Trigger to create entry | A problem has occurred and is affecting the project | An uncertainty is identified that could affect the project | A commitment is made in a meeting or decision |
| Closed when | Resolution verified effective by PM | Risk has passed, been mitigated or materialised (becomes issue) | Task completed and output verified |
| Link between registers | A risk that materialises → moves to the issue log. An issue resolution decision → logged in the decision log. An issue or risk → generates action items in the action tracker. | ||