Free template
RAID log template
Short answer
A free Excel RAID log with one row per risk, assumption, issue or dependency. Score is probability times impact, days open and overdue flags calculate automatically, and a summary tab counts open, high-rated and overdue items.
Free to use inside your organisation. Please don’t resell it or publish it as your own.
What's inside
Risks, assumptions, issues and dependencies in one sheet, with an owner, a review date, a calculated score and the decision you need from your sponsor.
- RAID log tab
- Summary tab
- How to use tab
How to use it
- Fill in the yellow cells on the RAID log tab, one row per item. Row 5 is an example; overwrite or delete it.
- Write each title as cause → event → impact in one sentence.
- Give every item one named owner and a due or review date.
- Score = probability × impact. 15+ is High, 8–14 Medium, below 8 Low. Change the thresholds if your PMO uses others.
- Say what decision you need; that is what your sponsor reads first.
- Days open and Overdue? calculate automatically and stop counting when Status is Closed.
Read the companion piece: Write RAID entries a sponsor will actually read.