An opening balance is the number each person starts with in the new system. If it's wrong on day one, every balance after it is wrong too, and the new system gets the blame. Agree the numbers before anyone logs in.
How a balance adds up
For the current leave year, each person's balance is:
| Days | |
|---|---|
| This year's allowance (pro-rated if they joined partway, or work part-time) | + |
| Days carried over from last year | + |
| Adjustments already agreed, such as an extra day for a long-service award | + or − |
| Leave already taken this year | − |
| Leave booked for later this year | − |
| Remaining | = |
Write down each line, not just the total. When someone asks why their balance is what it is, the lines are the answer.
A worked example
Alex works full time on 25 days plus public holidays, and you're moving on 1 October.
| Days | |
|---|---|
| Allowance for the year | 25 |
| Carried over from last year | + 3 |
| Taken so far this year | − 14.5 |
| Booked for November | − 3 |
| Remaining to book | 10.5 |
Now suppose the new system shows 7.5. The 3 missing days are the November booking, counted twice: the spreadsheet's remaining figure, which had already taken it off, was entered as the opening balance, and then the booking was imported as well. That's the most common mistake in a move.
The checks
- Does the old balance already deduct future bookings? If it does and you import those bookings too, they're taken off twice. Decide which side owns future leave, then check one person end to end.
- Is the carry-over allowed? Check that the days carried in match your policy and the law where each person works. Some countries limit how much can be carried over, or when it must be used.
- Part-timers. Check the allowance was pro-rated from their working week, and that public holidays were handled the same way for everyone. See part-time holiday entitlement.
- Starters and leavers. Anyone who joined this year should have a pro-rated allowance, with part days rounded the way your policy says. Leavers who've gone don't need an opening balance, but keep their records.
- Pending requests. Decide whether they're approved before the move or re-requested after it, so nothing is half in each system.
Reconcile three people
Before moving everyone, pick three people and check them line by line in the new system: a full-timer, a part-timer and someone with leave booked ahead. If all three match, the rest usually do. If one doesn't, you've found the rule that needs fixing while it's three people, not thirty.
How Clearleave handles it
You can import this year's bookings and let Clearleave work out the balance from the policy allowance, or skip the history and set each balance with an adjustment. Either way, every adjustment is saved with your name and a reason in the person's balance history, so the opening position stays traceable.
Sources
- Acas, Carrying over holiday
- GOV.UK, Calculate leave entitlement
- Acas, Checking holiday entitlement
- nidirect, Taking your holidays
This is general guidance, not legal advice: for a decision about a particular person, check the sources above or take advice.