Free timesheet template for Excel and PDF

With this template, your employees record the start, end and breaks of every working day. The Excel version calculates the daily working time and the monthly total automatically, the PDF version is for printing and filling in by hand. The templates are in German.

Preview of the timesheet template with columns for date, start, end, break, working time, project or job site and notes

Timesheet Excel

Enter month and year and the days fill in automatically. Working time and monthly total are calculated.

Download Excel

Timesheet PDF

For printing and filling in by hand, with a column for project or job site and fields for two signatures.

Download PDF

What the template contains

  • Name, personnel number, month and year
  • Per day: date, start, end, break, working time, project or job site, notes
  • Monthly total of working time
  • Signatures of employee and employer

How to fill in the timesheet

  1. Enter the header

    Name, personnel number, month and year.

  2. Record daily

    Start, end and break in minutes. The Excel version calculates the working time.

  3. Check and sign

    At the end of the month, both sides check the total and sign.

What must a timesheet contain?

Where the German Minimum Wage Act requires records, for example for mini-jobs and in sectors such as construction, the start, end and duration of daily working time must be recorded no later than the end of the seventh day after the work was performed and kept for at least two years (§ 17 MiLoG). Since the Federal Labour Court's decision of 13 September 2022, employers are also generally obliged to record their employees' working time. Learn more in our guide on time tracking.

Clock in by app instead of paper

Paper timesheets get lost, are filled in after the fact and have to be typed up for payroll. With SWTracker, your employees clock in via the app or in the browser, and breaks and overtime are calculated automatically according to your rules.

Frequently asked questions

Is an Excel timesheet permitted?

Yes. No specific format is currently required, only the meat industry must record electronically. What matters is that the start, end and duration of working time are recorded completely and on time.

Does the timesheet have to be signed?

A signature is not required by law. It does help with later disagreements, though, because both sides have confirmed the hours.

How long do I have to keep timesheets?

Records under § 17 MiLoG for at least two years. If the timesheets serve as the basis for payroll, longer retention periods under tax law may apply.

In what format does the Excel template show working time?

In decimal hours, for example 7.75 instead of 7:45. You enter the break in minutes, and it is deducted automatically.