Timesheet

Timesheet

The timesheet is the period's attendance per person: days worked, tardiness, absences, overtime, night differential, holiday work and leave, with each employee's problem days flagged. Use it to review your team before payroll, email people to fix their days, accept the rest as they are, and export the figures. It is the last place an attendance problem is still cheap to fix.

Where: Attendance › Timesheet. Also opened from a payroll checklist's Confirm attendance step, limited to that batch.

You need:

  • The Team Attendance right to see the rows
  • The Attendance Manager or Attendance Administrator right to email employees and mark them reviewed

How to review your team before payroll

  1. Go to Attendance › Timesheet. It opens on the cut-off period that contains today, taken from your primary pay cycle, or on the current month if there is none.
  2. Use Search Employee or Filters to narrow it to your team.
  3. Select Needs review to see only people with flagged days.
  4. Select a person to open their detail drawer. It lists each flagged day with its scheduled and actual times.
  5. For each day, either select Amend to correct it, or Email to ask the employee to fix it.
  6. When the remaining flags are acceptable, select Mark reviewed. The person moves to Reviewed.
  7. To email everyone flagged at once, select Email all not yet contacted.

How to export the timesheet

  1. Set the timeframe and filters.
  2. Select Export and choose Microsoft Excel (.xlsx), Simplified report (.xlsx) or DTR Form 48 (.pdf).
  3. For the full Excel file, choose the fields you want.

The full file covers every matching employee, whatever tile or status segment is pressed. DTR Form 48, the Philippine Civil Service daily time record, shows only for Civil Service companies and covers the calendar month the timeframe starts in. The simplified file and DTR Form 48 cannot be limited to one payroll batch.

When to use this, and when not to

The questionWhere to go
Is my team's attendance ready for payroll?Timesheet, here
Why is this specific day wrong?Event List
What needs fixing today?Dashboard
Hours for employees paid from timelogs?Time logs

Totals

Worked (days), Tardy (hours), Absences (days), Overtime (hours), Night diff (hours) and Holiday Work (days). Select one other than Worked to show only people with some, and again to clear it. Absences also shows people with a missing check-in or check-out.

Columns

Days are hours divided by each person's expected hours, so an 8-hour shift for someone on 8 hours is 1.0 day. Hover over a heading for its short definition.

ColumnWhat it counts
StatusWhere the person stands, with who accepted the flags or when they were emailed
Working (d)Scheduled hours, less breaks, on working activities. Scheduled, not clocked
Rest (d)Rest-day events. A full-day rest day is 1
TardyTardy charged after grace and rounding. Hover for Tardy in, Break tardy and Undertime, the raw minutes before grace
AbsencesAbsent days credited, with how many days. Missing punches are flagged separately
OTOvertime window hours, plus the full hours of activities tagged as overtime pay
Night diffNight differential hours, including those inside overtime
Holiday workingScheduled hours on days with a holiday type, rest days included
Leave paidAll leave days, paid and unpaid, despite its label
UnpaidThe unpaid part of that leave
Payable (d)Working days with a valid check-in, less tardy. Absent and incomplete days count as 0
Working Less Absent and OvertimeHidden by default. Working days, leaving out overtime activities, less absent days
Needs attentionThe person's flags, such as "Tardy 2×", or Nothing flagged

Flags and status segments

FlagRaised when
Missing time-outChecked in, never checked out
Missing time-inNo check-in, but a break or check-out was recorded
Absent, no leave filedNo punch at all, or credited absent, with no leave request on file. Pending leave counts as filed
TardyAny tardiness, even one minute

The segments split everyone into exactly one group: All, Needs review (flagged, not emailed, not reviewed), Notified (flagged and emailed), Reviewed (flags accepted) and Clean (nothing flagged).

Mark reviewed records who accepted the flags, when, and an optional note. It changes no figures and locks nothing. Undo review mark removes it. Emails record who sent them and which days. Sending again sends a reminder. The line manager is copied by default.

Graph

Graph shows a Breakdown by Subsidiary, Department, Branch, Position or Cost Centre, or a Daily trend, for Working (d), Tardy, Absences, Overtime, Night diff, Holiday Work or Leave. It follows the timeframe and filters, but not the search, and groups by each employee's home branch.

What these figures feed in payroll

Payroll does not read this page, and reviewing does not hold up a payroll run. Payroll reads the same event records, so the timesheet is a faithful preview:

  • Tardy and Absences reduce paid time, where the activity deducts tardy.
  • OT and Night diff are paid at the activity's overtime and night differential rates.
  • Holiday working is paid at the activity's holiday rates.
  • Leave is paid or unpaid according to its leave type.

Fix a day and both the timesheet and the next payroll run change.

What Happens Next

  • Amended days recalculate at once, or once the amendment is approved.
  • The attendance lock stops new requests for past dates on the locked days, so email people early.
  • An export is a snapshot. Re-export after corrections.

Tips

  • Start the week before cut-off. Emailed employees need time to raise corrections.
  • Mark reviewed only what you have looked at. The mark is your sign-off, and it carries your name.
  • Keep the export you paid from. When a payslip is queried months later, it is the answer.

Troubleshooting / FAQ

Q: Why is Leave paid higher than the paid leave I expected? Leave paid includes unpaid leave. Subtract Unpaid.

Q: Why does Payable differ from the hours people worked? It is scheduled days less tardy, not clocked hours. Extra time shows only as overtime.

Q: The drawer shows no flagged days, but the row has flags. The drawer can miss the last day of the timeframe. Open that day on the Event List.

Q: Mark reviewed says nothing was flagged. If the person's only flag is on the last day of the timeframe, widen the timeframe by a day and try again.

Related articles