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
- 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.
- Use Search Employee or Filters to narrow it to your team.
- Select Needs review to see only people with flagged days.
- Select a person to open their detail drawer. It lists each flagged day with its scheduled and actual times.
- For each day, either select Amend to correct it, or Email to ask the employee to fix it.
- When the remaining flags are acceptable, select Mark reviewed. The person moves to Reviewed.
- To email everyone flagged at once, select Email all not yet contacted.
How to export the timesheet
- Set the timeframe and filters.
- Select Export and choose Microsoft Excel (.xlsx), Simplified report (.xlsx) or DTR Form 48 (.pdf).
- 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 question | Where 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.
| Column | What it counts |
|---|---|
| Status | Where 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 |
| Tardy | Tardy charged after grace and rounding. Hover for Tardy in, Break tardy and Undertime, the raw minutes before grace |
| Absences | Absent days credited, with how many days. Missing punches are flagged separately |
| OT | Overtime window hours, plus the full hours of activities tagged as overtime pay |
| Night diff | Night differential hours, including those inside overtime |
| Holiday working | Scheduled hours on days with a holiday type, rest days included |
| Leave paid | All leave days, paid and unpaid, despite its label |
| Unpaid | The 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 Overtime | Hidden by default. Working days, leaving out overtime activities, less absent days |
| Needs attention | The person's flags, such as "Tardy 2×", or Nothing flagged |
Flags and status segments
| Flag | Raised when |
|---|---|
| Missing time-out | Checked in, never checked out |
| Missing time-in | No check-in, but a break or check-out was recorded |
| Absent, no leave filed | No punch at all, or credited absent, with no leave request on file. Pending leave counts as filed |
| Tardy | Any 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.