Free template
Status-report pack
Short answer
A free status-report pack: an Excel workbook with one row per project, health from one vocabulary (On track, At risk, Critical, Paused, No data) and a summary that counts each one, plus a one-page Word template for the weekly report on a single project.
Free to use inside your organisation. Please don’t resell it or publish it as your own.
What's inside
A portfolio status workbook that writes the “N of M projects on track” headline for you, and a one-page weekly status report in Word.
- Portfolio status tab
- Summary tab
- How to use tab
- Weekly status (Word) tab
How to use it
- List one project per row on the Portfolio status tab. Row 5 is an example; overwrite it.
- Pick each project’s health from the list: On track, At risk, Critical, Paused or No data. Leave it as No data until someone has assessed it.
- Base health on the plan, dates, progress and overdue work, and write the reason in one sentence.
- Put the decision you need, and by when, in its own column.
- Read the headline on the Summary tab: “N of M projects on track”. Don’t average health into a score.
- Use the Word template for the one-page weekly report, and list its sources so readers can check it.
Read the companion piece: Stop rebuilding project updates from scratch.