HR Templates

SMART Objective Tracker

A free Excel tracker for setting and monitoring employee objectives, with space for targets, deadlines, progress, and review notes — built from recruitment and HR administration practice.

SMART Objective Tracker cover

Why I built it

While working in a recruitment agency, I found that performance goals are much easier to manage when they are clear from the beginning.

For example, saying “Improve candidate documentation” does not tell an employee exactly what is expected.

A better objective would be:

“Complete and check all required candidate documents before deployment, and follow up on any missing documents before the final file review.”

Now both the employee and the manager have a clear idea of what needs to be done and how it will be checked.

What the tracker does

  • Records each objective with its specific target and deadline
  • Shows progress in a simple, readable format
  • Keeps review notes with the objective, so the evidence stays together
  • Provides a structure that both the employee and the manager fill in
  • Works for a single role, a department, or a whole appraisal cycle

Who it is for

  • Managers setting objectives for their team at the start of a period
  • HR and admin teams supporting an appraisal cycle in a small or mid-sized company
  • Recruitment agencies managing targets for documentation and deployment work
  • Anyone who has been asked to “set SMART goals” and wants a working example

How to use it

  1. Open the workbook and read the guide sheet first.
  2. Enter the employee’s name, role, and the appraisal period.
  3. Write each objective in the format: action + measure + deadline.
  4. Fill in the target, weight, and review date columns.
  5. Update progress at each check-in — monthly or quarterly.
  6. At the end of the period, record the result and the agreed next step.

The companion article How to Create SMART Goals for Employee Performance Appraisal explains how to write the objectives, and How to Conduct an Employee Performance Review That Is Actually Useful covers the review meeting itself.

What’s included

  • Objective entry sheet with target, measure, and deadline columns
  • Progress and status tracking
  • Review notes section
  • A short built-in guide explaining each column

Limitations and safety notes

  • This is a generic template, not a performance-management policy. Adapt the columns and rating definitions to your own appraisal process.
  • It is a spreadsheet — it contains no macros and no scripts, and it does not connect to any system or send any data anywhere.
  • Objective setting should follow your own HR policy and any applicable employment requirements. For anything unusual, take qualified advice.

Version history

  • 1.0 — 4 September 2026: first release.
  • Last reviewed: 4 October 2026. The structure is unchanged; the explanations above were added.

Community discussion

Comments 0

Comments are reviewed before they appear publicly. Be respectful and avoid sharing private information.

No approved comments yet. You can be the first to share a useful thought.

Add a comment

No account or login is needed. Your comment is emailed for moderation and is published only after approval in the CMS.

Sent securely through Web3Forms. Your email is used only to follow up if needed and is not included in the public comment.