The Scenario
Your business has grown from a dozen staff to forty-five, and holiday is still tracked the way it was when it was twelve people: a master spreadsheet maintained by the office manager. Holiday requests come in by Slack DM or email. The office manager updates the spreadsheet, replies to confirm, and adds the dates to a shared calendar. Each team lead is meant to check the spreadsheet before approving but most of them check the calendar, or just say yes.
Balances are calculated manually at year end. Carry-over rules are applied informally. The spreadsheet has been edited by enough people over the years that there are formulas pointing to deleted rows and cells with hard-coded numbers nobody can trace.
The Problem
The specific frustration is the day three people on the same five-person team are off at once and nobody noticed until two of them were already on their flights. The team lead approved each request individually and did not see the overlap. The office manager noticed but did not flag it because, technically, all three requests were within entitlement. The cover gap surfaces on the Monday morning when client emails go unanswered and the remaining two team members work flat out for a week.
The cost beneath is the slow erosion of accuracy. Balances at year end are estimates rather than exact figures. Carry-over disputes happen because the rule has been applied differently by different managers in different years. Bank holidays are sometimes counted, sometimes not. Maternity, paternity, and bereavement leave are recorded in side notes that nobody knows where to look up. The HR conversation that should be straightforward — “how much leave do I have left this year” — turns into a five-day investigation by the office manager.
The Approach
A proper leave management system replaces the spreadsheet with structured requests, automatic balance calculation, and team cover visibility. Each employee sees their own balance, requests leave through a simple interface, and gets a transparent breakdown of how the balance was calculated. Team leads see their team’s calendar, including the overlap warnings that the spreadsheet could not catch — “approving this request leaves two engineers on a team of five during a school holiday week.”
The system is built on a workflow automation system and integrated with the HR platform through an API integration so contractual entitlement, joiner pro-rata, leavers, and policy changes flow through automatically. Approval workflows respect the company’s escalation rules. Carry-over rules are applied consistently across every employee rather than being interpreted manager-by-manager. Special leave types — sickness, maternity, paternity, bereavement, sabbatical — are captured properly with the right policy controls. Calendar integration pushes approved leave into the team calendar and the absent person’s out-of-office in the email system.
The Outcome
The “three people off at once” problem stops because team leads see the cover picture at the moment they approve a request, not after the fact. Holiday balances are accurate to the day, accessible to each employee at any time, and immune to the spreadsheet errors that used to require year-end reconciliation. The office manager reclaims the time that used to go into spreadsheet maintenance and year-end balance corrections.
The HR conversation tightens. “How much leave do I have” gets answered in three seconds by the employee themselves. Carry-over disputes effectively stop because the rule is applied consistently and visibly. When the business hires its next ten people, the leave system scales with them without any spreadsheet drama. And the small things — maternity records being where they should be, sabbatical agreements being recorded properly, sickness patterns being visible at the right level — start to add up to a people function that feels grown-up rather than improvised.
Who This Applies To
People leaders, office managers, and operations leads at businesses between twenty and three hundred staff still running holiday on a spreadsheet or on a basic HR tool that lacks proper team cover visibility. Particularly relevant where teams have grown organically and the spreadsheet has aged beyond what anyone can comfortably maintain. Also applies to multi-site businesses where consistent application of leave policy across locations has become harder to enforce.
Take the Next Step
If your office manager is the single point of failure for everyone’s holiday balance, the spreadsheet has done its job and it is time to retire it. We build leave management systems that integrate with your HR platform and your calendar. Let us walk through what yours would look like.