Key points at a glance
- Time tracking in Excel is allowed; no particular form is currently required.
- Excel is free and familiar, but times are usually entered after the fact.
- Changes in a spreadsheet are hard to trace.
- An app saves the time when employees clock in and calculates breaks and overtime automatically.
- Excel can be enough for small teams with fixed hours; with changing work locations an app usually pays off.
Contents
Is time tracking in Excel allowed?
Yes. Since the decision of the Federal Labour Court (BAG) of 13 September 2022, all employers in Germany must record working time, but the court did not prescribe a particular form. An Excel spreadsheet is therefore permitted as long as it fully records the start, end and duration of daily working time. Only the meat industry must record electronically and in a tamper-proof way. Read our guide on time tracking obligations for the details.
A draft bill published by the Federal Ministry of Labour in June 2026 provides that working time should in principle be recorded electronically in the future, with an exception for businesses with up to ten employees. What the electronic form has to look like in detail will only be clear once the final law is passed.
What speaks for Excel
- No extra cost: Many businesses already have Excel.
- Familiar: Your employees do not have to learn anything new.
- Flexible: You adapt columns and formulas yourself.
- Quick to start: A template is all you need, for example our free timesheet template.
Where Excel reaches its limits
- Entered after the fact: Times are often filled in from memory in the evening or at the end of the week.
- No traceability: A normal spreadsheet does not show who changed a time and when.
- Error-prone formulas: A broken formula or a wrong break distorts the monthly total, often unnoticed.
- Many versions: When files are sent back and forth by email, it is unclear which version is correct.
- Lots of manual work: You keep overtime, vacation and sick days in separate lists and merge them by hand for payroll.
- Impractical on the move: On construction sites or in field service, times are usually noted on paper and typed up later.
The comparison at a glance
| Excel | Time tracking app | |
|---|---|---|
| Cost | No extra cost | Ongoing licence fees |
| When times are recorded | Usually after the fact | When clocking in and out |
| Breaks and overtime | Your own formulas | Automatically, based on your rules |
| Changes | Hard to trace | Logged, depending on the provider |
| On the move | Paper or a file | By smartphone |
| Vacation and absences | Separate list | In the same system |
| Reports | By hand | At the push of a button |
| Setup | Immediate | Short setup |
When is Excel enough, and when is an app worth it?
Excel can be enough if
- your team is small and works in one place,
- working hours are largely fixed and
- there is hardly any overtime.
A time tracking app usually pays off if
- your employees work on construction sites or in field service,
- shifts, part-time work or overtime make the calculation complex,
- you belong to one of the industries for which § 17 MiLoG sets fixed recording deadlines, or
- closing the month regularly takes hours.
What to look for in a time tracking app
- Data protection: Where is the data stored? Servers in the EU make GDPR compliance easier.
- Ease of use: Clocking in must take seconds, otherwise it gets forgotten.
- Traceability: Later corrections should be logged.
- Export: It should be possible to export times for your payroll.
- Trial period: Try the app with part of the team before you commit.
- Works council: If you have a works council, it must agree to the introduction (§ 87 (1) no. 6 BetrVG).
How to switch from Excel
- Set up your rules: Create working time models and break rules.
- Carry over balances: Enter remaining vacation and open overtime from your spreadsheet as starting values.
- Test in parallel: Run Excel and the app side by side for a month and compare the results.
How SWTracker helps
With SWTracker, your employees clock in and out with the Companion App or in the browser. Every timestamp is saved immediately, later changes are logged, and SWTracker calculates breaks and overtime based on your rules. You manage vacation and absences in the same system and export the times for payroll. The data is stored on servers in the EU.
Frequently asked questions
Is an Excel spreadsheet valid as a record of working time?
Yes, as long as it fully and traceably records the start, end and duration of daily working time. No particular form is currently required.
Will time tracking have to be electronic in the future?
A draft bill provides for this, with an exception for businesses with up to ten employees. It has not been passed yet.
From how many employees is an app worth it?
There is no fixed threshold. What matters are changing work locations, shifts and overtime. Even with just a few employees on construction sites, an app saves time when closing the month.
Can I carry over my Excel data?
You enter remaining vacation and overtime balances as starting values during setup. You keep older records as before.
Sources
- BAG, decision of 13 September 2022, 1 ABR 22/21
- § 16 Working Hours Act (ArbZG)
- § 17 Minimum Wage Act (MiLoG)
- § 87 Works Constitution Act (BetrVG)
- Draft bill of the BMAS amending the Working Hours Act, June 2026
This guide is for general information only and does not replace legal advice.