DEMO: the computation rules follow your answers. Branch, Day Off and Holidays come from HRIS in the live system; here they are detected from the file and can be changed.
Upload biometrics
Use the Excel exactly as it comes from the biometrics (Name, Id No, Date, Day, Time In, Time Out). You can upload many branch files at once.
Sample: 3 branches, 9 employees, cut-off Oct 16–31, 2026 (fictional names).
How it computes
Based on the rules you gave us.
| Schedule | Detected per branch from the usual time in (follows mall / store hours). 8 hours + 1 hour break. Change it in Review if needed. |
| Late | Per minute after the start time, no grace period. Deducted from the hours. |
| Undertime | Per minute before the end time. |
| Overtime | Branches: automatic, whole hours only (extra minutes are not counted). Head Office: OT slip only. |
| Night differential | 10:00 PM – 6:00 AM (ND OT = overtime hours after 10:00 PM). |
| Rest day | Branches: the employee's Day Off. Head Office: Sunday. |
| Holidays | Legal and Special holidays from the list (from HRIS in the live system). |
Review
OT slip: type the approved OT hours for that day (Head Office needs this; for branches it replaces the automatic OT). Days without time in: mark SIL or Leave if applicable.
Download
Computed DTR (Excel)
Same layout as your file: A–F from the biometrics, I–V computed.
Summary (Excel)
Attendance Editlist, one sheet per branch.
Summary (PDF)
Attendance Editlist, one page per branch. Choose "Save as PDF".
Preview · Attendance Editlist
Choose a branch to preview.