Free template

Timesheet template

A timesheet for one month, as Excel with formulas and as a PDF to print. Enter start, breaks and end: the Excel file calculates working time, weekly total, target and balance by itself.

Free and without sign-up. For Excel and LibreOffice, no macros, A4 print area.

Download the template

In other languages: German Excel, PDF; French Excel, PDF

Extract from the PDF template, with sample rows. In Excel the grey columns calculate by themselves.

How to fill in the timesheet

  1. Enter name, employer, month and year at the top. In the Excel file, date and weekday then fill in by themselves.
  2. Write start and end of each working day as a time, for example 07:30 and 17:00. If work ends after midnight, simply enter the time.
  3. Enter the main break with its start and end. Write further short breaks as minutes in the column next to it.
  4. If you want a balance, enter the target per day, for example 8:24 for 42 hours a week. Choose public holiday, rest day, vacation, sick or accident in the remark column.
  5. At the end of the month, the employee and the employer sign. Keep the timesheet for at least 5 years.

Timesheets right on the phone

In Stunden your staff clock in with one click, on the phone or in the browser. Breaks are recorded separately, every change to a time entry is logged with person and time, and the record of working time stays available for at least 5 years.

Timesheets in Switzerland: what they should contain

What must a timesheet contain?

Item under ArGV 1 Art. 73In this template
Personal details and type of workName, employer, workload
Daily and weekly working time and when it was workedStart, end, working time, week
Compensatory work and overtimeTarget, balance, remark compensation
Timing and length of breaks of half an hour or moreBreak from and to
Weekly rest days and compensatory rest days grantedRemark 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.