How to create work schedules: a practical guide for SMEs

Organising a team’s schedule seems straightforward until you sit down in front of the spreadsheet: you have to cover every shift, respect rest periods, fit in holidays, account for sick leave and, on top of all that, stay on the right side of the law. If you lose an entire afternoon every month working out who clocks in and who clocks out, this guide is for you. Let’s look, step by step, at how to create work schedules that work for your SME and for your staff.

Planning the working schedule

Before you assign names to the boxes on a rota, you need to plan. And planning means answering one basic question: what does your business need to cover, and when?

The starting point is to identify the company’s daily tasks and the time slots in which they have to be carried out. A shop doesn’t have the same workload peaks as a workshop or a restaurant. That’s why, before distributing staff, it pays to map out demand:

Periods of higher and lower activity throughout the day and the week.
Minimum staffing required in each slot to deliver a quality service.
Profiles and qualifications needed at each moment (not everyone can do every task).
Seasonal peaks or specific events that call for reinforcing the team.

With that map in front of you, distributing staff across shifts stops being a matter of intuition and becomes a data-based decision. What’s more, good planning is the best way to comply with employment law: the Estatuto de los Trabajadores (Spanish Workers’ Statute) sets working-time limits (40 hours a week on average over an annual reference period), minimum rest periods of 12 hours between shifts and a day and a half of weekly rest. If you factor in these limits from the planning stage, you won’t have to rebuild the entire rota later.

Don’t forget the time-recording obligation

Since 2019, in addition to organising schedules, your company is required to record the actual hours worked by each employee. Planning the theoretical shift is one thing; proving the hours actually worked is another. Keep this obligation in mind from the outset, because the rota and time tracking have to go hand in hand. If you want to go deeper, you can rely on time-tracking software that brings both together.

Creating the work schedules

Once you’ve planned, it’s time to build the rota. Here you essentially have two routes.

Option 1: spreadsheets

For a very small company with few employees and stable shifts, a spreadsheet may be enough. It’s free and flexible. But it has a hidden cost: every change is made by hand. A last-minute absence, a shift swap or a holiday request forces you to recalculate the whole rota and notify each person yourself. As the workforce grows, the spreadsheet becomes unmanageable and errors multiply: overlaps, uncovered shifts or rest periods that aren’t respected.

Option 2: shift-management software

When the team grows or shifts are rotating, the efficient approach is to rely on specialist software. A good system generates the rota automatically, taking into account:

The workers available in each slot.
Holidays already approved and expected absences.
Sick leave and last-minute changes.
The qualifications needed for each role.

This gives you an optimal distribution of staff without spending hours on it, and each employee receives their schedule in the app with no chains of messages or misunderstandings.

From the rota to day-to-day: making everything actually add up

Creating the schedule is only the beginning. The real challenge is getting the theoretical shift to match the reality of day-to-day operations, with all their unforeseen events. These are the three pillars that keep things from spiralling out of control:

Clear communication. Everyone should know their schedule in advance and be able to check it at any time. A team app avoids the classic “nobody told me about the change”.
Agile management of holidays and absences. If holiday requests are approved in the same system where the rota lives, you won’t have to cross-reference data by hand or discover an uncovered gap at the last minute.
Integrated time recording. Actual clock-in data tells you whether the planned schedule is being met, whether there are overtime hours you hadn’t anticipated and whether rest periods are being respected. It’s your evidence before the Inspección de Trabajo (Spanish Labour Inspectorate) and your barometer for adjusting future rotas.

Best practices for creating schedules that work

Get ahead of the high season. Publish rotas with enough notice for staff to organise themselves.
Share the load fairly. Rotate the least popular shifts (nights, public holidays, weekends) so they don’t always fall on the same people.
Respect rest periods by default. Configure the system to warn you if a shift breaches the 12-hour rest period between working days.
Listen to your team. Gathering preferences reduces last-minute changes and improves the working atmosphere.
Review and adjust. Compare what you planned against what was clocked in each month and fine-tune the next rota.

Conclusion

Creating work schedules comes down to two phases: planning well (knowing what needs covering and with whom) and building the rota while respecting both the law and the team’s needs. For a micro-business, a spreadsheet may do the job; as soon as the workforce grows or shifts start rotating, management software saves you time, cuts down on errors and gives you the peace of mind of staying compliant. In the end, a good schedule doesn’t just organise the work: it improves service, reduces stress and keeps your team happier.

Want to stop wrestling with Excel every month? Discover how LapsoWork helps you create rotas in minutes and request a free demo.