Blog Time records
The spreadsheet time record: when it works and when it stops
Start with the part nobody says: a spreadsheet is legal. No rule imposes a format. The problem is not legality. It is that a spreadsheet proves very little on the day you need to prove something.
It is legal, and that is worth saying
Article 34.9 of the Spanish Workers Statute requires a daily record for the whole workforce, four years of retention, and availability to employees, their representatives and the Labour Inspectorate. It does not say on what medium. A well-kept spreadsheet meets those three on paper.
Where it falls over is the fourth requirement, which is not written as a requirement and decides everything: that the record works as evidence.
The four things a sheet cannot do
- Who changed what, and when. An edited cell leaves no trail. As evidence, a record anyone can quietly retouch is worth roughly what a notebook is worth, which is less than people think.
- The copy the employee is owed. The monthly summary handed over with pay, in a file nobody can dispute afterwards, does not come out of a shared sheet without somebody assembling it by hand every month.
- A figure from three years ago in two minutes. Existing somewhere is not being available. Twelve files a year, named after whoever saved them, do not get produced during a visit.
- A signed correction. Missed clock-ins happen daily. What makes the fix solid is that the employee requests it, somebody else approves it, and the approver is named. In a sheet, fixing it means typing over it.
When it genuinely is enough
Honestly: some companies are well served by a sheet, and rolling out a system is spending their time. They are the ones that meet all four of these at once.
- Fewer than eight or ten people, all at one site.
- The same hours every day, no shifts and no irregular distribution.
- No overtime, or overtime paid in the same month.
- No remote work and nobody working at a client site.
The signals that it is over
Any one of these on its own already makes the sheet cost more than it saves:
- Two sites, or people who rotate between them.
- Shifts, irregular hours or a bank of hours.
- Anybody part-time. Here the exposure changes scale: with no record, article 12.4.c of the Workers Statute presumes the contract was agreed full-time.
- Remote work, even one day a week, because the split by work mode arrives with it.
- A claim, an inspection or a change of payroll provider. That is when you find out what the sheet was not keeping.
The decree in the pipeline rules it out by design
As of 15 October 2026 the Spanish digital-record royal decree is still unpublished, so it requires nothing today. But its draft asks for a digital record, remote access for the Inspectorate and traceability of modifications, and those are exactly the three a sheet cannot deliver. Anybody on a spreadsheet will make the move. The choice is making it with time to spare or against a short adaptation period.
Leaving without losing the history
This is the part that stops half the people who want to move, and it is the easy part. The history imports: the same file you already keep, with validation that tells you row by row what does not add up before anything is written, and a guarantee that running the file twice by mistake does not duplicate a single day. What you had stays, with its original dates, flagged as imported — which is precisely what you want to be able to tell an inspector.
Frequently asked questions
Is keeping a time record in a spreadsheet illegal?
No. Spanish law imposes no medium today: it requires a daily record, four years of retention and availability. A sheet can meet that. What it cannot do is show that nobody altered it, which is what counts on the day of a claim.
Does a sheet signed on paper at month end work?
As evidence it beats an unsigned sheet, but the record has to be daily rather than a monthly declaration after the fact. A sheet signed on the 30th carrying thirty days of hours is not a daily record.
Can we import the years we already keep in spreadsheets?
Yes, and it is worth doing: the history is what an inspection asks for. It imports with row-by-row validation, stays flagged as imported, and re-running the same file duplicates nothing.
All of this is built into Fichaloto. See how it works.
Keep reading
How to choose
Twelve questions worth asking before you sign
None of these twelve questions is technical. Every one of them is answered in a sentence, and you can ask for the answers in writing before signing anything.
Compliance
A clocking record that cannot be quietly rewritten
Most time-tracking tools store hours in a table anyone with database access can edit. That is fine until the day somebody asks you to prove a number.
Capacity
Planned, clocked, charged: three numbers that should match and usually do not
Most companies can tell you what they planned and what they invoiced. Very few can tell you, for a given week, whether those two things are related.