Alignment Timesheets

The Alignment report in Timesheets allows you to compare Planned time vs Logged time over a selected period.

This report helps you understand how accurately the work was executed against the plan by showing:

• How much time was planned

• How much time was actually logged

• the difference (Δ Delta, Hours)

• the ratio between them (Plan Match, %)

It is useful for managers, team leads, and project managers who want to track whether work is being logged according to expectations.

Templates

The report follows the same template structure as Timeline Timesheets.

User Timesheets

• Summary

• By Project

• By Issue

• By Epic

Project Timesheets

• Summary

• By User

• By Issue

• By Epic

Epic Timesheets

• Summary

• By User

• By Issue

By default, the report opens in:
User Timesheets → Summary

How the report works

The report compares Planned time and Logged time for each row and period.

Planned time

Planned time is calculated from:

• Jira issue Original Estimate

• Bookings

• Placeholders

• Imported Calendar events

It follows the same logic as planning in the Planner.

Logged time

Logged time is calculated from:

• Jira Worklogs

Optionally:

• Bookings or Calendar events can be treated as logged time if this setting is enabled:
  ActivityTimeline Configuration-> Timesheets Configuration:
  

  

Key metrics

Δ Delta, Hours

This shows the difference between logged and planned time.

Formula:

Δ = Logged time - Planned time

Examples:

• Planned 40h, Logged 45h → +5h

• Planned 40h, Logged 38h → -2h

• Planned 40h, Logged 40h → 0h

Interpretation:

• Positive (+) → more time logged than planned

• Negative (-) → less time logged than planned

Plan Match, %

This shows how logged time compares to planned time.

Formula:

Plan Match (%) = (Logged time / Planned time) × 100

Examples:

• Planned 40h, Logged 40h → 100%

• Planned 40h, Logged 20h → 50%

• Planned 40h, Logged 80h → 200%

Important:

• This is a ratio, not a performance score

• 100% = exact match

• >100% = more time logged than planned

• <100% = less time logged than planned

Display modes

The report has two display modes:

1. Δ Delta, Hours (default)

• Time buckets show difference in hours

• Examples:

  • +5h

  • -2h

  • 0h

2. Plan Match, %

• Time buckets show percentage values

• Cells may include a progress-style fill

Color coding

Cells are always colored based on Plan Match (%), regardless of the display mode.

Color ranges:

• < 50% → yellow

• 50% – 87% → light green

• 87% – 101% → green

• 101% – 125% → light red / orange

• 125%+ → red

This allows you to quickly identify:

• under-logging

• balanced execution

• over-logging

Out-of-office, holidays, and weekends

The Alignment report does not adjust calculations based on:

• days off

• holidays

• weekends

The report always compares:
Planned time vs Logged time

Example:

• Planned: 40h

• User had 2 days off

• Logged: 24h

Result:

• Plan Match = 60%

• Δ = -16h

Important behavior

If a user has a day off for the entire period (day/week/month), the system will not calculate planned time for that period.

In such cases:

• Planned time is treated as 0h

• Any logged time is considered over logging
  

  

Example:

• Planned: 0h (due to full day/week off)

• Logged: 8.5h

Result:

• Δ = +8.5h

• Plan Match → not applicable

Export

You can export the report using the Excel button.

The export includes the currently visible data:

• selected template

• filters

• grouping

• time range

FAQ

Why is Plan Match 200%?

Because more time was logged than planned.
Example: Planned 40h, Logged 80h → 200% (2× the planned effort).

Why is my Delta negative?

Because logged time is lower than planned time.
Example: Planned 40h, Logged 30h → Δ = -10h.

No. The Alignment report does not adjust calculations based on non-working days such as:

• holidays

• days off

• weekends

The report always compares:
Planned time vs Logged time

However, there is an important exception:

If a user has no capacity for the entire period (for example, a full day or week off), then:

• Planned time is treated as 0h

• Any logged time is considered unplanned (over logging)

Why is the cell colored when I am viewing Delta?

Color is always based on Plan Match (%), even in Δ Delta mode.

Are percentages averaged across rows?

No. The system:

• sums Planned time

• sums Logged time

• then calculates Plan Match from totals.