EN
Blog

Managing Staff Holidays and Absences Without Spreadsheets

How to organise staff holidays and absences without spreadsheets: what the law says, how to request and approve days off, and how to avoid clashes.

Gesthoras team · Infonet Consultores4 min read

Paper diary open at a monthly page showing the days of the calendar and a few handwritten notes

Staff holidays often live in a spreadsheet that someone updates when they remember, in scattered emails and in corridor conversations. It works until two people in the same role go away in the same week, someone doesn't know how many days they have left, or an absence appears nowhere and the working time record shows a gap that nobody can explain. This article explains how to organise holidays and absences so that they don't depend on a single file.

The basics of what the law says about holidays

Article 38 of the Estatuto de los Trabajadores (Spain's Workers' Statute) sets out the general rules:

  • Annual holidays are paid and cannot be replaced by financial compensation. Their length is whatever the collective agreement or the contract sets, and it can never be less than thirty calendar days.
  • Dates are set by mutual agreement between the company and the employee, in accordance with what the collective agreement establishes on annual holiday planning.
  • The holiday calendar is set within each company, and each person must know their dates at least two months before the holiday begins.
  • If the holidays coincide with certain situations, such as temporary incapacity, the law provides that they can be taken on another date, under the conditions of article 38.3 itself.

Your collective agreement may specify much more: working days or calendar days, preferred periods, holiday shifts. Take into account what it says before setting up your system.

Why a spreadsheet falls short

ProblemWhat happens with a spreadsheet
VersionsEach manager has their own copy and none of them match
RequestsThey arrive by email, by message or by word of mouth, and some get lost
Days balanceIt has to be calculated by hand and everyone keeps asking how many days they have left
ClashesNobody notices that two people in the same role overlap until it's too late
Link with clocking inThe absence doesn't appear alongside the working day and the record shows empty days with no explanation
HistoryWhen there is a question from a year ago, it's hard to find out what was approved and when

A simple procedure for requesting and approving days

  1. A single request channel. All requests for holidays and leave come in through the same place. What doesn't come in that way doesn't exist.
  2. Clear deadlines. Set how far in advance summer holidays and those at other times of year must be requested, bearing in mind that each person must know their dates at least two months beforehand.
  3. Known criteria. If highly requested periods have to be shared out, explain how it is decided: rotation, length of service, whatever the collective agreement says. Fewer arguments.
  4. A written reply. Whether approved or not, the reply is recorded with its date.
  5. Visibility for whoever organises the work. The manager needs to see at a glance who is absent each day.
  6. Balance in plain view. Each person should be able to see what they have requested and what has been approved without having to ask.

Absences count too

It's not all about holidays. Leave, sick leave, personal days if your collective agreement provides for them, medical appointments: all of this affects who is working each day. If absences are managed in one place and clocking in in another, problems appear:

  • A day with no clock-ins may be an oversight, a justified absence or an unauthorised absence. If you don't know which, you have to ask.
  • Daily attendance monitoring loses value if it doesn't distinguish between someone who is on holiday and someone who hasn't turned up.
  • When someone reviews the record months later, unexplained gaps raise questions.

Having absences alongside working days saves you from chasing anyone to find out why they didn't clock in.

How to plan the most requested periods

Summer, Christmas and some long weekends account for most requests. If you leave them until the end, everyone asks for the same thing at once and someone ends up without the dates they wanted. A simple timetable for planning them:

  1. Open the request window in good time. With enough margin to resolve requests and communicate the dates at least two months before they begin.
  2. Define how many people can be absent at the same time in each role. For example, in a team of six customer service staff, perhaps no more than two in the same week. It's an internal rule that helps you decide.
  3. Resolve all the requests at once. This is better than approving them in order of arrival, which rewards the quickest rather than the one who needs it most.
  4. Communicate the full calendar. Let each person know their dates and let the team know who covers for whom.
  5. Keep a record of what was approved. Next year it will help you rotate the most sought-after periods.

Common mistakes

  • Approving verbally. Later nobody remembers what was said.
  • Leaving the summer calendar until the last minute. The law requires each person to know their dates two months in advance.
  • Offering money in exchange for holidays. Article 38.1 says they cannot be replaced by financial compensation; if you have a special case, seek advice first.
  • Not looking at critical roles. Approving requests one by one without seeing who else is away that week.
  • Keeping absences outside the clocking-in system and discovering the gaps at the end of the month.

How Gesthoras helps you

With Gesthoras, as each person clocks in for their working day from their mobile, computer, a QR code or the RecLog terminal, you can see in real time who is working, who has finished their day and who hasn't turned up for their shift. The Advanced licence adds management of staff holidays and absences alongside their working days, staff requests in the same place as their clock-ins, and organisation by job categories. That way holidays are no longer in a separate sheet and the working time record can be understood at a glance.

It's explained in real-time attendance monitoring, and if today you keep everything in a file, in the comparison between Excel and Gesthoras you will see the differences.

More articles from the blog

See all

Let’s talk about your business

Our team of experts is ready to help you optimise your time tracking and boost your productivity.

Online support

We are available for your team. WhatsApp +34 621 39 39 47

Sales

Plans tailored to your company. +34 959 54 07 12 · contacto@infonetconsultores.com

Location

Our head office in Huelva (Spain). C/ Lentisco 3, of. 13 · View on map

Join smarter time tracking Start free with no card, and cancel whenever you like.
How it works RecLog Productivity Pricing Contact
Log in Start for free