DTR Consolidator
ServiceMaster PH · Timekeeping
Summaries → 128
Process
Consolidate
Files
Client Summary Files
*
Upload the per-client DTR summary workbooks (already-tallied hours). Each may hold one or many client sheets. Hold Ctrl to select multiple files.
All employees are stacked into one file in the 128 upload format (EMPLOYEECODE, NAME, CLIENT, REG, TARDY, OT, RD, ND, SH/LH variants, VL, SL, TOTAL). REG = days × 8; “c/o FMI” OT is folded into OT/RDOT.
Consolidate & Download
Files
Biometric Files
*
Hold Ctrl to select multiple files.
Masterlist
(optional)
Output
Format
Detailed
Grid
Grid PDF
Payroll Conso (128)
Payroll Assistant
(optional)
Client Code
(optional)
Client / Account name
(optional)
Premium columns (OT, RD, ND, SH/LH, VL, SL) are left blank for manual entry — they aren't derivable from biometric punches alone.
Break Deduction (hrs)
Break Threshold (hrs)
Exclude lates column
Generate DTR
Files
Grid Excel Files
*
Upload the Grid outputs from the Process tab. Hold Ctrl to select multiple files.
Consolidate & Download