# Mandatory Work Hours Registration: How to Comply Without Excel (Practical Guide 2026)

> What is required for time registration in Spain, how long to keep it, what fines exist, and how to set it up in an afternoon with TimeTrack: mobile check-in and CSV export.

- **Source (source):** https://aistohire.com/timetrack-time-tracking-and-time-clock-161/blog/mandatory-work-hours-registration-how-to-comply-without-excel
- **Platform (platform):** AIstoHire
- **Language (language):** en
- **Updated (updated):** 2026-11-20

## In summary

- The time registration is **mandatory in Spain since May 12, 2019**, for all companies and with no minimum staff: the **specific time of start and end** of each worker's day must be recorded, every day (art. 34.9 of the Workers' Statute, introduced by Royal Decree-Law 8/2019, of March 8).
- The records are **kept for four years** and must be available to the staff, their legal representatives, and the Labor and Social Security Inspectorate (ITSS).
- Excel is **still legal**, but it is where inspections fail: it is filled out afterwards, does not certify the actual time, and rarely matches the payroll.
- Not keeping it, keeping it incorrectly, or not preserving it is a **serious infringement**: from **€751 to €7,500** per workplace (LISOS, arts. 7.5 and 40.1.b, amounts in effect since Law 10/2021).
- **TimeTrack**, the mini-app for time control from **AIsToHire**, covers the operational part: clocking in from the mobile with breaks, hours bank, vacation with approval, shift schedule, and exporting the record in CSV. It is not labor advice nor does it replace your consultancy.

---

If you have arrived here searching for "mandatory time registration", "how to keep time control" or "Excel template for clocking in", the underlying problem is usually the same: you know you have to register the workday, you are managing it with a spreadsheet or a notebook, and you are not sure if that will suffice the day the Inspection calls. This guide explains **what the regulation exactly requires, what is looked at during an inspection, how much it costs not to comply, and how to set up the record in an afternoon**, with specific steps. In the end, you will see how [TimeTrack, the time control and clocking app from AIsToHire](/timetrack-time-tracking-and-time-clock-161), fits in, and also what things it **does not** do, which is equally important.

> Notice: this article is general information about a regulated subject, not labor or legal advice. Consult your consultancy or a social graduate regarding decisions about your company. Data verified on October 25, 2026.

## What the law exactly requires: the time of entry and exit, every day, for all people

Article 34.9 of the Workers' Statute requires every company to **ensure the daily recording of the workday, with the specific times of start and end of each worker's day**, without prejudice to flexible hours. It has been in effect since May 12, 2019, introduced by Royal Decree-Law 8/2019, of March 8, and **there is no staff threshold**: it applies equally to a company of 300 people as to a hair salon with two.

Three nuances that are often misunderstood:

- **The theoretical schedule of the contract is not enough.** What is registered is the actual work done that day, not what was planned.
- **It also applies to those who telework and those who are part-time.** In part-time contracts, registration was already mandatory before 2019 (art. 12.4.c ET).
- **The system must be "objective, reliable, and accessible."** This is the standard set by the ruling of the Court of Justice of the European Union of May 14, 2019 (case C-55/18, CCOO against Deutsche Bank), which is at the origin of the Spanish regulation.

Labor relations of a special nature with their own regime and workers providing services without a set schedule (top management, art. 2.1.a ET) are exempt from this specific obligation, but the general criterion is the opposite: if you have employees, you must register.

## What the record must contain and how long it must be kept

The minimum content is short: **person, day, start time, and end time**. The retention period is **four years**, and during that time the record must be available to the staff, their representatives, and the ITSS. The rest —breaks, projects, location— is not mandatory under 34.9, but it is what makes the difference when justifying a workday.

| Element | Mandatory? | Basis / nuance |
|---|---|---|
| Identification of the worker | Yes | Art. 34.9 ET |
| Date of the recorded day | Yes | **Daily** record |
| Specific start time | Yes | Art. 34.9 ET |
| Specific end time | Yes | Art. 34.9 ET |
| Breaks and rest periods | No under 34.9 | Essential if deducting time from the effective workday or if there is an agreement regulating it |
| Totals per day, week, and month | No | It allows detecting overtime; the ITSS cross-checks totals with payroll |
| Retention for 4 years | Yes | Art. 34.9 ET |
| Access of the staff to their own record | Yes | Art. 34.9 ET |
| Specific format (paper, Excel, app) | No | The Ministry of Labor's guide (May 2019) does not impose a format, requires reliability |
| Signature of the worker | No | The regulation does not require it; many companies add it as proof |

A practical consequence of the four-year retention: the record is not a paper that gets thrown away at the end of the month. If you keep it on loose sheets, in two years you must be able to pull out the record for March 14 of a specific person in a short time.

## Is it legal to keep time records in Excel? Yes, and yet this is where inspections fail

**Yes, today Excel is still legal.** The guide from the Ministry of Labor from May 2019 expressly admits paper or electronic records, as long as they are reliable and unchangeable. The problem is not the legality of the format: it’s that an Excel sheet filled out afterward does not prove much, and that is exactly what is discussed in an inspection.

![Comparison: on the left a laptop with a spreadsheet and disorganized loose papers; on the right a mobile phone with a stopwatch and organized cards](https://cdn.aistohire.com/i/6115-gscg-qdda-sgfd-zmmi.webp)

Where a spreadsheet fails in practice:

| Weak point | What happens in reality |
|---|---|
| Filled out afterward | On Friday, the five days are completed "from memory," with rounded hours |
| No timestamp | Nothing proves that the 09:00 line was written at 09:00 |
| Editable without a trace | Anyone can change a cell and there is no footprint |
| Filled out by the manager, not the person | It stops being a personal record and becomes a company declaration |
| Does not match the payroll | If the Excel shows 9 hours and the payroll pays 8, there is a contribution difference |
| Gets lost | Four years of loose sheets in a laptop that gets replaced |

The pattern of the report is usually not "I had no record," but **"I had a record that does not hold"**: identical hours logged every day, entries and exits at the exact time, people appearing to clock in on a day they were on leave. A system where each person clocks in at the moment, from their own mobile, eliminates that discussion in one go.

## What the Inspection looks for when presented

During a visit or a request, the ITSS does not just check that a file exists: **it asks for the record of a specific period, cross-references it with payrolls, schedules, and contributions, and looks for discrepancies**. The work record and overtime are a priority campaign within the ITSS Strategic Plan 2025-2027.

Typically, they ask for, with names and dates:

1. The daily record for a specific month, per person.
2. The schedule or the planned shifts for that same period.
3. The payrolls for that month and the payment concepts.
4. The reports of high and low, vacations, and permits.
5. The company agreement or the business decision after consulting with the legal representation on how the record is organized.

Then they look for inconsistencies: people who record more hours than they are paid for, repeated excesses over the limit of 9 hours per day without an agreement, overtime that exceeds the cap of 80 per year, or shifts that do not respect the 12 hours of rest between shifts.

A fact that measures the focus: according to the balance of actions of the ITSS corresponding to 2025, the workday of **18,804 part-time contracts** was extended because more hours were worked than were recorded. The record is not just a documentary procedure; it is the proof with which contracts and contributions are regularized.

## How much it costs not to keep it: the real amounts of the LISOS

Not keeping the record, keeping it defectively, or not preserving it for four years is a **serious infraction** of article 7.5 of the LISOS (Royal Legislative Decree 5/2000). The current range, after the update of amounts of Law 10/2021, of July 9, goes from **€751 to €7,500 per workplace**.

| Degree of serious infraction | Amount |
|---|---|
| Minimum | €751 – €1,500 |
| Medium | €1,501 – €3,750 |
| Maximum | €3,751 – €7,500 |

On top of that, you have to add what usually hurts more: if the record indicates that there are unpaid and unreported hours worked, in addition to the infraction report, the **settlement report** for the contribution differences arrives, with a surcharge. The fine for the paperwork is one thing; the regularization of four years of contributions is another.

## How to set up your team's time tracking in an afternoon

The actual setup involves three decisions and a launch: **defining the reference workday, adding the people, and starting to clock in**. With TimeTrack, those three steps are done from the browser, without installing anything on the computers or mobile devices of the team.

![Diagram of three steps: first a gear and a calendar to configure the workday, then three figures with their avatars to add the team, and finally a mobile clocking in with a download arrow towards a document](https://cdn.aistohire.com/i/5974-bdgu-owoi-qpqi-amca.webp)

### Step 1 — Set the reference workday and working days

In Settings, you configure the company name, the **default weekly workday** (40 hours by default, editable in half hours), **which days are working days** (Monday to Friday by default, marking all seven days individually), the time zone, the **vacation days per year** (22 by default), and the types of absence you want to offer. This weekly workday is used to calculate the theoretical workday for each period: working days in the range × (weekly workday ÷ number of working days). From there, the pool of hours is derived.

If a person has a different schedule than the general one —part-time, reduced hours— their own schedule is entered in their profile, which overrides the company's.

### Step 2 — Bring in your team

There are two paths. The quick one: **synchronize the roster from the active users of your AIsToHire account** with a button; the app links them and tells you how many it has created and how many it has updated. The manual one: adding each person with name, email, department, role, weekly workday, vacation days, start date, and status. Both methods coexist, so you can sync those who already have a user and manually add those who do not.

The distribution of permissions is as expected: the first user of the account and the administrators are **responsible**; the rest are **employees**. An employee can only write and consult their own information.

### Step 3 — Clock in, approve, and export

From there, each person opens the app and clocks in with a tap: entry, any necessary breaks, and exit, with a **live timer that deducts break time**. Each one navigates their part of hours week by week and sees what they have worked, the workday that was assigned to them, and the balance in favor or against, with the details of entries, exits, and breaks for each day. From the same screen, they can request vacations, sick leave, personal matters, or other absences —even half-day ones— check how many days they have left for the year, and can cancel their request while it is still pending.

The responsible person, for their part, sees the **team live** (who has clocked in, who is on break, and since what time), approves or rejects absences with a note, sets up the **shift schedule** by days with colors, and in Reports selects a date range, sees the summary by person, and **exports the clock-ins to CSV** (with BOM UTF-8, so Excel opens it without fighting with accents).

The columns of the CSV are: Employee, Date, Entry, Exit, Breaks (min), Worked (h:mm), and Worked (min). A practical note: **the entry and exit times in the CSV are written in UTC time**, not local time; if your center is in Spain (UTC+1 in winter, UTC+2 in summer), keep this in mind when reviewing the file or when delivering it.

## Breaks, remote work, and overtime: the three areas where the tracking fails

These are the three cases that generate the most doubts and where a poorly set up record stops being useful. **Breaks must be distinguishable, remote work is recorded the same as in-person work, and overtime is detected by comparing what is recorded with the agreed workday.**

- **Breaks.** Article 34.9 does not require them to be recorded by itself, but it does require that the record reflects the actual workday. If you deduct the half hour for lunch from the worked time, you must be able to show where that deduction comes from. In TimeTrack, the break is opened and closed from the same clocking button, and the timer deducts it automatically, so the effective time is calculated without anyone having to subtract manually.
- **Remote work.** Law 10/2021, of July 9, on remote work, refers in its article 14 to the time tracking of 34.9: those who work remotely clock in the same way. A clock-in from the browser resolves this without further ado; the record is identical, only the location changes.
- **Overtime.** Detection comes from comparing what is recorded with the workday that corresponded. The pool of hours in TimeTrack provides exactly that balance (worked versus theoretical, positive or negative) per week and per range. Note: **the app gives you the balance, it does not decide for you whether that excess is overtime, whether it is compensated with rest, or whether it is paid** — that depends on your agreement and what has been negotiated, and it is the territory of your consultancy.

## Geolocation clocking: what can be done and where the limit is

Location can be requested at the time of clocking in, but with three conditions: **it must be provided, it must be informed beforehand and in writing, and it must be limited to the workday**. The legal basis is Article 90 of the LOPDGDD in connection with Article 20.3 of the Workers' Statute, developed in the AEPD guide *Data protection in labor relations* (2021). No consent from the worker is needed —it would not be valid due to the imbalance of the relationship— but the duty of prior information is absolute.

![Top-down diagram of a clocking area: a building with its pin in the center, a green circle with the radius marked, a person inside the circle whose clocking is accepted and another far away, outside the circle, whose clocking is rejected](https://cdn.aistohire.com/i/2040-qpve-ardx-gttu-sbhk.webp)

What makes a difference to the AEPD is **capturing a point at the moment of clocking in** versus **tracking the person throughout the workday**: the former is a punctual and limited check; the latter is continuous monitoring and requires much more demanding justification.

This is how it works in TimeTrack, so you know exactly what is stored:

| Settings Option | What it does |
|---|---|
| Require location (`requireGeo`) | Without coordinates, the clocking is rejected |
| Work area | A point (set with "Use my location") and a **radius in meters**, from 20 to 5,000, with 150 m by default |
| Validation | The **server** calculates the distance to the center of the area and rejects the clocking if it exceeds the radius |
| What is stored | The coordinates at the moment of clocking, along with the record |
| What **is not** done | There is no continuous tracking, no tracking between clockings, no travel history |

And an honest warning about the configuration: if you activate the area but **do not** check "require location", anyone who denies location permission in their browser will be able to clock in without coordinates, because the area is only checked when there are coordinates to verify. If you want the area to be truly binding, both things need to be activated.

Before turning it on: inform each person in writing about what data it is, for what purpose, how long it is retained, who has access, and how to exercise their rights, and include it in the record of processing activities. That part is yours (or your advisor's); the app does not generate that documentation.

## What would change with the digital time registration, and what stage it is at

**As of October 25, 2026, the royal decree on digital time registration has not been published in the BOE and, therefore, is not enforceable.** The 2019 framework remains in effect: registration is mandatory and allows for paper, spreadsheet, or digital system. What exists is a regulation in process with a long history.

| Date | Milestone |
|---|---|
| September 30, 2025 | The Council of Ministers agrees to process it as an independent royal decree, through the urgent route |
| March 2026 | The Council of State issues a **negative opinion** (among other reasons, due to a *vacatio legis* of 20 days considered insufficient) |
| July 24, 2026 | Approval is postponed to correct the text and incorporate observations |
| September and October 2026 | New announcements and new postponements, with no set date |

What the draft proposes, if it ends up being approved in similar terms: **digital format as the only valid one**, traceability and immutability of records, **remote access for Inspections** without the need for a visit, access for the worker to their own record, and —the change with the most consequences— that the sanction is calculated **per affected worker** instead of by workplace. With that rule, a workforce of 100 people without reliable registration would stop moving in a range of €7,500 to discuss figures of another order.

Two cautions: none of this is enforceable until it is published in the BOE, and the final text may differ from the draft. **Check the current status before making decisions** and confirm it with your advisor. What is reasonable is not to wait until the last day: moving from paper to a digital system is a change of habit for the team, not a button.

## What TimeTrack Does and What It Doesn't Do

TimeTrack is the time tracking mini-app from AIsToHire: **it records clock-ins with breaks and optional location, keeps track of hours, manages absences with approval, plans shifts, and exports records in CSV**. It is not a labor consultancy, it does not sign or certify anything, and it does not decide for you how to classify an extra hour.

| Does | Does Not |
|---|---|
| Clock-in and clock-out with live timer and breaks | Does not automatically close an overlooked clock-in: if someone forgets to clock out, the record remains open until it is closed |
| Location at clock-in and work area with radius, validated on the server | Does not provide continuous tracking or geolocation outside of clock-ins |
| Weekly hours report with worked hours, theoretical workday, and balance | Does not classify or settle overtime hours |
| Absences and vacations with request, approval or rejection with note, and half-day | Does not manage payroll, contracts, or contributions |
| Balance of vacation days for the year per person | Does not connect with Social Security or external HR systems |
| Shift schedule by days, with colors, and visible shifts for each employee | Does not send email alerts or push notifications |
| Live team panel: who is clocked in, who is on break, and since when | Does not allow the manager to edit a saved clock-in |
| Manual employee registration and synchronization of the roster from account users | Does not include tablet kiosk, QR, NFC, PIN, or biometrics |
| Export of the range in CSV with BOM UTF-8 (hours in UTC) | Does not generate PDF, signed reports, or qualified time stamping |
| Works from the mobile or computer browser | Is not a native app from the App Store or Google Play, and does not work offline |

To be clear: TimeTrack provides you with **a daily record, per person, with clock-in and clock-out times, stored in the app and exportable** — which is the content required by article 34.9 of the Workers' Statute. What it does not provide is a ruling on whether your organization of working time complies with your agreement: that is decided by your labor advisor.

## Frequently Asked Questions

### Am I required to keep a record of hours if I only have three employees?

Yes. Article 34.9 of the Workers' Statute does not establish any minimum staff: the obligation is the same with 3 people as with 300. It also does not depend on the sector or whether the workday is fixed or flexible.

### Is an Excel sheet signed by everyone at the end of the month acceptable?

Legally, the Excel format is accepted, but a sheet signed at the end of the month is exactly the case that causes the most problems: it does not certify the actual time of entry and exit, and it is modifiable without leaving a trace. If the Inspection detects that the record is filled out afterward or does not match payrolls and schedules, it treats it as a defective record.

### How many years must clock-ins be kept?

Four years, counted from each record, and during that time they must be available to the employee, their legal representatives, and the Labor Inspection (article 34.9 of the Workers' Statute).

### What is the fine for not keeping a time record?

It is a serious infringement of article 7.5 of the LISOS, with a range of €751 to €7,500 per workplace depending on the severity. Additionally, if unreported hours worked are deducted from the record, a liquidation report may be issued for the differences in contributions.

### Can the company require me to clock in using my mobile's GPS?

It can request location at the time of clock-in if it is provided for the intended purpose, informs you in advance and in writing, and is limited to the workday. It does not need your consent, but it must fulfill the duty of information (article 90 LOPDGDD and AEPD guide on data protection in labor relations). Continuous tracking throughout the workday without specific justification is not permissible.

### Do I need to record the lunch break?

Article 34.9 requires recording the start and end of the workday, not each break. However, if you deduct that time from the effective workday, you need to be able to justify the deduction, so in practice, it is advisable to record it. In TimeTrack, the break is marked from the same clock-in button and is automatically deducted from the worked time.

### When does the mandatory digital clock-in come into effect?

As of October 25, 2026, it is not in effect: the royal decree is still in processing and has not been published in the BOE. There was an unfavorable ruling from the Council of State in March 2026 and several subsequent postponements. Until it is published, the 2019 framework remains valid, which allows paper, spreadsheet, or digital system.

### What happens if an employee forgets to clock out?

In TimeTrack, the clock-in remains open until that person closes it, and the app currently does not allow the manager to edit a record that has already been saved. This is a real limitation that is important to know: the practical approach is for the team to close their clock-in on the same day and for the manager to review the live team panel at the end of the workday, where it shows who is still clocked in.

### Do I need to install anything on each employee's mobile?

No. TimeTrack opens in the browser of the mobile or computer within your AIsToHire account. There is no need to install a store app or deploy anything on the devices, and no clock-in hardware is required.

### Can I extract the record to hand it over to the Inspection or my consultancy?

You can export clock-ins for a date range in CSV from Reports, with one row per clock-in: employee, date, entry, exit, break minutes, and worked time in h:mm and minutes. The file includes BOM UTF-8 so that Excel opens it correctly, and the hours are in UTC. How it is presented and what is delivered in each case, consult with your consultancy.

## In a nutshell

TimeTrack is the time tracking mini-app from AIsToHire that records your team's hours —clock in, clock out, and breaks— from your mobile or browser, manages the hour bank, vacations, and shifts, and allows you to export the records in CSV; it's available at [TimeTrack — Time tracking and team management](/timetrack-time-tracking-and-time-clock-161). It covers the operational aspect of time tracking required by art. 34.9 of the Workers' Statute; the interpretation of your agreement and your specific obligations remains the responsibility of your labor consultancy.

> Stop filling out the timesheet at the end of the month. Create your free account on AIsToHire, set up your company's work hours in five minutes, and let your team start clocking in today from their mobile: check-in, check-out, and breaks with a touch, daily hour bank, and the record ready to export in CSV when requested.

- [TimeTrack — Time tracking and team management](https://aistohire.com/timetrack-time-tracking-and-time-clock-161)

## About the platform

**TimeTrack — Time tracking and team management** — an app by AIstoHire. Available at: https://aistohire.com/timetrack-time-tracking-and-time-clock-161/blog/mandatory-work-hours-registration-how-to-comply-without-excel

### Other languages

- `es`: https://aistohire.com/es/timetrack-control-horario-y-fichaje-161/blog/registro-de-jornada-obligatorio-como-cumplirlo-sin-excel
- `fr`: https://aistohire.com/fr/timetrack-suivi-du-temps-et-pointage-161/blog/enregistrement-des-heures-de-travail-obligatoire-comment-s-y-conformer-sans-excel
- `it`: https://aistohire.com/it/timetrack-controllo-orario-e-timbratura-161/blog/registro-obbligatorio-delle-ore-lavorative-come-farlo-senza-excel
- `pt`: https://aistohire.com/pt/timetrack-controle-de-horario-e-ponto-161/blog/registro-de-jornada-obrigatorio-como-cumpri-lo-sem-excel
- `de`: https://aistohire.com/de/timetrack-zeiterfassung-und-stempeluhr-161/blog/pflicht-zur-arbeitszeiterfassung-so-erfuellen-sie-sie-ohne-excel
- `bg`: https://aistohire.com/bg/timetrack-prilozhenie-za-otchitane-na-rabotnoto-vreme-za-firmi-161/blog/zadalzhitelen-registar-na-rabotnoto-vreme-kak-da-go-spazite-bez-excel
- `ja`: https://aistohire.com/ja/kintai-kanri-dakoku-app-161/blog/kinmu-jikan-kiroku-gimu-excel-nashi-taiou
- `nl`: https://aistohire.com/nl/timetrack-tijdregistratie-app-voor-bedrijven-161/blog/verplichte-werktijdregistratie-spanje-voldoen-zonder-excel
- `ko`: https://aistohire.com/ko/timetrack-geuntae-gwanri-chultoegeun-161/blog/geunro-sigan-girok-uimu-excel-eopsi-jikigi
- `sv`: https://aistohire.com/sv/timetrack-app-for-in-och-utstampling-och-tidrapportering-for-foretag-161/blog/obligatorisk-tidsregistrering-sa-uppfyller-du-den-utan-excel
- `da`: https://aistohire.com/da/timetrack-app-til-tidsregistrering-for-virksomheder-161/blog/obligatorisk-arbejdstidsregistrering-uden-excel
- `ar`: https://aistohire.com/ar/timetrack-ttbiq-tsjil-alhdur-wmtabaa-alsaaat-llshrkat-161/blog/sijil-al-dawam-al-ilzami-kayfa-tltazim-bihi-bidun-excel
- `no`: https://aistohire.com/no/timetrack-app-for-innstempling-og-tidsregistrering-for-bedrifter-161/blog/obligatorisk-tidsregistrering-slik-oppfyller-du-den-uten-excel
- `fi`: https://aistohire.com/fi/timetrack-leimaus-ja-tyoajanseurantasovellus-yrityksille-161/blog/pakollinen-tyoajan-kirjaus-ilman-exelia
- `zh`: https://aistohire.com/zh/timetrack-time-clock-app-161/blog/mandatory-working-time-record-without-excel
- `pl`: https://aistohire.com/pl/timetrack-aplikacja-do-ewidencji-czasu-pracy-dla-firm-161/blog/obowiazkowa-ewidencja-czasu-pracy-jak-spelnic-bez-excela
- `he`: https://aistohire.com/he/timetrack-apliktsiit-shaon-nokchot-laskim-161/blog/rishum-shaot-avoda-chova-eich-la-amod-bli-excel
- `cs`: https://aistohire.com/cs/timetrack-aplikace-pro-dochazku-a-evidenci-pracovni-doby-161/blog/povinna-evidence-pracovni-doby-jak-ji-splnit-bez-excelu
- `id`: https://aistohire.com/id/timetrack-aplikasi-absensi-dan-jam-kerja-untuk-perusahaan-161/blog/pencatatan-jam-kerja-wajib-cara-memenuhinya-tanpa-excel
