Stop recalculating public holidays by hand: each consultant's holidays, allowance and carryover follow the location they work in.
A consultant in Bavaria has public holidays a colleague in Berlin does not, and somebody has to remember the difference every time a request comes in.
Leftover days from last year quietly roll on until someone claims twenty of them in one go.
Six months later nobody can say who approved which week, or on what grounds.
Staffing next month's project means asking around instead of looking at one screen.
Every later calculation follows from it, request after request.
Germany – Berlin and Germany – Bayern are separate locations with their own public holidays, so people in the same firm keep the calendar that applies to them.
A request that spans a bank holiday or a weekend deducts only the working days in between. A half day deducts 0.5.
A request that exceeds the remaining balance, including days already waiting for approval, is refused with the exact figure it is short by.
Every decision carries the person who made it, the time and an optional comment. Cancelling approved leave returns the days to the balance.
Last year's days are consumed before this year's allowance, and whatever is left expires on the location's cut-off date, 31 March by default.
The awkward ones are handled without a manual correction.
If a consultant falls ill during approved annual leave, the sick days replace the holiday for those dates and the vacation days go back to their balance.
Two overlapping requests for the same date are refused, and half days can only be combined up to one full day.
Per location you choose whether a public holiday counts on its actual date or moves to the next working day.
Thirty days before the cut-off, owners get one mail listing every consultant with carryover about to expire and how much.
Every correction to an entitlement or a carryover is written down with the name and the exact time of the person who made it, see Audit Trail
Germany – Berlin, Germany – Bayern, Poland and Albania arrive with their holiday dates filled in. You can add further locations for Austria, Switzerland, Luxembourg and the United Kingdom and enter their dates per year.
Yes. A region is its own location, so a Munich consultant and a Berlin consultant keep different public holidays inside the same organisation.
No. A request spanning a bank holiday or a weekend deducts only the working days it covers.
On the date set for that location, 31 March by default. Carryover is always spent before the current year's allowance, so nothing is lost unnecessarily.
Yes. A half day deducts 0.5 from the balance, and two half days on the same date are the most that fits.
Owners approve or reject requests from their consultants, with an optional comment kept on the record. Owners' own requests are approved on submission, and members' sick leave can be set to approve automatically.
Assign each consultant a location and let the allowances, holidays and carryover work themselves out. Free for 30 days.
