Project Status Report Excel Template

Project Status Report Excel Template

Project Status Report Excel Template

How to complete the Project Status Report workbook

1-General Notes on Completion
  • Project Managers complete a project Status Report on a monthly basis. This Status Report is submitted to the PMO for inclusion in the Project Portfolio Performance Reporting Pack which is reviewed at the monthly Capital Review Group (CRG). 
  • Project Status Reports from all relevant Project Managers will be created as of the last working day of each month and submitted to the PMO within three working days of month end. 
  • Project Managers should review the project Status Report with the Project Sponsor in advance of submitting into the PMO. The Project Status Report may also be produced at the Project Manager's discretion as an input to the project's Steering Committee Meeting. 
  • When saving and submitting the updated status report to the PMO, the name of the project and the ‘as at’ reporting date should be included in the title of the document e.g. "[project name] Project Status Report [YYMMDD]".

2-Version History Sheet
"This sheet should be updated with the details of changes made to the spreadsheet in order to support tracking how the final details were reached. It will help the project sponsor, project manager, and project team have a firm view on how the project Status Report was developed, where information came from, and track input from any reviewers, etc. The entry field is shaded in light blue as highlighted above in point 1. The remaining cells in this tab are locked."

3-Status Report Template Sheet - fixed information
  • Project ID: ID as created by PMO team when project first notified. 
  • Project Name: name as ratified at CRG an input by PMO onto PM3 tool. 
  • Project Type: Please select from the options in the dropdown.
  • Current Stage: Please select from the options in the dropdown 
  • EOG/COG Champion: Name of executive officer if not project sponsor. 
  • Project Sponsor: name of project sponsor. 
  • Project Manager: name of project manager 
  • Project Risk Indicator (PRI):  Select Low, Medium or High, depending how project scored in the 
  • Project Risk Indicator (PRI): The PRI template is completed initially as part of the Business Case, and is revisited at stage gates and change request processes.

4-Status Report Template Sheet - RAG definitions
  • Red: Red status indicates there is a live risk or issue on the project where remedial action is required to bring the project back on track within the parameters set as the baseline. The remedial action has not yet been identified and or is not yet in progress. The risk or issue is not being addressed. 
  • Amber: Amber status indicates there is a live risk or issue on the project; however remedial action(s) have been identified and/or are in progress to bring the project back on track within the parameters set as the baseline. The risk or issue is being addressed. 
  • Green: Green status indicates there is no risk or issue and no action is required at this time. The project is on track to deliver as scheduled and within budget tolerances. 
  • Summary Status: Provide an overview on the project. Provide reason(s) why milestone / deliverable is reporting Red / Amber / Green, and details of any corrective actions taken/planned or decisions to be escalated to Capital Review Group (CRG).

5-Status Report Template Sheet - Project Performance

PROJECT PERFORMANCE (Overall RAG this month vs Previous Month RAG) 
  • Approved: is the baselined project end date (Gate 5) as approved by CRG/Executive Officers/Board - format DD/MM/YYYY. 
  • Forecast: is the estimated end date (Gate 5) for the project.  If there is an ongoing variance between the Approved Schedule End Date and the Forecast Schedule End Date, the PM should raise a Change Request to address the variance. 

Financial (€000s) 
  • Approved: is the baselined project budget approved to spend by CRG/Executive Officers/Board - format (€000s) 
  • Forecast: is the total estimated € spend to deliver the overall project - format (€000s)
  • Actuals are recorded in cell under Approved/Forecast 
Effort (Man-days)
  • Approved: is the baselined number of man-days as approved by CRG/Executive Officers/Board - format (whole number) 
  • Forecast: is the total estimated man-days required to deliver the project - format (whole number) Actuals are recorded in cell under Approved/Forecast 

Benefits (€000s) 
  • Approved: is the baselined project benefits as approved by Executive Officers/Board - format (€000s) 
  • Forecast: is the total forecast business benefits to be delivered by the project - format (€000s) Actuals are recorded in cell under Approved/Forecast.

6-Status Report Template Sheet - Gates
Gates: Complete table for all Gates. 
  • Enter 'Not Applicable' only if agreed by CRG that Gate is not required by project. 
  • Approved date column is Gate Date as approved by CRG and can only be amended if a CR is approved by CRG. 
  • Enter Forecast Date if Date of Gate forecast to be different than Approved Date. 
  • Dates will be highlighted Amber if Forecast Date more than 30 days greater than Approved Date. 
  • Even if CRG does not require submission, enter Gate date.

7-Status Report Template Sheet - Milestones/Deliverables
Key Milestones/Deliverables: List the key Deliverable / Milestone details.These should be taken from the Project Business Case/Delivery Plan.

8-Status Report Template Sheet - Achievements/Highlights Last Period
Achievements / Highlights since last period:  List any project achievements/objectives met / highlights noted since the last status report was issued.

9-Status Report Template Sheet - Deliverables Due in Next Period
Key Deliverables due in next period: List the Deliverable / Milestone details relevant for the upcoming project period. These should be taken from the project Delivery Plan.

10-Status Report Template Sheet - RAID Key Risks/Assumptions/Issues/Dependencies
  • R.A.I.D Key Risks/ Assumptions/Issues/Dependencies: List key project Risks / Issues/Dependencies from the Project RAID Log deemed relevant for the project status report e.g. for inclusion in the pack for Steering Committee/Management Committee meeting. The RAG Status is automatically calculated from the Probability and Impact scores (for Risk) and Priority (for Issue) in exactly the same way as in the RAID log. 
  • List Key Actions to Mitigate/Resolve: List any actions from the project Action Log deemed relevant for the project status report e.g. for inclusion in the pack for project Steering Committee / PMO Steering Committee meeting.
Download also:

5 Comments

Post a Comment

Previous Post Next Post