Control Laboral App
Control Laboral App · Windows + Web
Employee vacation planner Excel template
Plan employee vacation requests in one workbook before deciding how much absence your team can cover. This free template contains an employee list, a request log and a monthly calendar for up to 20 people. You can change the displayed year and month. The downloadable workbook is in Spanish and includes replaceable fictional examples. It uses Excel formulas without macros.
By Control Laboral App · Updated
EUR 4 per employee per month, excluding applicable taxes. 14-day trial without a card.
Email us in English and receive a reply in English. The current application interface is Spanish.
Spanish-language XLSX workbook. Three sheets, 20 employees and 200 requests. Replace the fictional sample data before use.
What the workbook includes
Calendario is the monthly view. It counts employees with approved or pending requests on each day. Empleados provides 20 rows for employee IDs, names, teams and managers. Solicitudes holds up to 200 requests, including start and end dates, status and a note recording the decision.
Yellow cells are editable inputs. Other cells contain formulas or instructions. Review fields identify duplicate IDs, missing or reversed dates, and requests that overlap another approval for the same employee. The workbook language is Spanish throughout.
Set up your team vacation planner
- Replace the example employees and give each person a unique ID.
- Clear the example inputs in Solicitudes while keeping its formula columns.
- Add one row per request, including the employee ID, start date and end date.
- Choose a request status: Pendiente means pending, Aprobada approved, Rechazada rejected and Cancelada cancelled.
- Select the year, month and maximum simultaneous approved absences in Calendario. Review the dates before recording a decision.
Understand the calendar and overlap indicators
A marks an approved absence and P a pending request. A/P means the person has both on that day. Rejected and cancelled requests do not appear in the grid. Daily totals count people rather than requests, so overlapping approvals for one employee do not count that person twice in the approved total.
A daily approved count turns red when it exceeds your chosen maximum. This is a prompt to review coverage. The file does not approve requests, assign substitutes or resolve competing requests for you. The capacity limit is a manual team planning input.
Try the fictional January 2027 example
The opening view is January 2027. Ana, Bruno and Carla are fictional employees whose approved vacation overlaps on January 6 and 7. With a maximum of two simultaneous absences, those daily totals are highlighted. Another pending request for Ana overlaps her approved dates and receives a personal overlap note.
Change a status or date to check the result, then replace the examples. Changing the calendar year or month updates the displayed view; it does not move previously entered request dates into a different year.
Calendar days are not vacation entitlements
Request duration includes both start and end dates and counts calendar days, including weekends and holidays. It is not a working-day calculation or an available vacation balance. The workbook does not apply country holidays, accrual policies, employment agreements or statutory entitlements. Set up and review your own planning rules separately.
Move from a spreadsheet to a shared request workflow
A workbook can help a small team prepare its schedule. When requests and replies become scattered across emails, you can evaluate Control Laboral App: employees submit vacation or day-off requests, managers approve or reject them, and each request retains its visible status. Managers review the monthly team calendar alongside working-time records. The current application interface is Spanish; this English resource does not change that language requirement.
Frequently asked questions
- Is the downloaded workbook in English?
- No. It is a Spanish-language workbook with Spanish sheet names and statuses. This page explains the main fields and workflow in English.
- Can I use the planner in another year?
- Yes. Edit the year and month in Calendario. Request dates remain unchanged and must match the period you are planning.
- Does it calculate PTO accrual or legal leave balances?
- No. It counts calendar-day intervals and displays manually recorded decisions. It does not calculate PTO entitlements, accrual, payroll or statutory balances.
Explore related needs
Tell us what your team needs to manage
The button opens an email draft. Include your country, team size and work devices so we can assess the fit and setup terms.
Discuss your setup