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.
| Daily Time Record (DTR) with night differential — Philippines | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sample figures: replace the names, rate and times with yours. Yellow cells are inputs. | ||||||||||||
| Employer | Sampaguita Trading (sample) | |||||||||||
| Employee | Santos, Maria L. | |||||||||||
| Cut-off period | 16–30 November 2026 | |||||||||||
| Daily rate (₱) | ₱695.00 | Check the current regional minimum wage order. | ||||||||||
| Hours per normal day | 8 | Labor Code Art. 83 | ||||||||||
| Unpaid break (hours) | 1.0 | Meal break is not hours worked (Art. 85). | ||||||||||
| Night differential | 10% | Each hour worked 10:00 pm – 6:00 am, at least 10% (Art. 86). | ||||||||||
| Date | Day type | Time in | Time out | Hours worked | Regular hours | Overtime hours | Night hours (10 pm–6 am) | Day rate | Basic / holiday pay (₱) | Overtime pay (₱) | Night differential (₱) | Day total (₱) |
| Mon 16 Nov | Ordinary working day | 8:00 | 17:00 | 8.00 | 8.00 | 0.00 | 0.00 | 100% | ₱695.00 | ₱0.00 | ₱0.00 | ₱695.00 |
| Tue 17 Nov | Ordinary working day | 8:00 | 19:00 | 10.00 | 8.00 | 2.00 | 0.00 | 100% | ₱695.00 | ₱217.19 | ₱0.00 | ₱912.19 |
| Wed 18 Nov | Ordinary working day | 22:00 | 7:00 | 8.00 | 8.00 | 0.00 | 8.00 | 100% | ₱695.00 | ₱0.00 | ₱69.50 | ₱764.50 |
| Thu 19 Nov | Ordinary working day | 22:00 | 7:00 | 8.00 | 8.00 | 0.00 | 8.00 | 100% | ₱695.00 | ₱0.00 | ₱69.50 | ₱764.50 |
| Sun 22 Nov | Rest day | 8:00 | 17:00 | 8.00 | 8.00 | 0.00 | 0.00 | 130% | ₱903.50 | ₱0.00 | ₱0.00 | ₱903.50 |
| Fri 27 Nov | Ordinary working day | 14:00 | 1:00 | 10.00 | 8.00 | 2.00 | 3.00 | 100% | ₱695.00 | ₱217.19 | ₱30.41 | ₱942.59 |
| Mon 30 Nov | Regular holiday | 22:00 | 7:00 | 8.00 | 8.00 | 0.00 | 8.00 | 200% | ₱1,390.00 | ₱0.00 | ₱139.00 | ₱1,529.00 |
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| 0.00 | 0.00 | 0.00 | 0.00 | ₱0.00 | ₱0.00 | ₱0.00 | ₱0.00 | |||||
| Total | 60.00 | 56.00 | 4.00 | 27.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. |
| Day type | Rate for the day | Overtime premium |
|---|---|---|
| Ordinary working day | 100% | 25% |
| Rest day | 130% | 30% |
| Special non-working day | 130% | 30% |
| Special day on rest day | 150% | 30% |
| Regular holiday | 200% | 30% |
| Regular holiday on rest day | 260% | 30% |
| Regular holiday - not worked | 100% | 0% |
| Source: Labor Code of the Philippines, Arts. 86, 87, 93, 94; DOLE Handbook on Workers' Statutory Monetary Benefits. |