DTR with Night Differential (Philippines)

Fill in

Download PDF — free · Send for signature with proof — $1

Sold by Health Informatic Security System, S.L. (HISS), Spain. Payment processed by Stripe. Your statement shows a line with LAYERS. Refund within 14 days: hello@sumoffice.com.

DTR with Night Differential (Philippines) — page 1

Fill in

Daily Time Record (DTR) with night differential — Philippines
Sample figures: replace the names, rate and times with yours. Yellow cells are inputs.
EmployerSampaguita Trading (sample)
EmployeeSantos, Maria L.
Cut-off period16–30 November 2026
Daily rate (₱)₱695.00Check the current regional minimum wage order.
Hours per normal day8Labor Code Art. 83
Unpaid break (hours)1.0Meal break is not hours worked (Art. 85).
Night differential10%Each hour worked 10:00 pm – 6:00 am, at least 10% (Art. 86).
DateDay typeTime inTime outHours workedRegular hoursOvertime hoursNight hours (10 pm–6 am)Day rateBasic / holiday pay (₱)Overtime pay (₱)Night differential (₱)Day total (₱)
Mon 16 NovOrdinary working day8:0017:008.008.000.000.00100%₱695.00₱0.00₱0.00₱695.00
Tue 17 NovOrdinary working day8:0019:0010.008.002.000.00100%₱695.00₱217.19₱0.00₱912.19
Wed 18 NovOrdinary working day22:007:008.008.000.008.00100%₱695.00₱0.00₱69.50₱764.50
Thu 19 NovOrdinary working day22:007:008.008.000.008.00100%₱695.00₱0.00₱69.50₱764.50
Sun 22 NovRest day8:0017:008.008.000.000.00130%₱903.50₱0.00₱0.00₱903.50
Fri 27 NovOrdinary working day14:001:0010.008.002.003.00100%₱695.00₱217.19₱30.41₱942.59
Mon 30 NovRegular holiday22:007:008.008.000.008.00200%₱1,390.00₱0.00₱139.00₱1,529.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
0.000.000.000.00₱0.00₱0.00₱0.00₱0.00
Total60.0056.004.0027.00₱5,768.50₱434.37₱308.41₱6,511.28
Holiday and rest day premium for the payslip (amount above 100%)₱903.50
Copy to the payslip: Overtime pay, Night differential and the premium above 100% (the row under Total). The payslip basic pay already covers 100% of each day, so do not copy Basic / holiday pay.
Overtime: +25% of the hourly rate on an ordinary day, +30% of the rate for that day on a rest day or holiday (Art. 87).
Rest day or special non-working day worked: 130%; special day on a rest day: 150% (Art. 93).
Regular holiday worked: 200% for the first 8 hours; on a rest day: 260%. Not worked: 100% of the daily rate (Art. 94).
Night differential is 10% of the rate for that hour: 10% of 200% on a regular holiday; on overtime night hours, 10% of the overtime rate (ordinary day 1.25 × 1.10 = 137.5%, rest day 1.30 × 1.30 × 1.10 = 185.9%).
If the break falls between 10 pm and 6 am, reduce the night hours by hand.
Not covered by Art. 86: managerial employees, field personnel, and retail or service businesses regularly employing not more than 5 workers.
Nov 30 (Bonifacio Day) is a regular holiday. Check the yearly holiday proclamation for other dates.