Free Excel template

Free timesheet template for Excel

One timesheet per employee per month, with the start, end and breaks for each day. The hours, the contracted hours and the hours over and under are worked out for you, and it prints on one page.

Excel file (.xlsx) · Opens in Excel, Google Sheets and LibreOffice · No sign-up

What’s in the timesheet

The timesheet is made for businesses that record working time in a spreadsheet and want to do it properly – with the numbers you need for payroll and time off in lieu.

  • Start, end and break for each day

    One row for every day of the month, with the date and weekday filled in. Enter the start, the end and the break in minutes, and the hours are worked out for you.

  • Contracted hours for the month

    Enter the contracted weekly hours, e.g. 40, and the number of public holidays. The template works out the working days and the contracted hours for the month.

  • Hours over and under

    At the bottom you see the hours worked, the contracted hours after vacation and absence, and the difference – so overtime and missing hours stand out.

  • Vacation and absence

    Pick vacation, sick, time off in lieu or other absence from the list. Absence on weekdays lowers the contracted hours.

  • Project and note

    A column for a project, a client or a short explanation, such as why a day ran longer than usual.

  • Ready to print

    Fits on one A4 page with lines for the employee’s and the manager’s signature. A sheet with instructions is included.

How to fill in the template

  1. 1

    Fill in the yellow cells

    Enter the employee’s name, the year, the month, the contracted weekly hours and the number of public holidays on weekdays.

  2. 2

    Record each day

    Enter the start and end as hh:mm and the break in minutes. A shift past midnight, e.g. 22:00–02:00, is counted correctly too.

  3. 3

    Mark absence

    Pick the type in the Absence column when the employee is on vacation, off sick or off for another reason.

  4. 4

    Review and save

    Check the hours over and under, let the employee see the timesheet, and save it where it can be found for as long as your country requires.

What you need to know about recording working time

A timesheet is one way to record working time. Here are the rules it should help you follow.

The duty to record working time

In 2019 the EU Court of Justice ruled (C-55/18) that employers must have a system that records the daily working time of each worker. Countries have implemented this in national law at different paces, and in many it applies regardless of the size of the business.

The system must be objective, reliable and accessible. A specific method is usually not required, so a spreadsheet can work – but it’s up to you to make sure it meets the requirements. In practice it should let you:

  • Measure the total daily working time of each employee.
  • Give employees access to their own records.
  • Keep the records for as long as your country’s rules require.
  • Explain how employees can have a record corrected if it’s wrong.

Why start, end and breaks?

The daily working time must be measurable. With the start and end time and the breaks for each day, you have a clear record of the actual working time – not just the planned hours.

The times also make it easier to keep an eye on the EU Working Time Directive: as a rule, at least 11 consecutive hours of rest in every 24 hours, and an average working week of no more than 48 hours, overtime included, over the reference period.

Storing the records

How long the records must be kept depends on your country. With timesheets in spreadsheets, that means a folder per employee and month that mustn’t get lost, overwritten or changed without it showing.

Timesheets contain personal data. Limit access to the people who need it for their work, and delete them according to your company’s retention policy once the retention period has ended.

Read more in our guide to time recording requirements, including who may be exempt.

This is general information, not legal advice. Always check the rules in your country and any agreements that apply to your business.

When the spreadsheet no longer does the job

A timesheet in Excel works well for a couple of employees with fixed hours. But the more of you there are, the more time goes into collecting and checking.

  • There is one file per employee per month that has to be sent out, collected and filed in the right place.
  • You only notice missing days when the month is over – and then someone has to remember what they did.
  • Corrections can’t be seen afterwards, and a formula can be overwritten by accident.
  • Giving employees access to their own records and storing them for the required period is up to you.
  • The hours have to be typed or copied into payroll.

How Weekplace does the same job

  • Employees clock in and out on their phone, or record time straight in the calendar.
  • When an employee has fixed working hours, their time is created automatically every night from the weekly schedule.
  • Vacation, sickness, child’s sick day and other absence are recorded in the same place.
  • The weekly overview flags the days where a record is missing.
  • Employees can see their own records, and you can turn on approval.
  • Reports download as a CSV file for payroll and bookkeeping.

See how time tracking in Weekplace works.

Pay once

€199

one-time · excl. VAT

The same price whatever the number of employees. Pay once and use Weekplace forever.

  • Time tracking, shift scheduling, vacation and absence
  • Unlimited employees
  • No subscription and no monthly payments

No payment to get started

Frequently asked questions about timesheets

Do I have to keep timesheets?

In the EU, employers are generally required to have a system that records each worker’s daily working time, following a 2019 ruling by the EU Court of Justice (C-55/18). Countries have put this into national law at different paces, so check what applies where you are. A specific method is usually not required, so a timesheet can work if it reflects the actual working time and employees can see their own records.

How long should timesheets be kept?

That depends on your country’s rules, so check what applies to you. Keep them somewhere they can’t get lost or be changed by accident, and where only the right people have access.

Can I use the timesheet in Google Sheets?

Yes. The template is an ordinary Excel file (.xlsx) that opens in Excel, Google Sheets and LibreOffice. The formulas work out the hours, the contracted hours and the difference once the file is open.

How are the contracted hours worked out?

The contracted hours per day are the weekly hours divided by five. That is multiplied by the number of weekdays in the month minus public holidays. Absence on weekdays, such as vacation and sickness, lowers the contracted hours, so the difference shows the real hours over and under. Time off in lieu doesn’t lower the contracted hours, because it uses up hours worked over.

What’s the difference between a timesheet and a time tracking system?

A timesheet is one file per employee per month that someone has to collect, check and store. In a time tracking system like Weekplace, employees record their time on their phone, fixed working hours can be recorded automatically, and all records are kept in one place.

Thinking about a system instead? Read about time tracking for small businesses.

More free templates: shift schedule and vacation planner – or see all templates.