Free, no sign-up, no macros

RAID log template for Excel, free

A RAID log is a project’s list of Risks, Assumptions, Issues and Dependencies, kept in one place.

Each item gets an owner, a RAG status, an action and a due date, and the log is reviewed every week.

This template is an Excel workbook with the four sheets, a worked example and a summary of what is still open.

Download for Excel (.xlsx)raid-log-template.xlsx: Summary, Risks, Assumptions, Issues, Dependencies and How to use

RAID log example

One project filled in on all four sheets: moving a 120-person office to a new building, move weekend 20 March 2027. The rows point at each other the way a real log does: the electrics running late (I1) is part of what risk R1 warned about, and building control’s sign-off (D3) waits on the fire exit issue (I2).

Risks

Likelihood and impact from 1 to 5; the score is the two multiplied and sets the RAG.

RAID log example: risks
IDRiskOwnerDate raisedLikelihood (1-5)Impact (1-5)ScoreRAGStatusActionDue date
R1The fit-out of the new floor finishes latePriya Shah (Facilities)11 Jan 20273515RedOpenWeekly progress check with the landlord and the contractor; a completion date in the contract1 Feb 2027
R2The network line is not live on move dayTom Reid (IT)11 Jan 20273412AmberOpenOrder the line 90 days ahead and book a 4G backup router15 Feb 2027
R3Staff push back on hot-deskingAisha Khan (HR)18 Jan 2027428AmberOpenTwo drop-in sessions and a desk-booking trial on one floor1 Mar 2027
R4The removals firm loses or damages equipmentDan Price (Office manager)18 Jan 2027236GreenOpenTagged asset list, photos before packing, check the firm's insurance15 Mar 2027
R5Furniture lead time runs past ten weeksPriya Shah (Facilities)25 Jan 2027248AmberClosedOrdered from the supplier's stock range, delivery confirmed25 Jan 2027
R6Repairs owed on the old lease cost more than budgetedHelen Ward (Finance)25 Jan 2027339AmberOpenSurveyor's schedule of condition before giving notice28 Feb 2027

Assumptions

A6 is Red because the check came back: the permits do not transfer, so it needs a decision.

RAID log example: assumptions
IDAssumptionOwnerDate raisedImpact if wrongRAGStatusActionDue date
A1The landlord gives access for the fit-out from 1 FebruaryPriya Shah (Facilities)11 Jan 2027HighAmberOpenGet the access date in writing in the agreement for lease20 Jan 2027
A2Most of the current desks and chairs can be reusedDan Price (Office manager)11 Jan 2027MediumGreenClosedCondition survey done: 80% reusable18 Jan 2027
A3Headcount stays at 120 until after the moveAisha Khan (HR)18 Jan 2027MediumGreenOpenCheck hiring plans with each head of department monthly1 Mar 2027
A4The phone system moves without new handsetsTom Reid (IT)18 Jan 2027HighAmberIn progressVendor to confirm the handsets work on the new network8 Feb 2027
A5Everyone can work from home on the Friday before the moveAisha Khan (HR)25 Jan 2027LowGreenOpenAnnounce at the all-hands and check every laptop is issued15 Mar 2027
A6Parking permits transfer to the new siteDan Price (Office manager)25 Jan 2027LowRedOpenThe council says they do not: decide on a travel allowance instead15 Feb 2027

Issues

Problems that have happened, each with the action that resolves it.

RAID log example: issues
IDIssueOwnerDate raisedImpactRAGStatusActionDue date
I1The fit-out contractor is two weeks behind on the electricsPriya Shah (Facilities)8 Feb 2027HighRedOpenRecovery plan with weekend working and an agreed cost cap15 Feb 2027
I2The floor plan does not meet the fire exit rulesPriya Shah (Facilities)1 Feb 2027HighAmberIn progressArchitect revises the layout for building control to review again12 Feb 2027
I3Two teams want the same quiet roomDan Price (Office manager)3 Feb 2027LowGreenClosedBooking rota agreed between the two team leads5 Feb 2027
I4The removals quote is 20% over budgetHelen Ward (Finance)5 Feb 2027MediumAmberOpenSecond and third quotes requested19 Feb 2027
I5The wifi survey of the new floor shows a dead zoneTom Reid (IT)10 Feb 2027MediumAmberIn progressTwo extra access points ordered26 Feb 2027
I6Signing the lease is held up by the solicitors' questionsHelen Ward (Finance)15 Jan 2027HighGreenClosedQuestions answered; lease signed on 22 January22 Jan 2027

Dependencies

What the move waits on from the landlord, suppliers and other teams.

RAID log example: dependencies
IDDependencyOwnerDate raisedImpact if lateRAGStatusActionDue date
D1The landlord hands over the finished shell of the floorPriya Shah (Facilities)11 Jan 2027HighAmberOpenWeekly call with the landlord's agent1 Feb 2027
D2The telecoms provider installs the network lineTom Reid (IT)11 Jan 2027HighAmberIn progressChase the order reference every two weeks1 Mar 2027
D3Building control signs off the fit-outPriya Shah (Facilities)18 Jan 2027HighGreenOpenInspection booked; waits on I28 Mar 2027
D4The furniture supplier delivers the new desksDan Price (Office manager)18 Jan 2027MediumGreenOpenDelivery slot confirmed for the week before the move10 Mar 2027
D5Finance approves the removals purchase orderHelen Ward (Finance)25 Jan 2027MediumAmberOpenWaits for the third quote (I4)22 Feb 2027
D6The old landlord agrees a date for the exit inspectionHelen Ward (Finance)25 Jan 2027MediumGreenOpenThree dates proposed in writing30 Mar 2027

How to run a RAID log

  1. Start it at kick-off. Open the log in the first project meeting and ask four questions in turn: what could go wrong, what are we assuming, what is already a problem, and who are we waiting on. Write one item per row on its sheet.
  2. Give every row one owner and a due date. A person, not a team, and the date the action is due. Without both a row is a worry, not an item someone is working on.
  3. Score the risks. Likelihood and impact from 1 to 5. The score is the two multiplied, and the RAG follows it: 15 or more is Red, 8 to 14 Amber, below 8 Green. On the other three sheets, pick the RAG yourself: Red means it needs a decision this week.
  4. Move items between sheets. A risk that happens becomes an issue. An assumption that turns out wrong becomes an issue too. Close the old row and add the new one with the same wording, so the history stays readable.
  5. Review it every week. Go through the Red and Amber rows in the project meeting, update the status and the action, and close what is done. The Summary sheet shows what is still open on each sheet.

RAID log vs risk register

A risk register is the R of a RAID log on its own: the things that might happen, with how likely and how bad each one is. It answers “what could go wrong”. A RAID log also answers “what are we relying on”, “what has gone wrong” and “who are we waiting for”.

Use the register alone for a small internal project, and the full log when the project depends on suppliers, landlords or other teams. If you want the register on its own, with probability in percent and impact in working days, use the risk register template.

What RAG means

Red, Amber, Green: a traffic-light status. Red needs a decision or help now, Amber is being worked on but could slip, Green is under control. In the Risks sheet the RAG comes from the score; in the other three the owner sets it.

Updated .

Frequently asked questions

What does RAID stand for in project management?

Risks, Assumptions, Issues and Dependencies. A RAID log keeps the four lists side by side, so a project manager can see in one place what might go wrong, what the plan relies on, what has gone wrong and who the project is waiting on.

Does RAID ever mean something else?

Some teams use Risks, Actions, Issues and Decisions instead, keeping assumptions and dependencies elsewhere. The sheet works the same way: rename a tab and its first column if your organisation uses that version.

Is this RAID log template free?

Yes. It is an Excel workbook (.xlsx) you download from this page, with no sign-up and no email. There are no macros.

What is the difference between a RAID log and a risk register?

A risk register is one of the four parts: the list of things that might happen. A RAID log adds what the plan assumes, what has already happened and what the project depends on. A small project often keeps only a risk register; a larger one, or one with outside suppliers, usually needs the full log.

Who owns the RAID log?

The project manager keeps it up to date, and each row has its own owner who does the action. In a programme, a project office often collects every project's log in the same format so the Red items can be read across projects.

Does it work in Google Sheets?

Yes. Open a blank spreadsheet, choose File > Import > Upload, pick the file and choose Replace spreadsheet. The score and RAG formulas, the drop-down lists, the colours and the Summary counts come with it.

Track risks and issues in Onplana

Every Onplana project has a Risks tab and an Issue Log, on the Free plan, next to the tasks they affect. Dependencies are links between tasks on the Gantt chart, so a late task moves the ones after it.

Start free