Timesheets in Switzerland: what they should contain
What must a timesheet contain?
| Item under ArGV 1 Art. 73 | In this template |
|---|---|
| Personal details and type of work | Name, employer, workload |
| Daily and weekly working time and when it was worked | Start, end, working time, week |
| Compensatory work and overtime | Target, balance, remark compensation |
| Timing and length of breaks of half an hour or more | Break from and to |
| Weekly rest days and compensatory rest days granted | Remark rest day |
Employers must record the information needed to enforce the Employment Act and be able to show it to the authorities. The ordinance lists, among other things, the daily and weekly working time including compensatory work and overtime, when it was worked, rest days and breaks of half an hour or more. Depending on the business, night and Sunday work and time supplements are added.
ArG Art. 46; ArGV 1 Art. 73 Abs. 1
How long must timesheets be kept?
Working time records must be kept for at least 5 years after they cease to apply. This applies equally to paper, PDF and Excel. If hours are the basis for pay or invoices, longer periods may apply for accounting.
ArGV 1 Art. 73 Abs. 2; OR Art. 958f
Simplified recording and waiver
For staff who can largely set their own working hours, an agreement may provide that only the total daily working time is recorded; night and Sunday work must still be recorded in full with start and end. As things stand, recording may be waived entirely only by businesses with a collective agreement that provides for it, and only for staff with a high degree of autonomy, a gross annual salary subject to AHV including bonuses above CHF 120,000 and an individual written agreement. For everyone else, full recording applies. Check the exact conditions for each case.
ArGV 1 Art. 73a and 73b
Entering breaks correctly
Breaks are not working time and are deducted. Breaks of half an hour or more must be recorded with their timing and length, which is why the template has from and to fields for the main break. Enter shorter breaks as minutes. The break calculator shows how long the break must be at least.
ArG Art. 15; ArGV 1 Art. 18 and 73
Target, actual and balance
The daily target follows from the contractual weekly hours and the workload, for example 42 hours divided by 5 days equals 8:24. The template credits vacation, sickness and accident with the target of the day; public holidays and rest days set the target to zero. A positive balance means extra hours. Whether they become overtime under the Employment Act depends on the maximum weekly working time; the overtime calculator shows this.
OR Art. 321c; ArG Art. 9, 12 and 13
Work past midnight
If the end is before the start, the Excel template treats it as a time on the next day. A shift from 22:00 to 06:00 therefore comes out at 8 hours. A single row can hold less than 24 hours. Enter the shift in the row of the day it starts.
ArG Art. 10 and 16
Paper, Excel or an app?
A timesheet on paper or in Excel can meet the recording duty if it is complete, legible and available for 5 years. What matters is that times are entered promptly and changes can be traced. With an app, staff clock in directly, and totals, balance and filing happen without retyping. What fits better depends on the size of the team and the number of work sites.
ArGV 1 Art. 73
More free calculators and templates for working time, breaks, overtime and holidays: Free calculators
Frequently asked questions
Is the timesheet template free?
Yes. The Excel and PDF files are free and without sign-up, in German, French and English.
Does the template work in LibreOffice and on a Mac?
Yes. The file is a standard Excel format (.xlsx) without macros and calculates in Excel for Windows and Mac and in LibreOffice. The weekdays are written as text in the formulas, so they appear in English whatever the language of your program.
How do I enter working hours past midnight?
Enter start and end as times, for example 22:00 and 06:00. If the end is before the start, the template counts it on the next day. A row can hold less than 24 hours.
Why does the template show no balance?
The balance only appears once a target per day is entered at the top. Without a target, the template only calculates working time per day, week and month.
Does a timesheet have to be signed?
The law does not require a signature. If both sides sign at the end of the month, however, it is clear that the times were checked and accepted. That helps if extra hours are disputed later.
How long do I have to keep timesheets?
At least 5 years after they cease to apply (ArGV 1 Art. 73 Abs. 2). This applies to paper and to electronic timesheets.
Does the recording duty also apply to part-time and hourly paid staff?
Yes. The recording duty applies to all employees covered by the Employment Act, whatever their workload or form of pay. Exceptions exist only under ArGV 1 Art. 73a and 73b.
Can I adapt the template for my team?
Yes. You may rename columns, add your logo and share the file internally. Do not overwrite the formulas in the grey columns.