Overtime tracking Excel template
Track overtime per employee: worked hours versus contract hours, automatic overtime balance and a column for time-off-in-lieu or payout.
With this free overtime template for Excel you track per week how many hours an employee worked compared to their contract hours. The difference — overtime or undertime — is calculated automatically and accumulated into a running balance.
Per row you indicate whether overtime is paid out or taken as time off in lieu. That prevents discussions with employees and gives you a solid overtime administration for payroll.
Note: under the Dutch Working Hours Act employers must keep a proper record of working times. For teams, software with an approval workflow like PrikKlokPlus is more reliable than loose Excel files.
What's inside?
- Weekly log: contract hours, worked hours and automatic difference
- Running overtime balance per employee
- Column for payout or time off in lieu
- Instructions tab included
- Works in Excel, Google Sheets and LibreOffice
Frequently asked questions
Am I required to record overtime as an employer?
Yes. The Dutch Working Hours Act requires employers to keep a proper record of working and rest times, including overtime. The Netherlands Labour Authority can ask for this record during an inspection.
Does overtime always have to be paid out?
That depends on the employment contract and the collective agreement. Many CAOs offer a choice between payout and time off in lieu. Since 2019, overtime for minimum-wage earners must be compensated at least at minimum wage.
How do I prevent disputes about the overtime balance?
Record weekly and give the employee visibility. Even better is a system where the employee logs hours and the manager approves them — then the balance is always confirmed by both sides.
🔜 Free next week
Dutch holidays calendar 2026–2027 (.ics)
All official Dutch public holidays of 2026 and 2027 as an .ics file — import at once into Outlook, Google Calendar and Apple Calendar.
Available from 01/09/2026