Working time records
Working time records in a spreadsheet: when it is enough, and the day it stops being
Spanish law does not require software. It requires the record to be daily, complete, kept for four years and available on request. A spreadsheet can do all four. What it cannot do is prove nobody rewrote it, and that is exactly the question asked on the bad day.
What the law actually asks for
Article 34.9 of the Spanish Workers' Statute, in force since 12 May 2019, requires every company to record daily the start and end of each person's working day. It does not say how. It does not require software, fingerprints or turnstiles: it says what has to exist and for how long.
What it does require, and where most templates fall short:
- Daily and per person — one row per person per day, not a monthly total and not a «9 to 6» written once in January.
- Start and end of the working day — both times. A start time alone is not a working-time record.
- Four years of retention — and findable, not in a folder on a laptop that has since been replaced.
- Available — to the person themselves, to their legal representatives and to the labour inspectorate, on request.
- Per work centre — it matters because the penalty under article 7.5 of the LISOS applies per centre: €751 to €7,500, multiplied by how many you have. The obligation, article by article.
A spreadsheet that complies, if it is filled in every day
If you are going to do this in a spreadsheet, these are the minimum columns: date · person · work centre · clock-in · clock-out · breaks · total hours · notes. One tab per month, one row per person per day, and a sign-off from whoever keeps it.
And these are the three things that break a template like that in practice, in order of frequency: it gets filled in on Friday from memory, so it stops being daily; somebody forgets to clock out and the gap gets filled in by eye; and six months later there are three versions of the file in three places and nobody knows which is the real one.
Where it breaks: not the format, the proof
An inspector is not asking for a sheet with hours on it. They are asking for something harder: proof that those hours are the ones recorded at the time, and not the ones somebody decided last month they should have been. A file anyone can open and rewrite without leaving a trace cannot answer that.
And the risk is not symmetrical. Not keeping the record is a serious offence: €751 to €7,500 per centre. Falsifying it is a very serious offence: €7,501 to €225,018. A spreadsheet does not distinguish between fixing an oversight and falsifying, because both are done the same way and neither leaves a mark.
There is also a royal decree on digital time recording in progress which, if published, would tighten these requirements. As of today it is not in the official gazette, so the spreadsheet is still valid; it is not a good foundation for the next five years, though.
Moving off the sheet without losing the history
The first thing you do when setting up Fichaloto is upload the history: one row per person per day, with its in and out, exactly as it sits in the spreadsheet. It comes in as marks on the register, flagged as imported so they are told apart from those clocked here, and before anything is written the screen shows row by row what will happen and what does not add up.
From then on each mark is chained to the previous one with a fingerprint. Fixing a missed clock-out is still possible — it is requested, someone with permission approves it and it is signed with their name — but the past cannot be rewritten unnoticed, which is precisely what the sheet could not offer. How the chain works.
Frequently asked questions
Is a spreadsheet legal for Spanish working-time records?
Today, yes, if it meets article 34.9: daily, with start and end per person, kept four years and available to the workforce, their representatives and the inspectorate. The law imposes no particular medium. What a spreadsheet does not solve is proving it has not been modified.
Does the employee have to sign the record?
The rule does not require a signature. It does require the record to be available to them, so many companies collect a monthly sign-off as evidence it was provided. Where people clock in themselves, that problem disappears: the record is created by whoever works, not by whoever transcribes it.
Are monthly totals enough?
No. The record has to be daily and capture the start and end of each working day. A monthly total is not a working-time record, and it is one of the failures most often written up.
What if someone forgot to write down a day?
What matters is how it gets fixed. Filling the gap in by eye on a sheet is indistinguishable from falsifying it. In Fichaloto the correction is requested, stating the times, someone with permission approves it, and the mark written is signed with who approved it and when.
Getting started
Fourteen full days, no card and nothing to install. If it has not saved you work by then, there is nothing to cancel. And if you would rather see it first, book a demo and we will set it up with two or three of your real projects, which is where you find out whether it fits.