Keeping leave records without arguing with the employee in December
Echipa HR 365 · reviewed 2026-09-02 · 5 min read
Year-end disagreements do not come from wrong arithmetic, but from the records and the employee starting from different baselines. The fix is not a better spreadsheet, it is a single source of truth the person can see, updated at the moment of approval rather than at month end.
The five points where records drift apart
In any company without a single system, December’s arguments have the same causes. You can check yours one by one:
| Point of divergence | What it looks like in practice | How it closes |
|---|---|---|
| A request approved verbally | The manager said yes in the corridor, nobody wrote anything | No day is deducted without a written approval, however certain it seems |
| Days moved | The leave was postponed, but the record kept the original date | A change goes through the same flow as the request, not through a message |
| A different opening balance | Last year’s carry-over was calculated by somebody else, differently | The opening balance is fixed once, in writing, and never recalculated |
| Extra entitlement | Somebody has more days by contract, but the record uses the standard | Individual entitlement is held per person, not in the general formula |
| Part days | Half days get rounded differently every time | One rounding rule, written down, applied by the system |
One source of truth, not three
The typical situation: a file with HR, a calendar with the manager, and the employee’s memory. All three are updated at different moments, so they permanently differ. It does not matter which one is “official” — as long as there are three, the December argument is inevitable.
The rule that fixes it: the balance changes in one place and at one moment — at approval. Not at submission (because it can be refused), not at the start of the leave (because nobody is looking then), not at month end (because in the meantime people plan on old figures).
What the employee has to see
The most effective measure against disputes is not better records but visible ones. Somebody who can see their own balance and history does not ask and, more importantly, spots an error in March, when it is easy to correct, rather than in December.
- The opening balance for the year, as a number, with the date it was fixed.
- Every approved period, with the days deducted and who approved it.
- The current balance, updated automatically, not recalculated by hand.
- Days already scheduled but not yet taken — otherwise people plan on top of something already reserved.
The routine that prevents the argument rather than resolving it
Three fixed moments in the year
- HR — in January, fixes and communicates each person’s opening balance, in writing — it does not change after that
- HR — in June, sends everybody their current balance and asks for confirmation; corrections happen now, cheaply
- HR and managers — in September, list who has a lot unused and agree when it gets scheduled — not in November, when there is nobody left to cover
The June point is the only one that genuinely removes the year-end argument: a written confirmation at mid-year turns any later dispute from an argument about figures into one about three months, which is far easier to reconstruct.
When a spreadsheet genuinely stops being enough
Under twenty people, a well-kept file works. Above that, three problems appear that discipline does not solve: you cannot hold individual entitlements without fragile formulas, you cannot show somebody their balance without showing them their colleagues’, and you have no history — so any dispute gets resolved from memory.
Days taken in advance and days carried over
Together, these two situations produce most of the balances nobody can explain any more. The rule that keeps them clean: each has its own column, never mixed into the current balance.
| Situation | How it is recorded | What the person is told |
|---|---|---|
| Days taken before they were accrued | A separate advance column, with its own sign | How many days are in advance and by when they are covered |
| Days left from the previous year | A carry-over balance, distinct from the current year’s entitlement | How much is carry-over and how much is new entitlement |
| Extra days by contract | An attribute on the person, not an exception in the formula | The total figure, noting that it includes the extra |
The reason advance days are not quietly deducted: a balance that shows negative with no explanation destroys trust in the entire record, and recovering it costs more than an extra column would have. And carry-over kept separately answers by itself the most frequent question at the start of the year — how much do I have left from last year.
One last detail that looks minor and produces half the arguments: part days. If you grant half days, the rounding rule has to be written before the first case, not after. Rounding in the employee’s favour is the easiest to apply and to explain; any other version requires a justification you will have to repeat in every situation.
How do I treat days taken in advance?
They are marked explicitly as advance, not quietly deducted from a balance that does not exist yet. Otherwise the displayed balance goes negative with no explanation and nobody trusts it any more.
Who is allowed to correct an error in the records?
One person or role, with a written trace of the change and the reason. Records that three people can adjust with no history are not records.
Leave balances calculated automatically and visible to the employee
Every approval deducts the days at the same moment, and the person sees their balance and history in their own account — so corrections appear in March, not December.
Free account, every module for 7 days, no card required.