In a small business, talk about leave often happens on the spot. Someone asks "Can I take next Friday off?" and the answer is "Sure, we'll see." The shift plan is on a sheet of paper hanging on the wall or in a note on the owner's phone. While the team is small this setup works; everyone roughly knows who is away and when.
The problem starts on the day the information spreads to several places. Leave was requested by message but not written on the paper; the shift changed but the plan on the wall stayed old. Leave falling on the same day is noticed only that morning. In this article we look at how leave and shift information can be kept, at what point a plan kept by hand is enough and at what point it starts to struggle.
⚡ Example scenario: Think of a neighbourhood hair salon. Weekends are busy and weekday mornings are quiet; staff usually want to put their leave on weekdays. Leave requests arrive in the salon's message group, while the shift plan sits on a calendar page next to the till. When an employee changes their leave days they write it in the message group, but nobody marks it on the calendar page; the next week it becomes clear, only after appointments have been given, that more than one person is off on the same morning.
Where Leave and Shift Information Gets Scattered
When leave and shift information sits in one place, a clash can become visible while the plan is being made. In most businesses the scattering comes from three places: the channel the request arrives through, the place where the plan is posted, and what the owner keeps in mind. When the three do not update each other, each one tells a different truth.
Writing the same information in two separate places and one of them going out of date is a common situation in businesses. We covered this in general in the why do I enter the same information in two places article; leave and shifts are one of the most keenly felt examples of it, because out-of-date information can turn directly into an empty workstation.
When a Paper Rota or a Spreadsheet Is Enough
A plan kept by hand can serve a small team for a long time. A paper rota sits where everyone can see it, needs no computer skills, and changes are made with a pen. A spreadsheet on the computer does the same job; on top of that it makes it easier to keep past months and add up remaining leave.
A spreadsheet or paper can be enough for a team with clear rules and few changes. The strain comes at the point where more than one person starts writing to the same file or the plan is kept in more than one place. Customer records have a similar threshold; we described that threshold in the when is Excel no longer enough for customer tracking article. The table below gathers similar signs for leave and shifts.
| Situation | Plan kept by hand |
|---|---|
| Small team, fixed shift pattern | Can mostly be enough |
| Leave requests come to one person through one channel | Can mostly be enough |
| More than one person updates the plan | Old and new versions can get mixed up |
| Shifts change from week to week | Getting the change to everyone can become harder |
| There is more than one branch or team | A separate plan can be kept in each place, and seeing the total becomes harder |
How a Leave Request Is Taken
How a leave request is taken can determine how up to date the plan stays. When a request is taken verbally on the spot, whether it gets recorded is left to the memory of the person who took it.
Where the request comes from
Setting a single route for requests can make things easier: a notebook, a form or a single message channel. What matters is not what the route is, but that all requests come through the same route.
Who approves
When the name of the person who gives approval is clear, the employee knows whom to ask. Who stands in when that person is away can also be written down in advance; that way a request does not wait unanswered.
Where the approval is written
Approved leave can be entered at that moment in the place where the plan is kept. When the approval stays in a message and is written into the plan late, another leave may be granted for that day in the meantime.
Leave Falling on the Same Day
Leave already entered in the plan can show a clash the moment a new request arrives. When more than one leave falls on the same day, which one takes priority is the team's rule; what matters is that the rule has been discussed and written down beforehand. Approaches such as order of request, rotating priority or agreement within the team can be used.
Marking busy days in advance can also help. If the plan shows which days are not suitable for leave, employees can make their requests accordingly and the number of rejected requests may go down.
Who Holds the Shift Plan, Who Sees It
The shift plan is prepared by one person but read by everyone. When the place where the plan is prepared differs from the place where it is read, the version being read can be out of date. The paper on the wall, the photo of it on a phone and the latest version in the owner's hands can tell three different plans in the same week.
Everyone seeing the plan from the same place can close this gap. If employees can see their own shift on their phone, the question "when was I coming in this week?" may not reach the owner. Who holds the plan while the owner is away can also be written down separately; we covered what can be done if work stops while you are away in a separate article.
How a Last-Minute Change Is Recorded
When it is written down who made a change and when, the plan can later be read back. Illness, an urgent matter or two employees swapping places between themselves can change the plan at the last minute. These changes are often made verbally and reach the plan itself late.
A single route can also be set for last-minute changes: the person making the change updates the plan themselves or informs the person who gives approval, who then enters it into the plan. Whichever route is chosen, the moment the change reaches the plan, the version everyone sees has changed as well.
Tracking Remaining Leave Entitlement
How much leave an employee has used and how much entitlement is left is a question asked often during the year. When used leave is kept in the same place, this question can be answered by looking at the plan; there is no need to add it up backwards from separate messages.
The leave entitlement itself, that is, how much leave falls to whom and under which rules it is used, is a legal matter and outside the scope of this article. We recommend consulting your accountant or an employment law specialist on this. The job here is for leave granted and used to be recorded in an orderly way.
When to Move from a Spreadsheet to a Panel
There is no obligation to give up a plan kept by hand. The move can be discussed at the point where keeping the plan becomes a workload in itself or the same problems keep coming back. The signs below can show that this point is approaching.
| Sign observed | What it may mean |
|---|---|
| Clashing leave is noticed only on the day | Approvals may be entered into the plan late |
| Employees ask the owner about their shift | The plan may not be where everyone can see it |
| More than one version of the plan is circulating | The person and place updating the plan may not be clear |
| The remaining leave question requires adding up backwards | Used leave may not be kept in one place |
| The plan is in only one person's hands | The plan may not be updated while that person is away |
If these signs are showing, a panel that gathers leave requests, approvals and the shift plan on a single screen can be considered. In such a panel employees enter their own requests, the plan is updated when approval is given, and everyone sees the same version. Adding a new staff member to the plan can also be done from the same screen; we covered the preparation before they start in the what to prepare before a new employee starts article. Wider automation of human resources work is the subject of the human resources automation article.
Summary
In a small team, leave and shift information can be kept on paper or in a spreadsheet for a long time. The strain begins at the point where the information spreads to several places, more than one person updates the plan, or changes are made verbally. Requests coming through a single route, a clearly named person who gives approval, approval being entered into the plan straight away and the plan sitting in a single place everyone sees can ease this strain. If the same problems keep coming back, a panel can be discussed; if the team is small and the pattern is fixed, a plan kept by hand can be enough.
Frequently Asked Questions
Where should staff leave be kept
When the leave request, its approval and the shift plan are kept in the same place, a clash can become visible while the plan is being made. This place can be a paper rota, a spreadsheet or a panel; what matters is that the information does not spread to several places.
Can a shift plan be kept in Excel
If the team is small, the shift pattern is fixed and one person updates the plan, a spreadsheet can be enough. When more than one person starts updating the plan or different versions start circulating, the spreadsheet can come under strain.
How is leave falling on the same day resolved
Which request takes priority can be tied to a rule the team has discussed and written down beforehand: order of request, rotating priority or agreement within the team. Marking busy days in the plan in advance can also cut down clashes.
How is a last-minute shift change recorded
The person making the change updates the plan themselves or informs the person who gives approval. When it is written down who made the change and when, the plan can later be read back.
How is remaining leave entitlement calculated
How much leave entitlement each person has is a legal matter; you can consult your accountant or an employment law specialist on this. When used leave is kept in one place in an orderly way, the record needed to calculate the remaining entitlement can be ready.
Leave and shifts can sit on one screen
When request, approval and plan sit in the same place, everyone can see the same version. Talking together about the approach that suits your team's size and way of working can be a first step.
💬 Get a Quote on WhatsAppThe first consultation is free.
