Free template
Benefits register
Short answer
A free Excel benefits register with one row per benefit: baseline, target, latest actual and the next measurement date. % realised = (actual − baseline) ÷ (target − baseline), which works whether higher or lower is better.
Free to use inside your organisation. Please don’t resell it or publish it as your own.
What's inside
Track each benefit after go-live against its baseline and target. % realised works for both higher-is-better and lower-is-better measures.
- Benefits register tab
- How to use tab
How to use it
- One row per benefit. Row 5 is an example; overwrite it.
- Baseline is the value before the project; target is what the business case promised; latest actual is the most recent measurement.
- % realised = (actual − baseline) ÷ (target − baseline). It works for both directions.
- Never add up benefits with different units (days, %, money). Compare them per row.
- Set the next measurement date so someone owns checking it after go-live.