Why nobody trusts the holiday balance in the spreadsheet

Most small businesses do not start with a leave management problem.

They start with a spreadsheet.

At first, that spreadsheet feels fine. One tab for employees. One tab for holiday requests. Maybe a column for days used, days remaining, carryover, and bank holidays. Everyone knows where it lives. Someone in ops keeps it updated.

Then the team grows.

People start asking:

• "How much holiday do I have left?"
• "Did that day off get approved?"
• "Does this include my carried-over days?"
• "Have you updated the sheet from my Slack message?"
• "What about my part-time pattern?"

That is usually the moment the problem becomes clear.

The issue is not just that the company uses a spreadsheet. The issue is that nobody fully trusts the number in the spreadsheet.

The hidden cost of an untrusted leave balance

When employees do not trust their holiday balance, every request creates extra admin.

An employee checks the sheet, then messages HR or ops to confirm. A manager checks whether the request was approved. Someone else checks whether the spreadsheet was updated. Then somebody has to remember whether carryover, sickness, bank holidays, or part-time working patterns were included properly.

Each check only takes a few minutes.

But across a 30, 50, or 80-person team, those small checks add up. The real cost is not the spreadsheet itself. It is the repeated checking, correcting, and second-guessing around it.

Why leave balances become hard to trust

Leave spreadsheets usually become fragile for a few common reasons.

Requests happen outside the sheet. Someone asks in Slack, WhatsApp, email, or verbally. The request might get approved but not recorded straight away.

The rules get more complicated. Carryover, sickness, bank holidays, part-time staff, starters, and leavers all make the balance harder to calculate by hand.

Only one person really understands the sheet. If they are away, busy, or leave the business, everyone else has to work around it.

Employees cannot self-serve with confidence. If they still need to message someone to check their balance, the spreadsheet is not really saving admin time.

What a trusted leave balance should do

A trusted leave balance should answer one question quickly:

How much time off do I actually have left?

Employees should not have to ask someone in ops. Managers should not have to check three places. HR should not have to reconcile Slack messages with a spreadsheet every week.

For a small business, this does not mean buying a full HR system. It usually means moving leave into a simple place where requests, approvals, balances, carryover, and team visibility are connected.

When to move on from the spreadsheet

You probably do not need to replace your spreadsheet on day one.

But it may be time to move on if:

• Employees regularly ask how much holiday they have left
• Managers are unsure what has been approved
• Leave requests happen in Slack, WhatsApp, or email
• Balances need manual checking before approval
• Part-time patterns or carryover keep causing confusion
• One person is the only person who understands the sheet

That is the point where the spreadsheet stops being a simple tracker and becomes a source of extra work.

A simple next step

You do not need a full HRIS to fix this. You just need a leave process people can trust.