DTR Processing System

Active cutoff: May 09-23, 2026

EMPLOYEES IN MASTER
25
TIMELOG RECORDS
361
PROCESSED EMPLOYEES
25
EXPORTS READY
DTR   Payroll
1
Import Files

Upload the employee masterfile (CSV with rate types & shifts) and the raw biometric timelog (CSV or XLS).

Upload Files
2
Process DTR

Apply timekeeping policy: shift clamping, break enforcement, OT computation, absent flagging, night differential, and allowances.

Run Processing
3
Export DTR

Generate the multi-sheet DTR workbook: SUMMARY sheet + individual per-employee sheets with daily adjusted clockings and computed fields.

Generate DTR Download DTR
4
Generate Payroll

Build the payroll workbook: RATES, PAYROLL (gross/net + BIR TRAIN withholding), government deductions summary, and payslip template.

Generate Payroll Download Payroll
Timekeeping Policy — Quick Reference
MONTHLY
  • OT after 10 hrs — ₱200/hr fixed
  • Break = actual duration
  • Clockings as-is, no floor
DAILY
  • Monday = weekly rest day (OFF)
  • Early IN clamped to shift schedule
  • 1-hr break enforced; logout floored to :15
  • Absent on non-Monday working day = −1 day
  • ₱75 present + ₱75 if ≥ 10 hrs
HOURLY
  • OT after 8 hrs + 15 min
  • 1-hr break enforced; logout floored to :15
  • ₱50 transpo if logout ≥ 22:00 / midnight
  • No absent flag — no fixed schedule