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

  1. One row per benefit. Row 5 is an example; overwrite it.
  2. Baseline is the value before the project; target is what the business case promised; latest actual is the most recent measurement.
  3. % realised = (actual − baseline) ÷ (target − baseline). It works for both directions.
  4. Never add up benefits with different units (days, %, money). Compare them per row.
  5. Set the next measurement date so someone owns checking it after go-live.

See your portfolio the way your sponsor should

SprintPM opens soon, in English and Arabic. Join the waitlist to be among the first in.